From 3221e19d66907a05c9d215232a51346421b8249c Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:05:13 +0800 Subject: [PATCH] sql/core_person_alias.sql --- sql/core_person_alias.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/core_person_alias.sql b/sql/core_person_alias.sql index 21a64508..6fe22da2 100644 --- a/sql/core_person_alias.sql +++ b/sql/core_person_alias.sql @@ -8,3 +8,5 @@ ALTER TABLE core_person_alias ADD COLUMN person_id varchar(128) DEFAULT NULL; ALTER TABLE core_person_alias ADD COLUMN alias varchar(254) NOT NULL DEFAULT ''; ALTER TABLE core_person_alias ADD INDEX alias (alias); + +ALTER TABLE core_person_alias ADD INDEX lookup_person_id (person_id); \ No newline at end of file -- 2.39.2