michael@0: /* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*-
michael@0:  * vim: sw=2 ts=2 et lcs=trail\:.,tab\:>~ :
michael@0:  * This Source Code Form is subject to the terms of the Mozilla Public
michael@0:  * License, v. 2.0. If a copy of the MPL was not distributed with this
michael@0:  * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
michael@0: 
michael@0: #ifndef __nsPlacesTables_h__
michael@0: #define __nsPlacesTables_h__
michael@0: 
michael@0: 
michael@0: #define CREATE_MOZ_PLACES NS_LITERAL_CSTRING( \
michael@0:     "CREATE TABLE moz_places ( " \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", url LONGVARCHAR" \
michael@0:     ", title LONGVARCHAR" \
michael@0:     ", rev_host LONGVARCHAR" \
michael@0:     ", visit_count INTEGER DEFAULT 0" \
michael@0:     ", hidden INTEGER DEFAULT 0 NOT NULL" \
michael@0:     ", typed INTEGER DEFAULT 0 NOT NULL" \
michael@0:     ", favicon_id INTEGER" \
michael@0:     ", frecency INTEGER DEFAULT -1 NOT NULL" \
michael@0:     ", last_visit_date INTEGER " \
michael@0:     ", guid TEXT" \
michael@0:   ")" \
michael@0: )
michael@0: #define MOZ_PLACES_COLUMNS \
michael@0:   "id, url, title, rev_host, visit_count, hidden, typed, favicon_id, " \
michael@0:   "frecency, last_visit_date"
michael@0: 
michael@0: #define CREATE_MOZ_HISTORYVISITS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_historyvisits (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", from_visit INTEGER" \
michael@0:     ", place_id INTEGER" \
michael@0:     ", visit_date INTEGER" \
michael@0:     ", visit_type INTEGER" \
michael@0:     ", session INTEGER" \
michael@0:   ")" \
michael@0: )
michael@0: #define MOZ_HISTORYVISITS_COLUMNS \
michael@0:   "id, from_visit, place_id, visit_date, visit_type, session"
michael@0: 
michael@0: 
michael@0: #define CREATE_MOZ_INPUTHISTORY NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_inputhistory (" \
michael@0:     "  place_id INTEGER NOT NULL" \
michael@0:     ", input LONGVARCHAR NOT NULL" \
michael@0:     ", use_count INTEGER" \
michael@0:     ", PRIMARY KEY (place_id, input)" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_ANNOS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_annos (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", place_id INTEGER NOT NULL" \
michael@0:     ", anno_attribute_id INTEGER" \
michael@0:     ", mime_type VARCHAR(32) DEFAULT NULL" \
michael@0:     ", content LONGVARCHAR" \
michael@0:     ", flags INTEGER DEFAULT 0" \
michael@0:     ", expiration INTEGER DEFAULT 0" \
michael@0:     ", type INTEGER DEFAULT 0" \
michael@0:     ", dateAdded INTEGER DEFAULT 0" \
michael@0:     ", lastModified INTEGER DEFAULT 0" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_ANNO_ATTRIBUTES NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_anno_attributes (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", name VARCHAR(32) UNIQUE NOT NULL" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_ITEMS_ANNOS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_items_annos (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", item_id INTEGER NOT NULL" \
michael@0:     ", anno_attribute_id INTEGER" \
michael@0:     ", mime_type VARCHAR(32) DEFAULT NULL" \
michael@0:     ", content LONGVARCHAR" \
michael@0:     ", flags INTEGER DEFAULT 0" \
michael@0:     ", expiration INTEGER DEFAULT 0" \
michael@0:     ", type INTEGER DEFAULT 0" \
michael@0:     ", dateAdded INTEGER DEFAULT 0" \
michael@0:     ", lastModified INTEGER DEFAULT 0" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_FAVICONS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_favicons (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", url LONGVARCHAR UNIQUE" \
michael@0:     ", data BLOB" \
michael@0:     ", mime_type VARCHAR(32)" \
michael@0:     ", expiration LONG" \
michael@0:     ", guid TEXT" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_BOOKMARKS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_bookmarks (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", type INTEGER" \
michael@0:     ", fk INTEGER DEFAULT NULL" /* place_id */ \
michael@0:     ", parent INTEGER" \
michael@0:     ", position INTEGER" \
michael@0:     ", title LONGVARCHAR" \
michael@0:     ", keyword_id INTEGER" \
michael@0:     ", folder_type TEXT" \
michael@0:     ", dateAdded INTEGER" \
michael@0:     ", lastModified INTEGER" \
michael@0:     ", guid TEXT" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_BOOKMARKS_ROOTS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_bookmarks_roots (" \
michael@0:     "  root_name VARCHAR(16) UNIQUE" \
michael@0:     ", folder_id INTEGER" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_KEYWORDS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_keywords (" \
michael@0:     "  id INTEGER PRIMARY KEY AUTOINCREMENT" \
michael@0:     ", keyword TEXT UNIQUE" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #define CREATE_MOZ_HOSTS NS_LITERAL_CSTRING( \
michael@0:   "CREATE TABLE moz_hosts (" \
michael@0:     "  id INTEGER PRIMARY KEY" \
michael@0:     ", host TEXT NOT NULL UNIQUE" \
michael@0:     ", frecency INTEGER" \
michael@0:     ", typed INTEGER NOT NULL DEFAULT 0" \
michael@0:     ", prefix TEXT" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: // Note: this should be kept up-to-date with the definition in
michael@0: //       nsPlacesAutoComplete.js.
michael@0: #define CREATE_MOZ_OPENPAGES_TEMP NS_LITERAL_CSTRING( \
michael@0:   "CREATE TEMP TABLE moz_openpages_temp (" \
michael@0:     "  url TEXT PRIMARY KEY" \
michael@0:     ", open_count INTEGER" \
michael@0:   ")" \
michael@0: )
michael@0: 
michael@0: #endif // __nsPlacesTables_h__