Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	27 Feb 2005 01:21:07 -0000	1.29
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	25 Sep 2006 17:59:16 -0000	1.30
@@ -19,7 +19,7 @@
 ---------------------------------------------
 
 create table acs_privileges (
-	privilege	varchar(100) not null constraint acs_privileges_pk
+	privilege	varchar(100) not null constraint acs_privileges_privilege_pk
 			primary key,
 	pretty_name	varchar(100),
 	pretty_plural	varchar(100)
@@ -335,15 +335,15 @@
 
 create table acs_permissions (
 	object_id		integer not null
-				constraint acs_permissions_on_what_id_fk
+				constraint acs_permissions_object_id_fk
 				references acs_objects (object_id)
                                 on delete cascade,
 	grantee_id		integer not null
 				constraint acs_permissions_grantee_id_fk
 				references parties (party_id)
                                 on delete cascade,
 	privilege		varchar(100) not null 
-                                constraint acs_permissions_priv_fk
+                                constraint acs_permissions_privilege_fk
 				references acs_privileges (privilege)
                                 on delete cascade,
 	constraint acs_permissions_pk