OpenACS

peterm
committed
MAIN:peterm:20030930162951
on 30 Sep 03
fixing upgrade bug related to .ctl (ctl_file) files. First of all, don't offer ctl files when upgrading (ok, we should make this possible if… Show more
fixing upgrade bug related to .ctl (ctl_file) files. First of all, don't offer ctl files when upgrading (ok, we should make this possible if we need it). Second of all, use the ctl file selections the user actually made when choosing files to source (in proc apm_package_install_data_model)

Show less

/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