1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
/* SEPARATOR */
CREATE TABLE IF NOT EXISTS `ajxp_mail_queue` (
`id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
`recipient` varchar(255) NOT NULL,
`url` text NOT NULL,
`date_event` int(11) NOT NULL,
`notification_object` longblob NOT NULL,
`html` int(1) NOT NULL
)CHARACTER SET utf8 COLLATE utf8_unicode_ci;
/* SEPARATOR */
CREATE TABLE IF NOT EXISTS `ajxp_mail_sent` (
`id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
`recipient` varchar(255) NOT NULL,
`url` text NOT NULL,
`date_event` int(11) NOT NULL,
`notification_object` longblob NOT NULL,
`html` int(1) NOT NULL
)CHARACTER SET utf8 COLLATE utf8_unicode_ci;
/* SEPARATOR */
CREATE TRIGGER `mail_queue_go_to_sent` BEFORE DELETE ON `ajxp_mail_queue`
FOR EACH ROW INSERT INTO ajxp_mail_sent (id,recipient,url,date_event,notification_object,html) VALUES (old.id,old.recipient,old.url,old.date_event,old.notification_object,old.html);
|