Source code
Revision control
Copy as Markdown
Other Tools
SQLite format 3 @ ._ û û ↩ Û« * 3 http://example.com/exampled d. I https://www.mozilla.org/en-CA/d d# 3 http://mozilla.org/d d
® ®éÆ 3http://example.com/"Ihttps://www.mozilla.org/en-CA/3 http://mozilla.org/↩Û È Èì 'history_items )history_visits↩ { æ£{ v & ) AÅÏExample DomaindA _ AÅ eInternet for people, not profit - Mozillad ↩ AÅËd
ò üò÷
ñ ûñö ↩ ↩
↩ ↩ í í SafariAŲ
õ õ
Safari↩ ↩ ↩
ë ü÷ë example
Ò òâÒ AÅÏAÅ e↩ AÅË
ï ûõï
↩ø Ã !½↩Ï
»↩↩U â \ ±½ÃnøùF®dõS Ö H ø{ ( ;;gtablehistory_event_listenershistory_event_listeners CREATE TABLE history_event_listeners (listener_name TEXT PRIMARY KEY NOT NULL UNIQUE,last_seen REAL NOT NULL)M a; indexsqlite_autoindex_history_event_listeners_1history_event_listeners↩
;;Otablehistory_client_versionshistory_client_versions CREATE TABLE history_client_versions (client_version INTEGER PRIMARY KEY,last_seen REAL NOT NULL)S {tablemetadatametadata CREATE TABLE metadata (key TEXT NOT NULL UNIQUE, value)/ C indexsqlite_autoindex_metadata_1metadata
V11Wtablehistory_tombstoneshistory_tombstonesCREATE TABLE history_tombstones (id INTEGER PRIMARY KEY AUTOINCREMENT,start_time REAL NOT NULL,end_time REAL NOT NULL,url TEXT,generation INTEGER NOT NULL DEFAULT 0)
))itablehistory_visitshistory_visitsCREATE TABLE history_visits (id INTEGER PRIMARY KEY AUTOINCREMENT,history_item INTEGER NOT NULL REFERENCES history_items(id) ON DELETE CASCADE,visit_time REAL NOT NULL,title TEXT NULL,load_successful BOOLEAN NOT NULL DEFAULT 1,http_non_get BOOLEAN NOT NULL DEFAULT 0,synthesized BOOLEAN NOT NULL DEFAULT 0,redirect_source INTEGER NULL UNIQUE REFERENCES history_visits(id) ON DELETE CASCADE,redirect_destination INTEGER NULL UNIQUE REFERENCES history_visits(id) ON DELETE CASCADE,origin INTEGER NOT NULL DEFAULT 0,generation INTEGER NOT NULL DEFAULT 0,attributes INTEGER NOT NULL DEFAULT 0,score INTEGER NOT NULL DEFAULT 0);O) indexsqlite_autoindex_history_visits_2history_visits;O) indexsqlite_autoindex_history_visits_1history_visitsP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)''
qtablehistory_itemshistory_itemsCREATE TABLE history_items (id INTEGER PRIMARY KEY AUTOINCREMENT,url TEXT NOT NULL UNIQUE,domain_expansion TEXT NULL,visit_count INTEGER NOT NULL,daily_visit_counts BLOB NOT NULL,weekly_visit_counts BLOB NULL,autocomplete_triggers BLOB NULL,should_recompute_derived_visit_counts INTEGER NOT NULL,visit_count_score INTEGER NOT NULL,status_code INTEGER NOT NULL DEFAULT 0)9M' indexsqlite_autoindex_history_items_1history_items
↩ ý 56 Î ¡
¾
2
ý E1!indexhistory_tombstones__end_timehistory_tombstonesCREATE INDEX history_tombstones__end_time ON history_tombstones (end_time) I1)indexhistory_tombstones__generationhistory_tombstonesCREATE INDEX history_tombstones__generation ON history_tombstones (generation){9)!indexhistory_visits__originhistory_visitsCREATE INDEX history_visits__origin ON history_visits (origin, generation) A)aindexhistory_visits__last_visithistory_visitsCREATE INDEX history_visits__last_visit ON history_visits (history_item, visit_time DESC, synthesized ASC) K'-indexhistory_items__domain_expansionhistory_itemsCREATE INDEX history_items__domain_expansion ON history_items (domain_expansion)`?7Utriggerdecrement_count_on_deletehistory_items_to_tagsCREATE TRIGGER decrement_count_on_delete BEFORE DELETE ON history_items_to_tags BEGIN UPDATE history_tags SET item_count = item_count - 1 WHERE id = OLD.tag_id;END_?7Striggerincrement_count_on_inserthistory_items_to_tagsCREATE TRIGGER increment_count_on_insert AFTER INSERT ON history_items_to_tags BEGIN UPDATE history_tags SET item_count = item_count + 1 WHERE id = NEW.tag_id;ENDI]7 indexsqlite_autoindex_history_items_to_tags_1history_items_to_tagse77itablehistory_items_to_tagshistory_items_to_tagsCREATE TABLE history_items_to_tags (history_item INTEGER NOT NULL,tag_id INTEGER NOT NULL,timestamp REAL NOT NULL,FOREIGN KEY(tag_id) REFERENCES history_tags(id) ON DELETE CASCADE,FOREIGN KEY(history_item) REFERENCES history_items(id) ON DELETE CASCADE,UNIQUE(history_item, tag_id) ON CONFLICT REPLACE)|%%;tablehistory_tagshistory_tagsCREATE TABLE history_tags (id INTEGER PRIMARY KEY,type INTEGER NOT NULL,level INTEGER NOT NULL,identifier TEXT NOT NULL,title TEXT NOT NULL,modification_timestamp REAL NOT NULL,item_count INTEGER NOT NULL DEFAULT 0)H↩))Ktablehistory_eventshistory_eventsCREATE TABLE history_events (id INTEGER PRIMARY KEY AUTOINCREMENT,event_type TEXT NOT NULL,event_time REAL NOT NULL,pending_listeners TEXT NOT NULL,value BLOB)