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 -r1.1.2.3 -r1.1.2.4
--- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql	14 Sep 2007 20:38:53 -0000	1.1.2.3
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d3-0.22d4.sql	14 Sep 2007 23:58:31 -0000	1.1.2.4
@@ -297,9 +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;
+alter table as_session_items drop constraint as_sess_items_item_fk;
+alter table as_session_items drop constraint as_sess_items_section_fk;
+alter table as_session_items drop constraint as_sess_items_session_fk;
+alter table as_session_items add constraint "as_sess_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_sess_items_section_fk" FOREIGN KEY (section_id) REFERENCES as_sections(section_id) on delete cascade;
+alter table as_session_items add constraint "as_sess_items_session_fk" FOREIGN KEY (session_id) REFERENCES as_sessions(session_id) on delete cascade;