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  

Impressum / About Us