1 CREATE TABLE core_notify_server (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
3 hostname VARCHAR(128) NOT NULL DEFAULT '',
4 helo VARCHAR(128) NOT NULL DEFAULT '',
5 poolname VARCHAR(128) NOT NULL DEFAULT '',
6 is_active INT(4) NOT NULL DEFAULT 0,
7 last_send DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
12 ALTER TABLE core_notify_server ADD INDEX lookup (hostname,poolname,is_active);