From a538a12118bb484b658c40ecb73882bb8a2002a1 Mon Sep 17 00:00:00 2001 From: Till Brehm <tbrehm@ispconfig.org> Date: Sun, 31 Jan 2016 06:39:50 -0500 Subject: [PATCH] Fixed: FS#3933 - Invalid sendmail "from" in php_fpm_pool.conf.master --- install/sql/incremental/upd_dev_collection.sql | 20 +++++++++++++++++++- 1 files changed, 19 insertions(+), 1 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index a3f14c7..32e85bd 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -193,5 +193,23 @@ 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'; \ No newline at end of file +UPDATE `mail_forwarding` SET `allow_send_as` = 'y' WHERE `type` = 'alias'; + +--- DNSSEC-Implementation by dark alex +--- TODO: Review and resolve conflicts if more has been done in that column +ALTER TABLE `dns_rr` CHANGE COLUMN `type` `type` ENUM('A','AAAA','ALIAS','CNAME','DS','HINFO','LOC','MX','NAPTR','NS','PTR','RP','SRV','TXT','TLSA','DNSKEY') NULL DEFAULT NULL AFTER `name`; + +ALTER TABLE `dns_soa` + ADD COLUMN `dnssec_initialized` ENUM('Y','N') NOT NULL DEFAULT 'N', + ADD COLUMN `dnssec_wanted` ENUM('Y','N') NOT NULL DEFAULT 'N', + ADD COLUMN `dnssec_last_signed` BIGINT NOT NULL DEFAULT '0', + ADD COLUMN `dnssec_info` TEXT NULL; \ No newline at end of file -- Gitblit v1.9.1