Index: openacs-4/packages/acs-object-management/sql/postgresql/acs-object-management-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-object-management/sql/postgresql/acs-object-management-drop.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-object-management/sql/postgresql/acs-object-management-drop.sql	10 Dec 2009 22:21:10 -0000	1.1
@@ -0,0 +1,36 @@
+drop table acs_view_attribute_widget_params;
+drop table acs_view_attribute_widgets;
+drop table acs_form_widget_params;
+drop table acs_form_default_widgets;
+drop table acs_form_widgets;
+drop table acs_view_attributes;
+drop table acs_views;
+
+drop sequence acs_form_widget_param_seq;
+
+delete from acs_datatypes where datatype = 'richtext';
+delete from acs_datatypes where datatype = 'filename';
+delete from acs_datatypes where datatype = 'float';
+delete from acs_datatypes where datatype = 'naturalnum';
+
+alter table acs_datatypes drop column database_type;
+alter table acs_datatypes drop column column_size;
+alter table acs_datatypes drop column column_check_expr;
+alter table acs_datatypes drop column column_output_function;
+
+drop function content_type__create_type (varchar,varchar,varchar,varchar,varchar,varchar,varchar);
+drop function content_type__create_attribute (varchar,varchar,varchar,varchar,varchar,integer,varchar,varchar);
+drop function acs_datatype__date_output_function(text);
+drop function acs_datatype__timestamp_output_function(text);
+drop function acs_view__drop_sql_view (varchar);
+drop function acs_view__create_sql_view (varchar);
+drop function acs_object_type__refresh_view (varchar);
+drop function acs_object_type__create_type (varchar,varchar,varchar,varchar,varchar,varchar,varchar,boolean,varchar,varchar, boolean, boolean);
+drop function acs_object_type__create_type (varchar,varchar,varchar,varchar,varchar,varchar,varchar,boolean,varchar,varchar);
+drop function acs_attribute__create_attribute (varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer,integer,integer,varchar,boolean,boolean,varchar,varchar,boolean,varchar,varchar,varchar);
+drop function acs_attribute__create_attribute (varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer,integer,integer,varchar,boolean);
+drop function acs_attribute__create_attribute (varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer,integer,integer,integer,varchar,boolean);
+drop function acs_object_type__drop_type (varchar,boolean,boolean,boolean);
+drop function acs_object_type__drop_type (varchar,boolean);
+drop function acs_attribute__drop_attribute (varchar,varchar,boolean);
+drop function acs_attribute__drop_attribute (varchar,varchar);