山东日照项目数据迁移

– 初始化巡更数据同步信息

CREATE TABLE af_sync_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
create_by varchar(50) DEFAULT NULL COMMENT ‘创建人’,
create_time datetime DEFAULT NULL COMMENT ‘创建日期’,
update_by varchar(50) DEFAULT NULL COMMENT ‘更新人’,
update_time datetime DEFAULT NULL COMMENT ‘更新日期’,
del_flag varchar(1) DEFAULT NULL COMMENT ‘可用标识’,
data_id int(11) DEFAULT NULL COMMENT ‘已同步maxId’,
system varchar(32) DEFAULT NULL COMMENT ‘系统类型’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

---

– Records of af_sync_data

---

select top(1) ID from PatrolDB.dbo.DATAS order by ID DESC

INSERT INTO af_sync_data VALUES (‘1’, null, ‘2022-10-11 14:58:32’, null, ‘2022-10-11 15:57:18’, ‘0’, ‘3012’, ‘patrol’);

– 报警点迁移
select CONCAT(‘INSERT INTO af_alarm_point ( id, point_name, point_code, del_flag, company_id, point_type, fire_type, ip_device_id, emap_id, point_level, area_id) VALUES (’
,id,‘,
‘’’,ltrim(rtrim(name)),‘’‘,
‘’’,ltrim(rtrim(code)),‘’‘,
‘,0,’ ,
‘,company_id,’ ,
‘’’,ltrim(rtrim(type)),‘’‘,
‘’’,ltrim(rtrim(IFNULL(sub_type,‘’))),‘’',
‘,ip_device_id,’ ,
‘,emap_id,’,
‘,level,’,
‘,area_id,’
);
')
from tb_alarm_point

INSERT INTO anfang-rizhao.af_alarm_point (id, create_by, create_time, update_by, update_time, sys_org_code, company_id, del_flag, point_name, point_code, point_type, fire_type, ip_device_id, emap_id, point_level, area_id, remark, slave_id) VALUES (‘1229’, ‘admin’, NULL, ‘admin’, ‘2022-10-13 13:35:32’, ‘A02A01’, ‘1’, ‘0’, ‘门卫1出’, ‘8a8a930d7f910b20018044f1c2ad76af’, ‘ACCESS’, ‘’, ‘101’, ‘20’, ‘1’, ‘17’, ‘门禁-车闸’, NULL);
INSERT INTO anfang-rizhao.af_alarm_point (id, create_by, create_time, update_by, update_time, sys_org_code, company_id, del_flag, point_name, point_code, point_type, fire_type, ip_device_id, emap_id, point_level, area_id, remark, slave_id) VALUES (‘1230’, ‘admin’, NULL, ‘admin’, ‘2022-10-13 13:35:38’, ‘A02A01’, ‘1’, ‘0’, ‘门卫1入’, ‘8a8a930d7f910b20018044f25a8176b4’, ‘ACCESS’, ‘’, ‘102’, ‘20’, ‘1’, ‘17’, ‘门禁-车闸’, NULL);
INSERT INTO anfang-rizhao.af_alarm_point (id, create_by, create_time, update_by, update_time, sys_org_code, company_id, del_flag, point_name, point_code, point_type,