From 2d2151720ba8f20f0cd00ddc34d97c76204ae09b Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Wed, 23 Jul 2014 01:14:28 +0200 Subject: [PATCH] add kind column to mysql index on domainmetadata --- modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql | 2 ++ modules/gmysqlbackend/nodnssec-3.x_to_3.4.0_schema.mysql.sql | 2 +- modules/gmysqlbackend/schema.mysql.sql | 2 +- 3 files changed, 4 insertions(+), 2 deletions(-) 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 c06043f78b..95b5ddb3a5 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,8 @@ ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50); +DROP INDEX domainmetaidindex ON domainmetadata; +CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); CREATE TABLE comments ( id INT AUTO_INCREMENT, diff --git a/modules/gmysqlbackend/nodnssec-3.x_to_3.4.0_schema.mysql.sql b/modules/gmysqlbackend/nodnssec-3.x_to_3.4.0_schema.mysql.sql index 2a916f51f6..f57b0f7a43 100644 --- a/modules/gmysqlbackend/nodnssec-3.x_to_3.4.0_schema.mysql.sql +++ b/modules/gmysqlbackend/nodnssec-3.x_to_3.4.0_schema.mysql.sql @@ -20,7 +20,7 @@ CREATE TABLE domainmetadata ( PRIMARY KEY(id) ) Engine=InnoDB; -CREATE INDEX domainmetaidindex ON domainmetadata(domain_id); +CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); CREATE TABLE cryptokeys ( diff --git a/modules/gmysqlbackend/schema.mysql.sql b/modules/gmysqlbackend/schema.mysql.sql index 63e3ebfa72..3da223efb3 100644 --- a/modules/gmysqlbackend/schema.mysql.sql +++ b/modules/gmysqlbackend/schema.mysql.sql @@ -64,7 +64,7 @@ CREATE TABLE domainmetadata ( PRIMARY KEY (id) ) Engine=InnoDB; -CREATE INDEX domainmetaidindex ON domainmetadata(domain_id); +CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind); CREATE TABLE cryptokeys ( -- 2.47.2