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  

Impressum / About Us