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"';