Index: openacs-4/packages/acs-lang/acs-lang.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/acs-lang.info,v diff -u -r1.21 -r1.22 --- openacs-4/packages/acs-lang/acs-lang.info 17 Feb 2003 23:00:49 -0000 1.21 +++ openacs-4/packages/acs-lang/acs-lang.info 26 Feb 2003 09:43:34 -0000 1.22 @@ -7,7 +7,7 @@ t t - + oracle postgresql @@ -21,148 +21,13 @@ locale-specific formatting functions. - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + Index: openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 19 Dec 2002 15:29:31 -0000 1.6 +++ openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 26 Feb 2003 09:44:15 -0000 1.7 @@ -23,6 +23,7 @@ package_key varchar2(100) constraint lang_message_keys_fk references apm_package_types(package_key) + on delete cascade constraint lang_message_keys_p_key_nn not null, upgrade_status varchar2(30) Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d7-4.7d8.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d7-4.7d8.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d7-4.7d8.sql 26 Feb 2003 09:45:03 -0000 1.1 @@ -0,0 +1,7 @@ +-- Make message keys cascade when packages are deleted +alter table lang_message_keys drop constraint lang_message_keys_fk; +alter table lang_message_keys + add constraint lang_message_keys_fk + foreign key (package_key) + references apm_package_types(package_key) + on delete cascade; Index: openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 19 Dec 2002 15:29:52 -0000 1.7 +++ openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 26 Feb 2003 09:45:54 -0000 1.8 @@ -1,3 +1,4 @@ + -- -- packages/acs-lang/sql/postgresql/message-catalog.sql -- @@ -23,6 +24,7 @@ package_key varchar(100) constraint lang_message_keys_fk references apm_package_types(package_key) + on delete cascade constraint lang_message_keys_package_key_nn not null, upgrade_status varchar(30) Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d7-4.7d8.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d7-4.7d8.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d7-4.7d8.sql 26 Feb 2003 09:46:31 -0000 1.1 @@ -0,0 +1,21 @@ +-- Make message keys cascade when packages are deleted +create table upgrade_temp as select * from lang_message_keys; +drop table lang_message_keys; +create table lang_message_keys ( + message_key varchar(200) + constraint lang_message_keys_message_key_nn + not null, + package_key varchar(100) + constraint lang_message_keys_fk + references apm_package_types(package_key) + on delete cascade + constraint lang_message_keys_package_key_nn + not null, + upgrade_status varchar(30) + constraint lang_message_keys_us_ck + check (upgrade_status in ('no_upgrade', 'added','deleted')), + constraint lang_message_keys_pk + primary key (message_key, package_key) +); +insert into lang_message_keys select * from upgrade_temp; +drop table upgrade_temp;