Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.129.2.9 -r1.129.2.10 --- openacs-4/packages/acs-kernel/acs-kernel.info 6 Nov 2013 08:07:48 -0000 1.129.2.9 +++ openacs-4/packages/acs-kernel/acs-kernel.info 3 Jul 2014 11:57:13 -0000 1.129.2.10 @@ -7,15 +7,15 @@ t t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2013-09-08 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, partiies and the supporting PL/SQL and PL/pgSQL procedures. 3 - + Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v diff -u -r1.41 -r1.41.2.1 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 31 Jul 2011 23:11:46 -0000 1.41 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 3 Jul 2014 11:57:13 -0000 1.41.2.1 @@ -462,7 +462,7 @@ sort_order integer not null, datatype varchar(50) not null constraint acs_attributes_datatype_fk - references acs_datatypes (datatype), + references acs_datatypes (datatype) on update cascade, default_value text, min_n_values integer default 1 not null constraint acs_attributes_min_n_values_ck Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql 5 Mar 2011 22:35:23 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d3-5.7.0d4.sql 3 Jul 2014 11:57:14 -0000 1.3.4.1 @@ -3,6 +3,11 @@ alter table acs_datatypes add column_check_expr text; alter table acs_datatypes add column_output_function text; +alter table acs_attributes drop constraint acs_attributes_datatype_fk; +alter table acs_attributes add constraint acs_attributes_datatype_fk + foreign key (datatype) + references acs_datatypes(datatype) on update cascade; + insert into acs_datatypes (datatype, database_type) (select 'text', 'text' from dual Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.8.1d4-5.8.1d5.sql'. Fisheye: No comparison available. Pass `N' to diff?