1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v2.0.1-v2.0.2.sql	Fri Feb 17 18:26:37 2012 +0100
     1.3 @@ -0,0 +1,12 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +-- update version number:
     1.7 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.8 +  SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
     1.9 +  AS "subquery"("string", "major", "minor", "revision");
    1.10 +
    1.11 +-- add column "authentication" to table "member":
    1.12 +ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
    1.13 +COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
    1.14 +
    1.15 +COMMIT;