# HG changeset patch
# User jbe
# Date 1336682653 -7200
# Node ID 8423373fbaddac53047d738258c73c552ced823f
# Parent  d09c17b01c5d354cd7c10723deaf9151508cb724
Fixed update script from v1.4.0 to v2.0.0: Keep unused invite codes

diff -r d09c17b01c5d -r 8423373fbadd update/core-update.v1.4.0-v2.0.0.sql
--- a/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 18:32:43 2012 +0200
+++ b/update/core-update.v1.4.0-v2.0.0.sql	Thu May 10 22:44:13 2012 +0200
@@ -1252,6 +1252,14 @@
   FROM "invite_code"
   WHERE "member"."id" = "invite_code"."member_id";
 
+INSERT INTO "member" ("created", "invite_code", "admin_comment")
+  SELECT "created", "code", "comment"
+  FROM "invite_code" WHERE "member_id" ISNULL;
+
+INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
+  SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
+  FROM "member" WHERE "activated" ISNULL;
+
 DROP TABLE "invite_code";
 
 UPDATE "initiative" SET