Revision control
Copy as Markdown
SQLite format 3 @ 1 $ . .fê ö 1ûö n "Âjâ½OÛ| º7 à à UiC indexsqlite_autoindex_moz_historyvisit_tombstones_1moz_historyvisit_tombstones 5/)indexvisits_from_type_idxmoz_historyvisitsCREATE INDEX visits_from_type_idx ON moz_historyvisits(from_visit, visit_type)a%/}indexislocalindexmoz_historyvisitsCREATE INDEX islocalindex ON moz_historyvisits(is_local)] /{indexdateindexmoz_historyvisitsCREATE INDEX dateindex ON moz_historyvisits(visit_date)] /{indexfromindexmoz_historyvisitsCREATE INDEX fromindex ON moz_historyvisits(from_visit)r)/indexplacedateindexmoz_historyvisitsCREATE INDEX placedateindex ON moz_historyvisits(place_id, visit_date)k↩//tablemoz_historyvisitsmoz_historyvisitsCREATE TABLE moz_historyvisits (
id INTEGER PRIMARY KEY,
is_local INTEGER NOT NULL, -- XXX - not in desktop - will always be true for visits added locally, always false visits added by sync.
from_visit INTEGER, -- XXX - self-reference?
place_id INTEGER NOT NULL,
visit_date INTEGER NOT NULL,
visit_type INTEGER NOT NULL,
-- session INTEGER, -- XXX - what is 'session'? Appears unused.
unknown_fields TEXT,
FOREIGN KEY(place_id) REFERENCES moz_places(id) ON DELETE CASCADE,
FOREIGN KEY(from_visit) REFERENCES moz_historyvisits(id)
)" CCKtablemoz_places_stale_frecenciesmoz_places_stale_frecenciesCREATE TABLE moz_places_stale_frecencies (
place_id INTEGER PRIMARY KEY NOT NULL REFERENCES moz_places(id)
ON DELETE CASCADE,
stale_at INTEGER NOT NULL -- In milliseconds.
) 77)tablemoz_places_tombstonesmoz_places_tombstones↩CREATE TABLE moz_places_tombstones (
guid TEXT PRIMARY KEY
) WITHOUT ROWIDV
'!sindexoriginidindexmoz_places CREATE INDEX originidindex ON moz_places(origin_id)^ -!}indexguid_uniqueindexmoz_places CREATE UNIQUE INDEX guid_uniqueindex ON moz_places(guid)z=!#indexlastvisitdateremoteindexmoz_places
CREATE INDEX lastvisitdateremoteindex ON moz_places(last_visit_date_remote)w;! indexlastvisitdatelocalindexmoz_places CREATE INDEX lastvisitdatelocalindex ON moz_places(last_visit_date_local)U'!qindexfrecencyindexmoz_placesCREATE INDEX frecencyindex ON moz_places(frecency)f-! indexvisitcountremotemoz_placesCREATE INDEX visitcountremote ON moz_places(visit_count_remote)c+!indexvisitcountlocalmoz_placesCREATE INDEX visitcountlocal ON moz_places(visit_count_local)U'!qindexurl_hashindexmoz_placesCREATE INDEX url_hashindex ON moz_places(url_hash).!!'tablemoz_placesmoz_placesCREATE TABLE moz_places (
id INTEGER PRIMARY KEY,
url LONGVARCHAR NOT NULL,
title LONGVARCHAR,
-- note - desktop has rev_host here - that's now in moz_origin.
visit_count_local INTEGER NOT NULL DEFAULT 0,
visit_count_remote INTEGER NOT NULL DEFAULT 0,
hidden INTEGER DEFAULT 0 NOT NULL,
typed INTEGER DEFAULT 0 NOT NULL, -- XXX - is 'typed' ok? Note also we want this as a *count*, not a bool.
frecency INTEGER DEFAULT -1 NOT NULL,
-- XXX - splitting last visit into local and remote correct?
last_visit_date_local INTEGER NOT NULL DEFAULT 0,
last_visit_date_remote INTEGER NOT NULL DEFAULT 0,
guid TEXT NOT NULL UNIQUE,
foreign_count INTEGER DEFAULT 0 NOT NULL,
url_hash INTEGER DEFAULT 0 NOT NULL,
description TEXT, -- XXXX - title above?
preview_image_url TEXT,
-- origin_id would ideally be NOT NULL, but we use a trigger to keep
-- it up to date, so do perform the initial insert with a null.
origin_id INTEGER,
-- a couple of sync-related fields.
sync_status TINYINT NOT NULL DEFAULT 1, -- 1 is SyncStatus::New
sync_change_counter INTEGER NOT NULL DEFAULT 0, -- adding visits will increment this
unknown_fields TEXT,
FOREIGN KEY(origin_id) REFERENCES moz_origins(id) ON DELETE CASCADE
)3G! indexsqlite_autoindex_moz_places_1moz_place 0! / ↩ ± D↩×↩V↩ q 5c% https://www.cnn.com/Breaking News, Latest News and Videos | CNNh¼¨/DGPLto3GoPBw+peÞ;S 5) % https://www.bbc.com/BBC - Homepage4¼2IlUDm5r-Vkvgn+è§J¦ Im % https://www.mozilla.org/en-US/Internet for people, not profit â Mozilla (US)4¼vu0kxsz_oyTxx+jð¸k ;S % https://duckduckgo.com/DuckDuckGo â Privacy, simplified.4¼|KpA2EryoHiyBu+JhSüV ?% % https://getpocket.com/en/Pocket: Home4¼l'wgjGNToCqk7u+^W÷û r5c % https://www.cnn.com/Breaking News, Latest News and Videos | CNN¼¨/DGPLto3GoPBw+peÞ; A5 % https://ca.yahoo.com/?p=usYahoo | Mail, Weather, Search, News, Finance, Sports, Shopping, Entertainment, Video4¼³TZdaIQKxmmmJ+è M ; % https://www.google.com/Google4¼↩x_MeMT-dJE3Ev+Bü~ø
Îß𬽠%lUDm5r-Vkvgn%u0kxsz_oyTxx%pA2EryoHiyBu%wgjGNToCqk7u%DGPLto3GoPBw%TZdaIQKxmmmJ% _MeMT-dJE3Ev
´ öÊÕ¿àë´
+è§J¦
+jð¸
+JhSü
+^W÷û
+peÞ;
+è +Bü~ø
× ûõéãÝ×ï
Þ ü÷òíèãÞ
Ð úóåÞ×Ðì 4444h4 4
´ öëÕÊ¿´à
¼2I
¼v
¼|K
¼l'
¼¨/
¼³ ¼↩x
Þ ü÷òíèãÞ
Îß𬽠%lUDm5r-Vkvgn%u0kxsz_oyTxx%pA2EryoHiyBu%wgjGNToCqk7u%DGPLto3GoPBw%TZdaIQKxmmmJ% _MeMT-dJE3Ev
Ø üöðêäÞØ
↩ ↩ ê ðßμ«veSB0 ↩üê ¼¨/ ¼ ¼2I↩ ¼) ¼v ¼D
¼|K ¼{ ¼l' ¼i ¼ÈÛ ¼ºp ¼³ ¼Â ¼↩x ¼↩
3 õéÜϵ@3¨tgZM ¼¨/ ¼ ¼2I ¼)↩ ¼v ¼D ¼|K
¼{ ¼l' ¼i ¼ÈÛ ¼ºp ¼³ ¼Â ¼↩x
¼↩
± ü÷òíèãÞÙÔÏÊÅÀ»¶± ↩
Q öëàÕÊ¿´©}rg\Q
¼¨/
¼
¼2I
¼)↩
¼v
¼D
¼|K
¼{
¼l'
¼i
¼ÈÛ
¼ºp
¼³
¼Â
¼↩x ¼↩
± ü÷òíèãÞÙÔÏÊÅÀ»¶± ↩
ûîáÔǺ ôçÚÍÀ³¦ ↩
↩
↩
↩ Õª|M , % mobile¼÷¼÷mobile______- % unfiled¼÷¼÷unfiled_____, % toolbar¼÷¼÷toolbar_____) % menu¼÷¼÷menu________) % root¼÷¼÷root________
¬ ߬ðν %mobile______%unfiled_____%toolbar_____%menu________% root________
Å õéÝÑÅ ¼÷ ¼÷ ¼÷ ¼÷
¼÷
↩ Ç Ñ¦}P!ðÇ ' #%https://www.bbc.commoc.cbb.www.3/ +-https://www.mozilla.orggro.allizom.www.3- )+https://duckduckgo.commoc.ogkcudkcud.3+ ')https://getpocket.commoc.tekcopteg.3' #%https://www.cnn.commoc.nnc.www.g) %'https://ca.yahoo.commoc.oohay.ac.3- )+https://www.google.commoc.elgoog.www.3
E Ë{E²å^ #https://www.bbc.com +https://www.mozilla.org )https://duckduckgo.com 'https://getpocket.com #https://www.cnn.com %https://ca.yahoo.com ) https://www.google.com
} }íÊ£Û· %moc.cbb.www.-gro.allizom.www.+moc.ogkcudkcud.)moc.tekcopteg.%moc.nnc.www.'moc.oohay.ac.+ moc.elgoog.www.
¬ y yÚ 7origin_frecency_count3origin_frecency_sumA .origin_frecency_$Iorigin_frecency_sum_of%Iorigin_frecency_sum_of_squares fg↩
↩
↩
↩ K çͳeK ¼2K¼2K ¼x¼x ¼|M¼|M ¼l*¼l* ¼Èß¼Êû ¼¶¼¶ ¼↩~¼↩~↩
↩ø |
Ã
; Ö n "Âjâ½OÛ| º7 à à UiC indexsqlite_au øâiC indexsqlite_autoindex_moz_historyvisit_tombstones_1moz_historyvisit_tombstones 5/)indexvisits_from_type_idxmoz_historyvisitsCREATE INDEX visits_from_type_idx ON moz_historyvisits(from_visit, visit_type)a%/}indexislocalindexmoz_historyvisitsCREATE INDEX islocalindex ON moz_historyvisits(is_local)] /{indexdateindexmoz_historyvisitsCREATE INDEX dateindex ON moz_historyvisits(visit_date)] /{indexfromindexmoz_historyvisitsCREATE INDEX fromindex ON moz_historyvisits(from_visit)r)/indexplacedateindexmoz_historyvisitsCREATE INDEX placedateindex ON moz_historyvisits(place_id, visit_date)k↩//tablemoz_historyvisitsmoz_historyvisitsCREATE TABLE moz_historyvisits (
id INTEGER PRIMARY KEY,
is_local INTEGER NOT NULL, -- XXX - not in desktop - will always be true for visits added locally, always false visits added by sync.
from_visit INTEGER, -- XXX - self-reference?
place_id INTEGER NOT NULL,
visit_date INTEGER NOT NULL,
visit_type INTEGER NOT NULL,
-- session INTEGER, -- XXX - what is 'session'? Appears unused.
unknown_fields TEXT,
FOREIGN KEY(place_id) REFERENCES moz_places(id) ON DELETE CASCADE,
FOREIGN KEY(from_visit) REFERENCES moz_historyvisits(id)
)" CCKtablemoz_places_stale_frecenciesmoz_places_stale_frecenciesCREATE TABLE moz_places_stale_frecencies (
place_id INTEGER PRIMARY KEY NOT NULL REFERENCES moz_places(id)
ON DELETE CASCADE,
stale_at INTEGER NOT NULL -- In milliseconds.
) 77)tablemoz_places_tombstonesmoz_places_tombstones↩CREATE TABLE moz_places_tombstones (
guid TEXT PRIMARY KEY
) WITHOUT ROWIDV
'!sindexoriginidindexmoz_places CREATE INDEX originidindex ON moz_places(origin_id)^ -!}indexguid_uniqueindexmoz_places CREATE UNIQUE INDEX guid_uniqueindex ON moz_places(guid)z=!#indexlastvisitdateremoteindexmoz_places
CREATE INDEX lastvisitdateremoteindex ON moz_places(last_visit_date_remote)w;! indexlastvisitdatelocalindexmoz_places CREATE INDEX lastvisitdatelocalindex ON moz_places(last_visit_date_local)U'!qindexfrecencyindexmoz_placesCREATE INDEX frecencyindex ON moz_places(frecency)f-! indexvisitcountremotemoz_placesCREATE INDEX visitcountremote ON moz_places(visit_count_remote)c+!indexvisitcountlocalmoz_placesCREATE INDEX visitcountlocal ON moz_places(visit_count_local)U'!qindexurl_hashindexmoz_placesCREATE INDEX url_hashindex ON moz_places(url_hash).!!'tablemoz_placesmoz_placesCREATE TABLE moz_places (
id INTEGER PRIMARY KEY,
url LONGVARCHAR NOT NULL,
title LONGVARCHAR,
-- note - desktop has rev_host here - that's now in moz_origin.
visit_count_local INTEGER NOT NULL DEFAULT 0,
visit_count_remote INTEGER NOT NULL DEFAULT 0,
hidden INTEGER DEFAULT 0 NOT NULL,
typed INTEGER DEFAULT 0 NOT NULL, -- XXX - is 'typed' ok? Note also we want this as a *count*, not a bool.
frecency INTEGER DEFAULT -1 NOT NULL,
-- XXX - splitting last visit into local and remote correct?
last_visit_date_local INTEGER NOT NULL DEFAULT 0,
last_visit_date_remote INTEGER NOT NULL DEFAULT 0,
guid TEXT NOT NULL UNIQUE,
foreign_count INTEGER DEFAULT 0 NOT NULL,
url_hash INTEGER DEFAULT 0 NOT NULL,
description TEXT, -- XXXX - title above?
preview_image_url TEXT,
-- origin_id would ideally be NOT NULL, but we use a trigger to keep
-- it up to date, so do perform the initial insert with a null.
origin_id INTEGER,
-- a couple of sync-related fields.
sync_status TINYINT NOT NULL DEFAULT 1, -- 1 is SyncStatus::New
sync_change_counter INTEGER NOT NULL DEFAULT 0, -- adding visits will increment this
unknown_fields TEXT,
FOREIGN KEY(origin_id) REFERENCES moz_origins(id) ON DELETE CASCADE
)3G! indexsqlite_autoindex_moz_places_1moz_places ↩÷ ]
[ ø uVÿ¥¶ÌjV¬ ]u¯<¨w↩b ↩b↩↩ ##qtablemoz_originsmoz_origins CREATE TABLE moz_origins (
id INTEGER PRIMARY KEY,
prefix TEXT NOT NULL,
host TEXT NOT NULL,
rev_host TEXT NOT NULL,
frecency INTEGER NOT NULL, -- XXX - why not default of -1 like in moz_places?
UNIQUE (prefix, host)
)5 I# indexsqlite_autoindex_moz_origins_1moz_origins '77mtablemoz_bookmarks_deletedmoz_bookmarks_deleted CREATE TABLE moz_bookmarks_deleted (
guid TEXT PRIMARY KEY,
dateRemoved INTEGER NOT NULL
) WITHOUT ROWIDt7'indexitemlastmodifiedindexmoz_bookmarksCREATE INDEX itemlastmodifiedindex ON moz_bookmarks(fk, lastModified)''utablemoz_bookmarksmoz_bookmarksCREATE TABLE moz_bookmarks (
id INTEGER PRIMARY KEY,
fk INTEGER DEFAULT NULL, -- place_id
type INTEGER NOT NULL,
parent INTEGER,
position INTEGER NOT NULL,
dateAdded INTEGER NOT NULL DEFAULT 0,
lastModified INTEGER NOT NULL DEFAULT 0,
guid TEXT NOT NULL UNIQUE CHECK(length(guid) == 12),
syncStatus INTEGER NOT NULL DEFAULT 0,
syncChangeCounter INTEGER NOT NULL DEFAULT 1,
-- bookmarks must have a fk to a URL, other types must not.
CHECK((type == 1 AND fk IS NOT NULL) OR (type > 1 AND fk IS NULL))
-- only the root is allowed to have a non-null parent
CHECK(guid == "root________" OR parent IS NOT NULL)
FOREIGN KEY(fk) REFERENCES moz_places(id) ON DELETE RESTRICT
FOREIGN KEY(parent) REFERENCES moz_bookmarks(id) ON DELETE CASCADE
)9M' indexsqlite_autoindex_moz_bookmarks_1moz_bookmarks--Otablemoz_inputhistorymoz_inputhistoryCREATE TABLE moz_inputhistory (
place_id INTEGER NOT NULL,
input LONGVARCHAR NOT NULL,
use_count INTEGER,
PRIMARY KEY (place_id, input),
FOREIGN KEY(place_id) REFERENCES moz_places(id) ON DELETE CASCADE
)?S- indexsqlite_autoindex_moz_inputhistory_1moz_inputhistory
º UiC indexsqlite_autoindex_moz_historyvisit_tombstones_1moz_historyvisit_tombstones CC?tablemoz_historyvisit_tombstonesmoz_historyvisit_tombstonesCREATE TABLE moz_historyvisit_tombstones (
place_id INTEGER NOT NULL,
visit_date INTEGER NOT NULL,
FOREIGN KEY(place_id) REFERENCES moz_places(id) ON DELETE CASCADE,
PRIMARY KEY(place_id, visit_date)
) 5/)indexvisits_from_type_idxmoz_historyvisitsCREATE INDEX visits_from_type_idx ON moz_historyvisits(from_visit, visit_type)a%/}indexislocalindexmoz_historyvisitsCREATE INDEX islocalindex ON moz_historyvisits(is_local)] /{indexdateindexmoz_historyvisitsCREATE INDEX dateindex ON moz_historyvisits(visit_date) ¨ /{indexfromindexmoz_historyvisitsCREATE INDEX fromindex ON moz_historyvisits(from_visit)r)/indexplacedateindexmoz_historyvisitsCREATE INDEX placedateindex ON moz_historyvisits(place_id, visit_date) s//tablemoz_historyvisitsmoz_historyvisitsCREATE TABLE moz_historyvisits (
id INTEGER PRIMARY KEY,
is_local INTEGER NOT NULL, -- XXX - not in desktop - will always be true for visits added locally, always false visits added by sync.
from_visit INTEGER, -- XXX - self-reference?
place_id INTEGER NOT NULL,
visit_date INTEGER NOT NULL,
visit_type INTEGER NOT NULL,
G#[5 indexsqlite_autoindex_moz_bookmarks_synced_1moz_bookmarks_synced%!//Stablemoz_tags_relationmoz_tags_relation#CREATE TABLE moz_tags_relation(
tag_id INTEGER NOT NULL REFERENCES moz_tags(id) ON DELETE CASCADE,
place_id INTEGER NOT NULL REFERENCES moz_places(id) ON DELETE CASCADE,
PRIMARY KEY(tag_id, place_id)
) WITHOUT ROWID/ C indexsqlite_autoindex_moz_tags_1moz_tags" utablemoz_tagsmoz_tags!CREATE TABLE moz_tags(
id INTEGER PRIMARY KEY,
tag TEXT UNIQUE NOT NULL,
lastModified INTEGER NOT NULL
)q 5tablemoz_metamoz_meta CREATE TABLE moz_meta (
key TEXT PRIMARY KEY,
value NOT NULL
) WITHOUT ROWIDO #kindexhostindexmoz_origins CREATE INDEX hostindex ON moz_origins(rev_host)↩ W ù°,MS WÚ 0*33tablemoz_places_metadatamoz_places_metadata,CREATE TABLE moz_places_metadata (
id INTEGER PRIMARY KEY,
created_at INTEGER NOT NULL DEFAULT 0,
updated_at INTEGER NOT NULL DEFAULT 0,
place_id INTEGER NOT NULL,
total_view_time INTEGER NOT NULL DEFAULT 0, -- a rolling aggregate
search_query_id INTEGER,
referrer_place_id INTEGER,
document_type INTEGER NOT NULL DEFAULT 0, -- 0=generic, 1=media
typing_time INTEGER NOT NULL DEFAULT 0,
key_presses INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY(place_id) REFERENCES moz_places(id) ON DELETE CASCADE,
FOREIGN KEY(search_query_id) REFERENCES moz_places_metadata_search_queries(id) ON DELETE CASCADE,
FOREIGN KEY(referrer_place_id) REFERENCES moz_places(id) ON DELETE CASCADE
CHECK(place_id != referrer_place_id)
)F(%%Otablemoz_keywordsmoz_keywords*CREATE TABLE moz_keywords(
place_id INTEGER PRIMARY KEY REFERENCES moz_places(id)
ON DELETE RESTRICT,
keyword TEXT NOT NULL UNIQUE
)7)K% indexsqlite_autoindex_moz_keywords_1moz_keywords+↩+ }'OOitablemoz_bookmarks_synced_tag_relationmoz_bookmarks_synced_tag_relation)CREATE TABLE moz_bookmarks_synced_tag_relation(
itemId INTEGER NOT NULL REFERENCES moz_bookmarks_synced(id)
ON DELETE CASCADE,
tagId INTEGER NOT NULL REFERENCES moz_tags(id)
ON DELETE CASCADE,
PRIMARY KEY(itemId, tagId)
) WITHOUT ROWID6&IIgtablemoz_bookmarks_synced_structuremoz_bookmarks_synced_structure(CREATE TABLE moz_bookmarks_synced_structure(
guid TEXT,
parentGuid TEXT REFERENCES moz_bookmarks_synced(guid)
ON DELETE CASCADE,
position INTEGER NOT NULL,
PRIMARY KEY(parentGuid, guid)
) WITHOUT ROWID\%G5Iindexmoz_bookmarks_synced_keywordsmoz_bookmarks_synced'CREATE INDEX moz_bookmarks_synced_keywords ON moz_bookmarks_synced(keyword)
WHERE keyword NOT NULL$?5indexmoz_bookmarks_synced_urlsmoz_bookmarks_synced&CREATE INDEX moz_bookmarks_synced_urls ON moz_bookmarks_synced(placeId)G#[5 indexsqlite_autoindex_moz_bookmarks_synced_1moz_bookmarks_synced%/"55tablemoz_bookmarks_syncedmoz_bookmarks_synced$CREATE TABLE moz_bookmarks_synced(
id INTEGER PRIMARY KEY,
-- We intentionally don't validate GUIDs, as we allow and fix up invalid
-- ones.
guid TEXT UNIQUE NOT NULL,
-- The `parentid` from the record.
parentGuid TEXT,
-- The server modified time, in milliseconds. This is *not* a
-- ServerTimestamp, which is in fractional seconds.
serverModified INTEGER NOT NULL DEFAULT 0,
needsMerge BOOLEAN NOT NULL DEFAULT 0,
validity INTEGER NOT NULL DEFAULT 1, -- SyncValidity::Valid
isDeleted BOOLEAN NOT NULL DEFAULT 0,
kind INTEGER NOT NULL DEFAULT -1,
-- The creation date, in milliseconds.
dateAdded INTEGER NOT NULL DEFAULT 0,
title TEXT,
placeId INTEGER REFERENCES moz_places(id)
ON DELETE SET NULL,
keyword TEXT,
description TEXT,
loadInSidebar BOOLEAN,
smartBookmarkName TEXT,
feedURL TEXT,
siteURL TEXT,
-- All unknown fields from the server record, encoded as a JSON object.
unknownFields TEXT
) ¯//Stablemoz_tags_relationmoz_tags_relation#CREATE TABLE moz_tags_relation(
tag_id INTEGER NOT NULL REFERENCES moz_tags(id) ON DELETE CASCADE,
place_id INTEGER NOT NULL REFERENCES moz_places(id) ON DELETE CASCADE,
PRIMARY KEY(tag_id, place_id)
) WITHOUT ROWID/ C indexsqlite_autoindex_moz_tags_1moz_tags" utablemoz_tagsmoz_tags!CREATE TABLE moz_tags(
id INTEGER PRIMARY KEY,
tag TEXT UNIQUE NO>+QQgtablemoz_places_metadata_search_queriesmoz_places_metadata_search_queries-CREATE TABLE moz_places_metadata_search_queries (
id INTEGER PRIMARY KEY,
term TEXT NOT NULL UNIQUE
)c,wQ indexsqlite_autoindex_moz_places_metadata_search_queries_1moz_places_metadata_search_queries.