annotate update/core-update.v2.0.1-v2.0.2.sql @ 352:98c14d8d07f1
Support for proportional ordering of suggestions in core.sql; Begin of work on "lf_update_suggestion_order" (a second background job for sorting suggestions based on a proportional preferential voting system)
| author |
jbe |
| date |
Sat Mar 16 17:22:01 2013 +0100 (2013-03-16) |
| parents |
919d16c8e8e3 |
| children |
|
| rev |
line source |
|
jbe@214
|
1 BEGIN;
|
|
jbe@214
|
2
|
|
jbe@214
|
3 -- update version number:
|
|
jbe@214
|
4 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
|
|
jbe@214
|
5 SELECT * FROM (VALUES ('2.0.2', 2, 0, 2))
|
|
jbe@214
|
6 AS "subquery"("string", "major", "minor", "revision");
|
|
jbe@214
|
7
|
|
jbe@214
|
8 -- add column "authentication" to table "member":
|
|
jbe@214
|
9 ALTER TABLE "member" ADD COLUMN "authentication" TEXT;
|
|
jbe@214
|
10 COMMENT ON COLUMN "member"."authentication" IS 'Information about how this member was authenticated';
|
|
jbe@214
|
11
|
|
jbe@214
|
12 COMMIT;
|