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