| | |
|---|
| | | 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'; |
|---|
| | | |
|---|
| | | --- 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`; |
|---|
| | | |
|---|
| | | -- Mail Security: Send As Permission by dark alex |
|---|
| | | -- MS: alter table |
|---|
| | | ALTER TABLE `mail_forwarding` |
|---|
| | | ADD COLUMN `allow_send_as` ENUM('n','y') NOT NULL DEFAULT 'n' AFTER `active`; |
|---|
| | | -- MS: apply defaults |
|---|
| | | update mail_forwarding set allow_send_as='y' WHERE type = 'alias'; |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | 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; |
|---|
