From 671798f6b16d4f28929e4c54481e72089827d379 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:02:22 +0800 Subject: [PATCH] sql/core_company.sql --- sql/core_company.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/core_company.sql b/sql/core_company.sql index ad5c5186..60e7f514 100644 --- a/sql/core_company.sql +++ b/sql/core_company.sql @@ -50,6 +50,8 @@ ALTER TABLE core_company ADD COLUMN deleted_by INT(11) NOT NULL DEFAULT 0; ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME NOT NULL DEFAULT '0000-00-00'; +ALTER TABLE core_company ADD INDEX lookup_owner_id (owner_id); + -- our new code should have this fixed now.. -- UPDATE core_company set comptype='OWNER' where isOwner=1; -- 2.39.2