Database history tablesupgraded

1. zabbix升级到6之后，配置安装完成会有一个红色输出，但是不影响zabbix使用，出于强迫症，找到了该问题的解决方法。

Database history tables upgraded: No. Support for the old numeric type
is deprecated. Please upgrade to numeric values of extended range

2. 停止zabbix-server zabbix-agent nginx php-fpm相关服务，登录MySQL

[root@zabbix conf]# systemctl stop zabbix-server  zabbix-agent nginx php-fpm
[root@220-230 ~]# mysql -uroot -p  #登录MySQL
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 830
Server version: 8.0.31 MySQL Community Server - GPLCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> source /root/double.sql   #该文件在zabbix-server服务器下的/usr/share/zabbix-sql-scripts/目录下
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> ALTER TABLE trends-> MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,-> MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,-> MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0mysql> exit
Bye

3. zabbix.conf.php添加如下配置

$DB['DOUBLE_IEEE754'] = true;

4. 重启zabbix-server

systemctl restart zabbix-server