summaryrefslogtreecommitdiff
path: root/docs/SQL/oracle/2014101300.sql
blob: cff3c650d3b5ef7d0cff68a2e4279af23a40e5d0 (plain)
1
2
3
4
5
6
7
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")
);