Index: openacs-4/packages/assessment/sql/oracle/assessment-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/assessment-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/sql/oracle/assessment-drop.sql	28 Jan 2005 20:37:19 -0000	1.3
+++ openacs-4/packages/assessment/sql/oracle/assessment-drop.sql	30 Jan 2005 14:16:14 -0000	1.4
@@ -1,37 +1,51 @@
-drop table as_item_types_map;
-
-drop table as_item_choices;
-drop table as_item_attributes;
-drop table as_item_localized;
-
-drop table as_item_section_map;
-
-drop table as_items;
-drop table as_item_display_types;
-drop table as_item_type_attributes;
-drop table as_item_types;
-
-drop table as_assessment_section_map;
-drop table as_assessments;
-drop table as_sections;
-drop table as_section_display_types;
+drop sequence action_log_id_seq;
+drop table as_actions_log;
 drop table as_param_map;
-
 drop table as_action_params;
-drop table as_actions_log;
 drop table as_action_map;
 drop table as_actions;
 
-
 drop package as_inter_item_check;
 
-
 declare begin
-	acs_object_type.drop_type (object_type 	=>	'as_inter_item_checks');
+	acs_object_type.drop_type (object_type => 'as_inter_item_check');
 end;
 /
 show errors;
 
-
 drop table as_inter_item_checks;
 
+drop table as_item_rels;
+drop table as_item_types_map;
+
+drop table as_session_item_map;
+drop table as_session_choices;
+drop table as_session_items;
+drop table as_session_sections;
+drop table as_item_data_choices;
+drop table as_item_data;
+drop table as_section_data;
+drop table as_sessions;
+
+drop table as_item_section_map;
+drop table as_assessment_section_map;
+drop table as_assessment_styles;
+drop table as_assessments;
+drop table as_sections;
+drop table as_section_display_types;
+
+drop table as_item_help_map;
+drop table as_messages;
+drop table as_item_sa_answers;
+drop table as_item_choices;
+drop table as_items;
+
+drop table as_item_display_ta;
+drop table as_item_display_tb;
+drop table as_item_display_sb;
+drop table as_item_display_sa;
+drop table as_item_display_cb;
+drop table as_item_display_rb;
+drop table as_item_type_sa;
+drop table as_item_type_oq;
+drop table as_item_type_mc;