diff options
Diffstat (limited to 'www-apps/pydio/files/6.4.0.mysql')
-rw-r--r-- | www-apps/pydio/files/6.4.0.mysql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/www-apps/pydio/files/6.4.0.mysql b/www-apps/pydio/files/6.4.0.mysql new file mode 100644 index 0000000..90121d9 --- /dev/null +++ b/www-apps/pydio/files/6.4.0.mysql @@ -0,0 +1,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);
\ No newline at end of file |