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;

Impressum / About Us