API tools faq
paste
mzso

places.sqlite

mzso
Mar 17th, 2022
180
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.34 KB | None | 0 0
raw download clone embed print report
  1. CREATE 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 DEFAULT 0 NOT NULL, syncChangeCounter INTEGER DEFAULT 1 NOT NULL);
  2. CREATE TABLE moz_keywords (id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE, place_id INTEGER, post_data TEXT);
  3. CREATE TABLE sqlite_sequence(name,seq);
  4. CREATE TABLE moz_annos (id INTEGER PRIMARY KEY,place_id INTEGER NOT NULL,anno_attribute_id INTEGER,mime_type VARCHAR(32) DEFAULT NULL,content LONGVARCHAR, flags INTEGER DEFAULT 0,expiration INTEGER DEFAULT 0,TYPE INTEGER DEFAULT 0,dateAdded INTEGER DEFAULT 0,lastModified INTEGER DEFAULT 0);
  5. CREATE TABLE moz_anno_attributes (id INTEGER PRIMARY KEY,name VARCHAR(32) UNIQUE NOT NULL);
  6. CREATE TABLE moz_items_annos (id INTEGER PRIMARY KEY,item_id INTEGER NOT NULL,anno_attribute_id INTEGER,mime_type VARCHAR(32) DEFAULT NULL,content LONGVARCHAR, flags INTEGER DEFAULT 0,expiration INTEGER DEFAULT 0,TYPE INTEGER DEFAULT 0,dateAdded INTEGER DEFAULT 0,lastModified INTEGER DEFAULT 0);
  7. CREATE 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, favicon_id INTEGER, 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, origin_id INTEGER REFERENCES moz_origins(id), site_name TEXT);
  8. CREATE TABLE moz_historyvisits (id INTEGER PRIMARY KEY, from_visit INTEGER, place_id INTEGER, visit_date INTEGER, visit_type INTEGER, SESSION INTEGER);
  9. CREATE TABLE moz_inputhistory (place_id INTEGER NOT NULL, INPUT LONGVARCHAR NOT NULL, use_count INTEGER, PRIMARY KEY (place_id, INPUT));
  10. CREATE TABLE sqlite_stat1(tbl,idx,stat);
  11. CREATE TABLE moz_hosts (  id INTEGER PRIMARY KEY, host TEXT NOT NULL UNIQUE, frecency INTEGER, typed NOT NULL DEFAULT 0, prefix);
  12. CREATE TABLE moz_bookmarks_deleted (  guid TEXT PRIMARY KEY, dateRemoved INTEGER NOT NULL DEFAULT 0);
  13. CREATE TABLE moz_meta (KEY TEXT PRIMARY KEY, VALUE NOT NULL) WITHOUT ROWID ;
  14. CREATE TABLE moz_origins ( id INTEGER PRIMARY KEY, prefix TEXT NOT NULL, host TEXT NOT NULL, frecency INTEGER NOT NULL, UNIQUE (prefix, host) );
  15. 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) );
  16. CREATE TABLE moz_places_metadata_search_queries ( id INTEGER PRIMARY KEY, terms TEXT NOT NULL UNIQUE );
  17. CREATE TABLE moz_places_metadata_snapshots (   place_id INTEGER PRIMARY KEY,   created_at INTEGER NOT NULL,   removed_at INTEGER,   first_interaction_at INTEGER NOT NULL,   last_interaction_at INTEGER NOT NULL,   document_type INTEGER NOT NULL DEFAULT 0,   user_persisted INTEGER NOT NULL DEFAULT 0,   FOREIGN KEY (place_id) REFERENCES moz_places(id) ON DELETE CASCADE );
  18. CREATE TABLE moz_places_metadata_snapshots_extra (   place_id INTEGER NOT NULL,   TYPE INTEGER NOT NULL DEFAULT 0,   DATA TEXT NOT NULL,   PRIMARY KEY (place_id, TYPE),   FOREIGN KEY (place_id) REFERENCES moz_places_metadata_snapshots(place_id) ON DELETE CASCADE ) WITHOUT ROWID ;
  19. CREATE TABLE moz_places_metadata_snapshots_groups (   id INTEGER PRIMARY KEY,   title TEXT NOT NULL );
  20. CREATE TABLE moz_places_metadata_groups_to_snapshots (   group_id INTEGER NOT NULL,   place_id INTEGER NOT NULL,   PRIMARY KEY (group_id, place_id),   FOREIGN KEY (group_id) REFERENCES     moz_places_metadata_snapshots_groups(id) ON DELETE CASCADE,   FOREIGN KEY (place_id) REFERENCES     moz_places_metadata_snapshots(place_id) ON DELETE CASCADE ) WITHOUT ROWID;
  21. CREATE TABLE moz_session_metadata (   id INTEGER PRIMARY KEY,   guid TEXT NOT NULL UNIQUE,   last_saved_at INTEGER NOT NULL DEFAULT 0,   DATA TEXT );
  22. CREATE TABLE moz_session_to_places (   session_id INTEGER NOT NULL,   place_id INTEGER NOT NULL ,   POSITION INTEGER,   PRIMARY KEY (session_id, place_id),   FOREIGN KEY (place_id) REFERENCES moz_places(id) ON DELETE CASCADE   FOREIGN KEY (session_id) REFERENCES moz_session_metadata(id) ON DELETE CASCADE ) WITHOUT ROWID;
  23. CREATE TABLE moz_previews_tombstones (   hash TEXT PRIMARY KEY ) WITHOUT ROWID;
  24. CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk,TYPE);
  25. CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent,POSITION);
  26. CREATE INDEX moz_places_hostindex ON moz_places (rev_host);
  27. CREATE INDEX moz_places_visitcount ON moz_places (visit_count);
  28. CREATE INDEX moz_places_frecencyindex ON moz_places (frecency);
  29. CREATE INDEX moz_historyvisits_placedateindex ON moz_historyvisits (place_id, visit_date);
  30. CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit);
  31. CREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits (visit_date);
  32. CREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModified);
  33. CREATE INDEX moz_places_lastvisitdateindex ON moz_places (last_visit_date);
  34. CREATE INDEX moz_places_url_hashindex ON moz_places (url_hash);
  35. CREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id);
  36. CREATE UNIQUE INDEX moz_items_annos_itemattributeindex ON moz_items_annos (item_id, anno_attribute_id);
  37. CREATE UNIQUE INDEX moz_bookmarks_guid_uniqueindex ON moz_bookmarks (guid);
  38. CREATE UNIQUE INDEX moz_places_guid_uniqueindex ON moz_places (guid);
  39. CREATE UNIQUE INDEX moz_keywords_placepostdata_uniqueindex ON moz_keywords (place_id, post_data);
  40. CREATE INDEX moz_bookmarks_dateaddedindex ON moz_bookmarks (dateAdded);
  41. CREATE INDEX moz_places_originidindex ON moz_places (origin_id);
  42. CREATE UNIQUE INDEX moz_places_metadata_placecreated_uniqueindex ON moz_places_metadata (place_id, created_at);
  43.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!