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.5 -r1.6
--- openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql	3 Dec 2002 17:26:34 -0000	1.5
+++ openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql	19 Dec 2002 15:29:31 -0000	1.6
@@ -25,6 +25,9 @@
                        references apm_package_types(package_key)
                        constraint lang_message_keys_p_key_nn
                        not null,
+    upgrade_status     varchar2(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)
 );
@@ -42,6 +45,9 @@
                        constraint lang_messages_locale_nn
                        not null,
     message            clob,
+    upgrade_status     varchar2(30)
+                       constraint lang_messages_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated')),
     constraint lang_messages_fk
     foreign key (message_key, package_key) 
     references lang_message_keys(message_key, package_key)
Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d3-4.7d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d3-4.7d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d3-4.7d4.sql	19 Dec 2002 15:29:42 -0000	1.1
@@ -0,0 +1,9 @@
+alter table lang_message_keys add 
+          upgrade_status varchar2(30)
+                         constraint lang_message_keys_us_ck
+                         check (upgrade_status in ('no_upgrade', 'added','deleted'));
+
+alter table lang_messages add
+    upgrade_status     varchar2(30)
+                       constraint lang_messages_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated'));
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.6 -r1.7
--- openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql	4 Dec 2002 19:34:16 -0000	1.6
+++ openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql	19 Dec 2002 15:29:52 -0000	1.7
@@ -25,6 +25,9 @@
                        references apm_package_types(package_key)
                        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)
 );
@@ -42,6 +45,9 @@
                        constraint lang_messages_locale_nn
                        not null,
     message            text,
+    upgrade_status     varchar(30)
+                       constraint lang_messages_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated')),
     constraint lang_messages_fk
     foreign key (message_key, package_key) 
     references lang_message_keys(message_key, package_key)
Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d3-4.7d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d3-4.7d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d3-4.7d4.sql	19 Dec 2002 15:30:01 -0000	1.1
@@ -0,0 +1,9 @@
+alter table lang_message_keys add
+    upgrade_status     varchar(30)
+                       constraint lang_message_keys_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added','deleted'));      
+
+alter table lang_messages add
+    upgrade_status     varchar(30)
+                       constraint lang_messages_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated'));