From c487f25287f9166b973e961ff195b33d0f7182c1 Mon Sep 17 00:00:00 2001 From: Peter van Dijk Date: Wed, 10 Oct 2012 12:03:27 +0000 Subject: [PATCH] update mysql dnssec schema indexes git-svn-id: svn://svn.powerdns.com/pdns/trunk/pdns@2792 d19b8d6e-7fed-0310-83ef-9ca221ded41b --- pdns/dnssec.schema.mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/pdns/dnssec.schema.mysql.sql b/pdns/dnssec.schema.mysql.sql index c25d819417..e0a0b589d7 100644 --- a/pdns/dnssec.schema.mysql.sql +++ b/pdns/dnssec.schema.mysql.sql @@ -22,7 +22,7 @@ create index domainidindex on cryptokeys(domain_id); alter table records add ordername VARCHAR(255) BINARY; alter table records add auth bool; -create index orderindex on records(ordername); +create index recordorder on records (domain_id, ordername); create table tsigkeys ( id INT auto_increment, -- 2.47.3