blob: fbf7c8194877cb57930e78678e22a3fcacccb62c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
-- Upgrade: schema_version 18 to 19 (PostgreSQL)
--
BEGIN;
SELECT check_schema_version(18);
-- Per-project upload permission
INSERT INTO approval_category_values
(name, category_id, value)
VALUES
('Upload permission', 'READ', 2);
UPDATE project_rights SET max_value = 2
WHERE category_id = 'READ' AND max_value = 1;
ALTER TABLE account_groups ADD external_name VARCHAR(255);
ALTER TABLE account_groups ADD UNIQUE (external_name);
ALTER TABLE account_groups ADD group_type VARCHAR(8);
UPDATE account_groups SET group_type = 'SYSTEM'
WHERE group_id = (SELECT anonymous_group_id FROM system_config);
UPDATE account_groups SET group_type = 'SYSTEM'
WHERE group_id = (SELECT registered_group_id FROM system_config);
UPDATE account_groups SET group_type = 'LDAP'
WHERE automatic_membership = 'Y' AND group_type IS NULL;
UPDATE account_groups SET group_type = 'INTERNAL' WHERE group_type IS NULL;
ALTER TABLE account_groups ALTER group_type SET NOT NULL;
ALTER TABLE account_groups DROP automatic_membership;
DROP TABLE branches;
UPDATE schema_version SET version_nbr = 19;
COMMIT;
|
