SQLite format 3@ "".n   0 { h 6~%UG##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$ //wtablecollections_prismcollections_prism CREATE TABLE collections_prism ( id LONGVARCHAR PRIMARY KEY, date_modified REAL NOT NULL, title LONGVARCHAR NOT NULL)A U/indexsqlite_autoindex_collections_prism_1collections_prismK 11Atableitems_offline_dataitems_offline_data CREATE TABLE items_offline_data ( item_id LONGVARCHAR NOT NULL REFERENCES items(id) ON DELETE CASCADE PRIMARY KEY, offline_file_data LONGVARCHAR NOT NULL)C W1indexsqlite_autoindex_items_offline_data_1items_offline_data \ tablefaviconsfavicons CREATE TABLE favicons ( url LONGVARCHAR PRIMARY KEY, data BLOB)/ Cindexsqlite_autoindex_favicons_1favicons #IIAtablecollections_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)))=indexsqlite_autoindex_items_1items5I#indexsqlite_autoindex_collections_1collections               version10;last_compatible_version1 #mmap_status-1 ;last_compatible_version version # mmap_status