From abb23e5245e9bef79411fc9d5e31dfe9ec2f1138 Mon Sep 17 00:00:00 2001 From: Kees Monshouwer Date: Wed, 12 Jul 2017 16:00:09 +0200 Subject: [PATCH] Remmove redundant indexes from gmysqlbackend default schema Based on the work of @aj-gh in pull #4809 --- modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql | 3 +++ modules/gmysqlbackend/schema.mysql.sql | 3 +-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql b/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql index c622245442..108b36c942 100644 --- a/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql +++ b/modules/gmysqlbackend/3.4.0_to_4.1.0_schema.mysql.sql @@ -3,6 +3,8 @@ ALTER TABLE domains CHARACTER SET 'latin1'; ALTER TABLE records MODIFY id BIGINT AUTO_INCREMENT; ALTER TABLE records CHARACTER SET 'latin1'; +CREATE INDEX ordername ON records (ordername); +DROP INDEX recordorder ON records; ALTER TABLE supermasters MODIFY account VARCHAR(40) CHARACTER SET 'utf8' NOT NULL; ALTER TABLE supermasters CHARACTER SET 'latin1'; @@ -10,6 +12,7 @@ ALTER TABLE supermasters CHARACTER SET 'latin1'; ALTER TABLE comments MODIFY account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL; ALTER TABLE comments MODIFY comment TEXT CHARACTER SET 'utf8' NOT NULL; ALTER TABLE comments CHARACTER SET 'latin1'; +DROP INDEX comments_domain_id_idx ON comments; ALTER TABLE domainmetadata CHARACTER SET 'latin1'; diff --git a/modules/gmysqlbackend/schema.mysql.sql b/modules/gmysqlbackend/schema.mysql.sql index 4dcc71fc43..bf15329b90 100644 --- a/modules/gmysqlbackend/schema.mysql.sql +++ b/modules/gmysqlbackend/schema.mysql.sql @@ -29,7 +29,7 @@ CREATE TABLE records ( CREATE INDEX nametype_index ON records(name,type); CREATE INDEX domain_id ON records(domain_id); -CREATE INDEX recordorder ON records (domain_id, ordername); +CREATE INDEX ordername ON records (ordername); CREATE TABLE supermasters ( @@ -51,7 +51,6 @@ CREATE TABLE comments ( PRIMARY KEY (id) ) Engine=InnoDB CHARACTER SET 'latin1'; -CREATE INDEX comments_domain_id_idx ON comments (domain_id); CREATE INDEX comments_name_type_idx ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); -- 2.47.2