CREATE SEQUENCE ContactKindSeq START 1;
CREATE TABLE Contact(
+ id INTEGER PRIMARY KEY,
usr INTEGER NOT NULL,
knd INTEGER NOT NULL,
v TEXT NOT NULL,
priv INTEGER NOT NULL,
- PRIMARY KEY (usr, knd),
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
FOREIGN KEY (knd) REFERENCES ContactKind(id) ON DELETE CASCADE);
-
\ No newline at end of file
+
+CREATE SEQUENCE ContactSeq START 1;