SQLite format 3

@  
	

.K�
�
P�
P�3
�
fo
1��P
�stablebindingsbindingsCREATE TABLE bindings
 (oid INTEGER PRIMARY KEY AUTOINCREMENT,
  fingerprint TEXT, email TEXT, user_id TEXT, time INTEGER,
  policy INTEGER CHECK (policy in (1, 2, 3, 4, 5)),
  conflict STRING, effective_policy INTEGER DEFAULT 0 CHECK (effective_policy in (0, 1, 2, 3, 4, 5)),
  unique (fingerprint, email))c
3#
indexencryptions_bindingencryptionsCREATE INDEX encryptions_binding on encryptions (binding)e	##
�tableencryptionsencryptions
CREATE TABLE encryptions (binding INTEGER NOT NULL,  time INTEGER)�?!!
�ItablesignaturessignaturesCREATE TABLE signatures  (binding INTEGER NOT NULL, sig_digest TEXT,  origin TEXT, sig_time INTEGER, time INTEGER,  primary key (binding, sig_digest, origin))3G!
indexsqlite_autoindex_signatures_1signatures	Q)
kindexbindings_emailbindingsCREATE INDEX bindings_email on bindings (email)xA
�indexbindings_fingerprint_emailbindingsCREATE INDEX bindings_fingerprint_email
 on bindings (fingerprint, email)P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��f;;
etableultimately_trusted_keysultimately_trusted_keysCREATE TABLE ultimately_trusted_keys (keyid)/C
indexsqlite_autoindex_bindings_1bindings@

YtableversionversionCREATE TABLE version (version INTEGER)

��