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.8 -r1.9 --- openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 11 Aug 2003 16:43:04 -0000 1.8 +++ openacs-4/packages/acs-lang/sql/oracle/message-catalog.sql 18 Aug 2003 10:33:18 -0000 1.9 @@ -29,6 +29,7 @@ upgrade_status varchar2(30) constraint lang_message_keys_us_ck check (upgrade_status in ('no_upgrade', 'added','deleted')), + description clob, constraint lang_message_keys_pk primary key (message_key, package_key) ); 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 -r1.2 -r1.3 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql 11 Aug 2003 16:43:04 -0000 1.2 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-4.7d9-5.0d1.sql 18 Aug 2003 10:33:18 -0000 1.3 @@ -7,6 +7,8 @@ -- -- 3. Renames the lang_messages_audit.message column to 'old_message' in order to make the meaning more clear. -- +-- 4. Adds a description column to lang_message_keys. +-- -- @author Simon Carstensen (simon@collaboraid.biz) -- @author Lars Pind (lars@collaboraid.biz) -- @@ -49,3 +51,8 @@ update lang_messages_audit set old_message = message; commit; alter table lang_messages_audit drop (message); + + +-- 4. Adds a description column to lang_message_keys. + +alter table lang_message_keys add description clob; 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.10 -r1.11 --- openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 11 Aug 2003 16:43:05 -0000 1.10 +++ openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql 18 Aug 2003 10:33:18 -0000 1.11 @@ -30,6 +30,7 @@ upgrade_status varchar(30) constraint lang_message_keys_us_ck check (upgrade_status in ('no_upgrade', 'added','deleted')), + description text, constraint lang_message_keys_pk primary key (message_key, package_key) ); Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d9-5.0d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d9-5.0d1.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d9-5.0d1.sql 11 Aug 2003 16:43:05 -0000 1.2 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-4.7d9-5.0d1.sql 18 Aug 2003 10:33:18 -0000 1.3 @@ -7,6 +7,8 @@ -- -- 3. Renames the lang_messages_audit.message column to 'old_message' in order to make the meaning more clear. -- +-- 4. Adds a description column to lang_message_keys. +-- -- @author Simon Carstensen (simon@collaboraid.biz) -- @author Lars Pind (lars@collaboraid.biz) -- @@ -83,3 +85,7 @@ drop table lang_messages_audit; alter table lang_messages_audit_new rename to lang_messages_audit; + +-- 4. Adds a description column to lang_message_keys. + +alter table lang_message_keys add column description text;