Revision control
Copy as Markdown
SQLite format 3 @ ' ¼ @ v % / ' ._ ö 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_placesCREATE INDEX originidindex ON moz_places(origin_id)^ -!}indexguid_uniqueindexmoz_placesCREATE 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! 2
L: µûöðêäÞØÒÌÆÀº´®¨¢~xrlf`ZTNHB<60*$ úôîèâÜÖÐÊľ¸²¬¦ |vpjd^XRLF@: üz nF ] ( #t A » UX " o ;
³S Ò l 9 Q ø i ±3 v K ! ic ä. z E ð £] »* æv B @ á[ ë' ¬t ↩A å ÉX æ$ o : ô öR ¦i 4 ^ ¬M e 2 u} ½J ± Lc . z _E r i
[
' ts = | \T } ~l o9 x Q âi 34µ ê2^HàÊö½ #O§9t{eêÔ A%7mZ8By9VHgX0m 8%5LhwN6inmQcC X%Bj1XebVLwI9I# %9PBiuR6qzgJ2 ^ Æ%kPZ6ThpsQwmC [%EXZycr7TU6bm } %SvtXncIfylSG? %KH8WfdvBPEEf↩\ e%HPpQsAkAFfLGt u%N6IisrfZE7Ch 7%2vZgPtQhjl6h %W5EnSkYpVZXhØ °%eZPGpzLI76i9, ®%ZJEByzbPWoyV Ï%qwumToFRlj9D È%nhZQeaZj1pvqÚ ¸%hBrmWKxiTBnB3 %bWrkDhmYTTS9õ {%Q8poj0M2FvlhÓ ý%wxySGGy20DIg ã%tl3nqFql7KcIZ ° öìâØÎĺ° ò↩Ö ÖV Â
¨Õ kS P OÑ ° öìâØÎĺ° ñ↩Ö ÕV Á
§Õ jS N MÑ ° öìâØÎĺ° ð↩Ö ÔV À
¥Õ
hS L KÑ õêßÔɾ³¨ öÿ↩Ú Üÿ
Éÿ
÷ ´ÿ h ÿÙ wÿJ aÿ» Cÿ, Bÿ "ðàÐÀ° p`P@0 r
ò úr
çr
↩ Ùr
Ìr
ºr
²r
r
r
r
nr
^r
↩ Ur
<r
;r
~
° öìâØÎĺ° ï↩Ö ÒV ¿
¤Õ gS J Iѵ é2^HàÊö½ #O§9t{eêÔ ?%7mZ8By9VHgX0m 6%5LhwN6inmQcC W%Bj1XebVLwI9I# %9PBiuR6qzgJ2 ^ Å%kPZ6ThpsQwmC Z%EXZycr7TU6bm } %SvtXncIfylSG? ÿ%KH8WfdvBPEEf↩\ d%HPpQsAkAFfLGt s%N6IisrfZE7Ch 5%2vZgPtQhjl6h %W5EnSkYpVZXhØ ¯%eZPGpzLI76i9, %ZJEByzbPWoyV Î%qwumToFRlj9D Ç%nhZQeaZj1pvqÚ ·%hBrmWKxiTBnB3 %bWrkDhmYTTS9õ z%Q8poj0M2FvlhÓ ü%wxySGGy20DIg â%tl3nqFql7KcIZ ° öìâØÎĺ° î ↩Ö Ñ V ¾
£ Õ f S H G Ñ