From 994f32aaa99be234ba52ce2fb1bb808eee1e1c7d Mon Sep 17 00:00:00 2001 From: A. Täffner <darkalex@firesplash.de> Date: Mon, 11 Apr 2016 14:58:54 -0400 Subject: [PATCH] db permissions refined --- install/sql/incremental/upd_0078.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/install/sql/incremental/upd_0078.sql b/install/sql/incremental/upd_0078.sql index e9948dc..ea78b87 100644 --- a/install/sql/incremental/upd_0078.sql +++ b/install/sql/incremental/upd_0078.sql @@ -1 +1,2 @@ ALTER TABLE `dns_rr` CHANGE `data` `data` TEXT NOT NULL DEFAULT ''; +ALTER TABLE `web_domain` DROP INDEX `serverdomain`, ADD UNIQUE `serverdomain` ( `server_id` , `ip_address`, `domain` ); -- Gitblit v1.9.1