From e2c3b6e9590db09c0c618514b3f855b189987b1c Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:06:41 +0800 Subject: [PATCH] sql/core_email.sql --- sql/core_email.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_email.sql b/sql/core_email.sql index e803577b..b7e582f5 100644 --- a/sql/core_email.sql +++ b/sql/core_email.sql @@ -32,7 +32,7 @@ ALTER TABLE core_email ADD COLUMN use_file VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_email ADD COLUMN description VARCHAR(254) NOT NULL DEFAULT ''; - +ALTER TABLE core_email ADD INDEX lookup_owner_id (owner_id); UPDATE core_email SET updated_dt = NOW() where updated_dt IS NULL; -- 2.39.2