1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/toolkit/components/places/nsPlacesTables.h Wed Dec 31 06:09:35 2014 +0100
1.3 @@ -0,0 +1,150 @@
1.4 +/* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*-
1.5 + * vim: sw=2 ts=2 et lcs=trail\:.,tab\:>~ :
1.6 + * This Source Code Form is subject to the terms of the Mozilla Public
1.7 + * License, v. 2.0. If a copy of the MPL was not distributed with this
1.8 + * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
1.9 +
1.10 +#ifndef __nsPlacesTables_h__
1.11 +#define __nsPlacesTables_h__
1.12 +
1.13 +
1.14 +#define CREATE_MOZ_PLACES NS_LITERAL_CSTRING( \
1.15 + "CREATE TABLE moz_places ( " \
1.16 + " id INTEGER PRIMARY KEY" \
1.17 + ", url LONGVARCHAR" \
1.18 + ", title LONGVARCHAR" \
1.19 + ", rev_host LONGVARCHAR" \
1.20 + ", visit_count INTEGER DEFAULT 0" \
1.21 + ", hidden INTEGER DEFAULT 0 NOT NULL" \
1.22 + ", typed INTEGER DEFAULT 0 NOT NULL" \
1.23 + ", favicon_id INTEGER" \
1.24 + ", frecency INTEGER DEFAULT -1 NOT NULL" \
1.25 + ", last_visit_date INTEGER " \
1.26 + ", guid TEXT" \
1.27 + ")" \
1.28 +)
1.29 +#define MOZ_PLACES_COLUMNS \
1.30 + "id, url, title, rev_host, visit_count, hidden, typed, favicon_id, " \
1.31 + "frecency, last_visit_date"
1.32 +
1.33 +#define CREATE_MOZ_HISTORYVISITS NS_LITERAL_CSTRING( \
1.34 + "CREATE TABLE moz_historyvisits (" \
1.35 + " id INTEGER PRIMARY KEY" \
1.36 + ", from_visit INTEGER" \
1.37 + ", place_id INTEGER" \
1.38 + ", visit_date INTEGER" \
1.39 + ", visit_type INTEGER" \
1.40 + ", session INTEGER" \
1.41 + ")" \
1.42 +)
1.43 +#define MOZ_HISTORYVISITS_COLUMNS \
1.44 + "id, from_visit, place_id, visit_date, visit_type, session"
1.45 +
1.46 +
1.47 +#define CREATE_MOZ_INPUTHISTORY NS_LITERAL_CSTRING( \
1.48 + "CREATE TABLE moz_inputhistory (" \
1.49 + " place_id INTEGER NOT NULL" \
1.50 + ", input LONGVARCHAR NOT NULL" \
1.51 + ", use_count INTEGER" \
1.52 + ", PRIMARY KEY (place_id, input)" \
1.53 + ")" \
1.54 +)
1.55 +
1.56 +#define CREATE_MOZ_ANNOS NS_LITERAL_CSTRING( \
1.57 + "CREATE TABLE moz_annos (" \
1.58 + " id INTEGER PRIMARY KEY" \
1.59 + ", place_id INTEGER NOT NULL" \
1.60 + ", anno_attribute_id INTEGER" \
1.61 + ", mime_type VARCHAR(32) DEFAULT NULL" \
1.62 + ", content LONGVARCHAR" \
1.63 + ", flags INTEGER DEFAULT 0" \
1.64 + ", expiration INTEGER DEFAULT 0" \
1.65 + ", type INTEGER DEFAULT 0" \
1.66 + ", dateAdded INTEGER DEFAULT 0" \
1.67 + ", lastModified INTEGER DEFAULT 0" \
1.68 + ")" \
1.69 +)
1.70 +
1.71 +#define CREATE_MOZ_ANNO_ATTRIBUTES NS_LITERAL_CSTRING( \
1.72 + "CREATE TABLE moz_anno_attributes (" \
1.73 + " id INTEGER PRIMARY KEY" \
1.74 + ", name VARCHAR(32) UNIQUE NOT NULL" \
1.75 + ")" \
1.76 +)
1.77 +
1.78 +#define CREATE_MOZ_ITEMS_ANNOS NS_LITERAL_CSTRING( \
1.79 + "CREATE TABLE moz_items_annos (" \
1.80 + " id INTEGER PRIMARY KEY" \
1.81 + ", item_id INTEGER NOT NULL" \
1.82 + ", anno_attribute_id INTEGER" \
1.83 + ", mime_type VARCHAR(32) DEFAULT NULL" \
1.84 + ", content LONGVARCHAR" \
1.85 + ", flags INTEGER DEFAULT 0" \
1.86 + ", expiration INTEGER DEFAULT 0" \
1.87 + ", type INTEGER DEFAULT 0" \
1.88 + ", dateAdded INTEGER DEFAULT 0" \
1.89 + ", lastModified INTEGER DEFAULT 0" \
1.90 + ")" \
1.91 +)
1.92 +
1.93 +#define CREATE_MOZ_FAVICONS NS_LITERAL_CSTRING( \
1.94 + "CREATE TABLE moz_favicons (" \
1.95 + " id INTEGER PRIMARY KEY" \
1.96 + ", url LONGVARCHAR UNIQUE" \
1.97 + ", data BLOB" \
1.98 + ", mime_type VARCHAR(32)" \
1.99 + ", expiration LONG" \
1.100 + ", guid TEXT" \
1.101 + ")" \
1.102 +)
1.103 +
1.104 +#define CREATE_MOZ_BOOKMARKS NS_LITERAL_CSTRING( \
1.105 + "CREATE TABLE moz_bookmarks (" \
1.106 + " id INTEGER PRIMARY KEY" \
1.107 + ", type INTEGER" \
1.108 + ", fk INTEGER DEFAULT NULL" /* place_id */ \
1.109 + ", parent INTEGER" \
1.110 + ", position INTEGER" \
1.111 + ", title LONGVARCHAR" \
1.112 + ", keyword_id INTEGER" \
1.113 + ", folder_type TEXT" \
1.114 + ", dateAdded INTEGER" \
1.115 + ", lastModified INTEGER" \
1.116 + ", guid TEXT" \
1.117 + ")" \
1.118 +)
1.119 +
1.120 +#define CREATE_MOZ_BOOKMARKS_ROOTS NS_LITERAL_CSTRING( \
1.121 + "CREATE TABLE moz_bookmarks_roots (" \
1.122 + " root_name VARCHAR(16) UNIQUE" \
1.123 + ", folder_id INTEGER" \
1.124 + ")" \
1.125 +)
1.126 +
1.127 +#define CREATE_MOZ_KEYWORDS NS_LITERAL_CSTRING( \
1.128 + "CREATE TABLE moz_keywords (" \
1.129 + " id INTEGER PRIMARY KEY AUTOINCREMENT" \
1.130 + ", keyword TEXT UNIQUE" \
1.131 + ")" \
1.132 +)
1.133 +
1.134 +#define CREATE_MOZ_HOSTS NS_LITERAL_CSTRING( \
1.135 + "CREATE TABLE moz_hosts (" \
1.136 + " id INTEGER PRIMARY KEY" \
1.137 + ", host TEXT NOT NULL UNIQUE" \
1.138 + ", frecency INTEGER" \
1.139 + ", typed INTEGER NOT NULL DEFAULT 0" \
1.140 + ", prefix TEXT" \
1.141 + ")" \
1.142 +)
1.143 +
1.144 +// Note: this should be kept up-to-date with the definition in
1.145 +// nsPlacesAutoComplete.js.
1.146 +#define CREATE_MOZ_OPENPAGES_TEMP NS_LITERAL_CSTRING( \
1.147 + "CREATE TEMP TABLE moz_openpages_temp (" \
1.148 + " url TEXT PRIMARY KEY" \
1.149 + ", open_count INTEGER" \
1.150 + ")" \
1.151 +)
1.152 +
1.153 +#endif // __nsPlacesTables_h__
