liquid_feedback_core
diff core.sql @ 578:02a6149822e0
Support for role accounts
author | jbe |
---|---|
date | Thu Feb 22 11:50:20 2018 +0100 (2018-02-22) |
parents | 3536fb4148dc |
children | f6b84db4dd0c |
line diff
1.1 --- a/core.sql Thu Feb 22 11:24:55 2018 +0100 1.2 +++ b/core.sql Thu Feb 22 11:50:20 2018 +0100 1.3 @@ -127,6 +127,7 @@ 1.4 "name" TEXT UNIQUE, 1.5 "identification" TEXT UNIQUE, 1.6 "authentication" TEXT, 1.7 + "role" BOOLEAN NOT NULL DEFAULT FALSE, 1.8 "location" JSONB, 1.9 "text_search_data" TSVECTOR, 1.10 CONSTRAINT "deleted_requires_locked" 1.11 @@ -207,6 +208,17 @@ 1.12 COMMENT ON COLUMN "member_history"."until" IS 'Timestamp until the data was valid'; 1.13 1.14 1.15 +CREATE TABLE "agent" ( 1.16 + PRIMARY KEY ("controlled_id", "controller_id"), 1.17 + "controlled_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.18 + "controller_id" INT4 REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.19 + CONSTRAINT "controlled_id_and_controller_id_differ" CHECK ( 1.20 + "controlled_id" != "controller_id" ) ); 1.21 +CREATE INDEX "agent_controller_id_idx" ON "agent" ("controller_id"); 1.22 + 1.23 +COMMENT ON TABLE "agent" IS 'Privileges for role accounts'; 1.24 + 1.25 + 1.26 CREATE TABLE "verification" ( 1.27 "id" SERIAL8 PRIMARY KEY, 1.28 "requested" TIMESTAMPTZ,