File:  [mozdev] / RandomFlip / build / testMozilla Firefox 3.0 / places.sqlite
Revision 1.1: download - view: text, annotated - select for diffs - revision graph
Wed Aug 12 12:08:14 2009 UTC (9 years, 7 months ago) by induscrypt
CVS tags: MAIN, HEAD
Initial revision

SQLite format 3@  	
p!
-		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)EY3indexsqlite_autoindex_moz_anno_attributes_1moz_anno_attributes33Gtablemoz_anno_attributesmoz_anno_attributesCREATE TABLE moz_anno_attributes (  id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL)GEindexmoz_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
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
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)EY3indexsqlite_autoindex_moz_bookmarks_roots_1moz_bookmarks_roots335tablemoz_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
35
Problem loading pagepƔXp'	About UspCpC+%Get InvolvedpCpC0/Customize FirefoxpCpC-+
Mozilla FirefoxpCpC11Help and TutorialspCpC
pC.-
Latest HeadlinespCpp.+Getting StartedpCpC3
5Get Bookmark Add-onspCpC	p*#Recent Tagspp23Recently Bookmarkedpp01
Unsorted Bookmarksp{p//
Bookmarks Toolbarp{pC,)
Bookmarks Menup{p"
Tagsp{p{

p{p{+%Most Visitedpp
qyq
	

	
hhxp

	
B4IufW%
p	pCpCpCpC
pC
pppCpC
ppp
p{
	
p
pC
p
p{
unfiledtagstoolbarmenu
places
unfiledtagstoolbarmenu
places



[	-	http://www.mozilla.org/2005/made-up-favicon/4-1250078316250000PNG


IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<IDATxb?% 9߿gߕ񿉉 ի߻wOr9s3@
q@Uv0@3g>?Dc
+))@03
ca`

vݻ
0v6zŻނy Bn1`& dVA&
-L4
`/
00P1ܻ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


IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<IDATxb?% 9߿gߕ񿉉 ի߻wOr9s3@
q@Uv0@3g>?Dc
+))@03
ca`

vݻ
0v6zŻނy Bn1`& dVA&
-L4
`/
00P1ܻ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


IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<IDATxb?% 9߿gߕ񿉉 ի߻wOr9s3@
q@Uv0@3g>?Dc
+))@03
ca`

vݻ
0v6zŻނy Bn1`& dVA&
-L4
`/
00P1ܻ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


IHDRagAMA7tEXtSoftwareAdobe ImageReadyqe<IDATxb?% 9߿gߕ񿉉 ի߻wOr9s3@
q@Uv0@3g>?Dc
+))@03
ca`

vݻ
0v6zŻނy Bn1`& dVA&
-L4
`/
00P1ܻ4
lW S@|6./gxgٳ{| :Ű? ޽{AD Gr%P8#E=P@myc Rd;ȠƐƥx{VC\},O\	 0Ly.A )'k,IENDB`image/png"	0http://www.mozilla.org/2005/made-up-favicon/0-1250078316250000PNG


IHDRaIDAT8u]LSgxƐe//z&KʼnBnp3۠
7R0kp	YY@bPhiTJړZliZ8}K9=w/=\/!HvFSӤhjCwrǮ߃nk}P7lR/bUuv{?ՄmU.e<5ȰŋF$<
ueHl;{'|%gf˘ϔKJʘa	Kx,3\0מB8Z	2eesb*`01aH0
q۹z8ZEUh»XB0^SL	`pLm{'LSSpPϒR]hGt{G%82|w0feQC~ТTX-^3ɀE@Qa29ؖߴjjxbJ1a_(-ٛNȘI08EdI)jNE=
%LG$XP
JȘqg+!v>ĸzZM8V5uCK!/EܴeqFkq"rR4¼1F/Ø{<06g؅}[WƜ{2a0s0rqz)B<V#^%u6wGgie!b.ϲ8)6kQnpWھ7WO{Nĭ
t4#IENDB`image/png
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

	UTF-8p

	
h}P8	AURIProperties/characterSet3livemark/loadfailed3livemark/expiration-livemark/siteURI-livemark/feedURI=placesInternal/READ_ONLY!IbookmarkProperties/description5Places/SmartBookmark
hP8}AURIProperties/characterSet	3livemark/loadfailed3livemark/expiration-livemark/siteURI-livemark/feedURI=placesInternal/READ_ONLY"IbookmarkProperties/description5Places/SmartBookmark
	!bF(	+1250078940359.0pk#X
1poP{http://fxfeeds.mozilla.com/en-US/firefox/livebookmarks/pCOyhttp://fxfeeds.mozilla.com/en-US/firefox/headlines.xmlpC1pCe#Add bookmarks to this folder to see them displayed on the Bookmarks ToolbarpC#!RecentTagsp+1RecentlyBookmarkedp$#MostVisitedp
		


PG


 TP4
/!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?3https://addons.mozilla.org/en-US/firefox/bookmarks//en-US/firefox/bookmarks/gro.allizom.snodda.MQEplace:type=6&sort=14&maxResults=10type=6&sort=14&maxResults=10_
aUplace: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=1UYMplace:queryType=0&sort=8&maxResults=10queryType=0&sort=8&maxResults=10





0d$/http://localhost/
/chttp://www.mozilla.com/en-US/firefox/about/	3khttp://www.mozilla.com/en-US/firefox/community/3khttp://www.mozilla.com/en-US/firefox/customize/.ahttp://www.mozilla.com/en-US/firefox/help/1ghttp://www.mozilla.com/en-US/firefox/central/7shttps://addons.mozilla.org/en-US/firefox/bookmarks/&Qplace:type=6&sort=14&maxResults=10/aplace:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&excludeItemIfParentHasAnnotation=livemark%2FfeedURI&maxResults=10&excludeQueries=1*Yplace:queryType=0&sort=8&maxResults=10


	

apa!tsohlacol.
-moc.allizom.www.	-moc.allizom.www.-moc.allizom.www.-moc.allizom.www.-moc.allizom.www.3gro.allizom.snodda.


	


	


	

mmw	i	

L
@
 n	-	
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)335tablemoz_bookmarks_rootsmoz_bookmarks_rootsCREATE TABLE moz_bookmarks_roots (  root_name VARCHAR(16) UNIQUE, folder_id INTEGER)EY3indexsqlite_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
CREATE TABLE sqlite_sequence(name,seq)f
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)335tablemoz_bookmarks_rootsmoz_bookmarks_rootsCREATE TABLE moz_bookmarks_roots (  root_name VARCHAR(16) UNIQUE, folder_id INTEGER)EY3indexsqlite_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
CREATE TABLE sqlite_sequence(name,seq)f
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)GEindexmoz_annos_placeattributeindexmoz_annosCREATE UNIQUE INDEX moz_annos_placeattributeindex ON moz_annos (place_id, anno_attribute_id)
g	A
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)33Gtablemoz_anno_attributesmoz_anno_attributesCREATE TABLE moz_anno_attributes (  id INTEGER PRIMARY KEY, name VARCHAR(32) UNIQUE NOT NULL)EY3indexsqlite_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)






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