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

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 ;