From b395d495c406f43598fad3e142bdd8d523f5f812 Mon Sep 17 00:00:00 2001 From: A. Täffner <darkalex@firesplash.de> Date: Tue, 14 Jun 2016 03:23:17 -0400 Subject: [PATCH] Fixes ispconfig/ispconfig3#3943 --- 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