liquid_feedback_core
view update/core-update.v2.0.1-v2.0.2.sql @ 460:6d4e51332251
Work on new notification system: new column "disable_notifications" in "member" table, new tables "subscription" and "ignored_area", dropped view "selected_event_seen_by_member"
| author | jbe |
|---|---|
| date | Wed Mar 16 00:29:12 2016 +0100 (2016-03-16) |
| parents | 919d16c8e8e3 |
| children |
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;