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 -r1.1 -r1.2
--- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d3-4.7d4.sql	19 Dec 2002 15:29:42 -0000	1.1
+++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d3-4.7d4.sql	30 Sep 2003 12:32:23 -0000	1.2
@@ -7,3 +7,26 @@
     upgrade_status     varchar2(30)
                        constraint lang_messages_us_ck
                        check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated'));
+
+create table lang_messages_audit (    
+    message_key        varchar2(200)
+                       constraint lang_messages_audit_key_nn
+                       not null,
+    package_key        varchar2(100)
+                       constraint lang_messages_audit_p_key_nn
+                       not null,
+    locale             varchar2(30) 
+                       constraint lang_messages_audit_l_fk
+                       references ad_locales(locale)
+                       constraint lang_messages_audit_l_nn
+                       not null,
+    message            clob,
+    overwrite_date     date default sysdate not null,
+    overwrite_user     integer
+                       constraint lang_messages_audit_ou_fk
+                       references users (user_id),
+    constraint lang_messages_audit_fk
+    foreign key (message_key, package_key) 
+    references lang_message_keys(message_key, package_key)
+    on delete cascade
+);
