ALTER TABLE `t_app_user` ADD COLUMN `balance` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '余额' AFTER `points`; ALTER TABLE `t_exchange_code_use_record` MODIFY COLUMN `order_id` bigint NULL DEFAULT 0 COMMENT '订单ID,0表示兑换入账'; CREATE INDEX `idx_exchange_code_use_record_user_time` ON `t_exchange_code_use_record` (`user_id`, `create_time`);