# HG changeset patch
# User jbe
# Date 1300019335 -3600
# Node ID 0144b703b2610a4c93158427d5eff79cca3fca84
# Parent  1af27a67ee1a741ac0a63e90fbb0d46ec1b361e6
Modified update script to v1.4.0_rc1: Relate all invite codes and all members to default unit with id=1

diff -r 1af27a67ee1a -r 0144b703b261 update/core-update.v1.3.1-v1.4.0_rc1.sql
--- a/update/core-update.v1.3.1-v1.4.0_rc1.sql	Thu Mar 10 00:49:41 2011 +0100
+++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql	Sun Mar 13 13:28:55 2011 +0100
@@ -136,8 +136,7 @@
 COMMENT ON TABLE "invite_code_unit" IS 'Units where accounts created with a given invite codes get voting rights';
 
 INSERT INTO "invite_code_unit" ("invite_code_id", "unit_id")
-  SELECT "id" AS "invite_code_id", 1 AS "unit_id"
-  FROM "invite_code" WHERE "used" ISNULL;
+  SELECT "id" AS "invite_code_id", 1 AS "unit_id" FROM "invite_code";
 
 
 -- New table "privilege":
@@ -160,6 +159,10 @@
 COMMENT ON COLUMN "privilege"."voting_right_manager" IS 'Select which members are allowed to discuss and vote inside the unit';
 COMMENT ON COLUMN "privilege"."voting_right"         IS 'Right to discuss and vote';
 
+INSERT INTO "privilege" ("unit_id", "member_id", "voting_right")
+  SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right"
+  FROM "member";
+
 
 -- Remove table "ignored_issue", which is no longer existent: