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

liquid_feedback_core

fix default password.

the default password was not hashed and the login failed.

author	Daniel Poelzleithner <poelzi@poelzi.org>
date	Sun Sep 19 01:54:30 2010 +0200 (2010-09-19)
parents	f77c0f3d443c
children

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;