liquid_feedback_core

changeset 122:2a1f0bd5fcff

Changed comments in update script to v1.4.0_rc1
author jbe
date Mon Mar 07 19:25:59 2011 +0100 (2011-03-07)
parents 8a1a488a1a67
children 1af27a67ee1a
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	Mon Mar 07 19:15:14 2011 +0100
     1.2 +++ b/update/core-update.v1.3.1-v1.4.0_rc1.sql	Mon Mar 07 19:25:59 2011 +0100
     1.3 @@ -173,7 +173,7 @@
     1.4  COMMENT ON TYPE "delegation_scope" IS 'Scope for delegations: ''unit'', ''area'', or ''issue'' (order is relevant)';
     1.5  
     1.6  
     1.7 --- Delete views and functions being dependent on TYPE "delegation_scope":
     1.8 +-- Delete views and functions being dependent on type "delegation_scope":
     1.9  
    1.10  DROP FUNCTION "delegation_chain"
    1.11    ( "member_id_p" "member"."id"%TYPE,
    1.12 @@ -194,7 +194,7 @@
    1.13  DROP VIEW "active_delegation";
    1.14  
    1.15  
    1.16 --- Modify "delegation" table to use new "delegation_scope" TYPE:
    1.17 +-- Modify "delegation" table to use new "delegation_scope" type:
    1.18  
    1.19  ALTER TABLE "delegation" DROP CONSTRAINT "no_global_delegation_to_null";
    1.20  ALTER TABLE "delegation" DROP CONSTRAINT "area_id_and_issue_id_set_according_to_scope";
    1.21 @@ -218,7 +218,7 @@
    1.22  -- NOTE: Column "unit_id" filled after transaction (see below)
    1.23  
    1.24  
    1.25 --- Modify snapshot tables to use new "delegation_scope" TYPE:
    1.26 +-- Modify snapshot tables to use new "delegation_scope" type:
    1.27  
    1.28  ALTER TABLE "delegating_population_snapshot" ALTER "scope" TYPE "delegation_scope"
    1.29    USING CASE WHEN "scope" = 'global'
    1.30 @@ -247,7 +247,7 @@
    1.31  COMMENT ON TABLE "non_voter" IS 'Members who decided to not vote directly on an issue';
    1.32  
    1.33  
    1.34 --- New table "issue_comment":
    1.35 +-- New tables "issue_comment" and "rendered_issue_comment":
    1.36  
    1.37  CREATE TABLE "issue_comment" (
    1.38          PRIMARY KEY ("issue_id", "member_id"),
    1.39 @@ -268,9 +268,6 @@
    1.40  
    1.41  COMMENT ON COLUMN "issue_comment"."changed" IS 'Time the comment was last changed';
    1.42  
    1.43 -
    1.44 --- New table "rendered_issue_comment":
    1.45 -
    1.46  CREATE TABLE "rendered_issue_comment" (
    1.47          PRIMARY KEY ("issue_id", "member_id", "format"),
    1.48          FOREIGN KEY ("issue_id", "member_id")
    1.49 @@ -284,7 +281,7 @@
    1.50  COMMENT ON TABLE "rendered_issue_comment" IS 'This table may be used by frontends to cache "rendered" issue comments (e.g. HTML output generated from wiki text)';
    1.51  
    1.52  
    1.53 --- New table "voting_comment":
    1.54 +-- New tables "voting_comment" and "rendered_voting_comment":
    1.55  
    1.56  CREATE TABLE "voting_comment" (
    1.57          PRIMARY KEY ("issue_id", "member_id"),
    1.58 @@ -305,9 +302,6 @@
    1.59  
    1.60  COMMENT ON COLUMN "voting_comment"."changed" IS 'Is to be set or updated by the frontend, if comment was inserted or updated AFTER the issue has been closed. Otherwise it shall be set to NULL.';
    1.61  
    1.62 -
    1.63 --- New table "rendered_voting_comment":
    1.64 -
    1.65  CREATE TABLE "rendered_voting_comment" (
    1.66          PRIMARY KEY ("issue_id", "member_id", "format"),
    1.67          FOREIGN KEY ("issue_id", "member_id")
    1.68 @@ -1004,7 +998,7 @@
    1.69    IS 'Shortcut for "delegation_chain"(...) function where 4th parameter is null';
    1.70  
    1.71  
    1.72 --- Modified core functions:
    1.73 +-- Other modified functions:
    1.74  
    1.75  CREATE OR REPLACE FUNCTION "lock_issue"
    1.76    ( "issue_id_p" "issue"."id"%TYPE )
    1.77 @@ -1977,7 +1971,7 @@
    1.78  COMMIT;
    1.79  
    1.80  
    1.81 --- Generate issue states:
    1.82 +-- Generate issue states and add constraints:
    1.83  
    1.84  UPDATE "issue" SET "state" =
    1.85    CASE
    1.86 @@ -2046,7 +2040,7 @@
    1.87    ));
    1.88  
    1.89  
    1.90 --- Guess "revoked_by_member_id" values based on author of current draft:
    1.91 +-- Guess "revoked_by_member_id" values based on author of current draft and add constraint:
    1.92  
    1.93  UPDATE "initiative" SET "revoked_by_member_id" = "author_id"
    1.94    FROM "current_draft"
    1.95 @@ -2058,7 +2052,7 @@
    1.96    CHECK ("revoked" NOTNULL = "revoked_by_member_id" NOTNULL);
    1.97  
    1.98  
    1.99 --- Fill "unit_id" column with default value where neccessary:
   1.100 +-- Fill "unit_id" column with default value where neccessary and add constraints:
   1.101  
   1.102  UPDATE "delegation" SET "unit_id" = 1 WHERE "scope" = 'unit';
   1.103  

Impressum / About Us