1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/prepare-beta25-beta26.sql	Thu Mar 25 18:33:11 2010 +0100
     1.3 @@ -0,0 +1,25 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('incomplete_update_from_beta24_to_beta25', NULL, NULL, NULL))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +ALTER TABLE "member" ADD COLUMN "last_login" TIMESTAMPTZ;
    1.11 +ALTER TABLE "member_history" ADD COLUMN "active" BOOLEAN;
    1.12 +
    1.13 +UPDATE "member_history" SET "active" = TRUE;
    1.14 +INSERT INTO "member_history" ("member_id", "login", "active", "name")
    1.15 +  SELECT "id", "login", TRUE AS "active", "name"
    1.16 +  FROM "member" WHERE "active" = FALSE;
    1.17 +
    1.18 +COMMIT;
    1.19 +
    1.20 +-- Complete the update as follows:
    1.21 +-- =========================================
    1.22 +-- pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql
    1.23 +-- dropdb DATABASE_NAME
    1.24 +-- createdb DATABASE_NAME
    1.25 +-- psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME
    1.26 +-- psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME
    1.27 +-- rm tmp.sql
    1.28 +