From 0c5bf14b13b80e6c4980400c18d52f5236bcd936 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 28 Oct 2020 10:49:35 +0100 Subject: [PATCH] Continued: - added convertion to UTF-8 MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Roland Häder --- libs/lib_updates.php | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/libs/lib_updates.php b/libs/lib_updates.php index 9508f02..34036de 100644 --- a/libs/lib_updates.php +++ b/libs/lib_updates.php @@ -104,6 +104,17 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] . "ALTER TABLE `ctracker_data` CHANGE `proxy_addr` `proxy_addr` varchar(15) COLLATE 'latin1_swedish_ci' NULL COMMENT 'Detected proxy address' AFTER `remote_addr`", "ALTER TABLE `ctracker_data` ADD `spam_bot_dectections` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Spam-bot attempts'", ], + + // UTF-8 + [ + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_remote_addr` `ctracker_ticket_remote_addr` varchar(15) COLLATE 'utf8_general_ci' NOT NULL AFTER `ctracker_ticket`", + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_proxy_addr` `ctracker_ticket_proxy_addr` varchar(15) COLLATE 'utf8_general_ci' NULL AFTER `ctracker_ticket_remote_addr`", + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_user_agent` `ctracker_ticket_user_agent` tinytext COLLATE 'utf8_general_ci' NOT NULL AFTER `ctracker_ticket_proxy_addr`", + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_name` `ctracker_ticket_name` varchar(255) COLLATE 'utf8_general_ci' NOT NULL AFTER `ctracker_ticket_user_agent`", + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_email` `ctracker_ticket_email` varchar(255) COLLATE 'utf8_general_ci' NOT NULL AFTER `ctracker_ticket_name`", + "ALTER TABLE `ctracker_ticket`CHANGE `ctracker_ticket_comment` `ctracker_ticket_comment` tinytext COLLATE 'utf8_general_ci' NOT NULL AFTER `ctracker_ticket_email`", + "ALTER TABLE `ctracker_ticket`COLLATE 'utf8_general_ci'", + ], ]; } -- 2.39.5