SM0 She11

Path: / / usr / local / cwpsrv / var / services / roundcube_13-10-2021.bak / SQL / sqlite

Full Path (server): /usr/local/cwpsrv/var/services/roundcube_13-10-2021.bak/SQL/sqlite

📄 2008030300.sql [E] [D]
📄 2008060900.sql [E] [D]
📄 2008092100.sql [E] [D]
📄 2009090400.sql [E] [D]
📄 2009103100.sql [E] [D]
📄 2010042300.sql [E] [D]
📄 2010100600.sql [E] [D]
📄 2011011200.sql [E] [D]
📄 2011092800.sql [E] [D]
📄 2011111600.sql [E] [D]
📄 2011121400.sql [E] [D]
📄 2012080700.sql [E] [D]
📄 2013011000.sql [E] [D]
📄 2013011700.sql [E] [D]
📄 2013042700.sql [E] [D]
📄 2013052500.sql [E] [D]
📄 2013061000.sql [E] [D]
📄 2014042900.sql [E] [D]
📄 2015030800.sql [E] [D]
📄 2015111100.sql [E] [D]
📄 2016081200.sql [E] [D]
📄 2016100900.sql [E] [D]
📄 2016112200.sql [E] [D]
📄 2018021600.sql [E] [D]
📄 2018122300.sql [E] [D]
📄 2019092900.sql [E] [D]

Editing: 2011092800.sql

-- Updates from version 0.6

CREATE TABLE dictionary (
    user_id integer DEFAULT NULL,
   "language" varchar(5) NOT NULL,
    data text NOT NULL
);

CREATE UNIQUE INDEX ix_dictionary_user_language ON dictionary (user_id, "language");

CREATE TABLE searches (
  search_id integer NOT NULL PRIMARY KEY,
  user_id integer NOT NULL DEFAULT '0',
  "type" smallint NOT NULL DEFAULT '0',
  name varchar(128) NOT NULL,
  data text NOT NULL
);

CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);

DROP TABLE messages;

CREATE TABLE cache_index (
    user_id integer NOT NULL,
    mailbox varchar(255) NOT NULL,
    changed datetime NOT NULL default '0000-00-00 00:00:00',
    valid smallint NOT NULL DEFAULT '0',
    data text NOT NULL,
    PRIMARY KEY (user_id, mailbox)
);

CREATE INDEX ix_cache_index_changed ON cache_index (changed);

CREATE TABLE cache_thread (
    user_id integer NOT NULL,
    mailbox varchar(255) NOT NULL,
    changed datetime NOT NULL default '0000-00-00 00:00:00',
    data text NOT NULL,
    PRIMARY KEY (user_id, mailbox)
);

CREATE INDEX ix_cache_thread_changed ON cache_thread (changed);

CREATE TABLE cache_messages (
    user_id integer NOT NULL,
    mailbox varchar(255) NOT NULL,
    uid integer NOT NULL,
    changed datetime NOT NULL default '0000-00-00 00:00:00',
    data text NOT NULL,
    flags integer NOT NULL DEFAULT '0',
    PRIMARY KEY (user_id, mailbox, uid)
);

CREATE INDEX ix_cache_messages_changed ON cache_messages (changed);