From 7908086ad49c458af08996b6de8fac4a32b3c289 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 14 Mar 2011 18:45:21 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 50741441..c0b73b48 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -302,16 +302,15 @@ CREATE TABLE `core_watch` ( ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`); - -ALTER TABLE core_watch change change column user_id person_id int(11); -ALTER TABLE core_watch change alter column onid int(11); + # - used by email / tracker to handle alises CREATE TABLE `core_person_aliases` ( - + `id` int(11) NOT NULL AUTO_INCREMENT, `person_id` varchar(128) DEFAULT NULL, `alias` varchar(254) NOT NULL, PRIMARY KEY (`alias`) -) ; \ No newline at end of file +) ; +ALTER TABLE core_watch ADD INDEX qlookup (`alias`); -- 2.39.2