Changeset 87 in code for trunk/schema.sql

Timestamp:

Mar 12, 2020, 2:33:49 PM (5 years ago)

Author:

contact

Message:

schema: add UNIQUE constraints

File:

• trunk/schema.sql (modified) (2 diffs)

trunk/schema.sql

@@ -11 +11 @@
         username VARCHAR(255),
         realname VARCHAR(255),
-        FOREIGN KEY(user) REFERENCES User(username)
+        FOREIGN KEY(user) REFERENCES User(username),
+        UNIQUE(user, addr, nick)
 );
 
@@ -18 +19 @@
         network INTEGER NOT NULL,
         name VARCHAR(255) NOT NULL,
-        FOREIGN KEY(network) REFERENCES Network(id)
+        FOREIGN KEY(network) REFERENCES Network(id),
+        UNIQUE(network, name)
 );