1 BEGIN;

2

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");

6

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" ) );

12

13 ALTER TABLE "system_application" RENAME COLUMN "discovery_baseurl" TO "base_url";

14 ALTER TABLE "system_application" ADD COLUMN "manifest_url" TEXT;

15

16 COMMENT ON COLUMN "system_application"."base_url" IS 'Base URL for users';

17 COMMENT ON COLUMN "system_application"."manifest_url" IS 'URL referring to a manifest that can be used for application (type/version) discovery';

18

19 COMMIT;