From 2b3b4cfe53e93823e11da9dc6c898b43e43cfa70 Mon Sep 17 00:00:00 2001
From: Florian Schaal <florian@schaal-24.de>
Date: Sun, 28 Feb 2016 11:14:17 -0500
Subject: [PATCH] more detaled informations during install/setup when mysql is not using NO_ENGINE_SUBSTITUTION

---
 install/sql/powerdns.sql |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/install/sql/powerdns.sql b/install/sql/powerdns.sql
index 8f997ba..c9bf828 100644
--- a/install/sql/powerdns.sql
+++ b/install/sql/powerdns.sql
@@ -9,14 +9,14 @@
   `ispconfig_id` int(11) NOT NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `name_index` (`name`)
-) ENGINE=MyISAM;
+) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS `records` (
   `id` int(11) NOT NULL auto_increment,
   `domain_id` int(11) default NULL,
   `name` varchar(255) default NULL,
   `type` varchar(6) default NULL,
-  `content` varchar(255) default NULL,
+  `content` TEXT default NULL,
   `ttl` int(11) default NULL,
   `prio` int(11) default NULL,
   `change_date` int(11) default NULL,
@@ -25,10 +25,10 @@
   KEY `rec_name_index` (`name`),
   KEY `nametype_index` (`name`,`type`),
   KEY `domain_id` (`domain_id`)
-) ENGINE=MyISAM;
+) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS `supermasters` (
   `ip` varchar(25) NOT NULL,
   `nameserver` varchar(255) NOT NULL,
   `account` varchar(40) default NULL
-) ENGINE=MyISAM;
\ No newline at end of file
+) ENGINE=InnoDB;

--
Gitblit v1.9.1