Source code
Revision control
Copy as Markdown
Other Tools
SQLite format 3 @ } } .K û û ê d ¹ Å
Û v
ü Ó ýJ²¾0¨ § _?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;END{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)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) K'-indexhistory_items__domain_expansionhistory_itemsCREATE INDEX history_items__domain_expansion ON history_items (domain_expansion)e77itablehistory_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)I]7 indexsqlite_autoindex_history_items_to_tags_1history_items_to_tags|%%;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)
))itablehistory_visitshistory_visits CREATE 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_visits↩H
))Ktablehistory_eventshistory_events CREATE 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);;Gtablehistory_event_listenershistory_event_listeners CREATE TABLE history_event_listeners (listener_name TEXT PRIMARY KEY,last_seen REAL NOT NULL)M a; indexsqlite_autoindex_history_event_listeners_1history_event_listeners
;;Otablehistory_client_versionshistory_client_versionsCREATE TABLE history_client_versions (client_version INTEGER PRIMARY KEY,last_seen REAL NOT NULL)S {tablemetadatametadataCREATE TABLE metadata (key TEXT NOT NULL UNIQUE, value)/C indexsqlite_autoindex_metadata_1metadataV11Wtablehistory_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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)%'' tablehistory_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 DEFAULT 0, status_code INTEGER NOT NULL DEFAULT 0)9M' indexsqlite_autoindex_history_items_1history_items ↩ ¶ ¹h ©6↩ô↩°↩[ þ ¾ x + ð ¥ \
7 ß ²a ¶ O¯¢ u! https://duckduckgo.com/?q=server+ext4+vs+btrfs&t=osxduckduckgod dT¯¢ ! https://duckduckgo.com/?q=server+ext4+vs+xfs&t=osx&ia=webduckduckgod dM¯¢ q! https://duckduckgo.com/?q=server+ext4+vs+xfs&t=osxduckduckgod dc¯¢ https://askubuntu.com/questions/141013/xfs-or-ext4-on-external-hard-driveaskubuntud db¯¢ + https://www.partitionwizard.com/partitionmanager/xfs-vs-ext4.htmlpartitionwizardd d\¯¢ ↩! https://duckduckgo.com/?q=ubuntu+server+ext4+vs+xfs&t=osx&ia=webduckduckgod dT¯¢ ! https://duckduckgo.com/?q=ubuntu+server+ext4+vs+xfs&t=osxduckduckgod dd¯¢ + https://www.partitionwizard.com/partitionmanager/btrfs-vs-ext4.htmlpartitionwizardd d^¯¢ ! https://duckduckgo.com/?q=ubuntu+server+ext4+vs+btrfs&t=osx&ia=webduckduckgo} }W¯¢ ! https://duckduckgo.com/?q=ubuntu+server+ext4+vs+btrfs&t=osxduckduckgod dE¯¢ U/ http://de.archive.ubuntu.com/ubuntu/de.archive.ubuntud dG¯¢ U/ http://us.archive.ubuntu.com/ubuntu/us.archive.ubuntud È7¯¢ [ https://launchpad.net/ubuntu/+cdmirrorsd dI¯¢ o https://ubuntu.com/download/alternative-downloadsubuntud ÈB¯¢ m http://<country-code>.archive.ubuntu.com/ubuntu/d d<¯¢ K# https://wiki.ubuntu.com/Mirrorswiki.ubuntud ÈY¯¢ ! https://duckduckgo.com/?q=ubuntu+archive+mirrors&t=osx&ia=webduckduckgod dQ¯¢ y! https://duckduckgo.com/?q=ubuntu+archive+mirrors&t=osxduckduckgod d@¯¢ O) http://archive.ubuntu.com/ubuntu/archive.ubuntu} }>¯¢↩ M) http://archive.ubuntu.com/ubuntuarchive.ubuntud do¯¢ 7 https://askubuntu.com/questions/584054/how-do-i-configure-the-search-domain-correctlyaskubuntud d_¯¢ ! https://duckduckgo.com/?q=ubuntu+server+search+domains&t=osx&ia=webduckduckgod dX¯¢
! https://duckduckgo.com/?q=ubuntu+server+search+domains&t=osxduckduckgod dM¯¢ a/ https://www.subnet-calculator.com/cidr.phpsubnet-calculatord áC¯¢ Q/ https://www.subnet-calculator.com/subnet-calculatord d
" É¢zO$Óv;↩Â↩
↩@ ý ³ s + ç n 6
Å
|
S
" 0ahttps://www.subnet-calculator.com/cidr.php Ñ (Qhttps://www.subnet-calculator.com/ ÑHhttps://www.partitionwizard.com/partitionmanager/xfs-vs-ext4.html Ñ Jhttps://www.partitionwizard.com/partitionmanager/btrfs-vs-ext4.html Ñ%Khttps://wiki.ubuntu.com/Mirrors Ñ7ohttps://ubuntu.com/download/alternative-downloads Ñ-[https://launchpad.net/ubuntu/+cdmirrors ÑJhttps://duckduckgo.com/?q=ubuntu+server+search+domains&t=osx&ia=web Ñ Chttps://duckduckgo.com/?q=ubuntu+server+search+domains&t=osx Ñ
G↩https://duckduckgo.com/?q=ubuntu+server+ext4+vs+xfs&t=osx&ia=web Ñ?https://duckduckgo.com/?q=ubuntu+server+ext4+vs+xfs&t=osx ÑIhttps://duckduckgo.com/?q=ubuntu+server+ext4+vs+btrfs&t=osx&ia=web ÑBhttps://duckduckgo.com/?q=ubuntu+server+ext4+vs+btrfs&t=osx ÑDhttps://duckduckgo.com/?q=ubuntu+archive+mirrors&t=osx&ia=web Ñ<yhttps://duckduckgo.com/?q=ubuntu+archive+mirrors&t=osx Ñ?https://duckduckgo.com/?q=server+ext4+vs+xfs&t=osx&ia=web Ñ 8qhttps://duckduckgo.com/?q=server+ext4+vs+xfs&t=osx Ñ :uhttps://duckduckgo.com/?q=server+ext4+vs+btrfs&t=osx Ñ \7https://askubuntu.com/questions/584054/how-do-i-configure-the-search-domain-correctly Ñ P https://askubuntu.com/questions/141013/xfs-or-ext4-on-external-hard-drive Ñ *Uhttp://us.archive.ubuntu.com/ubuntu/ Ñ*Uhttp://de.archive.ubuntu.com/ubuntu/ Ñ'Ohttp://archive.ubuntu.com/ubuntu/ Ñ&Mhttp://archive.ubuntu.com/ubuntu Ñ↩6mhttp://<country-code>.archive.ubuntu.com/ubuntu/ Ñ↩ ¼ ëÒ¼ )history_visits1history_tombstonesê'history_items↩##↩ ↩ Þ Þ 7last_maintenance_dateAÅEWò
æ æ 7last_maintenance_date↩ ↩ ì ì ÈOSafariAÅê'Dh
ô ô Safari$O↩ ↩ 7ë ¹rT Ä|4↩Ì↩«↩z↩2↩ Ò N Ù » y 7
û
Í
p
B
$ Ý O Ä9ÖLÈDÿ¤_ù»}?!á¡Z'ë 8×Æ] I ÑAÄQZ=ÇAlternative downloads | Ubuntud/×ÆZ 7 ÑAÄQZ=*·Mirrors - Ubuntu WikidC×Æ3 _ Ñ AÄQZ=*àOnline IP CIDR / VLSM Supernet Calculatord<Óó Q Ñ AÄQá~server ext4 vs btrfs at DuckDuckGo<Óó Q Ñ AÄQjõäserver ext4 vs btrfs at DuckDuckGoÓó ↩ Ñ AÄQe7md:Óó M Ñ AÄQøserver ext4 vs xfs at DuckDuckGo:Óó M Ñ AÄQâ¨server ext4 vs xfs at DuckDuckGod:Óó↩ M Ñ AÄQÖFñserver ext4 vs xfs at DuckDuckGoÓó ↩ Ñ AÄQÇëddDÓó _ ÑAÄQ
Uaxubuntu server ext4 vs btrfs at DuckDuckGoAÓó
[ ÑAÄQc_Wubuntu server ext4 vs xfs at DuckDuckGoWÓó Ñ AÄQv·filesystem - XFS or ext4 on external hard drive - Ask UbuntudAÓó [ ÑAÄQ'ÏÄubuntu server ext4 vs xfs at DuckDuckGoAÓó [ ÑAÄQFubuntu server ext4 vs xfs at DuckDuckGo;Óó O Ñ AÄQnÊ°SXFS vs Ext4: Which One Is Better?;Óó O Ñ AÄQnÁmüXFS vs Ext4: Which One Is Better?dAÓó [ ÑAÄQn¹fubuntu server ext4 vs xfs at DuckDuckGoAÓó [ ÑAÄQnuM¥ubuntu server ext4 vs xfs at DuckDuckGoAÓó [ ÑAÄQn6↩ubuntu server ext4 vs xfs at DuckDuckGodAÓó [ ÑAÄQm¥ubuntu server ext4 vs xfs at DuckDuckGoÓó ↩ ÑAÄQmgdCÓò _ ÑAÄQeGubuntu server ext4 vs btrfs at DuckDuckGo@Óò~ Y ÑAÄQ\úxBtrfs vs Ext4: Which One Should I Use?@Óò} Y ÑAÄQ\êå¬Btrfs vs Ext4: Which One Should I Use?dCÓò| _ ÑAÄQ\Ö]ûubuntu server ext4 vs btrfs at DuckDuckGoCÓò{ _ ÑAÄQZ=*|ubuntu server ext4 vs btrfs at DuckDuckGoCÓòz _ ÑAÄQYï+ubuntu server ext4 vs btrfs at DuckDuckGodCÓòy _ ÑAÄQYtqubuntu server ext4 vs btrfs at DuckDuckGoÓòx ↩ ÑAÄQYzÃd*Óòw - ÑAÄQ3Ú¤±Index of /ubuntud*Óòv - ÑAÄQ1!ÎIndex of /ubuntud+Óòu - ÑAÄQ.Á}ØIndex of /ubuntu*Óòt - ÑAÄQö!¯Mirrors : Ubuntud8Óòs I ÑAÄQÕèAlternative downloads | Ubuntud>Óòr U ÑAÄQ´ãÅubuntu archive mirrors at DuckDuckGo>Óòq U ÑAÄQæ{«ubuntu archive mirrors at DuckDuckGoÓòp ↩ ÑAÄQ æd/Óòo 7 ÑAÄQ↩z©Mirrors - Ubuntu Wikid>Óòn U ÑAÄQ↩>Îubuntu archive mirrors at DuckDuckGo>Óòm U ÑAÄQ VÉ~ubuntu archive mirrors at DuckDuckGo>Óòl U ÑAÄQ +>ubuntu archive mirrors at DuckDuckGod>Óòk U ÑAÄQ ¹hZubuntu archive mirrors at DuckDuckGoÓòj ↩ ÑAÄQ ³çdDÓòi _ Ñ AÄQàLOnline IP CIDR / VLSM Supernet Calculator-Óòh - ÑAÄPü0ÓRIndex of /ubuntuùgd Óòg ↩ Ñ↩AÄPü0ÃÒùhddÓòf Ñ AÄPÍÐònetworking - How do I configure the search domain correctly? - Ask UbuntudDÓòe a Ñ AÄP͹S½ubuntu server search domains at DuckDuckGoDÓòd a Ñ AÄPÌ@лubuntu server search domains at DuckDuckGoDÓòc a Ñ AÄPÌ ¾Uubuntu server search domains at DuckDuckGodDÓòb a Ñ
AÄP˹¹subuntu server search domains at DuckDuckGoÓòa ↩ Ñ
AÄPË°¯¼dCÓò` _ Ñ AÄP¥QÛUOnline IP CIDR / VLSM Supernet CalculatorCÓò_ _ Ñ AÄPâ?6Online IP CIDR / VLSM Supernet Calculatord
7| ùòëäÝÖÏÈÁº³¬¥{tmf_XQJC<5.' ýöïèáÚÓÌž·°©¢| ùgùh ã] ãZ ã3 ù ù ù ù ù ù ù ù ù ù ù ù ù ù
ù ù ù ù ù ù ù~ ù} ù| ù{ ùz ùy ùx ùw ùv ùu ùt ùs ùr ùq ùp ùo ùn ùm ùl ùk ùj ùi ùg ùf ùe ùd ùc ùb ùa ù` ù_
7| ùòëäÝÖÏÈÁº³¬¥{tmf_XQJC<5.' ýöïèáÚÓÌž·°©¢| ùhùg ã] ãZ ã3 ù ù ù ù ù ù ù ù ù ù ù ù ù ù
ù ù ù ù ù ù ù~ ù} ù| ù{ ùz ùy ùx ùw ùv ùu ùt ùs ùr ùq ùp ùo ùn ùm ùl ùk ùj ùi ùh ùf ùe ùd ùc ùb ùa ù` ù_↩ 1 ͧ\. éÇnM(
↩é↩½↩↩x↩7↩ ð À l G û × [ 6
Î
w
J
(
Ê v L ã¾d0 1 ÈQ170855DrupalAÅße620 C ÈQ8777Hypertext Transfer ProtocolAÅß2îd+/ 1 ÈQ857177Adobe Flash PlayerAÅÛùö+. 1 ÈQ471748Exception handlingAŵ^lãi#- ÈQ1756442LR parserAŵJ¯?û5, C ÈQ1050390C dynamic memory allocationAŤdY0+ 9 ÈQ6522952FisherâYates shuffleAÅ£Å÷v(* ' ÈQ29564107Billie EilishAÅ®FÙ¶$) ! ÈQ205472Zipf's lawAÅK¤{oÁ÷,( 1 ÈQ179492Voynich manuscriptAÅKk³↩ÿ8' G ÈQ3053960Scrabble letter distributionsAÅI¾j Áþ"& ÈQ1762457BeddingAÅD; ÿ % ÈQ1536136MySQLiAŵpàl+$ - ÈQ2302053Spatial databaseAÅ)~§Æ þ&# ' ÈQ506059SQL injectionAÅ ·Ø'-" 5 ÈQ371199Cross-site scriptingAÅ ¦tq´1! ? ÈQ80776Robots exclusion standardAÅA«â3 A ÈQ180711Search engine optimizationAÅHzâfÃ# ÈQ1343954SitemapsAŶ¥ºäô+ 1 ÈQ11452General relativityAÅ òÆCxü# ! ÈQ11547Cosmic rayAÅóâãÈ\ë( + ÈQ640741MySQL WorkbenchAÅÀ.Ü" ÈQ686292SteinbergAÅãvî ÈQ182477NvidiaAÅìÈ£ÿ( ) ÈQ654117Mixing consoleAÅ/ [ý# ÈQ1193600MarkdownAÅVVV|·ù) / ÈQ1575Internet ExplorerAÅ˸òÐû' % ÈQ30637282YouTube KidsAÅì
X*. 5 ÈQ1152764Lloyds Banking GroupAÅì~÷øý ÈQ317671BotnetAÅÍ$ % ÈQ11189Proxy serverAÅÁ$ÇíR? W ÈQ859398Unified Extensible Firmware InterfaceAÅÀ9¨øý ÈQ34236FreeBSDAÅÁ'F! ÈQ308869Mac ProAÅA°æ¡jý* + ÈQ4854529Colors of noiseAÅ0 Ìeþ ÈQ230036jQueryAÅU↩x ↩ ÈQ850MySQLAÅßW û# ÈQ1000428MySQL ABAÅ «¿ÿ ÈQ53479StuxnetAÅû´Y/
3 ÈQ17310682CRISPR gene editingAÅR§¾äüú& % ÈQ232246Cowboy BebopAÅ↩@¼µ»ý ÈQ48524ChromiumAÅ´¸' ÈQ698FirefoxAÅçL&pþ# ' ÈQ777Google ChromeAűdJs, 3 ÈQ182868Weather forecastingAÅpµ· ´# ! ÈQ186819HeadphonesAÅ2@6ü$ ! ÈQ162564UltrasoundAÅa×*|û$ ÈQ28059734LineageOSAÅaðH1 ; ÈQ758234Physical attractivenessAÅ`ËP¹ËÑ↩ ìØÄ° áR Ñ ÝAÄQqeäáQ Ñ
"AÄQ_Èm¤áP Ñ÷AÄQ ¥áO Ñ ãAÄQ÷©áN Ñ ÜAÄPл©ü
Ä ôèÜÐÄ Ñ Ý0Ò Ñ
"0Ñ Ñ÷0Ð Ñ Ü0Î Ñ ã0Ï
B ùòÝȸ¨n]L;*÷æÕ¿©ylTB #wiki.ubuntu Ñ/us.archive.ubuntu Ñ ubuntu Ñ/subnet-calculator Ñ /subnet-calculator Ñ+partitionwizard Ñ +partitionwizard Ñ!duckduckgo Ñ !duckduckgo Ñ !duckduckgo Ñ !duckduckgo Ñ!duckduckgo Ñ!duckduckgo Ñ!duckduckgo Ñ!duckduckgo Ñ!duckduckgo Ñ!duckduckgo Ñ !duckduckgo Ñ
/de.archive.ubuntu Ñ askubuntu Ñ askubuntu Ñ )archive.ubuntu Ñ)archive.ubuntu Ñ↩ Ñ Ñ
7 ´ ìØÄ°t`L8$üèÔÀ¬p\H4 ↩ø↩ä↩Ð↩¼↩¨↩↩↩l↩X↩D↩0↩ ↩ ô à Ì ¸ ¤ | h T @ , ð Ü È ´ Ñ AÄQe7mù Ñ AÄQjõäù Ñ AÄQá~ù Ñ AÄQâ¨ù Ñ AÄQøù Ñ AÄQÇëdù Ñ AÄQÖFñù Ñ AÄQv·ù Ñ AÄQnÁmüù
Ñ AÄQnÊ°Sù ÑAÄQn6↩ù ÑAÄQnuM¥ù ÑAÄQn¹fù ÑAÄQFù ÑAÄQ'ÏÄù ÑAÄQc_Wù ÑAÄQmgù ÑAÄQm¥ù ÑAÄQ\êå¬ù} ÑAÄQ\úxù~ ÑAÄQYï+ùz ÑAÄQZ=*|ù{ ÑAÄQ\Ö]ûù| ÑAÄQeGù ÑAÄQ
Uaxù ÑAÄQYzÃùx ÑAÄQYtqùy ÑAÄQ3Ú¤±ùw ÑAÄQ1!Îùv ÑAÄQö!¯ùt ÑAÄQÕèùs ÑAÄQZ=Çã] ÑAÄQ æùp ÑAÄQ↩z©ùo ÑAÄQZ=*·ãZ ÑAÄQ +>ùl ÑAÄQ VÉ~ùm ÑAÄQ↩>Îùn ÑAÄQæ{«ùq ÑAÄQ´ãÅùr ÑAÄQ ³çùj ÑAÄQ ¹hZùk ÑAÄPü0ÓRùh ÑAÄQ.Á}Øùu Ñ↩AÄPü0ÃÒùg Ñ AÄPÍÐòùf Ñ AÄPÌ ¾Uùc Ñ AÄPÌ@лùd Ñ AÄP͹S½ùe Ñ
AÄPË°¯¼ùa Ñ
AÄP˹¹sùb Ñ AÄPâ?6ù_ Ñ AÄP¥QÛUù` Ñ AÄQàLùi Ñ AÄQZ=*àã3
7H øðèàØÐÈÀ¸°¨ xph`XPH@80( øðèàØÐÈÀ¸°¨ xph`XPH ã]ãZã3ùùùùùùùùùùùùùù
ùùùùùùù~ù}ù|ù{ùzùyùxùwùvùuùtùsùrùqùpùoùnùmùlùkùjùiùhùgùfùeùdùcùbùaù`ù_↩ ü ½↩Ã ê d ¹ Å
Û v
ü Ó ýJ²¾0¨ § _?7Striggerincrement_count_on_inserthistory_items_to_tagsCREATE TRIGGER increme U?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;END{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)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) K'-indexhistory_items__domain_expansionhistory_itemsCREATE INDEX history_items__domain_expansion ON history_items (domain_expansion) ²77itablehistory_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)I]7 indexsqlite_autoindex_history_items_to_tags_1history_items_to_tags ÿ%%;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)
))itablehistory_visitshistory_visits CREATE 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)ø zO) indexsqlite_autoindex_history_visits_2history_visits; O) indexsqlite_autoindex_history_visits_1history_visits↩H
))Ktablehistory_eventshistory_events CREATE 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);;Gtablehistory_event_listenershistory_event_listeners CREATE TABLE history_event_listeners (listener_name TEXT PRIMARY KEY,last_seen REAL NOT NULL)M a; indexsqlite_autoindex_history_event_listeners_1history_event_listeners
;;Otablehistory_client_versionshistory_client_versionsCREATE TABLE history_client_versions (client_version INTEGER PRIMARY KEY,last_seen REAL NOT NULL)S {tablemetadatametadataCREATE TABLE metadata (key TEXT NOT NULL UNIQUE, value)/C indexsqlite_autoindex_metadata_1metadataV11Wtablehistory_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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)%'' tablehistory_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 DEFAULT 0, status_code INTEGER NOT NULL DEFAULT 0)9M' indexsqlite_autoindex_history_items_1history_items ↩ N Ã↩ Ô H º 2
1N `?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;END{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)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) K'-indexhistory_items__domain_expansionhistory_itemsCREATE INDEX history_items__domain_expansion ON history_items (domain_expansion)I]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);↩O) indexsqlite_autoindex_history_visits_2history_visits; O) indexsqlite_autoindex_history_visits_1history_visits↩