1.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Thu Feb 22 11:24:55 2018 +0100
     1.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Thu Feb 22 11:50:20 2018 +0100
     1.3 @@ -4,6 +4,18 @@
     1.4    SELECT * FROM (VALUES ('4.0.1', 4, 0, 1))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 +ALTER TABLE "member" ADD COLUMN "role" BOOLEAN NOT NULL DEFAULT FALSE;
     1.8 +
     1.9 +CREATE TABLE "agent" (
    1.10 +        PRIMARY KEY ("controlled_id", "controller_id"),
    1.11 +        "controlled_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.12 +        "controller_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
    1.13 +        CONSTRAINT "controlled_id_and_controller_id_differ" CHECK (
    1.14 +            "controlled_id" != "controller_id" ) );
    1.15 +CREATE INDEX "agent_controller_id_idx" ON "agent" ("controller_id");
    1.16 +
    1.17 +COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
    1.18 +
    1.19  CREATE OR REPLACE VIEW "expired_token" AS
    1.20    SELECT * FROM "token" WHERE now() > "expiry" AND NOT (
    1.21      "token_type" = 'authorization' AND "used" AND EXISTS (