2024年01月26日

/* --------------- 修改表 --------------- */
-- 修改表: device_device[设备-设备]
-- 添加字段:
ALTER TABLE device_device ADD COLUMN child_table_name VARCHAR(256);
COMMENT ON COLUMN device_device.child_table_name IS '子表名';
/* --------------- 修改表 --------------- */
-- 修改表: device_device_model[设备-设备型号]
-- 添加字段:
ALTER TABLE device_device_model ADD COLUMN child_table_name VARCHAR(256);
COMMENT ON COLUMN device_device_model.child_table_name IS '子表名';
/* --------------- 修改表 --------------- */
-- 修改表: snapshot_device_state_snap[快照-设备状态快照]
-- 索引重建
DROP INDEX IF EXISTS uq_snapshot_device_state_snap_1 ;
DROP INDEX IF EXISTS idx_snapshot_device_state_snap_1 ;
CREATE UNIQUE INDEX IF NOT EXISTS uq_snapshot_device_state_snap_1 ON snapshot_device_state_snap(device_id);
CREATE INDEX IF NOT EXISTS idx_snapshot_device_state_snap_1 ON snapshot_device_state_snap(device_id, delete_time, revision, tenant_id);
-- 添加字段:
ALTER TABLE snapshot_device_state_snap ADD COLUMN employee_id VARCHAR(32) NOT NULL;
COMMENT ON COLUMN snapshot_device_state_snap.employee_id IS '基础数据-雇员标识';
ALTER TABLE snapshot_device_state_snap ADD COLUMN data_acquisition_box_id VARCHAR(32);
COMMENT ON COLUMN snapshot_device_state_snap.data_acquisition_box_id IS '设备-采集盒标识';
ALTER TABLE snapshot_device_state_snap ADD COLUMN use_data_acquisition_box_port int4;
COMMENT ON COLUMN snapshot_device_state_snap.use_data_acquisition_box_port IS '使用-设备-采集盒-端口';
ALTER TABLE snapshot_device_state_snap ADD COLUMN uploding_file_percentage int4;
COMMENT ON COLUMN snapshot_device_state_snap.uploding_file_percentage IS '待上传文件百分比';
-- 删除字段:
ALTER TABLE snapshot_device_state_snap DROP COLUMN user_data;
ALTER TABLE snapshot_device_state_snap DROP COLUMN device_state;
/* --------------- 修改表 --------------- */
-- 修改表: history_device_state_hist[历史-设备状态历史]
-- 索引重建
DROP INDEX IF EXISTS idx_history_device_state_hist_1 ;
CREATE INDEX IF NOT EXISTS idx_history_device_state_hist_1 ON history_device_state_hist(device_id, created_time, delete_time, revision, tenant_id);
-- 添加字段:
ALTER TABLE history_device_state_hist ADD COLUMN employee_id VARCHAR(32) NOT NULL;
COMMENT ON COLUMN history_device_state_hist.employee_id IS '基础数据-雇员标识';
ALTER TABLE history_device_state_hist ADD COLUMN data_acquisition_box_id VARCHAR(32);
COMMENT ON COLUMN history_device_state_hist.data_acquisition_box_id IS '设备-采集盒标识';
ALTER TABLE history_device_state_hist ADD COLUMN use_data_acquisition_box_port int4;
COMMENT ON COLUMN history_device_state_hist.use_data_acquisition_box_port IS '使用-设备-采集盒-端口';
ALTER TABLE history_device_state_hist ADD COLUMN uploding_file_percentage int4;
COMMENT ON COLUMN history_device_state_hist.uploding_file_percentage IS '待上传文件百分比';
-- 删除字段:
ALTER TABLE history_device_state_hist DROP COLUMN user_data;
ALTER TABLE history_device_state_hist DROP COLUMN device_state;

 
/* --------------- 修改表 --------------- */
-- 修改表: device_nfc_card[设备-NFC卡]
-- 添加字段:
ALTER TABLE device_nfc_card ADD COLUMN data_ VARCHAR(1024);
COMMENT ON COLUMN device_nfc_card.data_ IS '数据';