liquid_feedback_core
diff update/core-update.v2.0.1-v2.0.2.sql @ 214:919d16c8e8e3
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 | |
children |
line diff
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;