1 files changed, 40 insertions, 0 deletions
diff --git a/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade018_019_postgres.sql b/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade018_019_postgres.sql
new file mode 100644
index 0000000000..fbf7c81948
--- /dev/null
+++ b/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade018_019_postgres.sql
@@ -0,0 +1,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;