From 3a2a82c62207e3dc2feea5163317c83c177e390e Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Tue, 22 Jul 2014 10:06:30 +0200 Subject: [PATCH] mysql create index recordorder is only required if version<=3.1 --- modules/gmysqlbackend/dnssec-3.x_to_3.4.0_schema.mysql.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 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 5a2bc4668..c06043f78 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 @@ -1,6 +1,7 @@ -/* Uncomment next 2 lines for versions <= 3.1 */ +/* Uncomment next 3 lines for versions <= 3.1 */ /* DROP INDEX rec_name_index ON records; */ /* DROP INDEX orderindex ON records; */ +/* CREATE INDEX recordorder ON records (domain_id, ordername); */ ALTER TABLE records ADD disabled TINYINT(1) DEFAULT 0 AFTER change_date; ALTER TABLE records MODIFY content VARCHAR(64000) DEFAULT NULL; @@ -11,8 +12,6 @@ ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters ADD PRIMARY KEY(ip, nameserver); ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50); -CREATE INDEX recordorder ON records (domain_id, ordername); - CREATE TABLE comments ( id INT AUTO_INCREMENT, -- 2.40.0