From 3f90814e30ba737f7f32827afeffb1e11a3b80d6 Mon Sep 17 00:00:00 2001
From: Michael <heluecht@pirati.ca>
Date: Sat, 17 Dec 2016 16:32:31 +0000
Subject: [PATCH] Remove the "MyISAM" from the SQL scripts - this engine is
outdated.
---
mailstream/database.sql | 2 +-
retriever/database.sql | 6 +++---
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/mailstream/database.sql b/mailstream/database.sql
index 1c6d168a..7ce7b64e 100644
--- a/mailstream/database.sql
+++ b/mailstream/database.sql
@@ -10,4 +10,4 @@ CREATE TABLE IF NOT EXISTS `mailstream_item` (
KEY `message-id` (`message-id`),
KEY `created` (`created`),
KEY `completed` (`completed`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
diff --git a/retriever/database.sql b/retriever/database.sql
index 1661c169..23cac120 100644
--- a/retriever/database.sql
+++ b/retriever/database.sql
@@ -6,7 +6,7 @@ CREATE TABLE IF NOT EXISTS `retriever_rule` (
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `contact-id` (`contact-id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS `retriever_item` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
@@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS `retriever_item` (
KEY `resource` (`resource`),
KEY `all` (`item-uri`, `item-uid`, `contact-id`),
PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS `retriever_resource` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
@@ -33,4 +33,4 @@ CREATE TABLE IF NOT EXISTS `retriever_resource` (
`http-code` smallint(1) unsigned NULL DEFAULT NULL,
`redirect-url` varchar(800) CHARACTER SET ascii COLLATE ascii_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
+) DEFAULT CHARSET=utf8 COLLATE=utf8_bin
--
2.39.5