liquid_feedback_core
changeset 581:1cb6710fc429
Introduced "accepted" flag for agents of role/member accounts
author | jbe |
---|---|
date | Sun Mar 04 18:10:07 2018 +0100 (2018-03-04) |
parents | 78f6833f5f19 |
children | 225a0c047691 |
files | core.sql update/core-update.v4.0.0-v4.0.1.sql |
line diff
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';