annotate update/core-update.v4.0.0-v4.0.1.sql @ 577:3536fb4148dc
Merged experimental workaround for missing spatio-temporal index as commented-out section
| author |
jbe |
| date |
Thu Feb 22 11:24:55 2018 +0100 (2018-02-22) |
| parents |
eb5f4e4f17d8 |
| children |
02a6149822e0 |
| rev |
line source |
|
jbe@574
|
1 BEGIN;
|
|
jbe@574
|
2
|
|
jbe@574
|
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
|
|
jbe@574
|
4 SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
|
|
jbe@574
|
5 AS "subquery"("string", "major", "minor", "revision");
|
|
jbe@574
|
6
|
|
jbe@574
|
7 CREATE OR REPLACE VIEW "expired_token" AS
|
|
jbe@574
|
8 SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
|
|
jbe@574
|
9 "token_type" = 'authorization' AND "used" AND EXISTS (
|
|
jbe@574
|
10 SELECT NULL FROM "token" AS "other"
|
|
jbe@574
|
11 WHERE "other"."authorization_token_id" = "token"."id" ) );
|
|
jbe@574
|
12
|
|
jbe@575
|
13 ALTER TABLE "system_application" RENAME COLUMN "discovery_baseurl" TO "base_url";
|
|
jbe@575
|
14 ALTER TABLE "system_application" ADD COLUMN "manifest_url" TEXT;
|
|
jbe@575
|
15
|
|
jbe@576
|
16 COMMENT ON COLUMN "system_application"."base_url" IS 'Base URL for users';
|
|
jbe@576
|
17 COMMENT ON COLUMN "system_application"."manifest_url" IS 'URL referring to a manifest that can be used for application (type/version) discovery';
|
|
jbe@575
|
18
|
|
jbe@574
|
19 COMMIT;
|