Confirmed users
764
edits
Firefox/Projects/Places DB Creation Scripts: Difference between revisions
Firefox/Projects/Places DB Creation Scripts (view source)
Revision as of 20:46, 25 February 2009
, 25 February 2009→Design
(→Design) |
(→Design) |
||
| Line 54: | Line 54: | ||
Some notes on the above funcs and SQL: | Some notes on the above funcs and SQL: | ||
* GetAutoCompleteBaseQuery() | * GetAutoCompleteBaseQuery() selects from table moz_places(_temp) x moz_favicons; where frecency != 0; orders by column 9 (guessing this is frecency column...) | ||
* BOOK_TAG_SQL defined in terms of SQL_STR_FRAGMENT_GET_BOOK_TAG http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#94 | * BOOK_TAG_SQL defined in terms of SQL_STR_FRAGMENT_GET_BOOK_TAG http://mxr.mozilla.org/mozilla-central/source/toolkit/components/places/src/nsNavHistoryAutoComplete.cpp#94 which itself selects from moz_bookmarks x moz_bookmarks where TYPE_BOOKMARK; sometimes orders by lastModified; | ||
* mDBAdaptiveQuery uses moz_inputhistory | * mDBAdaptiveQuery uses BOOK_TAG_SQL, moz_inputhistory... | ||
= Implementation = | |||
set up django: | set up django: | ||