# HG changeset patch
# User jbe
# Date 1500059846 -7200
# Node ID 9c433d24ed00b30ae5487d7672adb5edf591e3d9
# Parent  ff2c21f883ce2f29adb8c43a8884b378a9a01a66
Data migration of accepted terms of use (from "setting" table to "member_settings" table)

diff -r ff2c21f883ce -r 9c433d24ed00 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 21:02:54 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 21:17:26 2017 +0200
@@ -678,6 +678,14 @@
 CREATE INDEX "non_voter_issue_id_idx" ON "non_voter" ("issue_id");
 
 
+INSERT INTO "member_useterms" ("member_id", "accepted", "contract_identifier")
+  SELECT
+    "member_id",
+    regexp_replace("value", '^accepted at ', '')::TIMESTAMPTZ AS "accepted",
+    regexp_replace("key", '^use_terms_checkbox_', '') AS "contract_identifier"
+  FROM "setting" WHERE "key" LIKE 'use_terms_checkbox_%';
+
+
 DROP TABLE "setting";
 DROP TABLE "setting_map";
 DROP TABLE "member_relation_setting";