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`);