blob: 40179e4071c0bf7c59d257b80625fcde27bf0271 (
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
|
-- Upgrade: schema_version 7 to 8
--
UPDATE approval_category_values
SET name = 'Create Signed Tag'
WHERE category_id = 'pTAG' AND value = 1;
INSERT INTO approval_category_values
(category_id, value, name)
VALUES
('pTAG', 2, 'Create Annotated Tag');
INSERT INTO approval_category_values
(category_id, value, name)
VALUES
('pTAG', 3, 'Create Any Tag');
UPDATE project_rights
SET max_value = 2
WHERE max_value = 1
AND category_id = 'pTAG';
UPDATE project_rights
SET min_value = max_value, max_value = min_value
WHERE max_value < min_value;
UPDATE schema_version SET version_nbr = 8;
|
