1 files changed, 39 insertions, 0 deletions
diff --git a/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade012_013_postgres.sql b/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade012_013_postgres.sql
new file mode 100644
index 0000000000..ad173a5da2
--- /dev/null
+++ b/gerrit-war/src/main/webapp/WEB-INF/sql/upgrade012_013_postgres.sql
@@ -0,0 +1,39 @@
+-- Upgrade: schema_version 12 to 13 (PostgreSQL)
+--
+
+CREATE TABLE account_group_members_audit
+(account_id INT NOT NULL
+,group_id INT NOT NULL
+,added_on TIMESTAMP WITH TIME ZONE NOT NULL
+,added_by INT NOT NULL
+,removed_on TIMESTAMP WITH TIME ZONE
+,removed_by INT
+,PRIMARY KEY (account_id, group_id, added_on)
+);
+
+ALTER TABLE account_groups ADD automatic_membership CHAR(1);
+UPDATE account_groups SET automatic_membership = 'N';
+ALTER TABLE account_groups ALTER COLUMN automatic_membership SET DEFAULT 'N';
+ALTER TABLE account_groups ALTER COLUMN automatic_membership SET NOT NULL;
+
+UPDATE account_groups SET automatic_membership = 'Y'
+WHERE group_id = (SELECT anonymous_group_id FROM system_config);
+
+UPDATE account_groups SET automatic_membership = 'Y'
+WHERE group_id = (SELECT registered_group_id FROM system_config);
+
+CREATE TABLE account_group_agreements
+(accepted_on TIMESTAMP WITH TIME ZONE NOT NULL
+,status CHAR(1) NOT NULL
+,reviewed_by INT
+,reviewed_on TIMESTAMP WITH TIME ZONE
+,review_comments TEXT
+,group_id INT NOT NULL
+,cla_id INT NOT NULL
+,PRIMARY KEY (group_id, cla_id)
+);
+
+ALTER TABLE account_group_members_audit OWNER TO gerrit2;
+ALTER TABLE account_group_agreements OWNER TO gerrit2;
+
+UPDATE schema_version SET version_nbr = 13;