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