From f244b1ad2362c4103d50c44584256f95e1103216 Mon Sep 17 00:00:00 2001
From: Aki Tuomi <cmouse@desteem.org>
Date: Mon, 2 Sep 2013 18:38:22 +0300
Subject: [PATCH] Add Engine=InnoDB for dnssec tables

---
 pdns/dnssec.schema.mysql.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/pdns/dnssec.schema.mysql.sql b/pdns/dnssec.schema.mysql.sql
index f2c1d73c48..0cb9af66b5 100644
--- a/pdns/dnssec.schema.mysql.sql
+++ b/pdns/dnssec.schema.mysql.sql
@@ -4,7 +4,7 @@ create table domainmetadata (
  kind       VARCHAR(16),
  content    TEXT,
  primary key(id)
-);
+) Engine=InnoDB;
 
 create index domainmetaidindex on domainmetadata(domain_id);               
 
@@ -16,7 +16,7 @@ create table cryptokeys (
  active     BOOL,
  content    TEXT,
  primary key(id)
-);       
+) Engine=InnoDB;
 
 create index domainidindex on cryptokeys(domain_id);           
 
@@ -30,7 +30,7 @@ create table tsigkeys (
  algorithm  VARCHAR(50),
  secret     VARCHAR(255),
  primary key(id)
-);
+) Engine=InnoDB;
 
 create unique index namealgoindex on tsigkeys(name, algorithm);
 alter table records change column type type VARCHAR(10);
-- 
2.47.2