2 -- used to trigger emails about changes to items being watched.
4 CREATE TABLE core_watch (
5 id int(11) NOT NULL AUTO_INCREMENT,
10 alter table core_watch ADD COLUMN ontable varchar(128) NOT NULL DEFAULT '';
11 alter table core_watch ADD COLUMN onid int(11) NOT NULL DEFAULT 0;
12 alter table core_watch ADD COLUMN person_id int(11) NOT NULL DEFAULT 0;
13 alter table core_watch ADD COLUMN event varchar(128) NOT NULL DEFAULT '';
14 alter table core_watch ADD COLUMN medium varchar(64) NOT NULL DEFAULT '';
15 alter table core_watch ADD COLUMN active int(11) NOT NULL DEFAULT '1';
17 ALTER TABLE core_watch ADD INDEX qlookup (ontable,onid,person_id,event,medium);
19 call mysql_change_engine('core_watch');