4 * Table is designed to be used with a mailer to notify or issue
5 * emails (or maybe others later??)
8 CREATE TABLE core_notify (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `act_when` DATETIME NOT NULL,
11 `onid` int(11) NOT NULL DEFAULT 0,
12 `ontable` varchar(128) NOT NULL DEFAULT '',
13 `person_id` int(11) NOT NULL DEFAULT 0,
14 `msgid` varchar(128) NOT NULL DEFAULT '',
15 `sent` DATETIME NOT NULL,
16 `bounced` int(4) NOT NULL DEFAULT 0,
18 INDEX `lookup`(`act_when`, `msgid`)