summaryrefslogtreecommitdiff
path: root/docs/SQL/mysql/2014101300.sql
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/SQL/mysql/2014101300.sql
parentc7bccf0ed1ab31bcf4a0f2c1ab07b8d7e934a00a (diff)
downloadkolab-syncroton-92b081cf384a7c5158a2852f52a3c11a717f936a.tar.gz
Complete email categories support, fix category changes detection (#3489)
Diffstat (limited to 'docs/SQL/mysql/2014101300.sql')
-rw-r--r--docs/SQL/mysql/2014101300.sql10
1 files changed, 10 insertions, 0 deletions
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 */;