docs/SQL

[Aleksander Machniak]

 docs/SQL/mysql.initial.sql |   10 ++++++++++
 1 file changed, 10 insertions(+)

New commits:
commit 0164e37993e4ba57fd5615a9cc441c577bd04bf5
Author: Aleksander Machniak <alec at alec.pl>
Date:   Fri Jan 18 09:10:50 2013 +0100

    Add insert into system with current schema version

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');