Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql	8 Aug 2003 12:21:27 -0000	1.1
+++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql	11 Aug 2003 16:43:04 -0000	1.2
@@ -1,3 +1,22 @@
+--
+-- Oracle upgrade script from 4.7d9 to 5.0d1
+--
+-- 1. Adds an enabled_p flag to ad_locales.
+-- 
+-- 2. Adds a comment field to lang_messages_audit
+--
+-- 3. Renames the lang_messages_audit.message column to 'old_message' in order to make the meaning more clear.
+--
+-- @author Simon Carstensen (simon@collaboraid.biz)
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- @creation-date 2003-08-11
+-- @cvs-id $Id$
+--
+
+
+-- 1. Adds an enabled_p flag to ad_locales.
+
 -- New enabled_p column in ad_locales
 alter table ad_locales
   add   enabled_p char(1) default 't'
@@ -10,3 +29,23 @@
 create or replace view enabled_locales as
 select * from ad_locales
 where enabled_p = 't';
+
+
+
+
+-- 2. Adds a comment field to lang_messages_audit
+
+-- Add a comment field to the message audit table
+alter table lang_messages_audit add comment_text clob;
+commit;
+
+
+
+
+-- 3. Renames the lang_messages_audit.message column to 'old_message' in order to make the meaning more clear.
+
+-- Rename the coclumn 'message' to 'old_message' in the lang_messages_audit table
+alter table lang_messages_audit add old_message clob;
+update lang_messages_audit set old_message = message;
+commit;
+alter table lang_messages_audit drop (message);
