From 3f90814e30ba737f7f32827afeffb1e11a3b80d6 Mon Sep 17 00:00:00 2001 From: Michael 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