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.4 -r1.5
--- openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql	21 Oct 2002 11:39:08 -0000	1.4
+++ openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql	3 Dec 2002 17:26:34 -0000	1.5
@@ -8,6 +8,14 @@
 -- @creation-date 2000-09-10
 -- @cvs-id $Id$
 --
+
+create table lang_user_timezone (
+    user_id            integer
+                       constraint lang_user_timezone_user_id_fk
+                       references users (user_id) on delete cascade,
+    timezone           varchar2(100)
+);
+
 create table lang_message_keys ( 
     message_key        varchar2(200)
                        constraint lang_message_keys_m_key_nn
@@ -48,6 +56,29 @@
     into an nsv_array.
 ';
 
+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
+);
+
 -- ****************************************************************************
 -- * The lang_translate_columns table holds the columns that require translation.
 -- * It is needed to generate the user interface for translating the web site.