commit | author | age
|
0d3e95
|
1 |
ALTER TABLE `client` CHANGE `web_servers` `web_servers` TEXT NULL DEFAULT NULL; |
TB |
2 |
ALTER TABLE `client` CHANGE `mail_servers` `mail_servers` TEXT NULL DEFAULT NULL; |
|
3 |
ALTER TABLE `client` CHANGE `xmpp_servers` `xmpp_servers` TEXT NULL DEFAULT NULL; |
|
4 |
ALTER TABLE `client` CHANGE `db_servers` `db_servers` TEXT NULL DEFAULT NULL; |
|
5 |
ALTER TABLE `client` CHANGE `dns_servers` `dns_servers` TEXT NULL DEFAULT NULL; |
|
6 |
UPDATE client SET web_servers = default_webserver WHERE (web_servers = '' OR web_servers IS NULL); |
|
7 |
UPDATE client SET mail_servers = default_mailserver WHERE (mail_servers = '' OR mail_servers IS NULL); |
|
8 |
UPDATE client SET xmpp_servers = default_xmppserver WHERE (xmpp_servers = '' OR xmpp_servers IS NULL); |
|
9 |
UPDATE client SET db_servers = default_dbserver WHERE (db_servers = '' OR db_servers IS NULL); |
|
10 |
UPDATE client SET dns_servers = default_dnsserver WHERE (dns_servers = '' OR dns_servers IS NULL); |