From 942f9f8aa52d73ac792b675049fbe3b5829404a8 Mon Sep 17 00:00:00 2001
From: Peter van Dijk <peter.van.dijk@netherlabs.nl>
Date: Thu, 4 Jul 2013 20:26:29 +0200
Subject: [PATCH] drop useless index

---
 pdns/docs/pdns.xml              | 5 ++++-
 pdns/no-dnssec.schema.mysql.sql | 1 -
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/pdns/docs/pdns.xml b/pdns/docs/pdns.xml
index bbdc0ce02..2639a0bff 100644
--- a/pdns/docs/pdns.xml
+++ b/pdns/docs/pdns.xml
@@ -12292,12 +12292,15 @@ create index recordorder on records (domain_id, ordername text_pattern_ops);
       </para>
     </note>
     <para>
-      The `ip` field in the supermasters table (for the various gsql backends) has been stretched to 64 characters
+      The `ip' field in the supermasters table (for the various gsql backends) has been stretched to 64 characters
       to support IPv6.
     </para>
     <para>
       pdnssec secure-zone now creates one KSK and one ZSK, instead of two ZSKs.
     </para>
+    <para>
+      The `rec_name_index' index was dropped from the gmysql schema, as it was superfluous.
+    </para>
   </sect1>
 
   </chapter>
diff --git a/pdns/no-dnssec.schema.mysql.sql b/pdns/no-dnssec.schema.mysql.sql
index 9c61c309d..86dfcfb3f 100644
--- a/pdns/no-dnssec.schema.mysql.sql
+++ b/pdns/no-dnssec.schema.mysql.sql
@@ -23,7 +23,6 @@ CREATE TABLE records (
   primary key(id)
 ) Engine=InnoDB;
 
-CREATE INDEX rec_name_index ON records(name);
 CREATE INDEX nametype_index ON records(name,type);
 CREATE INDEX domain_id ON records(domain_id);
 
-- 
2.49.0