From f30628b14112d0213bf40cd4dd7e5ab77c39d4f6 Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Sat, 05 Apr 2014 08:42:02 -0400
Subject: [PATCH] Fixed: FS#3359 - rkhunter running twice on Debian

---
 install/sql/incremental/upd_0068.sql |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/install/sql/incremental/upd_0068.sql b/install/sql/incremental/upd_0068.sql
index e7a0018..ab6425b 100644
--- a/install/sql/incremental/upd_0068.sql
+++ b/install/sql/incremental/upd_0068.sql
@@ -1,4 +1,5 @@
 ALTER TABLE  `dbispconfig`.`web_domain` ADD UNIQUE  `serverdomain` (  `server_id` ,  `domain` );
-DROP INDEX rr ON dns_rr;
-ALTER TABLE  `dns_rr` CHANGE  `name`  `name` VARCHAR( 128 ) NOT NULL ;
-CREATE INDEX `rr` ON dns_rr (`zone`,`type`,`name`);
\ No newline at end of file
+
+ALTER TABLE  `dns_rr` DROP KEY rr,
+	CHANGE  `name`  `name` VARCHAR( 128 ) NOT NULL,
+	ADD KEY `rr` (`zone`,`type`,`name`);

--
Gitblit v1.9.1