huang
a5388446d3
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 8m7s
11 lines
359 B
SQL
11 lines
359 B
SQL
-- 将设备 status 收敛为归属状态：1=在库，2=已分销。
|
||
-- 设备激活状态不落库，由“生效中主套餐 + 任意绑定卡已实名”动态计算。
|
||
UPDATE tb_device
|
||
SET status = CASE
|
||
WHEN shop_id IS NULL THEN 1
|
||
ELSE 2
|
||
END
|
||
WHERE status NOT IN (1, 2);
|
||
|
||
COMMENT ON COLUMN tb_device.status IS '归属状态 1-在库 2-已分销';
|