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