[vhffs-dev] [398] Oops, forgot a ; |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 398
Author: beuss
Date: 2007-01-14 17:32:18 +0000 (Sun, 14 Jan 2007)
Log Message:
-----------
Oops, forgot a ;
Modified Paths:
--------------
branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql
Modified: branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql
===================================================================
--- branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql 2007-01-14 14:39:35 UTC (rev 397)
+++ branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql 2007-01-14 17:32:18 UTC (rev 398)
@@ -368,7 +368,9 @@
/****** Indexes and unique constraints *******/
ALTER TABLE vhffs_users ADD CONSTRAINT vhffs_users_unique_username UNIQUE (username);
ALTER TABLE vhffs_groups ADD CONSTRAINT vhffs_groups_unique_groupname UNIQUE (groupname);
+ALTER TABLE vhffs_cvs ADD CONSTRAINT vhffs_cvs_unique_cvsroot UNIQUE (cvsroot);
+
/****** Non primary key constraints.
Defining foreign keys here allow to create tables in any order.
*******/
@@ -381,7 +383,7 @@
ALTER TABLE vhffs_users ADD CONSTRAINT fk_vhffs_users_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object (object_id) ON DELETE CASCADE;
ALTER TABLE vhffs_cvs ADD CONSTRAINT fk_vhffs_cvs_vhffs_users FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid);
-ALTER TABLE vhffs_cvs ADD CONSTRAINT fk_vhffs_cvs_vhffs_groups FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid)
+ALTER TABLE vhffs_cvs ADD CONSTRAINT fk_vhffs_cvs_vhffs_groups FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid);
ALTER TABLE vhffs_cvs ADD CONSTRAINT fk_vhffs_cvs_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;
ALTER TABLE vhffs_dns_global ADD CONSTRAINT fk_vhffs_dns_vhffs_users FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid);