SQLite format 3

@  

-� ���
)
��d!!
�tablerow_countsrow_countsCREATE TABLE row_counts ( 	id		integer primary key, 	rows	integer )q''
�!tableconfigurationconfigurationCREATE TABLE configuration ( 	guid		blob primary key, 	changeset	integer )9M'
indexsqlite_autoindex_configuration_1configuration�
�UtablechangesetchangesetCREATE TABLE changeset ( 	id			integer primary key,	message		text, 	owner		text, 	date_time	integer)k''
�tableparentfoldersparentfoldersCREATE TABLE parentfolders (	id			integer primary key,	folder		text)�v
%%
�/tableassetversionassetversionCREATE TABLE assetversion ( 	changeset	integer,	guid	blob,	name	text collate nocase,	parent	blob,	assettype integer,	digest	blob,  	oldversion	integer,  	parentfolderid integer, primary key (changeset, guid) )7K%
indexsqlite_autoindex_assetversion_1assetve
		



��





����





-
-&_�R��d!!
�tablerow_countsrowd�v
%%
�/tableassetversionassetversionCREATE TABLE assetversion ( 	changeset	integer,	guid	blob,	nam�v
%%
�/tableassetversionassetversionCREATE TABLE assetversion ( 	changeset	integer,	guid	blob,	name	text collate nocase,	parent	blob,	assettype integer,	digest	blob,  	oldversion	integer,  	parentfolderid integer, primary key (changeset, guid) )7K%
indexsqlite_autoindex_assetversion_1assetversionk''
�tableparentfoldersparentfoldersCREATE TABLE parentfolders (	id			integer primary key,	folder		text)�
�UtablechangesetchangesetCREATE TABLE changeset ( 	id			integer primary key,	message		text, 	owner		text, 	date_time	integer)q''
�!tableconfigurationconfigurationCREATE TABLE configuration ( 	guid		blob primary key, 	changeset	integer )9M'
indexsqlite_autoindex_configuration_1configuration

�
�
�J:�a9%
�mtriggerassetversion_insert_trassetversionCREATE TRIGGER assetversion_insert_tr 	after insert on assetversion 	for each row begin 		update row_counts set rows = rows+1 where id=0; 		update configuration set changeset=new.changeset where guid=new.guid; 		insert or ignore into configurd!!
�tablerow_countsrow_countsCREATE TABLE row_counts ( 	id		integer primary key, 	rows	integer )�a9%
�mtriggerassetversion_insert_trassetversionCREATE TRIGGER assetversion_insert_tr 	after insert on assetversion 	for each row begin 		update row_counts set rows = rows+1 where id=0; 		update configuration set changeset=new.changeset where guid=new.guid; 		insert or ignore into configuration(guid, changeset) values( new.guid, new.changeset ) ;	end�3	3
�triggerchangeset_insert_trchangesetCREATE TRIGGER changeset_insert_tr 	after insert on changeset 	for each row begin 		update row_counts set rows = rows+1 where id=1; 	end

�
���
e�~A'
�!indexassetversion_folder_cs__ixparentfoldersCREATE UNIQUE INDEX assetversion_folder_cs__ix on parentfolders ( folder )�
K%
�=indexassetversion_name_parent_cs__ixassetversion
CREATE INDEX assetversion_name_parent_cs__ix on assetversion ( name, parent, changeset )�C
;'
�-triggerconfiguration_insert_trconfigurationCREATE TRIGGER configuration_insert_tr 	after insert on configuration 	for each row begin 		update row_counts set rows = rows+1 where id=2; 	end�C;'
�-triggerconfiguration_delete_trconfigurationCREATE TRIGGER configuration_delete_tr 	after delete on configuration 	for each row begin 		update row_counts set rows = rows-1 where id=2; 	endz=%
�indexassetversion_guid_cs__ixassetversionCREATE INDEX assetversion_guid_cs__ix on assetversion ( guid, changeset )


��