File manager - Edit - /usr/local/cpanel/base/3rdparty/roundcube/SQL/sqlite/2011092800.sql
Back
-- 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);
| ver. 1.4 |
Github
|
.
| PHP 8.1.34 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings