Index: openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql 4 Apr 2003 15:58:42 -0000 1.2 +++ openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql 5 Apr 2003 02:38:42 -0000 1.3 @@ -12,6 +12,18 @@ -- If you have any other items with a NULL content_type this will capture them -- Please confirm and test this before running on a production database. + +select content_type__create_type ( + 'etp_page_revision', -- content_type + 'content_revision', -- supertype + 'ETP managed page', -- pretty_name + 'ETP managed pages', -- pretty_plural + 'etp_page_revisions', -- table_name + 'etp_page_revision_id', -- id_column + 'content_revision__revision_name' -- name_method +); + + update cr_items set content_type='etp_page_revision' where content_type is NULL; -- this is untested DAVEB