CAE2qBZ6

1CREATE TABLE IF NOT EXISTS `mails` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `to` varchar(255) NOT NULL,
4  `object` varchar(30) NOT NULL,
5  `data` text NOT NULL,
6  `temp_id` int(11) NOT NULL,
7  `mailing_id` int(11) NOT NULL,
8  `priority` tinyint(1) NOT NULL,
9  `send_time` datetime NOT NULL,
10  `error` tinyint(1) NOT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
13	
14SELECT `id`, `to` FROM `mails` WHERE (`to` LIKE 'info@mail.ru' OR `to` LIKE 'info@mail.ru,%' OR `to` LIKE '%,info@mail.ru' OR `to` LIKE '%,info@mail.ru,%') AND `mailing_id` = 172
15	
16CREATE TABLE IF NOT EXISTS `mails` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `to_id` varchar(255) NOT NULL,
19  `object` varchar(30) NOT NULL,
20  `data` text NOT NULL,
21  `temp_id` int(11) NOT NULL,
22  `mailing_id` int(11) NOT NULL,
23  `priority` tinyint(1) NOT NULL,
24  `send_time` datetime NOT NULL,
25  `error` tinyint(1) NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29CREATE TABLE IF NOT EXISTS `recipients` (
30  `id` int unsigned not null auto_increment,
31  `rec_id` int unsigned not null,
32  `to` varchar(255) NOT NULL not null,
33  INDEX pn_rec_index(`rec_id`),
34  FOREIGN KEY (`rec_id`) references mails(`to_id`) on delete cascade,
35  PRIMARY KEY(`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;