liquid_feedback_core
changeset 590:c918d08f5a80
Added missing index on "member_useterms" table
author | jbe |
---|---|
date | Fri Dec 07 15:57:34 2018 +0100 (2018-12-07) |
parents | aa23fa17604d |
children | d955519f7471 |
files | core.sql |
line diff
1.1 --- a/core.sql Fri Dec 07 15:48:02 2018 +0100 1.2 +++ b/core.sql Fri Dec 07 15:57:34 2018 +0100 1.3 @@ -301,6 +301,7 @@ 1.4 "member_id" INT4 NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE, 1.5 "accepted" TIMESTAMPTZ NOT NULL DEFAULT now(), 1.6 "contract_identifier" TEXT NOT NULL ); 1.7 +CREATE INDEX "member_useterms_member_id_contract_identifier" ON "member_useterms" ("member_id", "contract_identifier"); 1.8 1.9 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member'; 1.10