blob: 3c2634fd39bcbc7d825046fea2c648f0a2efa1bc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- Upgrade: schema_version 3 to 4
--
ALTER TABLE system_config ADD use_repo_download CHAR(1);
UPDATE system_config SET use_repo_download = 'N';
ALTER TABLE system_config ALTER COLUMN use_repo_download SET DEFAULT 'N';
ALTER TABLE system_config ALTER COLUMN use_repo_download SET NOT NULL;
ALTER TABLE system_config ADD git_daemon_url VARCHAR(255);
ALTER TABLE accounts ADD show_site_header CHAR(1);
UPDATE accounts SET show_site_header = 'Y';
ALTER TABLE accounts ALTER COLUMN show_site_header SET DEFAULT 'N';
ALTER TABLE accounts ALTER COLUMN show_site_header SET NOT NULL;
UPDATE schema_version SET version_nbr = 4;
CREATE INDEX changes_byProjectOpen
ON changes (dest_project_name, sort_key)
WHERE open = 'Y';
|