liquid_feedback_core
changeset 545:9c433d24ed00
Data migration of accepted terms of use (from "setting" table to "member_settings" table)
author | jbe |
---|---|
date | Fri Jul 14 21:17:26 2017 +0200 (2017-07-14) |
parents | ff2c21f883ce |
children | f46ebb677898 |
files | update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Fri Jul 14 21:02:54 2017 +0200 1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Fri Jul 14 21:17:26 2017 +0200 1.3 @@ -678,6 +678,14 @@ 1.4 CREATE INDEX "non_voter_issue_id_idx" ON "non_voter" ("issue_id"); 1.5 1.6 1.7 +INSERT INTO "member_useterms" ("member_id", "accepted", "contract_identifier") 1.8 + SELECT 1.9 + "member_id", 1.10 + regexp_replace("value", '^accepted at ', '')::TIMESTAMPTZ AS "accepted", 1.11 + regexp_replace("key", '^use_terms_checkbox_', '') AS "contract_identifier" 1.12 + FROM "setting" WHERE "key" LIKE 'use_terms_checkbox_%'; 1.13 + 1.14 + 1.15 DROP TABLE "setting"; 1.16 DROP TABLE "setting_map"; 1.17 DROP TABLE "member_relation_setting";