Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d2-0.22d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d2-0.22d3.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d2-0.22d3.sql	8 Dec 2006 14:20:33 -0000	1.1
@@ -0,0 +1,52 @@
+alter table as_session_sections drop constraint as_session_sections_section_fk;
+
+alter table as_session_sections drop constraint as_session_sections_session_fk;
+
+alter table as_session_sections add constraint as_session_sections_section_fk foreign key (section_id) references as_sections(section_id) on delete cascade;
+
+alter table as_session_sections add constraint as_session_sections_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_session_items drop constraint as_session_items_item_fk;
+
+alter table as_session_items drop constraint as_session_items_section_fk;
+
+alter table as_session_items drop constraint as_session_items_session_fk;
+
+alter table as_session_items add constraint as_session_items_item_fk foreign key (as_item_id) references as_items(as_item_id) on delete cascade;
+
+alter table as_session_items add constraint as_session_items_section_fk foreign key (section_id) references as_sections(section_id) on delete cascade;
+
+alter table as_session_items add constraint as_session_items_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_session_item_map drop constraint as_session_item_map_item_data_fk;
+
+alter table as_session_item_map drop constraint as_session_item_map_session_fk;
+
+alter table as_session_item_map add constraint as_session_item_map_item_data_fk foreign key (item_data_id) references as_item_data(item_data_id) on delete cascade;
+
+alter table as_session_item_map add constraint as_session_item_map_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_item_data_choices drop constraint as_item_data_choices_choice_id_fk;
+
+alter table as_item_data_choices drop constraint as_item_data_choices_data_id_fk;
+
+alter table as_item_data_choices add constraint as_item_data_choices_choice_id_fk foreign key (choice_id) references as_item_choices(choice_id) on delete cascade;
+
+alter table as_item_data_choices add constraint as_item_data_choices_data_id_fk foreign key (item_data_id) references as_item_data(item_data_id) on delete cascade;
+
+alter table as_session_choices drop constraint as_session_choices_choice_fk;
+
+alter table as_session_choices drop constraint as_session_choices_item_fk;
+
+alter table as_session_choices drop constraint as_session_choices_section_fk;
+
+alter table as_session_choices drop constraint as_session_choices_session_fk;
+
+alter table as_session_choices add constraint "as_session_choices_choice_fk" FOREIGN KEY (choice_id) REFERENCES as_item_choices(choice_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_item_fk" FOREIGN KEY (as_item_id) REFERENCES as_items(as_item_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_section_fk" FOREIGN KEY (section_id) REFERENCES as_sections(section_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_session_fk" FOREIGN KEY (session_id) REFERENCES as_sessions(session_id) on delete cascade;
+
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d2-0.22d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d2-0.22d3.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d2-0.22d3.sql	8 Dec 2006 14:20:32 -0000	1.1
@@ -0,0 +1,52 @@
+alter table as_session_sections drop constraint as_session_sections_section_fk;
+
+alter table as_session_sections drop constraint as_session_sections_session_fk;
+
+alter table as_session_sections add constraint as_session_sections_section_fk foreign key (section_id) references as_sections(section_id) on delete cascade;
+
+alter table as_session_sections add constraint as_session_sections_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_session_items drop constraint as_session_items_item_fk;
+
+alter table as_session_items drop constraint as_session_items_section_fk;
+
+alter table as_session_items drop constraint as_session_items_session_fk;
+
+alter table as_session_items add constraint as_session_items_item_fk foreign key (as_item_id) references as_items(as_item_id) on delete cascade;
+
+alter table as_session_items add constraint as_session_items_section_fk foreign key (section_id) references as_sections(section_id) on delete cascade;
+
+alter table as_session_items add constraint as_session_items_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_session_item_map drop constraint as_session_item_map_item_data_fk;
+
+alter table as_session_item_map drop constraint as_session_item_map_session_fk;
+
+alter table as_session_item_map add constraint as_session_item_map_item_data_fk foreign key (item_data_id) references as_item_data(item_data_id) on delete cascade;
+
+alter table as_session_item_map add constraint as_session_item_map_session_fk foreign key (session_id) references as_sessions(session_id) on delete cascade;
+
+alter table as_item_data_choices drop constraint as_item_data_choices_choice_id_fk;
+
+alter table as_item_data_choices drop constraint as_item_data_choices_data_id_fk;
+
+alter table as_item_data_choices add constraint as_item_data_choices_choice_id_fk foreign key (choice_id) references as_item_choices(choice_id) on delete cascade;
+
+alter table as_item_data_choices add constraint as_item_data_choices_data_id_fk foreign key (item_data_id) references as_item_data(item_data_id) on delete cascade;
+
+alter table as_session_choices drop constraint as_session_choices_choice_fk;
+
+alter table as_session_choices drop constraint as_session_choices_item_fk;
+
+alter table as_session_choices drop constraint as_session_choices_section_fk;
+
+alter table as_session_choices drop constraint as_session_choices_session_fk;
+
+alter table as_session_choices add constraint "as_session_choices_choice_fk" FOREIGN KEY (choice_id) REFERENCES as_item_choices(choice_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_item_fk" FOREIGN KEY (as_item_id) REFERENCES as_items(as_item_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_section_fk" FOREIGN KEY (section_id) REFERENCES as_sections(section_id) on delete cascade;
+
+alter table as_session_choices add constraint "as_session_choices_session_fk" FOREIGN KEY (session_id) REFERENCES as_sessions(session_id) on delete cascade;
+