1.1 --- a/core.sql	Sun Mar 04 17:59:11 2018 +0100
     1.2 +++ b/core.sql	Sun Mar 04 18:10:07 2018 +0100
     1.3 @@ -212,12 +212,15 @@
     1.4          PRIMARY KEY ("controlled_id", "controller_id"),
     1.5          "controlled_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.6          "controller_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.7 +        "accepted"              BOOLEAN,
     1.8          CONSTRAINT "controlled_id_and_controller_id_differ" CHECK (
     1.9              "controlled_id" != "controller_id" ) );
    1.10  CREATE INDEX "agent_controller_id_idx" ON "agent" ("controller_id");
    1.11  
    1.12  COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
    1.13  
    1.14 +COMMENT ON COLUMN "agent"."accepted" IS 'If "accepted" is NULL, then the member was invited to be an agent, but has not reacted yet. If it is TRUE, the member has accepted the invitation, if it is FALSE, the member has rejected the invitation.';
    1.15 +
    1.16  
    1.17  CREATE TABLE "verification" (
    1.18          "id"                    SERIAL8         PRIMARY KEY,

     2.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Sun Mar 04 17:59:11 2018 +0100
     2.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Sun Mar 04 18:10:07 2018 +0100
     2.3 @@ -10,12 +10,15 @@
     2.4          PRIMARY KEY ("controlled_id", "controller_id"),
     2.5          "controlled_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     2.6          "controller_id"         INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     2.7 +        "accepted"              BOOLEAN,
     2.8          CONSTRAINT "controlled_id_and_controller_id_differ" CHECK (
     2.9              "controlled_id" != "controller_id" ) );
    2.10  CREATE INDEX "agent_controller_id_idx" ON "agent" ("controller_id");
    2.11  
    2.12  COMMENT ON TABLE "agent" IS 'Privileges for role accounts';
    2.13  
    2.14 +COMMENT ON COLUMN "agent"."accepted" IS 'If "accepted" is NULL, then the member was invited to be an agent, but has not reacted yet. If it is TRUE, the member has accepted the invitation, if it is FALSE, the member has rejected the invitation.';
    2.15 +
    2.16  ALTER TABLE "session" ADD COLUMN "real_member_id" INT4 REFERENCES "member" ("id") ON DELETE RESTRICT ON UPDATE CASCADE;
    2.17  
    2.18  COMMENT ON COLUMN "session"."member_id"         IS 'Reference to member, who is logged in, or role account in use';