Index: openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql,v
diff -u -N -r1.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql	27 Feb 2005 01:21:07 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql	18 Aug 2006 18:17:49 -0000	1.10
@@ -19,7 +19,9 @@
 ---------------------------------------------
 
 create table acs_privileges (
-	privilege	varchar2(100) not null constraint acs_privileges_pk
+	privilege	varchar2(100) 
+			constraint acs_privileges_privilege_nn not null 
+			constraint acs_privileges_privilege_pk
 			primary key,
 	pretty_name	varchar2(100),
 	pretty_plural	varchar2(100)
@@ -137,16 +139,19 @@
 ------------------------------------
 
 create table acs_permissions (
-	object_id		integer not null
-				constraint acs_permissions_on_what_id_fk
+	object_id		integer 
+				constraint acs_permissions_object_id_nn not null
+				constraint acs_permissions_object_id_fk
 				references acs_objects (object_id)
                                 on delete cascade,
-	grantee_id		integer not null
+	grantee_id		integer 
+				constraint acs_permissions_grantee_id_nn 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
+	privilege		varchar(100) 
+				constraint acs_permissions_privilege_nn not null 
+                                constraint acs_permissions_privilege_fk
 				references acs_privileges (privilege)
                                 on delete cascade,
 	constraint acs_permissions_pk