SQLite format 3@  
._
�
���Y�(9
.�O)�#triggerenforce_ctime_before_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_before_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime > NEW.mtime) BEGIN UPDATE dbfs_mftrecord SET ctime=NEW.mtime WHERE itemid = NEW.itemid; END�l5)�triggerenforce_atime_insertdbfs_mftrecordCREATE TRIGGER enforce_atime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.atime == 0) BEGIN UPDATE dbfs_mftrecord SET atime=strftime('%s') WHERE itemid = NEW.itemid; END�l
5)�triggerenforce_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.mtime == 0) BEGIN UPDATE dbfs_mftrecord SET mtime=strftime('%s') WHERE itemid = NEW.itemid; END�l	5)�triggerenforce_ctime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime == 0) BEGIN UPDATE dbfs_mftrecord SET ctime=strftime('%s') WHERE itemid = NEW.itemid; END�$?)�ktriggerenforce_constraint_insertdbfs_mftrecordCREATE TRIGGER enforce_constraint_insert BEFORE INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.parentid != 1) AND (NEW.parentid != 2) BEGIN SELECT CASE WHEN ((SELECT itemtype FROM dbfs_mftrecord WHERE itemid = NEW.parentid) != 2) THEN RAISE(ABORT, 'parentid must reference either a folder, the root, or the temp folder') WHEN ((SELECT tombstoned FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 1) THEN RAISE(ABORT, 'parentid must reference a non-tombstoned folder') WHEN ((SELECT COUNT(itemid) FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 0) THEN RAISE(ABORT, 'parentid must reference a valid record') END; END�)I)
�mindexunique_parentid_namehash_indexdbfs_mftrecordCREATE UNIQUE INDEX unique_parentid_namehash_index ON dbfs_mftrecord (parentid, name_hash) WHERE tombstoned != 1P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�X))
�ktabledbfs_mftrecorddbfs_mftrecordCREATE TABLE dbfs_mftrecord ( itemid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, anchor INTEGER DEFAULT 0 NOT NULL UNIQUE, itemtype INTEGER DEFAULT 0 NOT NULL, parentid INTEGER NOT NULL, srid INTEGER DEFAULT NULL, content_name TEXT COLLATE NOCASE, content_flags INTEGER DEFAULT 0 NOT NULL, content_version INTEGER DEFAULT 0 NOT NULL, content_id TEXT NOCASE, content_hash BLOB, tombstoned INTEGER DEFAULT 0 NOT NULL, marked INTEGER DEFAULT NULL, materialized INT DEFAULT 0 NOT NULL, pending INT DEFAULT NULL, in_working_set INT DEFAULT 1 NOT NULL, capabilities INTEGER DEFAULT 0 NOT NULL, name TEXT NOT NULL COLLATE NOCASE, name_hash INTEGER NOT NULL, size INTEGER DEFAULT 0 NOT NULL, ctime INTEGER DEFAULT 0 NOT NULL, mtime INTEGER DEFAULT 0 NOT NULL, atime INTEGER DEFAULT 0 NOT NULL, attributes INTEGER DEFAULT NULL, ph_state INTEGER DEFAULT 0 NOT NULL, ph_pin INTEGER DEFAULT 0 NOT NULL, ph_insync INTEGER DEFAULT 0 NOT NULL, ph_local INTEGER DEFAULT 0 NOT NULL, tagdata BLOB DEFAULT NULL, secondary_state INTEGER DEFAULT NULL, error_code INTEGER DEFAULT NULL, link_type INTEGER DEFAULT NULL, link_target TEXT DEFAULT NULL, uti TEXT DEFAULT NULL COLLATE NOCASE, uti_override TEXT DEFAULT NULL, media_datetaken INTEGER DEFAULT NULL, media_duration INTEGER DEFAULT NULL, media_width INTEGER DEFAULT NULL, media_height INTEGER DEFAULT NULL, motw INTEGER DEFAULT NULL, last_change INTEGER DEFAULT 0 NOT NULL, last_change_fields INTEGER DEFAULT 0 NOT NULL );O)
indexsqlite_autoindex_dbfs_mftrecord_1dbfs_mftrecords!!
�1tabledbfs_statedbfs_stateCREATE TABLE dbfs_state ( name TEXT PRIMARY KEY UNIQUE, value BLOB ) WITHOUT ROWID�
))
�;table__oddbm_schema__oddbm_schemaCREATE TABLE __oddbm_schema (name TEXT PRIMARY KEY, value INTEGER UNIQUE) WITHOUT ROWID;O)
indexsqlite_autoindex___oddbm_schema_2__oddbm_schema	

��
	version

��
	version

���>*



temph_6.h_6.h_6.;
*	
			rooth_6.h_6.h_6.
���

		

��
)
dbfs_mftrecordc
���


			
�8����Y�(9
.��O)�#triggerenforce_ctime_before_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_before_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime > NEW.mtime) BEGIN UPDATE dbfs_mftrecord SET ctime=NEW.mtime WHERE itemid = NEW.itemid; END�l5)�triggerenforce_atime_insertdbfs_mftrecordCREATE TRIGGER enforce_atime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.atime == 0) BEGIN UPDATE dbfs_mftrecord SET atime=strftime('%s') WHERE itemid = NEW.itemid; END�l
5)�triggerenforce_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.mtime == 0) BEGIN UPDATE dbfs_mftrecord SET mtime=strftime('%s') WHERE itemid = NEW.itemid; END�l	5)�triggerenforce_ctime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime == 0) BEGIN UPDATE dbfs_mftrecord SET ctime=strftime('%s') WHERE itemid = NEW.itemid; END�$?)�ktriggerenforce_constraint_insertdbfs_mftrecordCREATE TRIGGER enforce_constraint_insert BEFORE INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.parentid != 1) AND (NEW.parentid != 2) BEGIN SELECT CASE WHEN ((SELECT itemtype FROM dbfs_mftrecord WHERE itemid = NEW.parentid) != 2) THEN RAISE(ABORT, 'parentid must reference either a folder, the root, or the temp folder') WHEN ((SELECT tombstoned FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 1) THEN RAISE(ABORT, 'parentid must reference a non-tombstoned folder') WHEN ((SELECT COUNT(itemid) FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 0) THEN RAISE(ABORT, 'parentid must reference a valid record') END; END�)I)
�mindexunique_parentid_namehash_indexdbfs_mftrecordCREATE UNIQUE INDEX unique_parentid_namehash_index ON dbfs_mftrecord (parentid, name_hash) WHERE tombstoned != 1P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�X))
�ktabledbfs_mftrecorddbfs_mftrecordCREATE TABLE dbfs_mftrecord ( itemid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, anchor INTEGER DEFAULT 0 NOT NULL UNIQUE, itemtype INTEGER DEFAULT 0 NOT NULL, parentid INTEGER NOT NULL, srid INTEGER DEFAULT NULL, content_name TEXT COLLATE NOCASE, content_flags INTEGER DEFAULT 0 NOT NULL, content_version INTEGER DEFAULT 0 NOT NULL, content_id TEXT NOCASE, content_hash BLOB, tombstoned INTEGER DEFAULT 0 NOT NULL, marked INTEGER DEFAULT NULL, materialized INT DEFAULT 0 NOT NULL, pending INT DEFAULT NULL, in_working_set INT DEFAULT 1 NOT NULL, capabilities INTEGER DEFAULT 0 NOT NULL, name TEXT NOT NULL COLLATE NOCASE, name_hash INTEGER NOT NULL, size INTEGER DEFAULT 0 NOT NULL, ctime INTEGER DEFAULT 0 NOT NULL, mtime INTEGER DEFAULT 0 NOT NULL, atime INTEGER DEFAULT 0 NOT NULL, attributes INTEGER DEFAULT NULL, ph_state INTEGER DEFAULT 0 NOT NULL, ph_pin INTEGER DEFAULT 0 NOT NULL, ph_insync INTEGER DEFAULT 0 NOT NULL, ph_local INTEGER DEFAULT 0 NOT NULL, tagdata BLOB DEFAULT NULL, secondary_state INTEGER DEFAULT NULL, error_code INTEGER DEFAULT NULL, link_type INTEGER DEFAULT NULL, link_target TEXT DEFAULT NULL, uti TEXT DEFAULT NULL COLLATE NOCASE, uti_override TEXT DEFAULT NULL, media_datetaken INTEGER DEFAULT NULL, media_duration INTEGER DEFAULT NULL, media_width INTEGER DEFAULT NULL, media_height INTEGER DEFAULT NULL, motw INTEGER DEFAULT NULL, last_change INTEGER DEFAULT 0 NOT NULL, last_change_fields INTEGER DEFAULT 0 NOT NULL );O)
indexsqlite_autoindex_dbfs_mftrecord_1dbfs_mftrecords!!
�1tabledbfs_statedbfs_stateCREATE TABLE dbfs_state ( name TEXT PRIMARY KEY UNIQUE, value BLOB ) WITHOUT ROWID�
))
�;table__oddbm_schema__oddbm_schemaCREATE TABLE __oddbm_schema (name TEXT PRIMARY KEY, value INTEGER UNIQUE) WITHOUT ROWID;O)
indexsqlite_autoindex___oddbm_schema_2__oddbm_schema

�"
3(	�!��6�<��1
��--
�Utabledbfs_anchorstatedbfs_anchorstateCREATE TABLE dbfs_anchorstate ( name TEXT PRIMARY KEY UNIQUE, value INTEGER NOT NULL ) WITHOUT ROWIDo3/
�	indexchange_itemid_indexdbfs_changerecordCREATE INDEX change_itemid_index on dbfs_changerecord (itemid)�(//
�tabledbfs_changerecorddbfs_changerecordCREATE TABLE dbfs_changerecord ( anchor INTEGER PRIMARY KEY NOT NULL, itemid INTEGER NOT NULL, parentid INTEGER NOT NULL, pid INTEGER NOT NULL, change_type INTEGER NOT NULL, old_name TEXT DEFAULT NULL COLLATE NOCASE, old_parentid TEXT DEFAULT NULL )m1)
�
indexcontent_name_indexdbfs_mftrecordCREATE INDEX content_name_index on dbfs_mftrecord (content_name)�I)
�Cindexparentid_namehash_anchor_indexdbfs_mftrecordCREATE INDEX parentid_namehash_anchor_index on dbfs_mftrecord (parentid, name_hash, anchor)a))
indexnamehash_indexdbfs_mftrecord
CREATE INDEX namehash_index on dbfs_mftrecord (name_hash)`))
}indexparentid_indexdbfs_mftrecordCREATE INDEX parentid_index on dbfs_mftrecord (parentid)Z%)
uindexanchor_indexdbfs_mftrecordCREATE INDEX anchor_index on dbfs_mftrecord (anchor)�?)�atriggerenforce_constraint_deletedbfs_mftrecordCREATE TRIGGER enforce_constraint_delete BEFORE DELETE ON dbfs_mftrecord FOR EACH ROW BEGIN SELECT CASE WHEN EXISTS (SELECT 1 FROM dbfs_mftrecord WHERE parentid = OLD.itemid) THEN RAISE(ABORT, 'record has at least one child') END; END�O)�#triggerenforce_ctime_before_mtime_updatedbfs_mftrecordCREATE TRIGGER enforce_ctime_before_mtime_update AFTER UPDATE ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime > NEW.mtime) BEGIN UPDATE dbfs_mftrecord SET ctime=NEW.mtime WHERE itemid = NEW.itemid; END�S)�triggerenforce_constraint_update_tombstonedbfs_mftrecordCREATE TRIGGER enforce_constraint_update_tombstone BEFORE UPDATE OF tombstoned ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.tombstoned = 1) BEGIN SELECT CASE WHEN EXISTS (SELECT 1 FROM dbfs_mftrecord WHERE parentid = NEW.itemid AND tombstoned = 0) THEN RAISE(ABORT, 'record has at least one non-tombstoned child') END; END�

Q)�triggerenforce_constraint_update_parentiddbfs_mftrecordCREATE TRIGGER enforce_constraint_update_parentid BEFORE UPDATE OF parentid ON dbfs_mftrecord BEGIN SELECT CASE WHEN ((SELECT itemtype FROM dbfs_mftrecord WHERE itemid = NEW.parentid) != 2) THEN RAISE(ABORT, 'parentid must reference either a folder, the root, or the temp folder') WHEN ((SELECT tombstoned FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 1) THEN RAISE(ABORT, 'parentid must reference a non-tombstoned folder') WHEN ((SELECT COUNT(itemid) FROM dbfs_mftrecord WHERE itemid = NEW.parentid) = 0) THEN RAISE(ABORT, 'parentid must reference a valid record') END; END�O)�#triggerenforce_ctime_before_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_before_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime > NEW.mtime) BEGIN UPDATE dbfs_mftrecord SET ctime=NEW.mtime WHERE itemid = NEW.itemid; END�l5)�triggerenforce_atime_insertdbfs_mftrecordCREATE TRIGGER enforce_atime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.atime == 0) BEGIN UPDATE dbfs_mftrecord SET atime=strftime('%s') WHERE itemid = NEW.itemid; END�l
5)�triggerenforce_mtime_insertdbfs_mftrecordCREATE TRIGGER enforce_mtime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.mtime == 0) BEGIN UPDATE dbfs_mftrecord SET mtime=strftime('%s') WHERE itemid = NEW.itemid; END�l	5)�triggerenforce_ctime_insertdbfs_mftrecordCREATE TRIGGER enforce_ctime_insert AFTER INSERT ON dbfs_mftrecord FOR EACH ROW WHEN    (NEW.ctime == 0) BEGIN UPDATE dbfs_mftrecord SET ctime=strftime('%s') WHERE itemid = NEW.itemid; END
���

		
���

		
���

		
���	



				
���
	



��

anchor