From 7927f098815a0ec4e232914d01626ae8de99383d Mon Sep 17 00:00:00 2001 From: Florian Schaal <florian@schaal-24.de> Date: Tue, 26 Jan 2016 07:16:56 -0500 Subject: [PATCH] FS#4072 - Centos 7 Amavisd config path --- install/sql/incremental/upd_dev_collection.sql | 16 +++++++++++++++- 1 files changed, 15 insertions(+), 1 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index 4c23d5f..624d748 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -99,7 +99,7 @@ `vjud_opt_mode` enum('in', 'out') NOT NULL DEFAULT 'in', `use_muc_host` enum('n','y') NOT NULL DEFAULT 'n', - `muc_name` varchar(30) NOT NULL DEFAULT '' + `muc_name` varchar(30) NOT NULL DEFAULT '', `muc_restrict_room_creation` enum('n', 'y', 'm') NOT NULL DEFAULT 'm', `muc_admins` text, `use_pastebin` enum('n','y') NOT NULL DEFAULT 'n', @@ -189,3 +189,17 @@ ADD COLUMN `custom` text; ALTER TABLE `web_domain` ADD `ssl_letsencrypt` enum('n','y') NOT NULL DEFAULT 'n' AFTER `ssl`; + +ALTER TABLE `openvz_template` CHANGE `vmguarpages` `vmguarpages` varchar(255) DEFAULT '65536:unlimited'; +ALTER TABLE `openvz_template` CHANGE `privvmpages` `privvmpages` varchar(255) DEFAULT '131072:139264'; + +CREATE TABLE `ftp_traffic` ( + `hostname` varchar(255) NOT NULL, + `traffic_date` date NOT NULL, + `in_bytes` bigint(32) unsigned NOT NULL, + `out_bytes` bigint(32) unsigned NOT NULL, + PRIMARY KEY (`hostname`,`traffic_date`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; + +ALTER TABLE `mail_forwarding` ADD COLUMN `allow_send_as` ENUM('n','y') NOT NULL DEFAULT 'n' AFTER `active`; +UPDATE `mail_forwarding` SET `allow_send_as` = 'y' WHERE `type` = 'alias'; -- Gitblit v1.9.1