-- 代码装配实例没有数据库 ID；登记事实仍以实例编码和厂商身份唯一定位。
|
ALTER TABLE t_detection_cabinet ADD COLUMN adapter_code VARCHAR(64) NULL AFTER adapter_id;
|
ALTER TABLE t_detection_channel ADD COLUMN adapter_code VARCHAR(64) NULL AFTER adapter_id;
|
|
UPDATE t_detection_cabinet c JOIN t_device_adapter a ON a.adapter_id=c.adapter_id
|
SET c.adapter_code=a.adapter_code;
|
UPDATE t_detection_channel ch JOIN t_device_adapter a ON a.adapter_id=ch.adapter_id
|
SET ch.adapter_code=a.adapter_code;
|
|
ALTER TABLE t_detection_cabinet
|
MODIFY COLUMN adapter_id BIGINT NULL,
|
MODIFY COLUMN adapter_code VARCHAR(64) NOT NULL,
|
DROP INDEX uk_cabinet_vendor_identity,
|
ADD UNIQUE KEY uk_cabinet_vendor_identity (adapter_code, vendor_device_type, vendor_device_id, del_flag);
|
ALTER TABLE t_detection_channel
|
MODIFY COLUMN adapter_id BIGINT NULL,
|
MODIFY COLUMN adapter_code VARCHAR(64) NOT NULL,
|
DROP INDEX uk_channel_stable_identity,
|
ADD UNIQUE KEY uk_channel_stable_identity (adapter_code, devtype, devid, subdevid, chlid, del_flag);
|
