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,