X-Git-Url: http://git.hcoop.net/hcoop/zz_old/portal.git/blobdiff_plain/46b0c2df0510b11fcc81dc98cdcf14477bc82db9..369e1577bf72be99dcbb142fe605e5b4e6548102:/tables.sql

diff --git a/tables.sql b/tables.sql
index 5481e29..df2d5be 100644
--- a/tables.sql
+++ b/tables.sql
@@ -111,11 +111,12 @@ CREATE TABLE ContactKind(
 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;