Annotation of RandomFlip/build/testMozilla Firefox 3.0/places.sqlite, revision 1.1.1.1

1.1       induscry    1: SQLite format 3&&@  &&        &
p!
                      2: -             Mm4D`&&&~G!&!indexmoz_places_lastvisitdateindexmoz_placesCREATE INDEX moz_places_lastvisitdateindex ON moz_places (last_visit_date)m=!&     indexmoz_places_frecencyindexmoz_placesCREATE INDEX moz_places_frecencyindex ON moz_places (frecency)j7!&  indexmoz_places_visitcountmoz_placesCREATE INDEX moz_places_visitcount ON moz_places (visit_count)e5!&&indexmoz_places_hostindexmoz_placesCREATE INDEX moz_places_hostindex ON moz_places (rev_host)m;!&indexmoz_places_faviconindexmoz_placesCREATE INDEX moz_places_faviconindex ON moz_places (favicon_id)sA!&indexmoz_places_url_uniqueindexmoz_placesCREATE UNIQUE INDEX moz_places_url_uniqueindex ON moz_places (url)F!!&Wtablemoz_placesmoz_placesCREATE 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 )$Q+&Yindexmoz_items_annos_itemattributeindexmoz_items_annosCREATE UNIQUE INDEX moz_items_annos_itemattributeindex ON moz_items_annos (item_id, anno_attribute_id)\++&otablemoz_items_annosmoz_items_annosCREATE 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)EY3&indexsqlite_autoindex_moz_anno_attributes_1moz_anno_attributes33&Gtablemoz_anno_attributesmoz_anno_attributesCREATE TABLE moz_anno_attributes (  id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL)G&Eindexmoz_annos_placeattributeindexmoz_annosCREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id)K
&etablemoz_annosmoz_annos
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)7K%&indexsqlite_autoindex_moz_favicons_1moz_favicons$%%&tablemoz_faviconsmoz_faviconsCREATE TABLE moz_favicons (  id INTEGER PRIMARY KEY, url LONGVARCHAR UNIQUE, data BLOB, mime_type VARCHAR(32), expiration LONG)f
                      3: W'&Wtriggermoz_bookmarks_beforedelete_v1_triggermoz_bookmarksCREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger BEFORE DELETE ON moz_bookmarks FOR EACH ROW WHEN OLD.keyword_id NOT NULL BEGIN DELETE FROM moz_keywords WHERE id = OLD.keyword_id AND NOT EXISTS ( SELECT id FROM moz_bookmarks WHERE keyword_id = OLD.keyword_id AND id <> OLD.id LIMIT 1 );ENDP        ++&Ytablesqlite_sequencesqlite_sequence
                      4: CREATE TABLE sqlite_sequence(name,seq)7K%&indexsqlite_autoindex_moz_keywords_1moz_keywords |%%&;tablemoz_keywordsmoz_keywordsCREATE TABLE moz_keywords (  id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE)EY3&indexsqlite_autoindex_moz_bookmarks_roots_1moz_bookmarks_roots33&5tablemoz_bookmarks_rootsmoz_bookmarks_rootsCREATE TABLE moz_bookmarks_roots (  root_name VARCHAR(16) UNIQUE, folder_id INTEGER)S'&5indexmoz_bookmarks_itemlastmodifiedindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModified)}?'&!indexmoz_bookmarks_parentindexmoz_bookmarksCREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position)q;'&
indexmoz_bookmarks_itemindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type)&''&Mtablemoz_bookmarksmoz_bookmarksCREATE 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 INT
^-N


t

B
3&&&&5&
                      5: Problem loading pagepƔXp'&&&&&   About UspCpC+&&&&%&Get InvolvedpCpC0&&&&/&&Customize FirefoxpCpC-&&&+
Mozilla FirefoxpCpC1&&&&1&Help and TutorialspCpC
&&&pC.&&&-
Latest HeadlinespCpp.&&&&+&&Getting StartedpCpC3
                      6: &&&&5&Get Bookmark Add-onspCpC   &&&p*&&&&#&&Recent Tagspp2&&&&3&Recently Bookmarkedpp0&&&1
&Unsorted Bookmarksp{p/&&&/
&&Bookmarks Toolbarp{pC,&&&)
&Bookmarks Menup{p"&&&
&Tagsp{p{&&&&

p{p{+&&&&%&&Most Visitedpp
                      7: qyq&&&
                      8: &&&&        &&&&&&&&&&&&&&&&&
&&&&&&&&&&
                      9: && &&&&&&&&&&&&&&&&&&&&&&&&
                     10: hhxp&&&&&&&&&&&&&&&&&&&&&&
&&&&&&&&&&
                     11: &&&        &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
                     12: B4IufW%&&
                     13: p&& pC&&pC&&pC&&pC
&pC
&pp&&pC&&pC
                     14: &&p&&p&&&p
&p{&
& 
&p
&pC
&p
&p{&
&unfiled&tags&toolbar&menu
                     15: &&places&
                     16: &unfiled&tags&toolbar&menu
                     17: &places&

                     18: 

&[      -&      &http://www.mozilla.org/2005/made-up-favicon/4-1250078316250000PNG
                     19: 
                     20: 
IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<&IDATxb?% 9߿gߕ񿉉 ի߻wO&&r&9s3@
                     21: q@Uv0@3g>?Dc
+))@03
                     22: ca`

vݻ
                     23: 0v&6zŻނy Bn1`& dVA&
                     24: -L4
`/
                     25: &00&P1ܻ&4
lW S@|6./gxgٳ{| :&Ű? ޽{AD Gr%P8#E=&P@myc &Rd;ȠƐƥ&x{VC\},O\   0Ly.A )&'k,IENDB`image/png       &http://www.mozilla.org/2005/made-up-favicon/3-1250078316250000PNG
                     26: 
                     27: 
IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<&IDATxb?% 9߿gߕ񿉉 ի߻wO&&r&9s3@
                     28: q@Uv0@3g>?Dc
+))@03
                     29: ca`

vݻ
                     30: 0v&6zŻނy Bn1`& dVA&
                     31: -L4
`/
                     32: &00&P1ܻ&4
lW S@|6./gxgٳ{| :&Ű? ޽{AD Gr%P8#E=&P@myc &Rd;ȠƐƥ&x{VC\},O\   0Ly.A )&'k,IENDB`image/png       &http://www.mozilla.org/2005/made-up-favicon/2-1250078316250000PNG
                     33: 
                     34: 
IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<&IDATxb?% 9߿gߕ񿉉 ի߻wO&&r&9s3@
                     35: q@Uv0@3g>?Dc
+))@03
                     36: ca`

vݻ
                     37: 0v&6zŻނy Bn1`& dVA&
                     38: -L4
`/
                     39: &00&P1ܻ&4
lW S@|6./gxgٳ{| :&Ű? ޽{AD Gr%P8#E=&P@myc &Rd;ȠƐƥ&x{VC\},O\   0Ly.A )&'k,IENDB`image/png       &http://www.mozilla.org/2005/made-up-favicon/1-1250078316250000PNG
                     40: 
                     41: 
IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<&IDATxb?% 9߿gߕ񿉉 ի߻wO&&r&9s3@
                     42: q@Uv0@3g>?Dc
+))@03
                     43: ca`

vݻ
                     44: 0v&6zŻނy Bn1`& dVA&
                     45: -L4
`/
                     46: &00&P1ܻ&4
lW S@|6./gxgٳ{| :&Ű? ޽{AD Gr%P8#E=&P@myc &Rd;ȠƐƥ&x{VC\},O\   0Ly.A )&'k,IENDB`image/png"&       0&http://www.mozilla.org/2005/made-up-favicon/0-1250078316250000PNG
                     47: 
                     48: 
IHDRaIDAT8u]LSgxƐe//z&KʼnBnp3۠
                     49: 7R0kp        YY@bPhiTJړZliZ8}K9=w&/=\/!HvFSӤhjCwrǮ߃nk}P7lR/bUuv{?ՄmU.e<5ȰŋF$<
                     50: ueHl;{'|%gf˘ϔKJʘa   Kx,3\0מB8Z    2eesb*`01aH0
                     51: q۹z8ZEUh»XB0^SL `pLm{&'LSSp&P&ϒR]hGt{G%82|w0feQC~ТTX-^3ɀE@Qa29ؖߴjjxbJ1a_(-ٛNȘI08EdI)jNE=
                     52: %LG$XP
                     53: JȘqg+!v>ĸzZM8V5u&CK!/EܴeqFkq"rR4¼1F/Ø{<06g؅}[WƜ{2a0s0rqz)B<V#^%u6wGgie!b.ϲ8)6kQnpWھ7WO{Nĭ
t4#IENDB`image/png
                     54: x4C &http://www.mozilla.org/2005/made-up-favicon/4-1250078316250000C     &http://www.mozilla.org/2005/made-up-favicon/3-1250078316250000C     &http://www.mozilla.org/2005/made-up-favicon/2-1250078316250000C     &http://www.mozilla.org/2005/made-up-favicon/1-1250078316250000C     &http://www.mozilla.org/2005/made-up-favicon/0-1250078316250000&
&&&&&&&&
                     55:        UTF-8p
                     56: &&&&
                     57:        &
h}P8     AURIProperties/characterSet3livemark/loadfailed3livemark/expiration-livemark/siteURI-livemark/feedURI=placesInternal/READ_ONLY!IbookmarkProperties/description&5Places/SmartBookmark
                     58: hP8}A&URIProperties/characterSet 3&livemark/loadfailed3&livemark/expiration-&livemark/siteURI-&livemark/feedURI=&placesInternal/READ_ONLY"I&bookmarkProperties/description5&Places/SmartBookmark&
    !bF(        &&+&&&&1250078940359.0pk#X
                     59: &&&&&&1&poP&&{&&&&http://fxfeeds.mozilla.com/en-US/firefox/livebookmarks/pCO&&y&&&&http://fxfeeds.mozilla.com/en-US/firefox/headlines.xmlpC&&&&&&1&pCe&&#&&&&Add bookmarks to this folder to see them displayed on the Bookmarks ToolbarpC#&&!&&&&&RecentTagsp+&&1&&&&&RecentlyBookmarkedp$&&&#&&&&&MostVisitedp
                     60:     &&&      &&&
                     61: &&&&&&&&&&&&&&&&&&&&&&&&&

                     62: PG


 TP4
                     63: /!&&&http://localhost/localhosttsohlacol.a  c7-&&&&http://www.mozilla.com/en-US/firefox/about//en-US/firefox/about/moc.allizom.www.ik?-&&&&http://www.mozilla.com/en-US/firefox/community//en-US/firefox/community/moc.allizom.www.ik?-&&&&http://www.mozilla.com/en-US/firefox/customize//en-US/firefox/customize/moc.allizom.www._a5-&&&&http://www.mozilla.com/en-US/firefox/help//en-US/firefox/help/moc.allizom.www.dg;-&&&http://www.mozilla.com/en-US/firefox/central//en-US/firefox/central/moc.allizom.www.ps?3&&&&https://addons.mozilla.org/en-US/firefox/bookmarks//en-US/firefox/bookmarks/gro.allizom.snodda.&MQE&&&&place:type=6&sort=14&maxResults=10type=6&sort=14&maxResults=10&_
aU&&&&place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&excludeItemIfParentHasAnnotation=livemark%2FfeedURI&maxResults=10&excludeQueries=1folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&excludeItemIfParentHasAnnotation=livemark%2FfeedURI&maxResults=10&excludeQueries=1&U&YM&&&&place:queryType=0&sort=8&maxResults=10queryType=0&sort=8&maxResults=10&
                     64: 
                     65: 



0d$/&http://localhost/
                     66: /c&http://www.mozilla.com/en-US/firefox/about/        3k&http://www.mozilla.com/en-US/firefox/community/3k&http://www.mozilla.com/en-US/firefox/customize/.a&http://www.mozilla.com/en-US/firefox/help/1g&http://www.mozilla.com/en-US/firefox/central/7s&https://addons.mozilla.org/en-US/firefox/bookmarks/&Q&place:type=6&sort=14&maxResults=10/a&place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&excludeItemIfParentHasAnnotation=livemark%2FfeedURI&maxResults=10&excludeQueries=1*Y&place:queryType=0&sort=8&maxResults=10&
                     67: 
                     68: &
                     69: &&  &&&&&&&&&&&&&&
                     70: 
                     71: apa!&tsohlacol.
                     72: -&moc.allizom.www.   -&moc.allizom.www.-&moc.allizom.www.-&moc.allizom.www.-&moc.allizom.www.3&gro.allizom.snodda.&&&&
                     73: 
                     74: &&
                     75: &&  &&&&&&&&&&&&&&&&&
                     76: 
                     77: &
                     78: & &&&&&&&&&&&&
                     79: 
                     80: &
                     81: &   &&&&&&&&&

mmw  i       
                     82: 
                     83: L
@
 n        -       
                     84: f

V
:
|&''&Mtablemoz_bookmarksmoz_bookmarksCREATE 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)q;'&
indexmoz_bookmarks_itemindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type)}?'&!indexmoz_bookmarks_parentindexmoz_bookmarksCREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position)S'&5indexmoz_bookmarks_itemlastmodifiedindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModified)33&5tablemoz_bookmarks_rootsmoz_bookmarks_rootsCREATE TABLE moz_bookmarks_roots (  root_name VARCHAR(16) UNIQUE, folder_id INTEGER)EY3&indexsqlite_autoindex_moz_bookmarks_roots_1moz_bookmarks_roots|%%&;tablemoz_keywordsmoz_keywordsCREATE TABLE moz_keywords (  id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE)7K%&indexsqlite_autoindex_moz_keywords_1moz_keywords       P       ++&Ytablesqlite_sequencesqlite_sequence
                     85: CREATE TABLE sqlite_sequence(name,seq)f
                     86: W'&Wtriggermoz_bookmarks_beforedelete_v1_triggermoz_bookmarksCREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger BEFORE DELETE ON moz_bookmarks FOR EACH ROW WHEN OLD.keyword_id NOT NULL BEGIN DELETE FROM moz_keywords WHERE id = OLD.keyword_id AND NOT EXISTS ( SELECT id FROM moz_bookmarks WHERE keyword_id = OLD.keyword_id AND id <> OLD.id LIMIT 1 );END$%%&tablemoz_faviconsmoz_faviconsCREATE TABLE moz_favicons (  id INTEGER PRIMARY KEY, url LONGVARCHAR UNIQUE, data BLOB, mime_type VARCHAR(32), expiration LONG)7K%&indexsqlite_autoindex_moz_favicons_1moz_faviconsK
&etablemoz_annosmoz_anno&''&Mtablemoz_bookmarksmoz_bookmarksCREATE 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)q;'&
indexmoz_bookmarks_itemindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type)}?'&!indexmoz_bookmarks_parentindexmoz_bookmarksCREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position)S'&5indexmoz_bookmarks_itemlastmodifiedindexmoz_bookmarksCREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModified)33&5tablemoz_bookmarks_rootsmoz_bookmarks_rootsCREATE TABLE moz_bookmarks_roots (  root_name VARCHAR(16) UNIQUE, folder_id INTEGER)EY3&indexsqlite_autoindex_moz_bookmarks_roots_1moz_bookmarks_roots|%%&;tablemoz_keywordsmoz_keywordsCREATE TABLE moz_keywords (  id INTEGER PRIMARY KEY AUTOINCREMENT, keyword TEXT UNIQUE)7K%&indexsqlite_autoindex_moz_keywords_1moz_keywords  P       ++&Ytablesqlite_sequencesqlite_sequence
                     87: CREATE TABLE sqlite_sequence(name,seq)f
                     88: W'&Wtriggermoz_bookmarks_beforedelete_v1_triggermoz_bookmarksCREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger BEFORE DELETE ON moz_bookmarks FOR EACH ROW WHEN OLD.keyword_id NOT NULL BEGIN DELETE FROM moz_keywords WHERE id = OLD.keyword_id AND NOT EXISTS ( SELECT id FROM moz_bookmarks WHERE keyword_id = OLD.keyword_id AND id <> OLD.id LIMIT 1 );END$%%&tablemoz_faviconsmoz_faviconsCREATE TABLE moz_favicons (  id INTEGER PRIMARY KEY, url LONGVARCHAR UNIQUE, data BLOB, mime_type VARCHAR(32), expiration LONG)7K%&indexsqlite_autoindex_moz_favicons_1moz_faviconsK
&etablemoz_annosmoz_annos
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)G&Eindexmoz_annos_placeattributeindexmoz_annosCREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id)
g     A
                     89: G

t
G6G|6--&tablemoz_inputhistorymoz_inputhistory CREATE TABLE moz_inputhistory (  place_id INTEGER NOT NULL, input LONGVARCHAR NOT NULL, use_count INTEGER, PRIMARY KEY (place_id, input))?S-&indexsqlite_autoindex_moz_inputhistory_1moz_inputhistory!C/&!indexmoz_historyvisits_dateindexmoz_historyvisitsCREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits (visit_date)C/&!indexmoz_historyvisits_fromindexmoz_historyvisitsCREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)M/&?indexmoz_historyvisits_placedateindexmoz_historyvisitsCREATE INDEX moz_historyvisits_placedateindex ON moz_historyvisits (place_id, visit_date)33&Gtablemoz_anno_attributesmoz_anno_attributesCREATE TABLE moz_anno_attributes (  id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL)EY3&indexsqlite_autoindex_moz_anno_attributes_1moz_anno_attributes\++&otablemoz_items_annosmoz_items_annosCREATE 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)$Q+&Yindexmoz_items_annos_itemattributeindexmoz_items_annosCREATE UNIQUE INDEX moz_items_annos_itemattributeindex ON moz_items_annos (item_id, anno_attribute_id)F!!&Wtablemoz_placesmoz_placesCREATE 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 )sA!&indexmoz_places_url_uniqueindexmoz_placesCREATE UNIQUE INDEX moz_places_url_uniqueindex ON moz_places (url)m;!&indexmoz_places_faviconindexmoz_placesCREATE INDEX moz_places_faviconindex ON moz_places (favicon_id)e5!&&indexmoz_places_hostindexmoz_placesCREATE INDEX moz_places_hostindex ON moz_places (rev_host)j7!&   indexmoz_places_visitcountmoz_placesCREATE INDEX moz_places_visitcount ON moz_places (visit_count)m=!&     indexmoz_places_frecencyindexmoz_placesCREATE INDEX moz_places_frecencyindex ON moz_places (frecency)~G!&!indexmoz_places_lastvisitdateindexmoz_placesCREATE INDEX moz_places_lastvisitdateindex ON moz_places (last_visit_date)G//&=tablemoz_historyvisitsmoz_historyvisitsCREATE TABLE moz_historyvisits (  id INTEGER PRIMARY KEY, from_visit INTEGER, place_id INTEGER, visit_date INTEGER, visit_type INTEGER, session INTEGER)
                     90: 
                     91: 
                     92: 

                     93: 

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>