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.1.2.1 -r1.1.2.2 --- openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql 7 Feb 2003 20:21:27 -0000 1.1.2.1 +++ openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.1d-1.2.sql 5 Apr 2003 02:34:29 -0000 1.1.2.2 @@ -12,6 +12,17 @@ -- 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