4dkankan-center-manage/doc/update-2.8.1-rtk.sql

CREATE TABLE `4dkankan_v4`.`t_rtk_update_log`  (
                                           `id` int NOT NULL AUTO_INCREMENT,
                                           `rtk_sn_code` varchar(255) NULL,
                                           `fd_account` varchar(255) NULL,
                                           `old_json_data` text NULL,
                                           `new_json_data` text NULL,
                                           `rec_status` varchar(255) NULL DEFAULT 'A',
                                           `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                           `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                           PRIMARY KEY (`id`)
);


ALTER TABLE `4dkankan_v4`.`t_rtk_update_log`
    MODIFY COLUMN `new_json_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL AFTER `old_json_data`;