Some SQL fixes for MariaDB compatibility.
@see commit 9a8de140c82d0db44ac6b6a6a1f31485df9072ab
| | |
| | | ALTER TABLE `shell_user` CHANGE `ssh_rsa` `ssh_rsa` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; |
| | | ALTER TABLE `shell_user` CHANGE `ssh_rsa` `ssh_rsa` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; |
| | |
| | | |
| | | -- increase column size |
| | | ALTER TABLE `client` CHANGE `template_additional` `template_additional` TEXT NOT NULL DEFAULT ''; |
| | | ALTER TABLE `client` CHANGE `template_additional` `template_additional` TEXT NOT NULL; |
| | | |
| | |
| | | ALTER TABLE `client` |
| | | ADD `web_servers` blob NOT NULL DEFAULT '' AFTER `default_webserver`, |
| | | ADD `mail_servers` blob NOT NULL DEFAULT '' AFTER `default_mailserver`, |
| | | ADD `db_servers` blob NOT NULL DEFAULT '' AFTER `default_dbserver`, |
| | | ADD `dns_servers` blob NOT NULL DEFAULT '' AFTER `default_dnsserver`; |
| | | ADD `web_servers` blob NOT NULL AFTER `default_webserver`, |
| | | ADD `mail_servers` blob NOT NULL AFTER `default_mailserver`, |
| | | ADD `db_servers` blob NOT NULL AFTER `default_dbserver`, |
| | | ADD `dns_servers` blob NOT NULL AFTER `default_dnsserver`; |
| | | |
| | | UPDATE `client` SET `web_servers` = `default_webserver`, `mail_servers` = `default_mailserver`, `db_servers` = `default_dbserver`, `dns_servers` = `default_dnsserver` WHERE 1; |