liquid_feedback_core
changeset 52:3fbf9e18ee52 v1.0.3
Bugfix: Corrected table for index "delegating_voter_member_id_idx"
Version change to 1.0.3
Version change to 1.0.3
author | jbe |
---|---|
date | Thu Jun 17 23:10:55 2010 +0200 (2010-06-17) |
parents | 5aee2ba01e7c |
children | c391eb3cd040 |
files | core.sql update/core-update.v1.0.2-v1.0.3.sql |
line diff
1.1 --- a/core.sql Wed Apr 21 20:07:26 2010 +0200 1.2 +++ b/core.sql Thu Jun 17 23:10:55 2010 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.0.2', 1, 0, 2)) 1.8 + SELECT * FROM (VALUES ('1.0.3', 1, 0, 3)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -751,7 +751,7 @@ 1.13 "weight" INT4, 1.14 "scope" "delegation_scope" NOT NULL, 1.15 "delegate_member_ids" INT4[] NOT NULL ); 1.16 -CREATE INDEX "delegating_voter_member_id_idx" ON "direct_voter" ("member_id"); 1.17 +CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id"); 1.18 1.19 COMMENT ON TABLE "delegating_voter" IS 'Delegations increasing the weight of entries in the "direct_voter" table'; 1.20
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/update/core-update.v1.0.2-v1.0.3.sql Thu Jun 17 23:10:55 2010 +0200 2.3 @@ -0,0 +1,10 @@ 2.4 +BEGIN; 2.5 + 2.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.7 + SELECT * FROM (VALUES ('1.0.3', 1, 0, 3)) 2.8 + AS "subquery"("string", "major", "minor", "revision"); 2.9 + 2.10 +DROP INDEX "delegating_voter_member_id_idx"; 2.11 +CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id"); 2.12 + 2.13 +COMMIT;