java-bbc/db/2025-07-22 短信验证码添加发送场景字段、新增后台配置.sql

USE `yami_bbc`;
ALTER TABLE `tz_sms_log`
    ADD COLUMN `scene_type` int NULL COMMENT '发送短信验证码场景类型，具体值参考SceneTypeEnum' AFTER `status`;

-- 添加订单时间默认配置
insert into `tz_sys_config`(`param_key`, `param_value`, `remark`) values
('ORDER_TIME_CONFIG', '{\"autoSuccessTime\":15,\"orderMaxTime\":30,\"maxFinallyRefundTime\":7,\"maxRefundApplyTime\":7,\"distributionSettlementTime\":15,\"maxOrderPayedTime\":7,\"maxSubmitVoucherTime\":3,\"maxInterventionTime\":7}', '订单时间配置');