The Tor Browser / file comparison
comparison: toolkit/components/places/nsPlacesTables.h
toolkit/components/places/nsPlacesTables.h
- changeset 0
- 6474c204b198
equal
deleted
inserted
replaced
| -1:000000000000 | 0:b2b1ce1d9956 |
|---|---|
| 1 /* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*- | |
| 2 * vim: sw=2 ts=2 et lcs=trail\:.,tab\:>~ : | |
| 3 * This Source Code Form is subject to the terms of the Mozilla Public | |
| 4 * License, v. 2.0. If a copy of the MPL was not distributed with this | |
| 5 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */ | |
| 6 | |
| 7 #ifndef __nsPlacesTables_h__ | |
| 8 #define __nsPlacesTables_h__ | |
| 9 | |
| 10 | |
| 11 #define CREATE_MOZ_PLACES NS_LITERAL_CSTRING( \ | |
| 12 "CREATE TABLE moz_places ( " \ | |
| 13 " id INTEGER PRIMARY KEY" \ | |
| 14 ", url LONGVARCHAR" \ | |
| 15 ", title LONGVARCHAR" \ | |
| 16 ", rev_host LONGVARCHAR" \ | |
| 17 ", visit_count INTEGER DEFAULT 0" \ | |
| 18 ", hidden INTEGER DEFAULT 0 NOT NULL" \ | |
| 19 ", typed INTEGER DEFAULT 0 NOT NULL" \ | |
| 20 ", favicon_id INTEGER" \ | |
| 21 ", frecency INTEGER DEFAULT -1 NOT NULL" \ | |
| 22 ", last_visit_date INTEGER " \ | |
| 23 ", guid TEXT" \ | |
| 24 ")" \ | |
| 25 ) | |
| 26 #define MOZ_PLACES_COLUMNS \ | |
| 27 "id, url, title, rev_host, visit_count, hidden, typed, favicon_id, " \ | |
| 28 "frecency, last_visit_date" | |
| 29 | |
| 30 #define CREATE_MOZ_HISTORYVISITS NS_LITERAL_CSTRING( \ | |
| 31 "CREATE TABLE moz_historyvisits (" \ | |
| 32 " id INTEGER PRIMARY KEY" \ | |
| 33 ", from_visit INTEGER" \ | |
| 34 ", place_id INTEGER" \ | |
| 35 ", visit_date INTEGER" \ | |
| 36 ", visit_type INTEGER" \ | |
| 37 ", session INTEGER" \ | |
| 38 ")" \ | |
| 39 ) | |
| 40 #define MOZ_HISTORYVISITS_COLUMNS \ | |
| 41 "id, from_visit, place_id, visit_date, visit_type, session" | |
| 42 | |
| 43 | |
| 44 #define CREATE_MOZ_INPUTHISTORY NS_LITERAL_CSTRING( \ | |
| 45 "CREATE TABLE moz_inputhistory (" \ | |
| 46 " place_id INTEGER NOT NULL" \ | |
| 47 ", input LONGVARCHAR NOT NULL" \ | |
| 48 ", use_count INTEGER" \ | |
| 49 ", PRIMARY KEY (place_id, input)" \ | |
| 50 ")" \ | |
| 51 ) | |
| 52 | |
| 53 #define CREATE_MOZ_ANNOS NS_LITERAL_CSTRING( \ | |
| 54 "CREATE TABLE moz_annos (" \ | |
| 55 " id INTEGER PRIMARY KEY" \ | |
| 56 ", place_id INTEGER NOT NULL" \ | |
| 57 ", anno_attribute_id INTEGER" \ | |
| 58 ", mime_type VARCHAR(32) DEFAULT NULL" \ | |
| 59 ", content LONGVARCHAR" \ | |
| 60 ", flags INTEGER DEFAULT 0" \ | |
| 61 ", expiration INTEGER DEFAULT 0" \ | |
| 62 ", type INTEGER DEFAULT 0" \ | |
| 63 ", dateAdded INTEGER DEFAULT 0" \ | |
| 64 ", lastModified INTEGER DEFAULT 0" \ | |
| 65 ")" \ | |
| 66 ) | |
| 67 | |
| 68 #define CREATE_MOZ_ANNO_ATTRIBUTES NS_LITERAL_CSTRING( \ | |
| 69 "CREATE TABLE moz_anno_attributes (" \ | |
| 70 " id INTEGER PRIMARY KEY" \ | |
| 71 ", name VARCHAR(32) UNIQUE NOT NULL" \ | |
| 72 ")" \ | |
| 73 ) | |
| 74 | |
| 75 #define CREATE_MOZ_ITEMS_ANNOS NS_LITERAL_CSTRING( \ | |
| 76 "CREATE TABLE moz_items_annos (" \ | |
| 77 " id INTEGER PRIMARY KEY" \ | |
| 78 ", item_id INTEGER NOT NULL" \ | |
| 79 ", anno_attribute_id INTEGER" \ | |
| 80 ", mime_type VARCHAR(32) DEFAULT NULL" \ | |
| 81 ", content LONGVARCHAR" \ | |
| 82 ", flags INTEGER DEFAULT 0" \ | |
| 83 ", expiration INTEGER DEFAULT 0" \ | |
| 84 ", type INTEGER DEFAULT 0" \ | |
| 85 ", dateAdded INTEGER DEFAULT 0" \ | |
| 86 ", lastModified INTEGER DEFAULT 0" \ | |
| 87 ")" \ | |
| 88 ) | |
| 89 | |
| 90 #define CREATE_MOZ_FAVICONS NS_LITERAL_CSTRING( \ | |
| 91 "CREATE TABLE moz_favicons (" \ | |
| 92 " id INTEGER PRIMARY KEY" \ | |
| 93 ", url LONGVARCHAR UNIQUE" \ | |
| 94 ", data BLOB" \ | |
| 95 ", mime_type VARCHAR(32)" \ | |
| 96 ", expiration LONG" \ | |
| 97 ", guid TEXT" \ | |
| 98 ")" \ | |
| 99 ) | |
| 100 | |
| 101 #define CREATE_MOZ_BOOKMARKS NS_LITERAL_CSTRING( \ | |
| 102 "CREATE TABLE moz_bookmarks (" \ | |
| 103 " id INTEGER PRIMARY KEY" \ | |
| 104 ", type INTEGER" \ | |
| 105 ", fk INTEGER DEFAULT NULL" /* place_id */ \ | |
| 106 ", parent INTEGER" \ | |
| 107 ", position INTEGER" \ | |
| 108 ", title LONGVARCHAR" \ | |
| 109 ", keyword_id INTEGER" \ | |
| 110 ", folder_type TEXT" \ | |
| 111 ", dateAdded INTEGER" \ | |
| 112 ", lastModified INTEGER" \ | |
| 113 ", guid TEXT" \ | |
| 114 ")" \ | |
| 115 ) | |
| 116 | |
| 117 #define CREATE_MOZ_BOOKMARKS_ROOTS NS_LITERAL_CSTRING( \ | |
| 118 "CREATE TABLE moz_bookmarks_roots (" \ | |
| 119 " root_name VARCHAR(16) UNIQUE" \ | |
| 120 ", folder_id INTEGER" \ | |
| 121 ")" \ | |
| 122 ) | |
| 123 | |
| 124 #define CREATE_MOZ_KEYWORDS NS_LITERAL_CSTRING( \ | |
| 125 "CREATE TABLE moz_keywords (" \ | |
| 126 " id INTEGER PRIMARY KEY AUTOINCREMENT" \ | |
| 127 ", keyword TEXT UNIQUE" \ | |
| 128 ")" \ | |
| 129 ) | |
| 130 | |
| 131 #define CREATE_MOZ_HOSTS NS_LITERAL_CSTRING( \ | |
| 132 "CREATE TABLE moz_hosts (" \ | |
| 133 " id INTEGER PRIMARY KEY" \ | |
| 134 ", host TEXT NOT NULL UNIQUE" \ | |
| 135 ", frecency INTEGER" \ | |
| 136 ", typed INTEGER NOT NULL DEFAULT 0" \ | |
| 137 ", prefix TEXT" \ | |
| 138 ")" \ | |
| 139 ) | |
| 140 | |
| 141 // Note: this should be kept up-to-date with the definition in | |
| 142 // nsPlacesAutoComplete.js. | |
| 143 #define CREATE_MOZ_OPENPAGES_TEMP NS_LITERAL_CSTRING( \ | |
| 144 "CREATE TEMP TABLE moz_openpages_temp (" \ | |
| 145 " url TEXT PRIMARY KEY" \ | |
| 146 ", open_count INTEGER" \ | |
| 147 ")" \ | |
| 148 ) | |
| 149 | |
| 150 #endif // __nsPlacesTables_h__ |
