"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/sqlite/2011092800.sql" (1 Jan 2020, 1503 Bytes) of package /linux/www/roundcubemail-1.4.2.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- Updates from version 0.6
    2 
    3 CREATE TABLE dictionary (
    4     user_id integer DEFAULT NULL,
    5    "language" varchar(5) NOT NULL,
    6     data text NOT NULL
    7 );
    8 
    9 CREATE UNIQUE INDEX ix_dictionary_user_language ON dictionary (user_id, "language");
   10 
   11 CREATE TABLE searches (
   12   search_id integer NOT NULL PRIMARY KEY,
   13   user_id integer NOT NULL DEFAULT '0',
   14   "type" smallint NOT NULL DEFAULT '0',
   15   name varchar(128) NOT NULL,
   16   data text NOT NULL
   17 );
   18 
   19 CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
   20 
   21 DROP TABLE messages;
   22 
   23 CREATE TABLE cache_index (
   24     user_id integer NOT NULL,
   25     mailbox varchar(255) NOT NULL,
   26     changed datetime NOT NULL default '0000-00-00 00:00:00',
   27     valid smallint NOT NULL DEFAULT '0',
   28     data text NOT NULL,
   29     PRIMARY KEY (user_id, mailbox)
   30 );
   31 
   32 CREATE INDEX ix_cache_index_changed ON cache_index (changed);
   33 
   34 CREATE TABLE cache_thread (
   35     user_id integer NOT NULL,
   36     mailbox varchar(255) NOT NULL,
   37     changed datetime NOT NULL default '0000-00-00 00:00:00',
   38     data text NOT NULL,
   39     PRIMARY KEY (user_id, mailbox)
   40 );
   41 
   42 CREATE INDEX ix_cache_thread_changed ON cache_thread (changed);
   43 
   44 CREATE TABLE cache_messages (
   45     user_id integer NOT NULL,
   46     mailbox varchar(255) NOT NULL,
   47     uid integer NOT NULL,
   48     changed datetime NOT NULL default '0000-00-00 00:00:00',
   49     data text NOT NULL,
   50     flags integer NOT NULL DEFAULT '0',
   51     PRIMARY KEY (user_id, mailbox, uid)
   52 );
   53 
   54 CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);