liquid_feedback_core: bc6d9dc60ca4 update/core-update.v2.0.1-v2.0.2.sql

liquid_feedback_core

Require members to be "activated" in order to receive messages/notifications; New views "member_eligible_to_be_notified" and "member_to_notify"

line source

1 BEGIN;

3 -- update version number:

4 CREATE OR REPLACE VIEW "liquid_feedback_version" AS

5 SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))

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

8 -- add column "authentication" to table "member":

9 ALTER TABLE "member" ADD COLUMN "authentication" TEXT;

10 COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';

12 COMMIT;