diff options
| author | Aleksander Machniak <alec@alec.pl> | 2013-05-25 15:37:46 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2013-05-25 15:37:46 +0200 |
| commit | 50abd557184326f173357b50e7593dc3f452be91 (patch) | |
| tree | dc5f097ba3eaac279e9f0021172e7dbbc878a706 /SQL/mysql.initial.sql | |
| parent | a963a2b38cf571b29543d17edadc46f91caba3aa (diff) | |
Added shared (cross-user) cache
Diffstat (limited to 'SQL/mysql.initial.sql')
| -rw-r--r-- | SQL/mysql.initial.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 5a86dd8f8..75268ca03 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -45,6 +45,17 @@ CREATE TABLE `cache` ( ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; +-- Table structure for table `cache_shared` + +CREATE TABLE `cache_shared` ( + `cache_key` varchar(255) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL , + `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', + `data` longtext NOT NULL, + INDEX `created_index` (`created`), + INDEX `cache_key_index` (`cache_key`) +) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; + + -- Table structure for table `cache_index` CREATE TABLE `cache_index` ( @@ -196,4 +207,4 @@ CREATE TABLE `system` ( /*!40014 SET FOREIGN_KEY_CHECKS=1 */; -INSERT INTO system (name, value) VALUES ('roundcube-version', '2013042700'); +INSERT INTO system (name, value) VALUES ('roundcube-version', '2013052500'); |