From 38f510ba9896bd81c72c90d2765342761fff33e8 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:00:49 +0800 Subject: [PATCH] sql/core_person.sql --- sql/core_person.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/core_person.sql b/sql/core_person.sql index e3ebb438..33dbd3cc 100644 --- a/sql/core_person.sql +++ b/sql/core_person.sql @@ -105,4 +105,5 @@ ALTER TABLE core_person ADD COLUMN post_code VARCHAR(256) NOT NULL DEFAULT ''; ALTER TABLE core_person ADD COLUMN oath_key VARCHAR(254) NOT NULL DEFAULT ''; -alter table core_person add index lookup_company_id( company_id); \ No newline at end of file +alter table core_person add index lookup_company_id( company_id); +alter table core_person add index lookup_buying_head_id( buying_head_id); \ No newline at end of file -- 2.39.2