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 -N -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 -N -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 -N
--- /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 -N -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 -N
--- /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;