# HG changeset patch
# User jbe
# Date 1544194654 -3600
# Node ID c918d08f5a8060b5b8b1be1ca908d9c8fb107234
# Parent  aa23fa17604d1a75d4bfa05ac135deeb22cbb5c7
Added missing index on "member_useterms" table

diff -r aa23fa17604d -r c918d08f5a80 core.sql
--- a/core.sql	Fri Dec 07 15:48:02 2018 +0100
+++ b/core.sql	Fri Dec 07 15:57:34 2018 +0100
@@ -301,6 +301,7 @@
         "member_id"             INT4            NOT NULL REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "accepted"              TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "contract_identifier"   TEXT            NOT NULL );
+CREATE INDEX "member_useterms_member_id_contract_identifier" ON "member_useterms" ("member_id", "contract_identifier");
 
 COMMENT ON TABLE "member_useterms" IS 'Keeps record of accepted terms of use; may contain multiple rows per member';