huang
d104d297ca
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 5m16s
主要变更： - 新增 Carrier CRUD API（创建、列表、详情、更新、删除、状态更新） - IotCard/IotCardImportTask 添加 carrier_type/carrier_name 冗余字段 - 移除 Carrier 表的 channel_name/channel_code 字段 - 查询时直接使用冗余字段，避免 JOIN Carrier 表 - 添加数据库迁移脚本（000021-000023） - 添加单元测试和集成测试 - 同步更新 OpenAPI 文档和 specs
13 lines
573 B
SQL
13 lines
573 B
SQL
-- 回滚：恢复 Carrier 表的 channel_name、channel_code 字段
|
||
|
||
-- 添加 channel_name 字段
|
||
ALTER TABLE tb_carrier ADD COLUMN channel_name VARCHAR(100);
|
||
COMMENT ON COLUMN tb_carrier.channel_name IS '渠道名称';
|
||
|
||
-- 添加 channel_code 字段
|
||
ALTER TABLE tb_carrier ADD COLUMN channel_code VARCHAR(50);
|
||
COMMENT ON COLUMN tb_carrier.channel_code IS '渠道编码';
|
||
|
||
-- 重建联合唯一索引（carrier_type + channel_code，排除已删除记录）
|
||
CREATE UNIQUE INDEX idx_carrier_type_channel ON tb_carrier(carrier_type, channel_code) WHERE deleted_at IS NULL;
|