Changeset 2090df0c85d347d43405ce36c1fd4a76ac8fab4d

Timestamp:

11/06/09 22:19:18 (10 months ago)

Author:

Stephen Bennett <spb@…>

Parents:

457755db65a4216ea59f1b548a2541db159025d0

Children:

20b3fcc6b52236b404b7d7aaf1517f57be3f84a2

git-committer:

Stephen Bennett <spb@exherbo.org> / 2009-11-06T22:19:18Z+0000

Message:

Use named constraints for uniqueness of various db columns, to make understanding the error messages easier

Files:

• sql/gms_create.sql (modified) (2 diffs)

sql/gms_create.sql

@@ -44 +44 @@
 CREATE TABLE groups (
     id              SERIAL PRIMARY KEY,
-    groupname       VARCHAR(32) NOT NULL,
+    groupname       VARCHAR(32) NOT NULL CONSTRAINT unique_group_name UNIQUE,
     grouptype       group_type NOT NULL,
     url             VARCHAR(64) NOT NULL,
     address         INTEGER DEFAULT NULL,
-    status          group_status,
+    status          group_status NOT NULL,
     verify_url      VARCHAR(255),
     verify_token    VARCHAR(16),
@@ -58 +58 @@
 CREATE TABLE channel_namespaces (
     group_id        INTEGER NOT NULL REFERENCES groups(id),
-    namespace       VARCHAR(32) UNIQUE NOT NULL
+    namespace       VARCHAR(32) NOT NULL CONSTRAINT unique_channel_ns UNIQUE
 );
 
 CREATE TABLE cloak_namespaces (
     group_id        INTEGER NOT NULL REFERENCES groups(id),
-    namespace       VARCHAR(32) UNIQUE NOT NULL
+    namespace       VARCHAR(32) NOT NULL CONSTRAINT unique_cloak_ns UNIQUE
 );