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