# HG changeset patch
# User jbe
# Date 1329499597 -3600
# Node ID 919d16c8e8e3e8daead6e72de0c98a3b2ec6036e
# Parent  c1f000ae7a5448fab9fab312c404937bfcff3889
Added new column "authentication to table "member"; Added update script to v2.0.2

diff -r c1f000ae7a54 -r 919d16c8e8e3 core.sql
--- a/core.sql	Sun Jan 29 00:42:30 2012 +0100
+++ b/core.sql	Fri Feb 17 18:26:37 2012 +0100
@@ -7,7 +7,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('2.0.0', 2, 0, 0))
+  SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -105,6 +105,7 @@
         "password_reset_secret_expiry" TIMESTAMPTZ,
         "name"                  TEXT            NOT NULL UNIQUE,
         "identification"        TEXT            UNIQUE,
+        "authentication"        TEXT,
         "organizational_unit"   TEXT,
         "internal_posts"        TEXT,
         "realname"              TEXT,
@@ -154,6 +155,7 @@
 COMMENT ON COLUMN "member"."notify_event_id"      IS 'Latest "id" of an "event" the member was notified about';
 COMMENT ON COLUMN "member"."name"                 IS 'Distinct name of the member';
 COMMENT ON COLUMN "member"."identification"       IS 'Optional identification number or code of the member';
+COMMENT ON COLUMN "member"."authentication"       IS 'Information about how this member was authenticated';
 COMMENT ON COLUMN "member"."organizational_unit"  IS 'Branch or division of the organization the member belongs to';
 COMMENT ON COLUMN "member"."internal_posts"       IS 'Posts (offices) of the member inside the organization';
 COMMENT ON COLUMN "member"."realname"             IS 'Real name of the member, may be identical with "name"';
diff -r c1f000ae7a54 -r 919d16c8e8e3 update/core-update.v2.0.1-v2.0.2.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update/core-update.v2.0.1-v2.0.2.sql	Fri Feb 17 18:26:37 2012 +0100
@@ -0,0 +1,12 @@
+BEGIN;
+
+-- update version number:
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
+  AS "subquery"("string", "major", "minor", "revision");
+
+-- add column "authentication" to table "member":
+ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
+COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
+
+COMMIT;