summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2013-01-18 08:10:50 (GMT)
committerAleksander Machniak <alec@alec.pl>2013-01-18 08:10:50 (GMT)
commit0164e37993e4ba57fd5615a9cc441c577bd04bf5 (patch)
treec4d149973f1d695166894848070c6d35c40536d2 /docs
parenta6efcf32ca8a96de397551b7497eaacccbb76991 (diff)
downloadkolab-syncroton-0164e37993e4ba57fd5615a9cc441c577bd04bf5.tar.gz
Add insert into system with current schema version
Diffstat (limited to 'docs')
-rw-r--r--docs/SQL/mysql.initial.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/docs/SQL/mysql.initial.sql b/docs/SQL/mysql.initial.sql
index 9bae2e1..b918f12 100644
--- a/docs/SQL/mysql.initial.sql
+++ b/docs/SQL/mysql.initial.sql
@@ -144,3 +144,13 @@ CREATE TABLE IF NOT EXISTS `syncroton_modseq` (
KEY `syncroton_modseq::device_id` (`device_id`),
CONSTRAINT `syncroton_modseq::device_id--syncroton_device::id` FOREIGN KEY (`device_id`) REFERENCES `syncroton_device` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;
+
+-- Roundcube core table should exist if we're using the same database
+
+CREATE TABLE IF NOT EXISTS `system` (
+ `name` varchar(64) NOT NULL,
+ `value` mediumtext,
+ PRIMARY KEY(`name`)
+) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+
+INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2013011600');