mescloud/db/mysql/alter_mes_client_upgrade_version.sql

-- 客户端版本号改为 0.0.0 格式
ALTER TABLE `mes_client_upgrade`
  MODIFY COLUMN `version` varchar(32) NULL DEFAULT NULL COMMENT 'version';

UPDATE `mes_client_upgrade`
SET `version` = CONCAT('0.0.', `version`)
WHERE `version` IS NOT NULL
  AND `version` <> ''
  AND `version` NOT LIKE '%.%';