4dkankan-center-manage/doc/update.2.8.0.sql

ALTER TABLE `4dkankan_v4`.`t_rtk_device`
    ADD COLUMN `account_type` int NULL DEFAULT 0 COMMENT '0账号池，1专用账号' AFTER `failure_time`;
ALTER TABLE `4dkankan_v4`.`t_rtk_device`
    ADD COLUMN `camera_type` int NULL COMMENT '0看看，1看见，2深时，3深光' AFTER `account_type`;

ALTER TABLE `4dkankan_v4`.`t_rtk_device`
    ADD COLUMN `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `camera_type`,
ADD COLUMN `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `user_name`,
ADD COLUMN `ip_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `password`,
ADD COLUMN `mount_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `ip_addr`,
ADD COLUMN `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `mount_point`,
ADD COLUMN `operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '运营商' AFTER `port`;

ALTER TABLE `4dkankan_v4`.`t_rtk_account`
DROP COLUMN `type`;