From d2f32ec752acec2ec8d8cab1d88204d202628a3b Mon Sep 17 00:00:00 2001
From: Sergio Cambra <sergio@programatica.es>
Date: Tue, 08 Jul 2014 08:00:01 -0400
Subject: [PATCH] fix to display icon on service columns of server list

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

diff --git a/install/sql/incremental/upd_0068.sql b/install/sql/incremental/upd_0068.sql
index e7a0018..adce5c2 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  `web_domain` ADD UNIQUE  `serverdomain` (  `server_id` ,  `domain` );
+
+ALTER TABLE  `dns_rr` DROP KEY rr,
+	CHANGE  `name`  `name` VARCHAR( 128 ) NOT NULL,
+	ADD KEY `rr` (`zone`,`type`,`name`);

--
Gitblit v1.9.1