liquid_feedback_core
view update/core-update.v4.0.0-v4.0.1.sql @ 575:8771e783d898
Split-up "discovery_baseurl" into "base_url" and "manifest_url"
| author | jbe |
|---|---|
| date | Mon Oct 23 14:35:35 2017 +0200 (2017-10-23) |
| parents | 2cb4a7d9e6e9 |
| children | eb5f4e4f17d8 |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
5 AS "subquery"("string", "major", "minor", "revision");
7 CREATE OR REPLACE VIEW "expired_token" AS
8 SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
9 "token_type" = 'authorization' AND "used" AND EXISTS (
10 SELECT NULL FROM "token" AS "other"
11 WHERE "other"."authorization_token_id" = "token"."id" ) );
13 ALTER TABLE "system_application" RENAME COLUMN "discovery_baseurl" TO "base_url";
14 ALTER TABLE "system_application" ADD COLUMN "manifest_url" TEXT;
16 COMMENT ON COLUMN "system_application"."base_url" IS 'Base URL for users; NULL for hidden application';
17 COMMENT ON COLUMN "system_application"."manifest_url" IS 'URL referring to a manifest that can be used for application (type/version) discovery; NULL for hidden application';
19 COMMIT;