Index: openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1.3-2.2.0a1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/upgrade/Attic/upgrade-2.1.3-2.2.0a1.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1.3-2.2.0a1.sql 13 Dec 2005 15:32:35 -0000 1.1.2.1 +++ openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1.3-2.2.0a1.sql 13 Mar 2006 00:46:52 -0000 1.1.2.2 @@ -117,3 +117,19 @@ select inline_0(); drop function inline_0(); + +-- Create auxiliary tables + +create table apm_parameter_values_copy ( + value_id integer, + package_id integer, + parameter_id integer, + attr_value text +); + +insert into apm_parameter_values_copy ( + value_id, + package_id, + parameter_id, + attr_value +) select * from apm_parameter_values;