The Tor Browser: toolkit/components/places/nsPlacesTables.h@6474c204b198

Cloned upstream origin tor-browser at tor-browser-31.3.0esr-4.5-1-build1
revision ID fc1c9ff7c1b2defdbc039f12214767608f46423f for hacking purpose.

     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/. */

     7 #ifndef __nsPlacesTables_h__

     8 #define __nsPlacesTables_h__

    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"

    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"

    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 )

    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 )

    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 )

    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 )

    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 )

   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 )

   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 )

   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 )

   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 )

   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 )

   150 #endif // __nsPlacesTables_h__

The Tor Browser / file revision