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",

Impressum / About Us