Index: openacs-4/packages/faq/sql/oracle/faq-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/oracle/faq-create.sql,v
diff -u -r1.5 -r1.5.16.1
--- openacs-4/packages/faq/sql/oracle/faq-create.sql	1 Apr 2004 22:52:45 -0000	1.5
+++ openacs-4/packages/faq/sql/oracle/faq-create.sql	14 Feb 2019 16:15:01 -0000	1.5.16.1
@@ -21,6 +21,7 @@
 create table faqs (
 		faq_id    constraint faqs_faq_id_fk
 			  references acs_objects (object_id)
+                          on delete cascade
 			  constraint faqs_pk
 			  primary key,
 		faq_name  varchar (250)
@@ -49,9 +50,10 @@
 create table faq_q_and_as (
 	entry_id  constraint faq_q_and_as_entry_id_fk  
 		  references acs_objects (object_id)
+                  on delete cascade
 		  constraint faq_q_sand_a_pk
          	  primary key,
-	faq_id	  integer references faqs not null,
+	faq_id	  integer not null references faqs on delete cascade,
 	question  varchar (4000) not null,
 	answer    varchar (4000) not null,
 	-- determines the order of questions in a FAQ
@@ -122,4 +124,4 @@
 end;
 /
 
-@@ faq-package-create.sql
\ No newline at end of file
+@@ faq-package-create.sql
