jbe@214: BEGIN;
jbe@214: 
jbe@214: -- update version number:
jbe@214: CREATE OR REPLACE VIEW "liquid_feedback_version" AS
jbe@214:   SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
jbe@214:   AS "subquery"("string", "major", "minor", "revision");
jbe@214: 
jbe@214: -- add column "authentication" to table "member":
jbe@214: ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
jbe@214: COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
jbe@214: 
jbe@214: COMMIT;