From 50abd557184326f173357b50e7593dc3f452be91 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Sat, 25 May 2013 15:37:46 +0200 Subject: Added shared (cross-user) cache --- SQL/mysql.initial.sql | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'SQL/mysql.initial.sql') 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'); -- cgit v1.2.3