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

Impressum / About Us