OpenACS

stevew
committed
MAIN:stevew:20010823220223
on 24 Aug 01
Port group-type/change-join-policy
/upgrade/upgrade-4.7d9-5.0d1.sql (+2 -2)
13 13 -- @author Lars Pind (lars@collaboraid.biz)
14 14 --
15 15 -- @creation-date 2003-08-11
16 16 -- @cvs-id $Id$
17 17 --
18 18
19 19
20 20
21 21 -- 1. Adds an enabled_p flag to ad_locales.
22 22
23 23 -- New enabled_p column in ad_locales
24 24 alter table ad_locales
25 25   add enabled_p boolean;
26 26 alter table ad_locales
27 27 alter enabled_p set default 't';
28 28
29 29 -- Let all locales be enabled for sites that are upgrading
30 30 update ad_locales set enabled_p = 't';
31 31
32 32 -- New view
33   create or replace view enabled_locales as
  33 create view enabled_locales as
34 34 select * from ad_locales
35 35 where enabled_p = 't';
36 36
37 37
38 38
39 39
40 40 -- 2. Adds a comment field to lang_messages_audit
41 41 -- 3. Renames the lang_messages_audit.message column to 'old_message' in order to make the meaning more clear.
42 42
43 43 create table lang_messages_audit_new (   
44 44     message_key        varchar(200)
45 45                        constraint lang_messages_audit_key_nn
46 46                        not null,
47 47     package_key        varchar(100)
48 48                        constraint lang_messages_audit_p_key_nn
49 49                        not null,
50 50     locale             varchar(30)
51 51                        constraint lang_messages_audit_l_fk
52 52                        references ad_locales(locale)
53 53                        constraint lang_messages_audit_l_nn