From 6e1bd90b34d295a4f12b8a0ec95a530d58e11f5c Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Tue, 08 Jul 2014 08:45:34 -0400 Subject: [PATCH] - added incremental sql from merge request #73 --- 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