Index: openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql	5 Dec 2004 17:08:57 -0000	1.4
+++ openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql	28 Jan 2005 20:36:56 -0000	1.5
@@ -15,3 +15,43 @@
 drop table as_assessments;
 drop table as_sections;
 drop table as_section_display_types;
+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 functions
+
+drop function as_inter_item_check__new (integer,boolean,integer,integer,varchar,varchar,varchar,boolean,integer,integer,integer,integer);
+
+drop function as_inter_item_check__delete (integer);
+
+create function inline_0()
+returns integer as '
+declare
+	object_rec	record;
+begin 
+
+	-- drop objects
+ 	for object_rec in select object_id from acs_objects where object_type = ''as_inter_item_check''
+	loop
+		PERFORM acs_object__delete ( object_rec.object_id );
+	end loop;
+
+	return 0;
+end;' language 'plpgsql';
+
+select inline_0();
+
+drop function inline_0();
+
+-- drop type
+
+select acs_object_type__drop_type (
+	'as_inter_item_check',
+	't'
+	);
+
+drop table as_inter_item_checks;
+