summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorAleksander Machniak <machniak@kolabsys.com>2014-09-05 10:12:40 (GMT)
committerAleksander Machniak <machniak@kolabsys.com>2014-09-05 10:12:40 (GMT)
commit92b081cf384a7c5158a2852f52a3c11a717f936a (patch)
treecc779a44747add7af5af40a69353308c5a099d20 /docs
parentc7bccf0ed1ab31bcf4a0f2c1ab07b8d7e934a00a (diff)
downloadkolab-syncroton-92b081cf384a7c5158a2852f52a3c11a717f936a.tar.gz
Complete email categories support, fix category changes detection (#3489)
Diffstat (limited to 'docs')
-rw-r--r--docs/SQL/mysql.initial.sql12
-rw-r--r--docs/SQL/mysql/2014101300.sql10
-rw-r--r--docs/SQL/oracle.initial.sql11
-rw-r--r--docs/SQL/oracle/2014101300.sql8
4 files changed, 39 insertions, 2 deletions
diff --git a/docs/SQL/mysql.initial.sql b/docs/SQL/mysql.initial.sql
index 7c68bf2..aa8aeb4 100644
--- a/docs/SQL/mysql.initial.sql
+++ b/docs/SQL/mysql.initial.sql
@@ -105,6 +105,16 @@ CREATE TABLE IF NOT EXISTS `syncroton_modseq` (
CONSTRAINT `syncroton_modseq::device_id--syncroton_device::id` FOREIGN KEY (`device_id`) REFERENCES `syncroton_device` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+CREATE TABLE IF NOT EXISTS `syncroton_relations_state` (
+ `device_id` varchar(40) NOT NULL,
+ `folder_id` varchar(40) NOT NULL,
+ `synctime` datetime NOT NULL,
+ `data` longblob,
+ PRIMARY KEY (`device_id`,`folder_id`,`synctime`),
+ KEY `syncroton_relations_state::device_id` (`device_id`),
+ CONSTRAINT `syncroton_relations_state::device_id--syncroton_device::id` FOREIGN KEY (`device_id`) REFERENCES `syncroton_device` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
+
-- Roundcube core table should exist if we're using the same database
CREATE TABLE IF NOT EXISTS `system` (
@@ -113,4 +123,4 @@ CREATE TABLE IF NOT EXISTS `system` (
PRIMARY KEY(`name`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2014093000');
+INSERT INTO `system` (`name`, `value`) VALUES ('syncroton-version', '2014101300');
diff --git a/docs/SQL/mysql/2014101300.sql b/docs/SQL/mysql/2014101300.sql
new file mode 100644
index 0000000..cf3ea13
--- /dev/null
+++ b/docs/SQL/mysql/2014101300.sql
@@ -0,0 +1,10 @@
+CREATE TABLE IF NOT EXISTS `syncroton_relations_state` (
+ `device_id` varchar(40) NOT NULL,
+ `folder_id` varchar(40) NOT NULL,
+ `synctime` datetime NOT NULL,
+ `data` longblob,
+ PRIMARY KEY (`device_id`,`folder_id`,`synctime`),
+ KEY `syncroton_relations_state::device_id` (`device_id`),
+ CONSTRAINT `syncroton_relations_state::device_id--syncroton_device::id`
+ FOREIGN KEY (`device_id`) REFERENCES `syncroton_device` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
diff --git a/docs/SQL/oracle.initial.sql b/docs/SQL/oracle.initial.sql
index f3d1894..1ac4227 100644
--- a/docs/SQL/oracle.initial.sql
+++ b/docs/SQL/oracle.initial.sql
@@ -101,4 +101,13 @@ CREATE TABLE "syncroton_modseq" (
PRIMARY KEY ("device_id", "folder_id", "synctime")
);
-INSERT INTO "system" ("name", "value") VALUES ('syncroton-version', '2014093000');
+CREATE TABLE "syncroton_relations_state" (
+ "device_id" varchar(40) NOT NULL
+ REFERENCES "syncroton_device" ("id") ON DELETE CASCADE,
+ "folder_id" varchar(40) NOT NULL,
+ "synctime" timestamp NOT NULL,
+ "data" clob,
+ PRIMARY KEY ("device_id", "folder_id", "synctime")
+);
+
+INSERT INTO "system" ("name", "value") VALUES ('syncroton-version', '2014101300');
diff --git a/docs/SQL/oracle/2014101300.sql b/docs/SQL/oracle/2014101300.sql
new file mode 100644
index 0000000..cff3c65
--- /dev/null
+++ b/docs/SQL/oracle/2014101300.sql
@@ -0,0 +1,8 @@
+CREATE TABLE "syncroton_relations_state" (
+ "device_id" varchar(40) NOT NULL
+ REFERENCES "syncroton_device" ("id") ON DELETE CASCADE,
+ "folder_id" varchar(40) NOT NULL,
+ "synctime" timestamp NOT NULL,
+ "data" clob,
+ PRIMARY KEY ("device_id", "folder_id", "synctime")
+);