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.6 --- 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 29 Jan 2019 17:10:34 -0000 1.6 @@ -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,6 +50,7 @@ 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, @@ -122,4 +124,4 @@ end; / -@@ faq-package-create.sql \ No newline at end of file +@@ faq-package-create.sql