From 95d8e3c01a86762a6a2e4a4b3731eaf6302657cf Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 13:19:39 +0800 Subject: [PATCH] sql/core_person.sql --- sql/core_person.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/core_person.sql b/sql/core_person.sql index a001d10e..e3ebb438 100644 --- a/sql/core_person.sql +++ b/sql/core_person.sql @@ -103,4 +103,6 @@ ALTER TABLE core_person add index lookup_owner(owner_id); 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 ''; \ No newline at end of file +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 -- 2.39.2