Index: openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql	23 Oct 2001 18:53:36 -0000	1.9
+++ openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql	24 Oct 2001 01:10:30 -0000	1.10
@@ -135,6 +135,11 @@
         return new;
 
 end;' language 'plpgsql';
+
+create trigger sp_folders_update_tr before update 
+on sp_folders for each row 
+execute procedure sp_folders_update_tr ();
+
 -- end of tree_sortkey triggers DaveB
 
 
@@ -229,7 +234,7 @@
 -- this also creates the acs_object type
         select content_type__create_type (
 		'static_page',		-- content_type 
-		null,			-- supertype    
+		'content_revision',	-- supertype    
 		'Static Page',		-- pretty_name  
 		'Static Pages',		-- pretty_plural
 		'static_pages',		-- table_name   
Index: openacs-4/packages/static-pages/sql/postgresql/static-pages-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/postgresql/static-pages-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/static-pages/sql/postgresql/static-pages-drop.sql	24 Jul 2001 19:51:56 -0000	1.3
+++ openacs-4/packages/static-pages/sql/postgresql/static-pages-drop.sql	24 Oct 2001 01:10:30 -0000	1.4
@@ -18,12 +18,12 @@
 create function inline__0()
 returns integer as '
 declare
-        v_root_folder_row sp_folders.folder_id%TYPE;
+        v_root_folder_row RECORD;
 begin
 	for v_root_folder_row in 
 		select folder_id from sp_folders where parent_id is null
 	 loop
-		static_page__delete_folder(v_root_folder_row);
+		perform static_page__delete_folder(v_root_folder_row.folder_id);
 	end loop;
         return 0;
 end;' language 'plpgsql';
@@ -33,8 +33,6 @@
 drop function inline__0();
 
 
--- FIXME this won't work until content_type__drop_attribute in 
--- acs-content-repository/sql/postgresql/content-type.sql is fixed DaveB
 
 -- Delete content type 'static_page' and its attributes.
 
@@ -48,7 +46,9 @@
 
 select drop_package('static_page');
 
-drop sequence sp_session_id_seq;
+drop view sp_session_id_seq;
+drop sequence sp_session_id_sequence;
+
 drop table sp_extant_files;
 drop table sp_extant_folders;
 
@@ -57,4 +57,11 @@
 
 drop index sp_folders_parent_id_idx;
 drop index sp_folders_package_id_idx;
+
+drop trigger sp_folders_insert_tr on sp_folders;
+drop trigger sp_folders_update_tr on sp_folders;
+drop function sp_folders_insert_tr();
+drop function sp_folders_update_tr();
 drop table sp_folders;
+
+