HEX

File: C:/Users/fred/AppData/Local/Microsoft/Edge/User Data/Default/Collections/collectionsSQLite
SQLite format 3@  }�}.��
~�����0

	{	�h	6�U���G##�UtablecollectionscollectionsCREATE TABLE collections ( id LONGVARCHAR PRIMARY KEY, date_created REAL NOT NULL, date_modified REAL NOT NULL, title LONGVARCHAR NOT NULL, position INTEGER NOT NULL, is_syncable INTEGER DEFAULT 1, suggestion_url LONGVARCHAR, suggestion_dismissed INTEGER, suggestion_type INTEGER, thumbnail BLOB, is_custom_thumbnail INTEGER NOT NULL DEFAULT 0, tag LONGVARCHAR, thumbnail_url LONGVARCHAR, is_marked_for_deletion INTEGER)��tableitemsitemsCREATE TABLE items ( id LONGVARCHAR PRIMARY KEY, date_created REAL NOT NULL, date_modified REAL NOT NULL, title LONGVARCHAR, source BLOB, entity_blob BLOB, favicon_url LONGVARCHAR REFERENCES favicons(url) ON DELETE CASCADE, canonical_image_data BLOB, canonical_image_url LONGVARCHAR, text_content LONGVARCHAR, html_content LONGVARCHAR, type LONGVARCHAR, progressing INTEGER, is_syncable INTEGER DEFAULT 1, color LONGVARCHAR, third_party_data BLOB, remote_url LONGVARCHAR, tag LONGVARCHAR, is_marked_for_deletion INTEGER)�\�tablecommentscommentsCREATE TABLE comments ( id LONGVARCHAR PRIMARY KEY, parent_id LONGVARCHAR NOT NULL, text LONGVARCHAR NOT NULL, properties BLOB, FOREIGN KEY (parent_id) REFERENCES items(id) ON DELETE CASCADE)/Cindexsqlite_autoindex_comments_1commentsf�/tablemetametaCREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)';indexsqlite_autoindex_meta_1meta`�AU/indexsqlite_autoindex_collections_prism_1collections_prism��K
11�Atableitems_offline_dataitems_offline_dataCREATE TABLE items_offline_data ( item_id LONGVARCHAR NOT NULL REFERENCES items(id) ON DELETE CASCADE PRIMARY KEY, offline_file_data LONGVARCHAR NOT NULL)CW1indexsqlite_autoindex_items_offline_data_1items_offline_data\�tablefaviconsfavicons	CREATE TABLE favicons ( url LONGVARCHAR PRIMARY KEY, data BLOB)/	Cindexsqlite_autoindex_favicons_1favicons
�#II�Atablecollections_items_relationshipcollections_items_relationshipCREATE TABLE collections_items_relationship ( item_id LONGVARCHAR NOT NULL REFERENCES items(id) ON DELETE CASCADE, parent_id LONGVARCHAR NOT NULL REFERENCES collections(id) ON DELETE CASCADE, position INTEGER NOT NULL)�Q!!�mtableitems_syncitems_syncCREATE TABLE items_sync ( item_id LONGVARCHAR, is_syncable INTEGER DEFAULT 1, server_id LONGVARCHAR NULL, date_last_synced REAL NULL, FOREIGN KEY(item_id) REFERENCES items(id))�u--�tablecollections_synccollections_syncCREATE TABLE collections_sync ( collection_id LONGVARCHAR, is_syncable INTEGER DEFAULT 1, server_id LONGVARCHAR NULL, date_last_synced REAL NULL, FOREIGN KEY(collection_id) REFERENCES collections(id))��$//�wtablecollections_prismcollections_prism
CREATE TABLE collections_prism ( id LONGVARCHAR PRIMARY KEY, date_modified REAL NOT NULL, title LONGVARCHAR NOT NULL))=indexsqlite_autoindex_items_1items��5I#indexsqlite_autoindex_collections_1collections













�����version10;last_compatible_version1
#mmap_status-1
����;last_compatible_versionversion#	mmap_status