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