X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=libs%2Flib_updates.php;h=34036de400673f7705936f8fea56d114d7ec74cd;hb=0c5bf14b13b80e6c4980400c18d52f5236bcd936;hp=9508f02db4ba32b54b73e5268960a59904a2b6ab;hpb=ae115564170d880e36df22df8363320c46037a66;p=ctracker.git

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'",
+		],
 	];
 }