First part of fix for issue #3896 - Unknown column 'default_mailserver' in 'field list' when saving client limits main template
| | |
| | | UPDATE client SET mail_servers = default_mailserver WHERE (mail_servers = '' OR mail_servers IS NULL); |
| | | UPDATE client SET xmpp_servers = default_xmppserver WHERE (xmpp_servers = '' OR xmpp_servers IS NULL); |
| | | UPDATE client SET db_servers = default_dbserver WHERE (db_servers = '' OR db_servers IS NULL); |
| | | UPDATE client SET dns_servers = default_dnsserver WHERE (dns_servers = '' OR dns_servers IS NULL); |
| | | UPDATE client SET dns_servers = default_dnsserver WHERE (dns_servers = '' OR dns_servers IS NULL); |
| | | ALTER TABLE `client_template` ADD `default_slave_dnsserver` INT NOT NULL DEFAULT '0' AFTER `limit_dns_slave_zone`; |
| | | ALTER TABLE `client_template` ADD `mail_servers` TEXT NULL DEFAULT NULL AFTER `template_type`; |
| | | ALTER TABLE `client_template` ADD `web_servers` TEXT NULL DEFAULT NULL AFTER `limit_xmpp_httparchive`; |
| | | ALTER TABLE `client_template` ADD `dns_servers` TEXT NULL DEFAULT NULL AFTER `limit_aps`; |
| | | ALTER TABLE `client_template` ADD `db_servers` TEXT NULL DEFAULT NULL AFTER `limit_dns_record`; |
| | |
| | | `bank_account_swift` varchar(255) DEFAULT NULL, |
| | | `paypal_email` varchar(255) DEFAULT NULL, |
| | | `default_mailserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `mail_servers` blob, |
| | | `mail_servers` text, |
| | | `limit_maildomain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_mailbox` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_mailalias` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | `limit_spamfilter_user` int(11) NOT NULL DEFAULT '0', |
| | | `limit_spamfilter_policy` int(11) NOT NULL DEFAULT '0', |
| | | `default_xmppserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `xmpp_servers` blob, |
| | | `xmpp_servers` text, |
| | | `limit_xmpp_domain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_xmpp_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_xmpp_muc` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | |
| | | `limit_xmpp_pastebin` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `limit_xmpp_httparchive` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `default_webserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `web_servers` blob, |
| | | `web_servers` text, |
| | | `limit_web_ip` text, |
| | | `limit_web_domain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_web_quota` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n', |
| | | `limit_aps` int(11) NOT NULL DEFAULT '-1', |
| | | `default_dnsserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `db_servers` blob, |
| | | `db_servers` text, |
| | | `limit_dns_zone` int(11) NOT NULL DEFAULT '-1', |
| | | `default_slave_dnsserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `limit_dns_slave_zone` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_dns_record` int(11) NOT NULL DEFAULT '-1', |
| | | `default_dbserver` int(11) NOT NULL DEFAULT '1', |
| | | `dns_servers` blob, |
| | | `dns_servers` text, |
| | | `limit_database` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_quota` int(11) NOT NULL default '-1', |
| | |
| | | `sys_perm_other` varchar(5) default NULL, |
| | | `template_name` varchar(64) NOT NULL DEFAULT '', |
| | | `template_type` varchar(1) NOT NULL default 'm', |
| | | `mail_servers` text, |
| | | `limit_maildomain` int(11) NOT NULL default '-1', |
| | | `limit_mailbox` int(11) NOT NULL default '-1', |
| | | `limit_mailalias` int(11) NOT NULL default '-1', |
| | |
| | | `limit_spamfilter_user` int(11) NOT NULL default '0', |
| | | `limit_spamfilter_policy` int(11) NOT NULL default '0', |
| | | `default_xmppserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `xmpp_servers` blob, |
| | | `xmpp_servers` text, |
| | | `limit_xmpp_domain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_xmpp_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_xmpp_muc` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | |
| | | `limit_xmpp_status` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `limit_xmpp_pastebin` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `limit_xmpp_httparchive` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `web_servers` text, |
| | | `limit_web_ip` text, |
| | | `limit_web_domain` int(11) NOT NULL default '-1', |
| | | `limit_web_quota` int(11) NOT NULL default '-1', |
| | |
| | | `limit_backup` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'y', |
| | | `limit_directive_snippets` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n', |
| | | `limit_aps` int(11) NOT NULL DEFAULT '-1', |
| | | `dns_servers` text, |
| | | `limit_dns_zone` int(11) NOT NULL default '-1', |
| | | `default_slave_dnsserver` int(11) NOT NULL DEFAULT '0', |
| | | `limit_dns_slave_zone` int(11) NOT NULL default '-1', |
| | | `limit_dns_record` int(11) NOT NULL default '-1', |
| | | `db_servers` text, |
| | | `limit_database` int(11) NOT NULL default '-1', |
| | | `limit_database_user` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_quota` int(11) NOT NULL default '-1', |
| | |
| | | 'maxlength' => '10', |
| | | 'rows' => '', |
| | | 'cols' => '' |
| | | ), |
| | | ),/* |
| | | 'default_mailserver' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'SELECT', |
| | |
| | | ), |
| | | 'value' => array(''), |
| | | 'name' => 'default_mailserver' |
| | | ), |
| | | ),*/ |
| | | 'limit_maildomain' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'TEXT', |
| | |
| | | 'maxlength' => '10', |
| | | 'rows' => '', |
| | | 'cols' => '' |
| | | ), |
| | | ),/* |
| | | 'default_xmppserver' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'SELECT', |
| | |
| | | ), |
| | | 'value' => '', |
| | | 'name' => 'default_xmppserver' |
| | | ), |
| | | ),*/ |
| | | 'xmpp_servers' => array ( |
| | | 'datatype' => 'VARCHAR', |
| | | 'formtype' => 'MULTIPLE', |
| | |
| | | 'formtype' => 'CHECKBOX', |
| | | 'default' => 'n', |
| | | 'value' => array(0 => 'n', 1 => 'y') |
| | | ), |
| | | ),/* |
| | | 'default_webserver' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'SELECT', |
| | |
| | | ), |
| | | 'value' => array(''), |
| | | 'name' => 'default_webserver' |
| | | ), |
| | | ),*/ |
| | | 'limit_web_domain' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'TEXT', |
| | |
| | | 'formtype' => 'CHECKBOX', |
| | | 'default' => 'n', |
| | | 'value' => array(0 => 'n', 1 => 'y') |
| | | ), |
| | | ),/* |
| | | 'default_dnsserver' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'SELECT', |
| | |
| | | ), |
| | | 'value' => array(''), |
| | | 'name' => 'default_dnsserver' |
| | | ), |
| | | ),*/ |
| | | 'limit_dns_zone' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'TEXT', |
| | |
| | | 'cols' => '' |
| | | ), |
| | | */ |
| | | /* |
| | | 'default_dbserver' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'SELECT', |
| | |
| | | ), |
| | | 'value' => array(''), |
| | | 'name' => 'default_dbserver' |
| | | ), |
| | | ),*/ |
| | | 'limit_database' => array ( |
| | | 'datatype' => 'INTEGER', |
| | | 'formtype' => 'TEXT', |