Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -r1.52 -r1.53 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 12 Mar 2004 18:48:50 -0000 1.52 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 26 Apr 2004 18:50:51 -0000 1.53 @@ -414,6 +414,24 @@ such as general-comments and notifications. '; +-- Use this table to make it easy to change the attribute set of package versions +-- TODO: Migrate this to use acs_attributes instead? +create table apm_package_version_attr ( + version_id integer + constraint apm_package_vers_attr_vid_fk + references apm_package_versions(version_id) + constraint apm_package_vers_attr_vid_nn + not null, + attribute_name varchar(100) + constraint apm_package_vers_attr_an_nn + not null, + attribute_value varchar(4000), + constraint apm_package_vers_attr_pk + primary key (version_id, attribute_name) +); + + + -- Metadata for the apm_package_versions object. create or replace function inline_2 ()