From f6f0731f8cd892923fd7e5e4d55f3208e0fe0a40 Mon Sep 17 00:00:00 2001 From: Morten Stevens Date: Mon, 15 Sep 2014 13:41:25 +0200 Subject: [PATCH] Migrate existing DNSSEC tables to InnoDB --- modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql b/modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql index 1c37289337..c2645c8496 100644 --- a/modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql +++ b/modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql @@ -12,6 +12,9 @@ ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); ALTER TABLE domainmetadata MODIFY kind VARCHAR(32); ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50); +ALTER TABLE domainmetadata ENGINE=InnoDB; +ALTER TABLE cryptokeys ENGINE=InnoDB; +ALTER TABLE tsigkeys ENGINE=InnoDB; DROP INDEX domainmetaidindex ON domainmetadata; CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); -- 2.47.2