liquid_feedback_core

changeset 245:8423373fbadd

Fixed update script from v1.4.0 to v2.0.0: Keep unused invite codes
author jbe
date Thu May 10 22:44:13 2012 +0200 (2012-05-10)
parents d09c17b01c5d
children dc644643db99
files update/core-update.v1.4.0-v2.0.0.sql
line diff
     1.1 --- a/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 18:32:43 2012 +0200
     1.2 +++ b/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 22:44:13 2012 +0200
     1.3 @@ -1252,6 +1252,14 @@
     1.4    FROM "invite_code"
     1.5    WHERE "member"."id" = "invite_code"."member_id";
     1.6  
     1.7 +INSERT INTO "member" ("created", "invite_code", "admin_comment")
     1.8 +  SELECT "created", "code", "comment"
     1.9 +  FROM "invite_code" WHERE "member_id" ISNULL;
    1.10 +
    1.11 +INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
    1.12 +  SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
    1.13 +  FROM "member" WHERE "activated" ISNULL;
    1.14 +
    1.15  DROP TABLE "invite_code";
    1.16  
    1.17  UPDATE "initiative" SET

Impressum / About Us