Index: openacs-4/packages/faq/sql/postgresql/faq-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-create.sql,v diff -u -N -r1.9 -r1.9.2.1 --- openacs-4/packages/faq/sql/postgresql/faq-create.sql 12 Jul 2018 08:51:04 -0000 1.9 +++ openacs-4/packages/faq/sql/postgresql/faq-create.sql 14 Feb 2019 16:15:01 -0000 1.9.2.1 @@ -30,6 +30,7 @@ create table faqs ( faq_id integer constraint faqs_faq_id_fk references acs_objects(object_id) + on delete cascade constraint faqs_pk primary key, faq_name varchar (250) @@ -66,9 +67,10 @@ create table faq_q_and_as ( entry_id integer 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