liquid_feedback_core
changeset 124:0144b703b261 v1.4.0_rc1
Modified update script to v1.4.0_rc1: Relate all invite codes and all members to default unit with id=1
author | jbe |
---|---|
date | Sun Mar 13 13:28:55 2011 +0100 (2011-03-13) |
parents | 1af27a67ee1a |
children | 96db76cde218 |
files | update/core-update.v1.3.1-v1.4.0_rc1.sql |
line diff
1.1 --- a/update/core-update.v1.3.1-v1.4.0_rc1.sql Thu Mar 10 00:49:41 2011 +0100 1.2 +++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql Sun Mar 13 13:28:55 2011 +0100 1.3 @@ -136,8 +136,7 @@ 1.4 COMMENT ON TABLE "invite_code_unit" IS 'Units where accounts created with a given invite codes get voting rights'; 1.5 1.6 INSERT INTO "invite_code_unit" ("invite_code_id", "unit_id") 1.7 - SELECT "id" AS "invite_code_id", 1 AS "unit_id" 1.8 - FROM "invite_code" WHERE "used" ISNULL; 1.9 + SELECT "id" AS "invite_code_id", 1 AS "unit_id" FROM "invite_code"; 1.10 1.11 1.12 -- New table "privilege": 1.13 @@ -160,6 +159,10 @@ 1.14 COMMENT ON COLUMN "privilege"."voting_right_manager" IS 'Select which members are allowed to discuss and vote inside the unit'; 1.15 COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to discuss and vote'; 1.16 1.17 +INSERT INTO "privilege" ("unit_id", "member_id", "voting_right") 1.18 + SELECT 1 AS "unit_id", "id" AS "member_id", TRUE AS "voting_right" 1.19 + FROM "member"; 1.20 + 1.21 1.22 -- Remove table "ignored_issue", which is no longer existent: 1.23