Lines Matching refs:email_id
164 `email_id` int unsigned DEFAULT NULL,
170 KEY `IDX_ES1` (`email_id`),
172 (`generated_sent_date`,`email_id`),
173 CONSTRAINT `FK_EA1` FOREIGN KEY (`email_id`) REFERENCES
178 INSERT INTO `email_stats` (`id`, `email_id`, `date_sent`) VALUES
181 id email_id date_sent generated_sent_date
195 `email_id` int unsigned DEFAULT NULL,
201 KEY `IDX_ES1` (`email_id`),
203 (`generated_sent_date`,`email_id`),
204 CONSTRAINT `FK_EA1` FOREIGN KEY (`email_id`) REFERENCES
209 INSERT INTO `email_stats` (`id`, `email_id`, `date_sent`) VALUES
215 id email_id date_sent generated_sent_date
217 UPDATE `email_stats` SET `email_id`=2
220 id email_id date_sent generated_sent_date
232 `email_id` int unsigned DEFAULT NULL,
235 (CONCAT(YEAR(`date_sent`),'-', COALESCE(`email_id`, ' '))) VIRTUAL,
237 KEY `idx_es1` (`email_id`),
239 (`generated_sent_email`,`email_id`),
240 CONSTRAINT `fk_ea1` FOREIGN KEY (`email_id`) REFERENCES
245 INSERT INTO `email_stats` (`id`, `email_id`, `date_sent`) VALUES
248 id email_id date_sent generated_sent_email
255 id email_id date_sent generated_sent_email
270 `email_id` int unsigned DEFAULT NULL,
273 (CONCAT(YEAR(`date_sent`),'-', COALESCE(`email_id`, ' '))) VIRTUAL,
275 KEY `idx_es1` (`email_id`),
277 (`generated_sent_email`,`email_id`),
278 CONSTRAINT `fk_ea1` FOREIGN KEY (`email_id`) REFERENCES
283 INSERT INTO `email_stats` (`id`, `email_id`, `date_sent`) VALUES
286 id email_id date_sent generated_sent_email
293 id email_id date_sent generated_sent_email