Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql,v
diff -u -N -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql	8 Apr 2007 17:16:03 -0000	1.1.2.2
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql	14 Sep 2007 20:38:53 -0000	1.1.2.3
@@ -297,3 +297,9 @@
 /
 show errors;
 	
+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;
