| -- 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; |