) ;
ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`);
+CREATE TABLE core_notify (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `act_when` datetime NOT NULL,
+ `onid` int(11) NOT NULL,
+ `ontable` int(11) NOT NULL,
+ `person_id` int(11) NOT NULL,
+ `msgid` varchar(128) NOT NULL,
+ PRIMARY KEY (`id`),
+ INDEX `lookup`(`act_when`, `msgid`)
+);
+
+