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.28 -r1.29
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	18 Jun 2004 18:21:57 -0000	1.28
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	27 Feb 2005 01:21:07 -0000	1.29
@@ -336,13 +336,16 @@
 create table acs_permissions (
 	object_id		integer not null
 				constraint acs_permissions_on_what_id_fk
-				references acs_objects (object_id),
+				references acs_objects (object_id)
+                                on delete cascade,
 	grantee_id		integer not null
 				constraint acs_permissions_grantee_id_fk
-				references parties (party_id),
+				references parties (party_id)
+                                on delete cascade,
 	privilege		varchar(100) not null 
                                 constraint acs_permissions_priv_fk
-				references acs_privileges (privilege),
+				references acs_privileges (privilege)
+                                on delete cascade,
 	constraint acs_permissions_pk
 	primary key (object_id, grantee_id, privilege)
 );
