summaryrefslogtreecommitdiff
path: root/docs/SQL/oracle/2014101300.sql
diff options
context:
space:
mode:
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")
+);