SQLite format 3 @ . & K .jÐ ø -a> ~Á|0{dzõzz"y³y3x»xKwÒvÊuáuGtÁt;sAsúq×pîqp{oüohnênemn,m9lk½lPjjhÆh gµdcÓc6bbÑaa> K-%%[tablesqlite_stat1sqlite_stat1.CREATE TABLE sqlite_stat1(tbl,idx,stat) ,;;)tablemoz_previews_tombstonesmoz_previews_tombstones-CREATE TABLE moz_previews_tombstones ( hash TEXT PRIMARY KEY ) WITHOUT ROWID7*QQYtablemoz_places_metadata_search_queriesmoz_places_metadata_search_queries+CREATE TABLE moz_places_metadata_search_queries ( id INTEGER PRIMARY KEY, terms TEXT NOT NULL UNIQUE )c+wQ indexsqlite_autoindex_moz_places_metadata_search_queries_1moz_places_metadata_search_queries,)O3?indexmoz_places_metadata_referrerindexmoz_places_metadata*CREATE INDEX moz_places_metadata_referrerindex ON moz_places_metadata (referrer_place_id):(e3iindexmoz_places_metadata_placecreated_uniqueindexmoz_places_metadata)CREATE UNIQUE INDEX moz_places_metadata_placecreated_uniqueindex ON moz_places_metadata (place_id, created_at)"'33ktablemoz_places_metadatamoz_places_metadata(CREATE TABLE moz_places_metadata (id INTEGER PRIMARY KEY, place_id INTEGER NOT NULL, referrer_place_id INTEGER, created_at INTEGER NOT NULL DEFAULT 0, updated_at INTEGER NOT NULL DEFAULT 0, total_view_time INTEGER NOT NULL DEFAULT 0, typing_time INTEGER NOT NULL DEFAULT 0, key_presses INTEGER NOT NULL DEFAULT 0, scrolling_time INTEGER NOT NULL DEFAULT 0, scrolling_distance INTEGER NOT NULL DEFAULT 0, document_type INTEGER NOT NULL DEFAULT 0, search_query_id INTEGER, FOREIGN KEY (place_id) REFERENCES moz_places(id) ON DELETE CASCADE, FOREIGN KEY (referrer_place_id) REFERENCES moz_places(id) ON DELETE CASCADE, FOREIGN KEY(search_query_id) REFERENCES moz_places_metadata_search_queries(id) ON DELETE CASCADE CHECK(place_id != referrer_place_id) )h& #tablemoz_metamoz_meta'CREATE TABLE moz_meta (key TEXT PRIMARY KEY, value NOT NULL) WITHOUT ROWID $%Q+Yindexmoz_items_annos_itemattributeindexmoz_items_annos&CREATE UNIQUE INDEX moz_items_annos_itemattributeindex ON moz_items_annos (item_id, anno_attribute_id)8$++'tablemoz_items_annosmoz_items_annos%CREATE TABLE moz_items_annos ( id INTEGER PRIMARY KEY, item_id INTEGER NOT NULL, anno_attribute_id INTEGER, content LONGVARCHAR, flags INTEGER DEFAULT 0, expiration INTEGER DEFAULT 0, type INTEGER DEFAULT 0, dateAdded INTEGER DEFAULT 0, lastModified INTEGER DEFAULT 0)#G Eindexmoz_annos_placeattributeindexmoz_annos$CREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id)'" tablemoz_annosmoz_annos#CREATE TABLE moz_annos ( id INTEGER PRIMARY KEY, place_id INTEGER NOT NULL, anno_attribute_id INTEGER, content LONGVARCHAR, flags INTEGER DEFAULT 0, expiration INTEGER DEFAULT 0, type INTEGER DEFAULT 0, dateAdded INTEGER DEFAULT 0, lastModified INTEGER DEFAULT 0) 33Gtablemoz_anno_attributesmoz_anno_attributes!CREATE TABLE moz_anno_attributes ( id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL)E!Y3 indexsqlite_autoindex_moz_anno_attributes_1moz_anno_attributes" Y%Mindexmoz_keywords_placepostdata_uniqueindexmoz_keywords CREATE UNIQUE INDEX moz_keywords_placepostdata_uniqueindex ON moz_keywords (place_id, post_data)P ++Ytablesqlite_sequencesqlite_sequence CREATE TABLE sqlite_sequence(name,seq) %%tablemoz_keywordsmoz_keywords CREATE TABLE moz_keywords ( id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE, place_id INTEGER, post_data TEXT)7 K% indexsqlite_autoindex_moz_keywords_1moz_keywords I'!indexmoz_bookmarks_guid_uniqueindexmoz_bookmarks CREATE UNIQUE INDEX moz_bookmarks_guid_uniqueindex ON moz_bookmarks (guid)|E'indexmoz_bookmarks_dateaddedindexmoz_bookmarksCREATE INDEX moz_bookmarks_dateaddedindex ON moz_bookmarks (dateAdded)S'5indexmoz_bookmarks_itemlastmodifiedindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModified)}?'!indexmoz_bookmarks_parentindexmoz_bookmarksCREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position)q;' indexmoz_bookmarks_itemindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type)77Utablemoz_bookmarks_deletedmoz_bookmarks_deletedCREATE TABLE moz_bookmarks_deleted ( guid TEXT PRIMARY KEY, dateRemoved INTEGER NOT NULL DEFAULT 0)I]7 indexsqlite_autoindex_moz_bookmarks_deleted_1moz_bookmarks_deletedg''
tablemoz_bookmarksmoz_bookmarksCREATE TABLE moz_bookmarks ( id INTEGER PRIMARY KEY, type INTEGER, fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER, guid TEXT, syncStatus INTEGER NOT NULL DEFAULT 0, syncChangeCounter INTEGER NOT NULL DEFAULT 1)6-- tablemoz_inputhistorymoz_inputhistoryCREATE TABLE moz_inputhistory ( place_id INTEGER NOT NULL, input LONGVARCHAR NOT NULL, use_count INTEGER, PRIMARY KEY (place_id, input))?S- indexsqlite_autoindex_moz_inputhistory_1moz_inputhistoryC/!indexmoz_historyvisits_dateindexmoz_historyvisitsCREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits (visit_date)C/!indexmoz_historyvisits_fromindexmoz_historyvisitsCREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)M/?indexmoz_historyvisits_placedateindexmoz_historyvisitsCREATE INDEX moz_historyvisits_placedateindex ON moz_historyvisits (place_id, visit_date)f;;ctablemoz_historyvisits_extramoz_historyvisits_extraCREATE TABLE moz_historyvisits_extra ( visit_id INTEGER PRIMARY KEY NOT NULL, sync_json TEXT, FOREIGN KEY (visit_id) REFERENCES moz_historyvisits(id) ON DELETE CASCADE) //9tablemoz_historyvisitsmoz_historyvisitsCREATE TABLE moz_historyvisits ( id INTEGER PRIMARY KEY, from_visit INTEGER, place_id INTEGER, visit_date INTEGER, visit_type INTEGER, session INTEGER, source INTEGER DEFAULT 0 NOT NULL, triggeringPlaceId INTEGER)w C!indexmoz_places_altfrecencyindexmoz_places CREATE INDEX moz_places_altfrecencyindex ON moz_places (alt_frecency)n =! indexmoz_places_originidindexmoz_places CREATE INDEX moz_places_originidindex ON moz_places (origin_id)v
|
CREATE INDEX moz_places_lastvisitdateindex ON moz_places (last_visit_date)m=! indexmoz_places_frecencyindexmoz_places CREATE INDEX moz_places_frecencyindex ON moz_places (frecency)j7! indexmoz_places_visitcountmoz_placesCREATE INDEX moz_places_visitcount ON moz_places (visit_count)e5!indexmoz_places_hostindexmoz_placesCREATE INDEX moz_places_hostindex ON moz_places (rev_host)m=! indexmoz_places_url_hashindexmoz_placesCREATE INDEX moz_places_url_hashindex ON moz_places (url_hash)I--Etablemoz_places_extramoz_places_extraCREATE TABLE moz_places_extra ( place_id INTEGER PRIMARY KEY NOT NULL, sync_json TEXT, FOREIGN KEY (place_id) REFERENCES moz_places(id) ON DELETE CASCADE )g!!tablemoz_placesmoz_placesCREATE TABLE moz_places ( id INTEGER PRIMARY KEY, url LONGVARCHAR, title LONGVARCHAR, rev_host LONGVARCHAR, visit_count INTEGER DEFAULT 0, hidden INTEGER DEFAULT 0 NOT NULL, typed INTEGER DEFAULT 0 NOT NULL, frecency INTEGER DEFAULT -1 NOT NULL, last_visit_date INTEGER , guid TEXT, foreign_count INTEGER DEFAULT 0 NOT NULL, url_hash INTEGER DEFAULT 0 NOT NULL , description TEXT, preview_image_url TEXT, site_name TEXT, origin_id INTEGER REFERENCES moz_origins(id), recalc_frecency INTEGER NOT NULL DEFAULT 0, alt_frecency INTEGER, recalc_alt_frecency INTEGER NOT NULL DEFAULT 0)$##tablemoz_originsmoz_originsCREATE TABLE moz_origins ( id INTEGER PRIMARY KEY, prefix TEXT NOT NULL, host TEXT NOT NULL, frecency INTEGER NOT NULL, recalc_frecency INTEGER NOT NULL DEFAULT 0, alt_frecency INTEGER, recalc_alt_frecency INTEGER NOT NULL DEFAULT 0, UNIQUE (prefix, host) )5I# indexsqlite_autoindex_moz_origins_1moz_origins N +¸o $ 3 https://support.mozilla.orgb! + https://www.mozilla.org ! ' 7 https://start.firefoxchina.cnwÛ ! - https://portableapps.comb %
|
