From 0082fd00f16aeaa88e1eab12f1efd992e245854a Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 3 Jun 2016 16:03:09 +0800 Subject: [PATCH] sql/core_person_alias.sql --- sql/core_person_alias.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/sql/core_person_alias.sql b/sql/core_person_alias.sql index e69de29b..21a64508 100644 --- a/sql/core_person_alias.sql +++ b/sql/core_person_alias.sql @@ -0,0 +1,10 @@ + +CREATE TABLE core_person_alias ( + id int(11) NOT NULL AUTO_INCREMENT, + + PRIMARY KEY (id) +) ; +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); -- 2.39.2