ALTER TABLE `4dkankan_v4`.`t_authorize_camera` ADD COLUMN `amount` decimal(15, 2) NULL AFTER `update_time`, ADD COLUMN `currency_symbol` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'CNY' AFTER `amount`, ADD COLUMN `order_sn` varchar(255) NULL AFTER `currency_symbol`; update t_rtk_device set rtk_type = 1 WHERE rtk_type = 0 ;