liquid_feedback_core: 6fce4f08157b update/core-update.v1.0.2-v1.0.3.sql

liquid_feedback_core

view update/core-update.v1.0.2-v1.0.3.sql @ 208:6fce4f08157b

fix init.sql

error was:
ERROR: new row for relation "member" violates check constraint "active_requires_activated_and_last_activity"

solution: init fields "activated" and "last_activity" with NOW()

author	Lars Winterfeld <lars.winterfeld@tu-ilmenau.de>
date	Sun Oct 23 19:45:04 2011 -0700 (2011-10-23)
parents	3fbf9e18ee52
children

line source

1 BEGIN;

3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS

4 SELECT * FROM (VALUES ('1.0.3', 1, 0, 3))

5 AS "subquery"("string", "major", "minor", "revision");

7 DROP INDEX "delegating_voter_member_id_idx";

8 CREATE INDEX "delegating_voter_member_id_idx" ON "delegating_voter" ("member_id");

10 COMMIT;