liquid_feedback_core
changeset 27:77ac81cbe5c0
SQL update script from beta18: Changed destination version from v1.0.0 to beta19
(fixes mistake in changeset 66971fefaba2)
(fixes mistake in changeset 66971fefaba2)
author | jbe |
---|---|
date | Sat Feb 06 03:59:03 2010 +0100 (2010-02-06) |
parents | 66971fefaba2 |
children | a73ccca7557a |
files | update/prepare-beta18-beta19.sql update/prepare-beta18-v1.0.0.sql |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/update/prepare-beta18-beta19.sql Sat Feb 06 03:59:03 2010 +0100 1.3 @@ -0,0 +1,60 @@ 1.4 +BEGIN; 1.5 + 1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 1.7 + SELECT * FROM (VALUES ('incomplete_update_from_beta18_to_beta19', NULL, NULL, NULL)) 1.8 + AS "subquery"("string", "major", "minor", "revision"); 1.9 + 1.10 +ALTER TABLE "issue" RENAME COLUMN "latest_snapshot_event" TO "tmp"; 1.11 +ALTER TABLE "direct_population_snapshot" RENAME COLUMN "event" TO "tmp"; 1.12 +ALTER TABLE "delegating_population_snapshot" RENAME COLUMN "event" TO "tmp"; 1.13 +ALTER TABLE "direct_interest_snapshot" RENAME COLUMN "event" TO "tmp"; 1.14 +ALTER TABLE "delegating_interest_snapshot" RENAME COLUMN "event" TO "tmp"; 1.15 +ALTER TABLE "direct_supporter_snapshot" RENAME COLUMN "event" TO "tmp"; 1.16 + 1.17 +ALTER TABLE "issue" ADD COLUMN "latest_snapshot_event" TEXT; 1.18 +ALTER TABLE "direct_population_snapshot" ADD COLUMN "event" TEXT; 1.19 +ALTER TABLE "delegating_population_snapshot" ADD COLUMN "event" TEXT; 1.20 +ALTER TABLE "direct_interest_snapshot" ADD COLUMN "event" TEXT; 1.21 +ALTER TABLE "delegating_interest_snapshot" ADD COLUMN "event" TEXT; 1.22 +ALTER TABLE "direct_supporter_snapshot" ADD COLUMN "event" TEXT; 1.23 + 1.24 +ALTER TABLE "issue" ADD COLUMN "admission_time" INTERVAL; 1.25 +ALTER TABLE "issue" ADD COLUMN "discussion_time" INTERVAL; 1.26 +ALTER TABLE "issue" ADD COLUMN "verification_time" INTERVAL; 1.27 +ALTER TABLE "issue" ADD COLUMN "voting_time" INTERVAL; 1.28 + 1.29 +UPDATE "issue" SET "latest_snapshot_event" = "tmp"; 1.30 +UPDATE "direct_population_snapshot" SET "event" = "tmp"; 1.31 +UPDATE "delegating_population_snapshot" SET "event" = "tmp"; 1.32 +UPDATE "direct_interest_snapshot" SET "event" = "tmp"; 1.33 +UPDATE "delegating_interest_snapshot" SET "event" = "tmp"; 1.34 +UPDATE "direct_supporter_snapshot" SET "event" = "tmp"; 1.35 + 1.36 +UPDATE "issue" SET "latest_snapshot_event" = 'full_freeze' WHERE "latest_snapshot_event" = 'start_of_voting'; 1.37 +UPDATE "direct_population_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 1.38 +UPDATE "delegating_population_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 1.39 +UPDATE "direct_interest_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 1.40 +UPDATE "delegating_interest_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 1.41 +UPDATE "direct_supporter_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 1.42 + 1.43 +UPDATE "issue" SET 1.44 + "admission_time" = "policy"."admission_time", 1.45 + "discussion_time" = "policy"."discussion_time", 1.46 + "verification_time" = "policy"."verification_time", 1.47 + "voting_time" = "policy"."voting_time" 1.48 + FROM "policy" WHERE "issue"."policy_id" = "policy"."id"; 1.49 + 1.50 +-- remove "tmp" columns indirectly 1.51 +DROP TYPE "snapshot_event" CASCADE; 1.52 + 1.53 +COMMIT; 1.54 + 1.55 +-- Complete the update as follows: 1.56 +-- ========================================= 1.57 +-- pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql 1.58 +-- dropdb DATABASE_NAME 1.59 +-- createdb DATABASE_NAME 1.60 +-- psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME 1.61 +-- psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME 1.62 +-- rm tmp.sql 1.63 +
2.1 --- a/update/prepare-beta18-v1.0.0.sql Sat Feb 06 03:38:49 2010 +0100 2.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 2.3 @@ -1,60 +0,0 @@ 2.4 -BEGIN; 2.5 - 2.6 -CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.7 - SELECT * FROM (VALUES ('incomplete_update_from_beta18_to_v1.0.0', NULL, NULL, NULL)) 2.8 - AS "subquery"("string", "major", "minor", "revision"); 2.9 - 2.10 -ALTER TABLE "issue" RENAME COLUMN "latest_snapshot_event" TO "tmp"; 2.11 -ALTER TABLE "direct_population_snapshot" RENAME COLUMN "event" TO "tmp"; 2.12 -ALTER TABLE "delegating_population_snapshot" RENAME COLUMN "event" TO "tmp"; 2.13 -ALTER TABLE "direct_interest_snapshot" RENAME COLUMN "event" TO "tmp"; 2.14 -ALTER TABLE "delegating_interest_snapshot" RENAME COLUMN "event" TO "tmp"; 2.15 -ALTER TABLE "direct_supporter_snapshot" RENAME COLUMN "event" TO "tmp"; 2.16 - 2.17 -ALTER TABLE "issue" ADD COLUMN "latest_snapshot_event" TEXT; 2.18 -ALTER TABLE "direct_population_snapshot" ADD COLUMN "event" TEXT; 2.19 -ALTER TABLE "delegating_population_snapshot" ADD COLUMN "event" TEXT; 2.20 -ALTER TABLE "direct_interest_snapshot" ADD COLUMN "event" TEXT; 2.21 -ALTER TABLE "delegating_interest_snapshot" ADD COLUMN "event" TEXT; 2.22 -ALTER TABLE "direct_supporter_snapshot" ADD COLUMN "event" TEXT; 2.23 - 2.24 -ALTER TABLE "issue" ADD COLUMN "admission_time" INTERVAL; 2.25 -ALTER TABLE "issue" ADD COLUMN "discussion_time" INTERVAL; 2.26 -ALTER TABLE "issue" ADD COLUMN "verification_time" INTERVAL; 2.27 -ALTER TABLE "issue" ADD COLUMN "voting_time" INTERVAL; 2.28 - 2.29 -UPDATE "issue" SET "latest_snapshot_event" = "tmp"; 2.30 -UPDATE "direct_population_snapshot" SET "event" = "tmp"; 2.31 -UPDATE "delegating_population_snapshot" SET "event" = "tmp"; 2.32 -UPDATE "direct_interest_snapshot" SET "event" = "tmp"; 2.33 -UPDATE "delegating_interest_snapshot" SET "event" = "tmp"; 2.34 -UPDATE "direct_supporter_snapshot" SET "event" = "tmp"; 2.35 - 2.36 -UPDATE "issue" SET "latest_snapshot_event" = 'full_freeze' WHERE "latest_snapshot_event" = 'start_of_voting'; 2.37 -UPDATE "direct_population_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 2.38 -UPDATE "delegating_population_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 2.39 -UPDATE "direct_interest_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 2.40 -UPDATE "delegating_interest_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 2.41 -UPDATE "direct_supporter_snapshot" SET "event" = 'full_freeze' WHERE "event" = 'start_of_voting'; 2.42 - 2.43 -UPDATE "issue" SET 2.44 - "admission_time" = "policy"."admission_time", 2.45 - "discussion_time" = "policy"."discussion_time", 2.46 - "verification_time" = "policy"."verification_time", 2.47 - "voting_time" = "policy"."voting_time" 2.48 - FROM "policy" WHERE "issue"."policy_id" = "policy"."id"; 2.49 - 2.50 --- remove "tmp" columns indirectly 2.51 -DROP TYPE "snapshot_event" CASCADE; 2.52 - 2.53 -COMMIT; 2.54 - 2.55 --- Complete the update as follows: 2.56 --- ========================================= 2.57 --- pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql 2.58 --- dropdb DATABASE_NAME 2.59 --- createdb DATABASE_NAME 2.60 --- psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME 2.61 --- psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME 2.62 --- rm tmp.sql 2.63 -