liquid_feedback_core
changeset 179:fb2394116b39
Update script to v1.5.0: Drop "battle_view" before modifying "initiative" table
author | jbe |
---|---|
date | Wed Jun 08 20:52:06 2011 +0200 (2011-06-08) |
parents | 184b023a5b1d |
children | 1024224df943 |
files | update/core-update.v1.4.0-v1.5.0.sql |
line diff
1.1 --- a/update/core-update.v1.4.0-v1.5.0.sql Wed Jun 08 20:47:19 2011 +0200 1.2 +++ b/update/core-update.v1.4.0-v1.5.0.sql Wed Jun 08 20:52:06 2011 +0200 1.3 @@ -81,6 +81,8 @@ 1.4 COMMENT ON COLUMN "issue"."snapshot" IS 'Point in time, when snapshot tables have been updated and "population" and *_count values were precalculated'; 1.5 COMMENT ON COLUMN "issue"."status_quo_schulze_rank" IS 'Schulze rank of status quo, as calculated by "calculate_ranks" function'; 1.6 1.7 +DROP VIEW "battle_view"; 1.8 + 1.9 ALTER TABLE "initiative" DROP COLUMN "agreed"; 1.10 ALTER TABLE "initiative" ADD COLUMN "direct_majority" BOOLEAN; 1.11 ALTER TABLE "initiative" ADD COLUMN "indirect_majority" BOOLEAN; 1.12 @@ -235,7 +237,7 @@ 1.13 1.14 COMMENT ON VIEW "battle_participant" IS 'Helper view for "battle_view" containing admitted initiatives plus virtual "status-quo" initiative denoted by NULL reference'; 1.15 1.16 -CREATE OR REPLACE VIEW "battle_view" AS 1.17 +CREATE VIEW "battle_view" AS 1.18 SELECT 1.19 "issue"."id" AS "issue_id", 1.20 "winning_initiative"."id" AS "winning_initiative_id",