liquid_feedback_core: update/core-update.v1.2.7-v1.2.8.sql annotate

liquid_feedback_core

Added new column "promising" to table "initiative"; Simplified tie-breaking

Also added example to demo.sql, which results in a promising initiative.

rev	line source
jbe@74	1 BEGIN;
jbe@74	2
jbe@74	3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
jbe@74	4 SELECT * FROM (VALUES ('1.2.8', 1, 2, 8))
jbe@74	5 AS "subquery"("string", "major", "minor", "revision");
jbe@74	6
jbe@74	7 ALTER TABLE "delegation" DROP CONSTRAINT "delegation_area_id_key";
jbe@74	8 ALTER TABLE "delegation" DROP CONSTRAINT "delegation_issue_id_key";
jbe@74	9 DROP INDEX "delegation_global_truster_id_trustee_id_unique_idx";
jbe@74	10
jbe@74	11 ALTER TABLE "delegation" ADD UNIQUE ("area_id", "truster_id");
jbe@74	12 ALTER TABLE "delegation" ADD UNIQUE ("issue_id", "truster_id");
jbe@75	13 CREATE UNIQUE INDEX "delegation_global_truster_id_unique_idx"
jbe@74	14 ON "delegation" ("truster_id") WHERE "scope" = 'global';
jbe@74	15
jbe@74	16 COMMIT;