Places:Indexes

Revision as of 18:33, 31 October 2007 by Dietrich (talk | contribs) (New page: ==Indexes== * CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk) * [http://mxr.mozilla.org/seamonkey/source/toolkit/components/places/src/nsNavBookmarks.cpp#325 source] * CREATE...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Indexes

CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk)
source

CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent)
source

CREATE INDEX moz_places_urlindex ON moz_places (url)
source

CREATE INDEX moz_places_titleindex ON moz_places (title)
source

CREATE INDEX moz_places_faviconindex ON moz_places (favicon_id)
source

CREATE INDEX moz_historyvisits_pageindex ON moz_historyvisits (place_id)
CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)
CREATE INDEX moz_places_hostindex ON moz_places (rev_host)
CREATE INDEX moz_places_visitcount ON moz_places (rev_host)
CREATE INDEX moz_places_hostindex ON moz_places (rev_host)
CREATE INDEX moz_places_visitcount ON moz_places (visit_count)
CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)
CREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits (visit_date)

Retrieved from "https://wiki.mozilla.org/index.php?title=Places:Indexes&oldid=72691"