[vhffs-dev] [svn] commit: r292 - in /branches/vhffs_4.1/vhffs-backend/src/pgsql: alter_from4.0_tocurrent.sql initdb.sql

[vhffs-dev@xxxxxxxxx]

Author: beuss
Date: Fri Nov 10 08:01:38 2006
New Revision: 292

Log:
Renamed constraint for vhffs_users and added one for vhffs groups (unique group name).

Modified:
    branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0_tocurrent.sql
    branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql

Modified: branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0_tocurrent.sql
==============================================================================
--- branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0_tocurrent.sql (original)
+++ branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0_tocurrent.sql Fri Nov 10 08:01:38 2006
@@ -25,4 +25,6 @@
 SELECT setval('vhffs_svn_svn_id_seq', (SELECT COALESCE(MAX(svn_id), 1) FROM vhffs_svn));
 
 -- username must be unique
-ALTER TABLE vhffs_users ADD CONSTRAINT unique_username UNIQUE (username);
+ALTER TABLE vhffs_users ADD CONSTRAINT vhffs_users_unique_username UNIQUE (username);
+ALTER TABLE vhffs_groups ADD CONSTRAINT vhffs_groups_unique_groupname UNIQUE (groupname);
+

Modified: branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql
==============================================================================
--- branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql (original)
+++ branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql Fri Nov 10 08:01:38 2006
@@ -366,7 +366,8 @@
 
 
 /****** Indexes and unique constraints *******/
-ALTER TABLE vhffs_users ADD CONSTRAINT unique_username UNIQUE (username);
+ALTER TABLE vhffs_users ADD CONSTRAINT vhffs_users_unique_username UNIQUE (username);
+ALTER TABLE vhffs_groups ADD CONSTRAINT vhffs_groups_unique_groupname UNIQUE (groupname);
 
 /****** Non primary key constraints.
       Defining foreign keys here allow to create tables in any order.