liquid_feedback_core
changeset 214:919d16c8e8e3 v2.0.2
Added new column "authentication to table "member"; Added update script to v2.0.2
author | jbe |
---|---|
date | Fri Feb 17 18:26:37 2012 +0100 (2012-02-17) |
parents | c1f000ae7a54 |
children | 49d470425fc5 |
files | core.sql update/core-update.v2.0.1-v2.0.2.sql |
line diff
1.1 --- a/core.sql Sun Jan 29 00:42:30 2012 +0100 1.2 +++ b/core.sql Fri Feb 17 18:26:37 2012 +0100 1.3 @@ -7,7 +7,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('2.0.0', 2, 0, 0)) 1.8 + SELECT * FROM (VALUES ('2.0.2', 2, 0, 2)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -105,6 +105,7 @@ 1.13 "password_reset_secret_expiry" TIMESTAMPTZ, 1.14 "name" TEXT NOT NULL UNIQUE, 1.15 "identification" TEXT UNIQUE, 1.16 + "authentication" TEXT, 1.17 "organizational_unit" TEXT, 1.18 "internal_posts" TEXT, 1.19 "realname" TEXT, 1.20 @@ -154,6 +155,7 @@ 1.21 COMMENT ON COLUMN "member"."notify_event_id" IS 'Latest "id" of an "event" the member was notified about'; 1.22 COMMENT ON COLUMN "member"."name" IS 'Distinct name of the member'; 1.23 COMMENT ON COLUMN "member"."identification" IS 'Optional identification number or code of the member'; 1.24 +COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated'; 1.25 COMMENT ON COLUMN "member"."organizational_unit" IS 'Branch or division of the organization the member belongs to'; 1.26 COMMENT ON COLUMN "member"."internal_posts" IS 'Posts (offices) of the member inside the organization'; 1.27 COMMENT ON COLUMN "member"."realname" IS 'Real name of the member, may be identical with "name"';
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/update/core-update.v2.0.1-v2.0.2.sql Fri Feb 17 18:26:37 2012 +0100 2.3 @@ -0,0 +1,12 @@ 2.4 +BEGIN; 2.5 + 2.6 +-- update version number: 2.7 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 2.8 + SELECT * FROM (VALUES ('2.0.2', 2, 0, 2)) 2.9 + AS "subquery"("string", "major", "minor", "revision"); 2.10 + 2.11 +-- add column "authentication" to table "member": 2.12 +ALTER TABLE "member" ADD COLUMN "authentication" TEXT; 2.13 +COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated'; 2.14 + 2.15 +COMMIT;