liquid_feedback_core
annotate update/core-update.v2.0.1-v2.0.2.sql @ 222:cd5fa6c46e13
Changes in event system:
- replaced column "notify_event_id" of "member" table by singleton table "notification_sent"
- removed view "pending_notification"
- added view "selected_event_seen_by_member"
- replaced column "notify_event_id" of "member" table by singleton table "notification_sent"
- removed view "pending_notification"
- added view "selected_event_seen_by_member"
| author | jbe |
|---|---|
| date | Sat Feb 25 15:13:01 2012 +0100 (2012-02-25) |
| parents | 919d16c8e8e3 |
| children |
| rev | line source |
|---|---|
| jbe@214 | 1 BEGIN; |
| jbe@214 | 2 |
| jbe@214 | 3 -- update version number: |
| jbe@214 | 4 CREATE OR REPLACE VIEW "liquid_feedback_version" AS |
| jbe@214 | 5 SELECT * FROM (VALUES ('2.0.2', 2, 0, 2)) |
| jbe@214 | 6 AS "subquery"("string", "major", "minor", "revision"); |
| jbe@214 | 7 |
| jbe@214 | 8 -- add column "authentication" to table "member": |
| jbe@214 | 9 ALTER TABLE "member" ADD COLUMN "authentication" TEXT; |
| jbe@214 | 10 COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated'; |
| jbe@214 | 11 |
| jbe@214 | 12 COMMIT; |