Index: openacs-4/packages/spam/sql/oracle/spam-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/spam/sql/oracle/spam-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/spam/sql/oracle/spam-create.sql	20 Apr 2001 20:51:25 -0000	1.1
+++ openacs-4/packages/spam/sql/oracle/spam-create.sql	4 Sep 2001 21:14:59 -0000	1.2
@@ -2,7 +2,8 @@
 	-- extends acs_mail_bodies
 	spam_id		integer not null	
 			constraint spam_messages_spam_id_fk
-			references acs_mail_links(mail_link_id),
+			references acs_mail_links(mail_link_id)
+                        on delete cascade,
 	-- date to send the spam out 
 	-- spam will be put in mail queue at that time
 	send_date	date not null,