# HG changeset patch
# User jbe
# Date 1276809055 -7200
# Node ID 3fbf9e18ee5261fd915542b46e6f31b81147b019
# Parent  5aee2ba01e7c8eec774ffbbc04d41df253b5b433
Bugfix: Corrected table for index "delegating_voter_member_id_idx"
Version change to 1.0.3

diff -r 5aee2ba01e7c -r 3fbf9e18ee52 core.sql
--- a/core.sql	Wed Apr 21 20:07:26 2010 +0200
+++ b/core.sql	Thu Jun 17 23:10:55 2010 +0200
@@ -6,7 +6,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('1.0.2', 1, 0, 2))
+  SELECT * FROM (VALUES ('1.0.3', 1, 0, 3))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -751,7 +751,7 @@
         "weight"                INT4,
         "scope"              "delegation_scope" NOT NULL,
         "delegate_member_ids"   INT4[]          NOT NULL );
-CREATE INDEX "delegating_voter_member_id_idx" ON "direct_voter" ("member_id");
+CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id");
 
 COMMENT ON TABLE "delegating_voter" IS 'Delegations increasing the weight of entries in the "direct_voter" table';
 
diff -r 5aee2ba01e7c -r 3fbf9e18ee52 update/core-update.v1.0.2-v1.0.3.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v1.0.2-v1.0.3.sql	Thu Jun 17 23:10:55 2010 +0200
@@ -0,0 +1,10 @@
+BEGIN;
+
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('1.0.3', 1, 0, 3))
+  AS "subquery"("string", "major", "minor", "revision");
+
+DROP INDEX "delegating_voter_member_id_idx";
+CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id");
+
+COMMIT;