prod_group_bg/ems/sql/ems_init_data.sql

-- 区域初始数据
-- 服务区
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S3001', '0', '0', '常泰高速服务区(北区)', '常泰北区', '江苏省泰州市泰兴市虹桥镇常泰高速常州方向', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S3002', '0', '0', '常泰高速服务区(南区)', '常泰南区', '江苏省泰州市泰兴市虹桥镇常泰高速泰州方向', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S3003', '0', '0', '主路沿线', '主路', '主路沿线光伏', 3, 0);
-- 建筑
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300100', '321283124S3001', '0,321283124S3001', '北区本级', '北区', '北区', 0, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300101', '321283124S3001', '0,321283124S3001', '综合楼', '综合楼', '北区中部', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300102', '321283124S3001', '0,321283124S3001', '司机之家', '司机之家', '司机之家', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300103', '321283124S3001', '0,321283124S3001', '警务室', '警务室', '北区东北角', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300104', '321283124S3001', '0,321283124S3001', '北区广场', '北区广场', '北区广场', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300150', '321283124S3001', '0,321283124S3001', '北区光伏', '光伏', '北区光伏', 5, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300160', '321283124S3001', '0,321283124S3001', '北区储能', '储能', '北区储能', 6, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300170', '321283124S3001', '0,321283124S3001', '北区充电桩', '充电桩', '北区充电桩', 7, 0);


INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300200', '321283124S3002', '0,321283124S3002', '南区本级', '南区', '南区', 0, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300201', '321283124S3002', '0,321283124S3002', '综合楼', '综合楼', '南区中部', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300202', '321283124S3002', '0,321283124S3002', '司机之家', '司机之家', '南区西侧', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300203', '321283124S3002', '0,321283124S3002', '宿舍楼', '宿舍楼', '南区西南角', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300204', '321283124S3002', '0,321283124S3002', '南区广场', '南区广场', '南区广场', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300250', '321283124S3002', '0,321283124S3002', '南区光伏', '光伏', '南区', 5, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300260', '321283124S3002', '0,321283124S3002', '南区储能', '储能', '南区储能', 6, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S300270', '321283124S3002', '0,321283124S3002', '南区充电桩', '充电桩', '南区充电桩', 7, 0);

INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('S30K140-S30K150', '321283124S3003', '0,321283124S3003', '桩号段S30K140-S30K150', '桩号段S30K140-S30K150', '区段S30K140+300-S30K150+200', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('S30K150-S30K180', '321283124S3003', '0,321283124S3003', '桩号段S30K140-S30K150', '桩号段S30K140-S30K150', '区段S30K150+300-S30K180+300', 2, 0);

-- 区块
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010101', '321283124S300101', '0,321283124S3001,321283124S300101', '一楼', '一楼', '综合楼一楼', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010102', '321283124S300101', '0,321283124S3001,321283124S300101', '商铺', '商铺', '综合楼商铺', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010103', '321283124S300101', '0,321283124S3001,321283124S300101', '厨房', '厨房', '综合楼厨房', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010104', '321283124S300101', '0,321283124S3001,321283124S300101', '二楼', '二楼', '综合楼厨房', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10101', '321283124S30010101', '0,321283124S3001,321283124S300101,321283124S30010101', '卫生间', '卫生间', '卫生间', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10102', '321283124S30010101', '0,321283124S3001,321283124S300101,321283124S30010101', '开水间', '开水间', '开水间', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10103', '321283124S30010101', '0,321283124S3001,321283124S300101,321283124S30010101', '货车服务空间', '货车服务空间', '货车服务空间', 16, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10201', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '超市', '超市', '超市', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10202', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '特产市集', '特产市集', '特产市集', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10203', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '中餐厅', '中餐厅', '中餐厅', 5, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10204', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '德克士', '德克士', '德克士', 6, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10205', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '共和春面馆', '共和春面馆', '共和春面馆', 7, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10206', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '堂食餐饮', '堂食餐饮', '堂食餐饮', 8, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10207', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '传统小吃', '传统小吃', '传统小吃', 9, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10208', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '沪上阿姨', '沪上阿姨', '沪上阿姨', 10, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10209', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '微团生活馆', '微团生活馆', '微团生活馆', 11, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('B-10210', '321283124S30010102', '0,321283124S3001,321283124S300101,321283124S30010102', '服饰鞋帽', '服饰鞋帽', '服饰鞋帽', 12, 0);

INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010201', '321283124S300102', '0,321283124S3001,321283124S300102', '北区司机之家维修间', '司机之家维修间', '北区司机之家维修间', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30010202', '321283124S300102', '0,321283124S3001,321283124S300102', '北区司机之家二楼', '司机之家二楼', '北区司机之家二楼', 3, 0);

INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020101', '321283124S300201', '0,321283124S3002,321283124S300201', '一楼', '一楼', '综合楼一楼', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020102', '321283124S300201', '0,321283124S3002,321283124S300201', '商铺', '商铺', '综合楼商铺', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020103', '321283124S300201', '0,321283124S3002,321283124S300201', '厨房', '厨房', '综合楼厨房', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020104', '321283124S300201', '0,321283124S3002,321283124S300201', '二楼', '二楼', '综合楼厨房', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10101', '321283124S30020101', '0,321283124S3002,321283124S300201,321283124S30020101', '卫生间', '卫生间', '卫生间', 1, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10102', '321283124S30020101', '0,321283124S3002,321283124S300201,321283124S30020101', '开水间', '开水间', '开水间', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10103', '321283124S30020101', '0,321283124S3002,321283124S300201,321283124S30020101', '货车服务空间', '货车服务空间', '货车服务空间', 16, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10201', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '超市', '超市', '超市', 3, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10202', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '特产市集', '特产市集', '特产市集', 4, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10203', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '中餐厅', '中餐厅', '中餐厅', 5, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10204', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '德克士', '德克士', '德克士', 6, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10205', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '共和春面馆', '共和春面馆', '共和春面馆', 7, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10206', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '堂食餐饮', '堂食餐饮', '堂食餐饮', 8, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10207', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '传统小吃', '传统小吃', '传统小吃', 9, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10208', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '沪上阿姨', '沪上阿姨', '沪上阿姨', 10, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10209', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '微团生活馆', '微团生活馆', '微团生活馆', 11, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('N-10210', '321283124S30020102', '0,321283124S3002,321283124S300201,321283124S30020102', '服饰鞋帽', '服饰鞋帽', '服饰鞋帽', 12, 0);

INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020201', '321283124S300202', '0,321283124S3002,321283124S300202', '南区司机之家维修间', '南区司机之家维修间', '南区司机之家维修间', 2, 0);
INSERT INTO `adm_area` (`area_code`, `parent_code`, `ancestors`, `area_name`, `short_name`, `desc`, `order_num`, `status`) VALUES ('321283124S30020202', '321283124S300202', '0,321283124S3002,321283124S300202', '南区司机之家二楼', '南区司机之家二楼', '南区司机之家二楼', 3, 0);

-- 区域属性属性
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S3001', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 7250, 6000, NULL, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S3002', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 7250, 6000, NULL, 120.052389, 32.070408);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S3003', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, 120.051596, 32.071064);

INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300100', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 7250, 7250, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300101', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 4100, 4100, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300102', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 1000, 1000, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300103', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 2000, 2000, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300104', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 920, 920, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300150', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300160', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300170', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);


INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300200', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 7250, 7250, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300201', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 4100, 4100, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300202', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 1000, 1000, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300203', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 2000, 2000, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300204', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', 920, 920, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300250', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300260', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S300270', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('S30K140-S30K150', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('S30K150-S30K180', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, NULL, NULL, NULL);

INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020101', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020102', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020103', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020104', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10101', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10102', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10103', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10201', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10202', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10203', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10204', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10205', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10206', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10207', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10208', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10209', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('N-10210', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020201', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30020202', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);


INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010101', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010102', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010103', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010104', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10101', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10102', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10103', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10201', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10202', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10203', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10204', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10205', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10206', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10207', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10208', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10209', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('B-10210', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010201', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);
INSERT INTO `adm_area_attr` (`area_code`, `attr_org`, `mgr_org`, `leader`, `phone`, `open_date`, `floor_area`, `usable_area`, `floor`, `longitude`, `latitude`) VALUES ('321283124S30010202', '常泰大桥服务区', '润扬大桥投资管理有限公司', 'xxx', '13000000000', '2025-01-01', NULL, NULL, 1, 120.050937, 32.071956);


-- 能源设施初始数据
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('W201', '北区-供电网', 'W', 'W2', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('W202', '南区-供电网', 'W', 'W2', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('E501', '北区-光伏',   'E', 'E5', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('E502', '南区-光伏',   'E', 'E5', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('E503', '主路-光伏',   'E', 'E5', 1, '321283124S3003');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('C101', '北区-储能',   'C', 'C1', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('C102', '南区-储能',   'C', 'C1', 1, '321283124S3002');

INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-ZM-01', '北区-照明设施',   'Z', 'Z010', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-ZM-02', '南区-照明设施',   'Z', 'Z010', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-KT-01', '北区-暖通设施',   'Z', 'Z020', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-KT-02', '南区-暖通设施',   'Z', 'Z020', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-AF-01', '北区-安防设施',   'Z', 'Z030', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-AF-02', '南区-安防设施',   'Z', 'Z030', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-FW-01', '北区-服务设施',   'Z', 'Z040', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-FW-02', '南区-服务设施',   'Z', 'Z040', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-QT-01', '北区-其他设施',   'Z', 'Z999', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Z-QT-02', '南区-其他设施',   'Z', 'Z999', 1, '321283124S3002');


INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('NH01', '北区-能耗监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('NH02', '南区-能耗监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('GCC01', '北区-光储充监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('GCC02', '南区-光储充监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Charge01', '北区-充电桩监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('Charge02', '南区-充电桩监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('ZHZM01', '北区-照明监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('ZHZM02', '南区-照明监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('ZHHM01', '北区-海绵监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('ZHHM02', '南区-海绵监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('LG01', '北区-垃圾厨余监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('LG02', '南区-垃圾厨余监测', 'W', 'W4', 1, '321283124S3002');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('DEV01', '北区-设备监测', 'W', 'W4', 1, '321283124S3001');
INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_category`, `facs_subcategory`, `enable`, `ref_area`) VALUES ('DEV02', '南区-设备监测', 'W', 'W4', 1, '321283124S3002');

-- 能源设备
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-2003', '北区能耗采集器C', '-', '-', '1', '综合楼', '321283124S300101', '321283124S3001', 'M_W2_SM_INDOOR_ENERGY', 'NH01', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-2004', '北区能耗采集器D', '-', '-', '1', '综合楼', '321283124S300101', '321283124S3001', 'M_W2_SM_INDOOR_ENERGY', 'NH01', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-2005', '北区汽修间能耗采集器', '-', '-', '1', '司机之家', '321283124S300102', '321283124S3001', 'M_W2_SM_INDOOR_ENERGY', 'NH01', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-2006', '北区警务室能耗采集器', '-', '-', '1', '警务室', '321283124S300103', '321283124S3001', 'M_W2_SM_INDOOR_ENERGY', 'NH01', 'SM', 'SYS_NHJC');

INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-1003', '南区能耗采集器C', '-', '-', '1', '综合楼', '321283124S300201', '321283124S3002', 'M_W2_SM_INDOOR_ENERGY', 'NH02', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-1004', '南区能耗采集器D', '-', '-', '1', '综合楼', '321283124S300201', '321283124S3002', 'M_W2_SM_INDOOR_ENERGY', 'NH02', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-1005', '南区汽修间能耗采集器', '-', '-', '1', '司机之家', '321283124S300202', '321283124S3002', 'M_W2_SM_INDOOR_ENERGY', 'NH02', 'SM', 'SYS_NHJC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'ID-E-C-1007', '南区宿舍能耗采集器', '-', '-', '1', '宿舍', '321283124S300203', '321283124S3002', 'M_W2_SM_INDOOR_ENERGY', 'NH02', 'SM', 'SYS_NHJC');

-- mock设备
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-001', '光储设备1',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'C101', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-002', '光储设备2',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'C101', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-003', '光储设备3',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'C101', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-004', '光储设备4',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'C101', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-005', '光储设备5',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'C102', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-006', '光储设备6',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'C102', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-007', '光储设备7',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'C102', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('GCZR-008', '光储设备8',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'C102', NULL, 'SYS_GCC');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-B-EVSE-10001', '1号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-FW-01', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-B-EVSE-10002', '2号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-FW-01', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-B-EVSE-10003', '3号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-FW-01', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-B-EVSE-10004', '4号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-FW-01', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-N-EVSE-20001', '1号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-FW-02', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-N-EVSE-20002', '2号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-FW-02', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-N-EVSE-20003', '3号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-FW-02', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('D-N-EVSE-20004', '4号充电桩',    '特来电', 'TCDZ-DCO.7', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-FW-02', 'DC-EVSE', 'SYS_CD');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('ZHZM-01', '照明01',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-ZM-01', NULL, 'SYS_ZHZM');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('ZHZM-02', '照明02',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-ZM-02', NULL, 'SYS_ZHZM');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('ZHHM-01', '海绵设备1',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-QT-01', NULL, 'SYS_ZHHM');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('ZHHM-02', '海绵设备2',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-QT-02', NULL, 'SYS_ZHHM');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('LGCY-01', '厨余垃圾设备1',    'xxx', 'xxx', 1, '北区广场', '321283124S300104', '321283124S3001',  'test', 'Z-QT-01', NULL, 'SYS_LG');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ('LGCY-02', '厨余垃圾设备2',    'xxx', 'xxx', 1, '南区广场', '321283124S300204', '321283124S3002',  'test', 'Z-QT-02', NULL, 'SYS_LG');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( '321283124S3001_99-ZHLD-001', '光伏板1','Canadian Solar', 'x1', '1', null, '321283124S300150', '321283124S3001', 'test', 'E501', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( '321283124S3001_99-CPD-001', '光伏板2', 'Canadian Solar', 'x1', '1', null, '321283124S300150', '321283124S3001', 'test', 'E501', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( '321283124S3002_99-ZHLD-001', '光伏板3','Canadian Solar', 'x1', '1', null, '321283124S300250', '321283124S3002', 'test', 'E502', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( '321283124S3002_99-CPD-001', '光伏板4', 'Canadian Solar', 'x1', '1', null, '321283124S300250', '321283124S3002', 'test', 'E502', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'E503-K140-K150-001', '光伏板5',        'Canadian Solar', 'x1', '1', null, 'S30K140-S30K150', '321283124S3003', 'test', 'E503', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'E503-K140-K150-002', '光伏板6',        'Canadian Solar', 'x1', '1', null, 'S30K140-S30K150', '321283124S3003', 'test', 'E503', null, 'SYS_GF');
INSERT INTO `adm_ems_device` (`device_code`, `device_name`, `device_brand`, `device_spec`, `device_status`, `location`, `location_ref`, `area_code`, `device_model`, `ref_facs`, `ps_code`, `subsystem_code`) VALUES ( 'E503-K140-K150-003', '光伏板7',        'Canadian Solar', 'x1', '1', null, 'S30K150-S30K180', '321283124S3003', 'test', 'E503', null, 'SYS_GF');


-- 策略初始数据
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3001', 'CL_YW_01', '北区-默认策略', 1, 1, '默认执行', 0, NULL);
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3002', 'CL_YW_02', '南区-默认策略', 1, 1, '默认执行', 0, NULL);
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3001', 'CL_YH_01', '北区-默认策略', 2, 1, '默认执行', 0, NULL);
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3002', 'CL_YH_02', '南区-默认策略', 2, 1, '默认执行', 0, NULL);
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3001', 'CL_WC_01', '北区-默认策略', 3, 1, '默认执行', 0, NULL);
INSERT INTO `adm_op_energy_strategy` (`area_code`, `strategy_code`, `strategy_name`, `strategy_type`, `strategy_state`, `strategy_desc`, `exec_mode`, `exec_rule`) VALUES ('321283124S3002', 'CL_WC_02', '南区-默认策略', 3, 1, '默认执行', 0, NULL);

-- 策略参数数据
-- 源网 控制模式：
-- default.controlMode [{"code":"maxPowerTrack", "name":"最大功率点跟踪（MPPT）", "desc":"通过实时调整光伏阵列的工作状态，使光伏系统始终运行在最大功率点"},{"code":"inverterControl", "name":"逆变器控制", "desc":"通过光伏逆变器实施控制"},{"code":"powerAndVoltage", "name":"无功功率及电压控制", "desc":"根据电网需求，通过调节光伏系统输出的无功功率和电压，实现电压稳定和电力因素的优化"}]
-- 源网 控制模式 逆变器控制 策略
-- inverterControl.inverterControl：[{"code":"svpwm", "name":"空间矢量控制（SVPWM）", "desc":"通过对逆变器开关状态的优化控制，实现并网电流的高精度控制"},{"code":"dtc", "name":"直流转矩控制", "desc":"以控制逆变器输出转矩和磁链为目标，快速响应"}]

INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_01', 'default', 'controlMode', '控制模式', 'maxPowerTrack', 'enum', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_01', 'inverterControl', 'controlMode', '逆变器控制策略', null, 'enum', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_01', 'powerAndVoltage', 'reactivePower', '无功功率', null, 'text', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_01', 'powerAndVoltage', 'voltage', '电压', null, 'text', 1);

INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_02', 'default', 'controlMode', '控制模式', 'maxPowerTrack', 'enum', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_02', 'inverterControl', 'controlMode', '逆变器控制策略', null, 'enum', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_02', 'powerAndVoltage', 'reactivePower', '无功功率', null, 'text', 1);
INSERT INTO `adm_op_energy_strategy_param` (`strategy_code`, `param_group`, `param_key`, `param_name`, `param_value`, `param_value_format`, `edit_enable`) VALUES ('CL_YW_02', 'powerAndVoltage', 'voltage', '电压', null, 'text', 1);


-- 对象模型表
INSERT INTO `adm_ems_obj_model` (`model_code`, `model_name`, `obj_type`, `ability_handler`, `event_handler`) VALUES ('M_W2_SM_INDOOR_ENERGY', '室内能耗计量终端', 2, 'http://172.17.60.27:9203/ems-dev-adapter/in-door-energy/ct/abilityCall', NULL);
INSERT INTO `adm_ems_obj_model` (`model_code`, `model_name`, `obj_type`, `ability_handler`, `event_handler`) VALUES ('M_W2_QF_GEEKOPEN', 'GeekOpen断路器', 2, 'http://172.17.60.27:9203/ems-dev-adapter/circuit-breaker/GeekOpen/abilityCall', NULL);
INSERT INTO `adm_ems_obj_model` (`model_code`, `model_name`, `obj_type`, `ability_handler`, `event_handler`) VALUES ('M_W2_QS_KEKA_86', 'KEKA开关（86型）', 2, 'http://172.17.60.27:9203/ems-dev-adapter/button-switch/keka/86ButtonSwitchCall', NULL);

-- 对象属性数据
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Base', 'ip', '网络地址', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Base', 'gateway', '网关地址', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Base', 'subnetMask', '子网掩码', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Measure', 'interface1', 'D1口通道', NULL, 'Table');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Measure', 'interface2', 'D2口通道', NULL, 'Table');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Measure', 'interface3', 'D3口通道', NULL, 'Table');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'Measure', 'interface4', 'D4口通道', NULL, 'Table');

INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Base', 'version', '固件版本号', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Base', 'iccid', '物联网卡ICCID号', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Base', 'imei', '设备imei', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'timerEnable', '上报定时开关', '', 'Enum');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'timerInterval', '上报时间间隔', '秒（S）', 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'signal', '信号强度', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'keyLock', '状态-按键锁定', NULL, 'Enum');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'key', '状态-通断', NULL, 'Enum');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'resetLock', '重置锁', NULL, 'Enum');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'State', 'onState', '设备上电的默认状态', '1', 'Enum');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Measure', 'power', '实时功率', '瓦（W）', 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Measure', 'voltage', '实时电压', '伏特（V）', 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Measure', 'current', '实时电流', '安培（A）', 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Measure', 'energy', '累计电量值', '千瓦时（kW·h）', 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'protocol', '协议', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'server', 'MQTT地址', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'port', 'MQTT端口', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'clientId', '设备ID', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'username', '用户名', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'subcribe', '订阅主题', NULL, 'Value');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QF_GEEKOPEN', 'Protocol', 'publish', '发布主题', NULL, 'Value');

INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Base', 'gatewayId', '网关编号', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Protocol', 'protocol', '协议', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Protocol', 'server', 'MQTT地址', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Protocol', 'port', 'MQTT端口', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Protocol', 'publish', '发布主题', NULL, 'String');
INSERT INTO `adm_ems_obj_attr` (`model_code`, `attr_group`, `attr_key`, `attr_name`, `attr_unit`, `attr_value_type`) VALUES ('M_W2_QS_KEKA_86', 'Protocol', 'subcribe', '订阅主题', NULL, 'String');

-- 对象属性
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.175', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（电表）北区综合楼ALZ","key":"C_2003_AV_0000","value":null,"updateTime":null},{"name":"（电表）北区综合楼AKZ","key":"C_2003_AV_0001","value":null,"updateTime":null},{"name":"（电表）北区综合楼APXF2","key":"C_2003_AV_0002","value":null,"updateTime":null},{"name":"（电表）北区综合楼APXF1","key":"C_2003_AV_0003","value":null,"updateTime":null},{"name":"（电表）北区综合楼APJK","key":"C_2003_AV_0005","value":null,"updateTime":null},{"name":"（电表）北区综合楼APsbjf","key":"C_2003_AV_0006","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'interface2', '[{"name":"（电表）德克士","key":"C_2003_AV_0206","value":null,"updateTime":null},{"name":"（电表）微团生活馆","key":"C_2003_AV_0214","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0222","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0230","value":null,"updateTime":null},{"name":"（电表）沪上阿姨（奶茶）","key":"C_2003_AV_0238","value":null,"updateTime":null},{"name":"（电表）服饰鞋帽（服饰）","key":"C_2003_AV_0246","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0254","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0262","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0270","value":null,"updateTime":null},{"name":"（电表）传统小吃（小吃）","key":"C_2003_AV_0278","value":null,"updateTime":null},{"name":"（电表）美广","key":"C_2003_AV_0286","value":null,"updateTime":null},{"name":"（电表）共和春（面馆）","key":"C_2003_AV_0294","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0302","value":null,"updateTime":null},{"name":"（电表）特产市集（特产）","key":"C_2003_AV_0310","value":null,"updateTime":null},{"name":"（电表）超市","key":"C_2003_AV_0318","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0326","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0334","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0342","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_2003_AV_0350","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）厨房配电","key":"C_2003_AV_0406","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2003', 'M_W2_SM_INDOOR_ENERGY', 'interface4', '[{"name":"（电表）北区综合楼APDT","key":"C_2003_AV_0600","value":null,"updateTime":null},{"name":"（电表）北区综合楼2APDP","key":"C_2003_AV_0601","value":null,"updateTime":null},{"name":"（电表）北区综合楼APKT1","key":"C_2003_AV_0603","value":null,"updateTime":null},{"name":"（电表）北区综合楼APKT2","key":"C_2003_AV_0604","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2004', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.176', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2004', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2004', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2004', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（水表）货车服务空间","key":"C_2004_AV_0000","value":null,"updateTime":null},{"name":"（水表）沪上阿姨","key":"C_2004_AV_0001","value":null,"updateTime":null},{"name":"（水表）微团生活馆","key":"C_2004_AV_0002","value":null,"updateTime":null},{"name":"（水表）服饰鞋帽","key":"C_2004_AV_0003","value":null,"updateTime":null},{"name":"（水表）卫生间","key":"C_2004_AV_0004","value":null,"updateTime":null},{"name":"（水表）开水间","key":"C_2004_AV_0005","value":null,"updateTime":null},{"name":"（水表）超市","key":"C_2004_AV_0006","value":null,"updateTime":null},{"name":"（水表）特产市集","key":"C_2004_AV_0007","value":null,"updateTime":null},{"name":"（水表）堂食餐饮","key":"C_2004_AV_0008","value":null,"updateTime":null},{"name":"（水表）传统小吃","key":"C_2004_AV_0009","value":null,"updateTime":null},{"name":"（水表）德克士","key":"C_2004_AV_0010","value":null,"updateTime":null},{"name":"（水表）共和春面馆","key":"C_2004_AV_0011","value":null,"updateTime":null},{"name":"（水表）中餐厅","key":"C_2004_AV_0012","value":null,"updateTime":null},{"name":"（水表）二楼","key":"C_2004_AV_0200","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2004', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）北区综合楼APXK 消控室","key":"C_2004_AV_0400","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.177', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'interface2', '[{"name":"（电表）北区司机之家维修间ALWX","key":"C_2005_AV_0200","value":null,"updateTime":null},{"name":"（电表）北区司机之家维修间ALE","key":"C_2005_AV_0201","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）北区司机之家维修间ALZ","key":"C_2005_AV_0400","value":null,"updateTime":null},{"name":"（电表）北区司机之家维修间ALSS","key":"C_2005_AV_0401","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2005', 'M_W2_SM_INDOOR_ENERGY', 'interface4', '[{"name":"（水表）司机之家","key":"C_2005_AV_0600","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2006', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.178', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2006', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2006', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-2006', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（电表）警务室AL","key":"C_2006_AV_0000","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.162', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（电表）南区综合楼ALZ","key":"C_1003_AV_0000","value":null,"updateTime":null},{"name":"（电表）南区综合楼AKZ","key":"C_1003_AV_0001","value":null,"updateTime":null},{"name":"（电表）南区综合楼APXF2","key":"C_1003_AV_0002","value":null,"updateTime":null},{"name":"（电表）南区综合楼APXF1","key":"C_1003_AV_0003","value":null,"updateTime":null},{"name":"（电表）南区综合楼APJF","key":"C_1003_AV_0004","value":null,"updateTime":null},{"name":"（电表）南区综合楼APJK","key":"C_1003_AV_0005","value":null,"updateTime":null},{"name":"（电表）南区综合楼APsbjf","key":"C_1003_AV_0006","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'interface2', '[{"name":"（电表）德克士","key":"C_1003_AV_0206","value":null,"updateTime":null},{"name":"（电表）微团生活馆","key":"C_1003_AV_0214","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0222","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0230","value":null,"updateTime":null},{"name":"（电表）沪上阿姨（奶茶）","key":"C_1003_AV_0238","value":null,"updateTime":null},{"name":"（电表）服饰鞋帽（服饰）","key":"C_1003_AV_0246","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0254","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0262","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0270","value":null,"updateTime":null},{"name":"（电表）传统小吃（小吃）","key":"C_1003_AV_0278","value":null,"updateTime":null},{"name":"（电表）美广","key":"C_1003_AV_0286","value":null,"updateTime":null},{"name":"（电表）共和春（面馆）","key":"C_1003_AV_0294","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0302","value":null,"updateTime":null},{"name":"（电表）特产市集（特产）","key":"C_1003_AV_0310","value":null,"updateTime":null},{"name":"（电表）超市","key":"C_1003_AV_0318","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0326","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0334","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0342","value":null,"updateTime":null},{"name":"（电表）备用","key":"C_1003_AV_0350","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）厨房配电","key":"C_1003_AV_0406","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1003', 'M_W2_SM_INDOOR_ENERGY', 'interface4', '[{"name":"（电表）南区综合楼APDT","key":"C_1003_AV_0600","value":null,"updateTime":null},{"name":"（电表）南区综合楼2APDP","key":"C_1003_AV_0601","value":null,"updateTime":null},{"name":"（电表）南区综合楼2ALZt","key":"C_1003_AV_0602","value":null,"updateTime":null},{"name":"（电表）南区综合楼APKT1","key":"C_1003_AV_0603","value":null,"updateTime":null},{"name":"（电表）南区综合楼APKT2","key":"C_1003_AV_0604","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1004', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.163', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1004', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1004', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1004', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（水表）货车服务空间","key":"C_1004_AV_0000","value":null,"updateTime":null},{"name":"（水表）沪上阿姨","key":"C_1004_AV_0001","value":null,"updateTime":null},{"name":"（水表）微团生活馆","key":"C_1004_AV_0002","value":null,"updateTime":null},{"name":"（水表）服饰鞋帽","key":"C_1004_AV_0003","value":null,"updateTime":null},{"name":"（水表）卫生间","key":"C_1004_AV_0004","value":null,"updateTime":null},{"name":"（水表）开水间","key":"C_1004_AV_0005","value":null,"updateTime":null},{"name":"（水表）超市","key":"C_1004_AV_0006","value":null,"updateTime":null},{"name":"（水表）特产市集","key":"C_1004_AV_0007","value":null,"updateTime":null},{"name":"（水表）堂食餐饮","key":"C_1004_AV_0008","value":null,"updateTime":null},{"name":"（水表）传统小吃","key":"C_1004_AV_0009","value":null,"updateTime":null},{"name":"（水表）德克士","key":"C_1004_AV_0010","value":null,"updateTime":null},{"name":"（水表）共和春面馆","key":"C_1004_AV_0011","value":null,"updateTime":null},{"name":"（水表）中餐厅","key":"C_1004_AV_0012","value":null,"updateTime":null},{"name":"（水表）二楼","key":"C_1004_AV_0200","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1004', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）南区综合楼APXK 消控室","key":"C_1004_AV_0400","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.164', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（电表）南区司机之家维修间ALZ","key":"C_1005_AV_0000","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'interface2', '[{"name":"（电表）南区司机之家维修间ALWX","key":"C_1005_AV_0200","value":null,"updateTime":null},{"name":"（电表）南区司机之家维修间ALE","key":"C_1005_AV_0201","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'interface3', '[{"name":"（电表）南区司机之家维修间ALSS","key":"C_1005_AV_0400","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1005', 'M_W2_SM_INDOOR_ENERGY', 'interface4', '[{"name":"（水表）司机之家","key":"C_1005_AV_0600","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1007', 'M_W2_SM_INDOOR_ENERGY', 'ip', '172.17.50.166', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1007', 'M_W2_SM_INDOOR_ENERGY', 'gateway', '172.17.50.254', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1007', 'M_W2_SM_INDOOR_ENERGY', 'subnetMask', '255.255.255.0', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1007', 'M_W2_SM_INDOOR_ENERGY', 'interface1', '[{"name":"（电表）南区宿舍ALZ","key":"C_1007_AV_0000","value":null,"updateTime":null}]', NULL);
INSERT INTO `adm_ems_obj_attr_value` (`obj_code`, `model_code`, `attr_key`, `attr_value`, `update_time`) VALUES ('ID-E-C-1007', 'M_W2_SM_INDOOR_ENERGY', 'interface2', '[{"name":"（电表）南区宿舍ALE","key":"C_1007_AV_0200","value":null,"updateTime":null}]', NULL);

-- 对象能力DEMO数据
INSERT INTO `adm_ems_obj_ability` (`model_code`, `ability_key`, `ability_name`, `ability_desc`, `ability_param`, `hidden_flag`) VALUES ('M_W2_SM_INDOOR_ENERGY', 'MeterReadingGw', '实时抄报-网关', '网关-测点批量抄报', null, 1);

-- 能源设施能流关系DEMO数据
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('W201', 1, 'Z101', 1, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('E501', 1, 'W201', 1, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('E501', 1, 'Z101', 1, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-B-T-1001', 2, 'D-B-AP-10001', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-B-T-1001', 2, 'D-B-AP-10002', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-N-T-1002', 2, 'D-N-AP-10001', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-N-T-1002', 2, 'D-N-AP-10002', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-B-AP-10001', 2, 'D-B-AP-10001-QR_00', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-B-AP-10001', 2, 'D-B-AP-10001-QF_01', 2, '45', '供电');
INSERT INTO `adm_ems_flow_rel` (`export_obj`, `export_obj_type`, `input_obj`, `input_obj_type`, `ems_cls`, `flow_desc`) VALUES ('D-B-AP-10001', 2, 'D-B-AP-10001-QF_02', 2, '45', '供电');

-- 区域&标签关系表
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-102', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10201', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10202', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10203', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10204', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10205', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10206', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10207', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10208', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10209', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('B-10210', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('321283124S300102', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-102', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10201', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10202', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10203', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10204', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10205', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10206', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10207', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10208', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10209', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('N-10210', 1, 'Area_01');
insert into adm_obj_tag_rel (`obj_code`, `obj_type`, `tag_code`) VALUES ('321283124S300202', 1, 'Area_01');


-- 服务区用电属性数据
INSERT INTO adm_area_elec_attr (`area_code`, `price_code`, `req_capacity_flag`, `trans_capacity`, `req_quantity`) VALUES ('321283124S3001', '4001', 1, 630, NULL);
INSERT INTO adm_area_elec_attr (`area_code`, `price_code`, `req_capacity_flag`, `trans_capacity`, `req_quantity`) VALUES ('321283124S3002', '4001', 1, 630, NULL);

-- 两部制初始电价数据
INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `op_price`, `cp_price`, `p_price`, `v_Price`, `dv_Price`, `max_req_price`, `trans_capacity_price`) VALUES ('4001', 4, '1-10(20)千伏', 0.6587,NULL,1.05392, 0.428155,  NULL, 51.2, 32);


-- 峰谷电价策略数据
-- 默认策略
INSERT INTO adm_elecprice_strategy (`strategy_code`, `strategy_name`, `strategy_desc`, `support_type`, `exec_month`, `exec_date_type`, `exec_date`, `priority`, `edit_flag`) VALUES ('-1', '默认策略', '0:00-24:00 执行平段电价', '0', '01,02,03,04,05,06,07,08,09,10,11,12',2, null, 0, 0);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('-1', '00:00:00', '23:59:59', 0);

-- 默认策略
INSERT INTO adm_elecprice_strategy (`strategy_code`, `strategy_name`, `strategy_desc`, `support_type`, `exec_month`, `exec_date_type`, `exec_date`, `priority`, `edit_flag`) VALUES ('1001', '春秋两季峰谷', '3-5月，9-11月', '-1,0,1', '03,04,05,09,10,11', 2, null, 1, 1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '00:00:00', '01:59:59', 0);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '02:00:00', '05:59:59', -1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '06:00:00', '09:59:59', 0);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '10:00:00', '13:59:59', -1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '14:00:00', '14:59:59', -1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '15:00:00', '21:59:59', 1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '22:00:00', '23:59:59', 1);


INSERT INTO adm_elecprice_strategy (`strategy_code`, `strategy_name`, `strategy_desc`, `support_type`, `exec_month`, `exec_date_type`, `exec_date`, `priority`, `edit_flag`) VALUES ('1002', '夏冬两季峰谷', '1-2月，6-8月，12月', '-1,0,1', '01,02,06,07,08,12', 2, null, 1, 1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '00:00:00', '05:59:59', -1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '06:00:00', '10:59:59', 0);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '11:00:00', '12:59:59', -1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '13:00:00', '13:59:59', 0);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '14:00:00', '21:59:59', 1);
INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1002', '22:00:00', '23:59:59', 0);



-- 非电能源价格
INSERT INTO `adm_fd_energyprice_config` (`cfg_code`, `area_code`, `meter_cls`, `unit_price`, `meter_unit`) VALUES ('0000', '-1', 70, 4.1, '吨');
INSERT INTO `adm_fd_energyprice_config` (`cfg_code`, `area_code`, `meter_cls`, `unit_price`, `meter_unit`) VALUES ('0001', '321283124S3001', 70, 4.1, '吨');
INSERT INTO `adm_fd_energyprice_config` (`cfg_code`, `area_code`, `meter_cls`, `unit_price`, `meter_unit`) VALUES ('0002', '321283124S3002', 70, 4.1, '吨');

-- 商户能源计费策略
INSERT INTO adm_co_charging_config (`area_code`, `elec_unit_price`, `elec_gt_compute_type`, `elec_compute_desc`, `water_unit_price`, `water_gt_compute_type`, `water_compute_desc`) VALUES ('321283124S3001', 0.6068, 1, '1.按户数均摊\n公摊电费每户收费 = 公摊电费 / 户数\n2、按面积分摊\n单户公摊电费 = 公摊电费 * (单户面积 / 总面积)', 3.04, 0, NULL);
INSERT INTO adm_co_charging_config (`area_code`, `elec_unit_price`, `elec_gt_compute_type`, `elec_compute_desc`, `water_unit_price`, `water_gt_compute_type`, `water_compute_desc`) VALUES ('321283124S3002', 0.6068, 1, '1.按户数均摊\n公摊电费每户收费 = 公摊电费 / 户数\n2、按面积分摊\n单户公摊电费 = 公摊电费 * (单户面积 / 总面积)', 3.04, 0, NULL);

-- 子系统DEMO数据
INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_GF', '光伏系统', '光伏', '南通', '张', '1380000', '李工', '123123', NULL);
INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_CN', '储能系统', '储能', '储能厂商', '王', '122112', '陈', '21212', NULL);
INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_BA', 'BA', '楼控', '楼控', '李', '12', '王', '121', NULL);
INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_CD', '充电桩系统', '充电桩', '特来电', '张三', '1212121121', '刘工', '1212221111', NULL);
INSERT INTO adm_ems_subsystem (system_code, system_name, short_name, man_facturer, contact_person, contact_number,
                               maintainer_person, maintainer_number, descr)
VALUES ('SYS_GCC', '光储充系统', '光储充', '光储充厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_GCZR', '光储直柔系统', '光储直柔', '光储直柔厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_Charge', '充电桩系统', '充电桩', '充电桩厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_ZHZM', '智慧照明系统', '智慧照明', '智慧照明厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_ZHHM', '智慧海绵系统', '智慧海绵', '智慧海绵厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_LG', '垃圾厨余系统', '垃圾厨余', '垃圾厨余厂商', '张三', '1212121121', '刘工', '1212221111', NULL),
       ('SYS_NHJC', '能耗监测系统', '能耗监测', '能耗监测厂商', '张三', '1212121121', '刘工', '1212221111', NULL);

-- 北区电表
-- 综合楼电表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0000','M_W2_SM_INDOOR_ENERGY', '北区综合楼ALZ',       '321283124S30010101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0001','M_W2_SM_INDOOR_ENERGY', '北区综合楼AKZ',       '321283124S30010101', '一楼强电间', 45, 0, 300, 0, 1, '线接上之后北区综合楼APJK不通');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0002','M_W2_SM_INDOOR_ENERGY', '北区综合楼APXF2',     '321283124S30010101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0003','M_W2_SM_INDOOR_ENERGY', '北区综合楼APXF1',     '321283124S30010101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0005','M_W2_SM_INDOOR_ENERGY', '北区综合楼APJK',      '321283124S30010101', '一楼监控室', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0006','M_W2_SM_INDOOR_ENERGY', '北区综合楼APsbjf',    '321283124S30010101', '一楼地下室', 45, 0, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0206','M_W2_SM_INDOOR_ENERGY', '德克士',             '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0214','M_W2_SM_INDOOR_ENERGY', '微团生活馆',          '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0222','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0230','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0238','M_W2_SM_INDOOR_ENERGY', '沪上阿姨（奶茶）',     '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0246','M_W2_SM_INDOOR_ENERGY', '服饰鞋帽（服饰）',     '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0254','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0262','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0270','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30010102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0278','M_W2_SM_INDOOR_ENERGY', '传统小吃（小吃）',      '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0286','M_W2_SM_INDOOR_ENERGY', '美广',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0294','M_W2_SM_INDOOR_ENERGY', '共和春（面馆）',        '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0302','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0310','M_W2_SM_INDOOR_ENERGY', '特产市集（特产）',      '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0318','M_W2_SM_INDOOR_ENERGY', '超市',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0326','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0334','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0342','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0350','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30010102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0406','M_W2_SM_INDOOR_ENERGY', '厨房配电',            '321283124S30010103', '配电箱-APCF',   45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0600','M_W2_SM_INDOOR_ENERGY', '北区综合楼APDT',      '321283124S30010104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0601','M_W2_SM_INDOOR_ENERGY', '北区综合楼2APDP',     '321283124S30010104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0603','M_W2_SM_INDOOR_ENERGY', '北区综合楼APKT1',     '321283124S30010104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2003_AV_0604','M_W2_SM_INDOOR_ENERGY', '北区综合楼APKT2',     '321283124S30010104', '二楼强电间',     45, 0, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0400','M_W2_SM_INDOOR_ENERGY', '北区综合楼APXK',      '321283124S30010101', '消控室',   45, 0, 300, 0, 1, null);

-- 北区司机之家电表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2005_AV_0200','M_W2_SM_INDOOR_ENERGY', '北区司机之家维修间ALWX', '321283124S30010201', '一楼强电间',   45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2005_AV_0201','M_W2_SM_INDOOR_ENERGY', '北区司机之家维修间ALE',  '321283124S30010201', '一楼强电间',   45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2005_AV_0400','M_W2_SM_INDOOR_ENERGY', '北区司机之家维修间ALZ',  '321283124S30010201', '一楼强电间',   45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2005_AV_0401','M_W2_SM_INDOOR_ENERGY', '北区司机之家维修间ALSS', '321283124S30010202', '二楼强电间',   45, 1, 300, 0, 1, null);

-- 北区警务室
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2006_AV_0000','M_W2_SM_INDOOR_ENERGY', '警务室AL', '321283124S300103', '一楼强电间',   45, 0, 300, 0, 1, null);

-- 北区水表
-- 北综合楼水表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0000','M_W2_SM_INDOOR_ENERGY', '货车服务空间', '321283124S30010101', '货车服务空间',   70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0001','M_W2_SM_INDOOR_ENERGY', '沪上阿姨',    '321283124S30010102', '沪上阿姨',      70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0002','M_W2_SM_INDOOR_ENERGY', '微团生活馆',   '321283124S30010102', '微团生活馆',    70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0003','M_W2_SM_INDOOR_ENERGY', '服饰鞋帽',     '321283124S30010102', '服饰鞋帽',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0004','M_W2_SM_INDOOR_ENERGY', '卫生间',       '321283124S30010101', '卫生间',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0005','M_W2_SM_INDOOR_ENERGY', '开水间',       '321283124S30010101', '开水间',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0006','M_W2_SM_INDOOR_ENERGY', '超市',         '321283124S30010102', '超市',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0007','M_W2_SM_INDOOR_ENERGY', '特产市集',     '321283124S30010102', '特产市集',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0008','M_W2_SM_INDOOR_ENERGY', '堂食餐饮',     '321283124S30010102', '堂食餐饮',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0009','M_W2_SM_INDOOR_ENERGY', '传统小吃',     '321283124S30010102', '传统小吃',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0010','M_W2_SM_INDOOR_ENERGY', '德克士',       '321283124S30010102', '德克士',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0011','M_W2_SM_INDOOR_ENERGY', '共和春面馆',    '321283124S30010102', '共和春面馆',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0012','M_W2_SM_INDOOR_ENERGY', '中餐厅',       '321283124S30010102', '中餐厅',     70, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2004_AV_0200','M_W2_SM_INDOOR_ENERGY', '二楼',       '321283124S30010102', '二楼',     70, 0, 300, 0, 1, null);

-- 司机之家水表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'C_2005_AV_0600','M_W2_SM_INDOOR_ENERGY', '北区司机之家维修间ALSS', '321283124S300102', '司机之家',   70, 0, 300, 0, 1, null);

-- 南区电表
-- 综合楼
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0000','M_W2_SM_INDOOR_ENERGY', '南区综合楼ALZ',       '321283124S30020101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0001','M_W2_SM_INDOOR_ENERGY', '南区综合楼AKZ',       '321283124S30020101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0002','M_W2_SM_INDOOR_ENERGY', '南区综合楼APXF2',     '321283124S30020101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0003','M_W2_SM_INDOOR_ENERGY', '南区综合楼APXF1',     '321283124S30020101', '一楼强电间', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0004','M_W2_SM_INDOOR_ENERGY', '南区综合楼APJF',      '321283124S30020101', '一楼机房',  45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0005','M_W2_SM_INDOOR_ENERGY', '南区综合楼APJK',      '321283124S30020101', '一楼监控室', 45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0006','M_W2_SM_INDOOR_ENERGY', '南区综合楼APsbjf',    '321283124S30020101', '一楼地下室', 45, 0, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0206','M_W2_SM_INDOOR_ENERGY', '德克士',             '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0214','M_W2_SM_INDOOR_ENERGY', '微团生活馆',          '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0222','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0230','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0238','M_W2_SM_INDOOR_ENERGY', '沪上阿姨（奶茶）',     '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0246','M_W2_SM_INDOOR_ENERGY', '服饰鞋帽（服饰）',     '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0254','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0262','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0270','M_W2_SM_INDOOR_ENERGY', '备用',               '321283124S30020102', '配电箱-ALSPZ2', 45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0278','M_W2_SM_INDOOR_ENERGY', '传统小吃（小吃）',      '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0286','M_W2_SM_INDOOR_ENERGY', '美广',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, '没电');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0294','M_W2_SM_INDOOR_ENERGY', '共和春（面馆）',        '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0302','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0310','M_W2_SM_INDOOR_ENERGY', '特产市集（特产）',      '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0318','M_W2_SM_INDOOR_ENERGY', '超市',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0326','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0334','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0342','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0350','M_W2_SM_INDOOR_ENERGY', '备用',                '321283124S30020102', '配电箱-ALSPZ1', 45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0406','M_W2_SM_INDOOR_ENERGY', '厨房配电',             '321283124S30020103', '配电箱-APCF',   45, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0600','M_W2_SM_INDOOR_ENERGY', '南区综合楼APDT',      '321283124S30020104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0601','M_W2_SM_INDOOR_ENERGY', '南区综合楼2APDP',     '321283124S30020104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0602','M_W2_SM_INDOOR_ENERGY', '南区综合楼2ALZt',     '321283124S30020104', '二楼强电间',     45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0603','M_W2_SM_INDOOR_ENERGY', '南区综合楼APKT1',     '321283124S30020104', '二楼强电间',     45, 0, 300, 0, 1, '暂未供电');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1003_AV_0604','M_W2_SM_INDOOR_ENERGY', '南区综合楼APKT2',     '321283124S30020104', '二楼强电间',     45, 0, 300, 0, 1, '暂未供电');

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0400','M_W2_SM_INDOOR_ENERGY', '南区综合楼APXK',      '321283124S30020101', '消控室',        45, 0, 300, 0, 1, null);

-- 南区司机之家电表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1005_AV_0000','M_W2_SM_INDOOR_ENERGY', '南区司机之家维修间ALZ',   '321283124S30020201', '一楼强电间',   45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1005_AV_0200','M_W2_SM_INDOOR_ENERGY', '南区司机之家维修间ALWX',  '321283124S30020201', '一楼强电间',   45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1005_AV_0201','M_W2_SM_INDOOR_ENERGY', '南区司机之家维修间ALE',   '321283124S30020201', '一楼强电间',   45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1005_AV_0400','M_W2_SM_INDOOR_ENERGY', '南区司机之家维修间ALSS',  '321283124S30020202', '二楼强电间',   45, 0, 300, 0, 1, null);

-- 南区宿舍电表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1007_AV_0000','M_W2_SM_INDOOR_ENERGY', '南区宿舍ALZ',   '321283124S300203', '一楼强电间',   45, 0, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1007_AV_0200','M_W2_SM_INDOOR_ENERGY', '南区宿舍ALE',   '321283124S300203', '一楼强电间',   45, 0, 300, 0, 1, null);

-- 南区水表
-- 北综合楼水表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0000','M_W2_SM_INDOOR_ENERGY', '货车服务空间', '321283124S30020101', '货车服务空间',   70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0001','M_W2_SM_INDOOR_ENERGY', '沪上阿姨',    '321283124S30020102', '沪上阿姨',      70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0002','M_W2_SM_INDOOR_ENERGY', '微团生活馆',   '321283124S30020102', '微团生活馆',    70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0003','M_W2_SM_INDOOR_ENERGY', '服饰鞋帽',     '321283124S30020102', '服饰鞋帽',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0004','M_W2_SM_INDOOR_ENERGY', '卫生间',       '321283124S30020101', '卫生间',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0005','M_W2_SM_INDOOR_ENERGY', '开水间',       '321283124S30020101', '开水间',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0006','M_W2_SM_INDOOR_ENERGY', '超市',         '321283124S30020102', '超市',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0007','M_W2_SM_INDOOR_ENERGY', '特产市集',     '321283124S30020102', '特产市集',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0008','M_W2_SM_INDOOR_ENERGY', '堂食餐饮',     '321283124S30020102', '堂食餐饮',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0009','M_W2_SM_INDOOR_ENERGY', '传统小吃',     '321283124S30020102', '传统小吃',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0010','M_W2_SM_INDOOR_ENERGY', '德克士',       '321283124S30020102', '德克士',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0011','M_W2_SM_INDOOR_ENERGY', '共和春面馆',    '321283124S30020102', '共和春面馆',     70, 1, 300, 0, 1, null);
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0012','M_W2_SM_INDOOR_ENERGY', '中餐厅',       '321283124S30020102', '中餐厅',     70, 1, 300, 0, 1, null);

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1004_AV_0200','M_W2_SM_INDOOR_ENERGY', '二楼',       '321283124S30020104', '二楼',     70, 0, 300, 0, 1, null);

-- 司机之家水表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'C_1005_AV_0600','M_W2_SM_INDOOR_ENERGY', '司机之家水表', '321283124S300202', '司机之家',   70, 0, 300, 0, 1, null);

-- 测试表
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', '864142073640059', 'M_W2_QF_GEEKOPEN', '智能断路器', '321283124S300101', '综合楼C3-茶水间', 45, 0, 3600, 0, 1, '智能表');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'J-E-B-101', 'test', '综合楼B-101', '321283124S300101', '一楼设备间', 45, 1, NULL, 1, 1, '智能表');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3001', 'J-W-B-102', 'test', '综合楼B-102', '321283124S300101', '一楼设备间', 70, 1, NULL, 1, 1, '智能表');

INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'J-E-N-101', 'test', '综合楼N-101', '321283124S300201', '一楼设备间', 45, 1, NULL, 1, 1, '智能表');
INSERT INTO `adm_meter_device` (`area_code`, `device_code`, `device_model`, `device_name`, `location_ref`, `location`, `meter_cls`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('321283124S3002', 'J-W-N-102', 'test', '综合楼N-103', '321283124S300201', '一楼设备间', 70, 1, NULL, 1, 1, '智能表');



-- 北区区域-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300101', 45, 'C_2004_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10204', 45, 'C_2003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10209', 45, 'C_2003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10209', 45, 'C_2003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10210', 45, 'C_2003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10207', 45, 'C_2003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10205', 45, 'C_2003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10202', 45, 'C_2003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10201', 45, 'C_2003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010103', 45, 'C_2003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010104', 45, 'C_2003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010104', 45, 'C_2003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010104', 45, 'C_2003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010104', 45, 'C_2003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300102', 45, 'C_2005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300102', 45, 'C_2005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300102', 45, 'C_2005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300102', 45, 'C_2005_AV_0401');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300103', 45, 'C_2006_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10103', 70, 'C_2004_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10208', 70, 'C_2004_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10209', 70, 'C_2004_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10210', 70, 'C_2004_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10101', 70, 'C_2004_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10102', 70, 'C_2004_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10201', 70, 'C_2004_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10202', 70, 'C_2004_AV_0007');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10206', 70, 'C_2004_AV_0008');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10207', 70, 'C_2004_AV_0009');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10204', 70, 'C_2004_AV_0010');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10205', 70, 'C_2004_AV_0011');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'B-10203', 70, 'C_2004_AV_0012');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30010104', 70, 'C_2004_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300102', 70, 'C_2005_AV_0600');

-- 南区区域-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300201', 45, 'C_1004_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10204', 45, 'C_1003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10209', 45, 'C_1003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10208', 45, 'C_1003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10210', 45, 'C_1003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10207', 45, 'C_1003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10205', 45, 'C_1003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10202', 45, 'C_1003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10201', 45, 'C_1003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020103', 45, 'C_1003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 45, 'C_1003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 45, 'C_1003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 45, 'C_1003_AV_0602');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 45, 'C_1003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 45, 'C_1003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300202', 45, 'C_1005_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300202', 45, 'C_1005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300202', 45, 'C_1005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300202', 45, 'C_1005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300203', 45, 'C_1007_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300203', 45, 'C_1007_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10103', 70, 'C_1004_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10208', 70, 'C_1004_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10209', 70, 'C_1004_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10210', 70, 'C_1004_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10101', 70, 'C_1004_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10102', 70, 'C_1004_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10201', 70, 'C_1004_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10202', 70, 'C_1004_AV_0007');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10206', 70, 'C_1004_AV_0008');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10207', 70, 'C_1004_AV_0009');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10204', 70, 'C_1004_AV_0010');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10205', 70, 'C_1004_AV_0011');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, 'N-10203', 70, 'C_1004_AV_0012');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S30020104', 70, 'C_1004_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (1, '321283124S300202', 70, 'C_1005_AV_0600');

-- 北区负荷设施-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-KT-01', 45, 'C_2003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-ZM-01', 45, 'C_2003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0222');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0230');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0254');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0262');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0270');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0286');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0302');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0326');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0334');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0342');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0350');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2005_AV_0401');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 45, 'C_2006_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 45, 'C_2003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-AF-01', 45, 'C_2004_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0007');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0008');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0009');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0010');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0011');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-01', 70, 'C_2004_AV_0012');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 70, 'C_2004_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-01', 70, 'C_2005_AV_0600');

-- 南区负荷设施-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-KT-02', 45, 'C_1003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-ZM-02', 45, 'C_1003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0222');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0230');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0254');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0262');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0270');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0286');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0302');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0326');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0334');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0342');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0350');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1005_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1007_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 45, 'C_1007_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0602');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 45, 'C_1003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-AF-02', 45, 'C_1004_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0007');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0008');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0009');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0010');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0011');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-FW-02', 70, 'C_1004_AV_0012');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 70, 'C_1004_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'Z-QT-02', 70, 'C_1005_AV_0600');

-- 北区市电供能设施-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0222');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0230');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0254');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0262');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0270');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0286');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0302');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0326');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0334');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0342');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0350');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2005_AV_0401');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2006_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W201', 45, 'C_2004_AV_0400');

-- 南区市电供能设施-表计测点绑定关系
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0001');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0206');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0214');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0222');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0230');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0238');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0246');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0254');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0262');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0270');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0278');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0286');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0294');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0302');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0310');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0318');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0326');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0334');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0342');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0350');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0406');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1005_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1005_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1005_AV_0201');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1005_AV_0400');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1007_AV_0000');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1007_AV_0200');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0002');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0003');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0004');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0005');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0006');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0600');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0601');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0602');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0603');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1003_AV_0604');
INSERT INTO `adm_meter_boundary_rel` (`obj_type`, `boundary_obj`, `meter_cls`, `meter_device`) VALUES (2, 'W202', 45, 'C_1004_AV_0400');


-- 抄表demo数据
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202401', 0, '2023-12-31', 100, '2024-01-31', 100, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202402', 100, '2024-01-31', 238, '2024-02-28', 138, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202403', 238, '2024-02-28', 365, '2024-03-31', 127, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202404', 365, '2024-03-31', 537, '2024-04-30', 172, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202405', 537, '2024-04-30', 686, '2024-05-31', 149, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202406', 686, '2024-05-31', 921, '2024-06-30', 235, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202407', 921, '2024-06-30', 1189, '2024-07-31', 268, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202408', 1189, '2024-07-31', 1464, '2024-08-31', 275, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202409', 1464, '2024-08-31', 1797, '2024-09-30', 333, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202410', 1797, '2024-09-30', 2045, '2024-10-31', 248, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202411', 2045, '2024-10-31', 2345, '2024-11-30', 300, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2024', '202412', 2345, '2024-11-30', 2570, '2024-12-31', 225, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202501', 2570, '2024-12-31', 2815, '2025-01-31', 245, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202502', 2815, '2025-01-31', 3123, '2025-02-28', 308, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202503', 3123, '2025-02-28', 3441, '2025-03-31', 318, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202504', 3441, '2025-03-31', 3853, '2025-04-30', 412, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202505', 3853, '2025-04-30', 4211, '2025-05-31', 358, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202506', 4211, '2025-05-31', 4605, '2025-06-30', 394, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-E-B-101', '321283124S3001', '2025', '202507', 4605, '2025-06-30', 5016, '2025-07-31', 411, NULL, NULL);


INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202401', 0, '2023-12-31', 100, '2024-01-31', 100, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202402', 100, '2024-01-31', 238, '2024-02-28', 138, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202403', 238, '2024-02-28', 365, '2024-03-31', 127, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202404', 365, '2024-03-31', 537, '2024-04-30', 172, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202405', 537, '2024-04-30', 686, '2024-05-31', 149, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202406', 686, '2024-05-31', 921, '2024-06-30', 235, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202407', 921, '2024-06-30', 1189, '2024-07-31', 268, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202408', 1189, '2024-07-31', 1464, '2024-08-31', 275, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202409', 1464, '2024-08-31', 1797, '2024-09-30', 333, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202410', 1797, '2024-09-30', 2045, '2024-10-31', 248, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202411', 2045, '2024-10-31', 2345, '2024-11-30', 300, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2024', '202412', 2345, '2024-11-30', 2620, '2024-12-31', 275, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202501', 2620, '2024-12-31', 2877, '2025-01-31', 257, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202502', 2877, '2025-01-31', 3111, '2025-02-28', 234, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202503', 3111, '2025-02-28', 3254, '2025-03-31', 143, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202504', 3254, '2025-03-31', 3452, '2025-04-30', 198, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202505', 3452, '2025-04-30', 3666, '2025-05-31', 214, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202506', 3666, '2025-05-31', 3915, '2025-06-30', 249, NULL, NULL);
INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-W-B-102', '321283124S3001', '2025', '202507', 3915, '2025-06-30', 4182, '2025-07-31', 267, NULL, NULL);




-- 台账数据
INSERT INTO `adm_ems_device_rbook` (`record_code`, `area_code`, `obj_type`, `obj_code`, `obj_name`, `record_time`, `ins_location`, `maintain_title`, `maintain_content`, `maintain_person`) VALUES ('TZ-20240901001', '321283124S3001', 1, 'W201', '北区-电网', '2024-09-01 10:32:00', '北区-广场', '北区广场变压器维护', '执行例行维护', '李大航');
INSERT INTO `adm_ems_device_rbook` (`record_code`, `area_code`, `obj_type`, `obj_code`, `obj_name`, `record_time`, `ins_location`, `maintain_title`, `maintain_content`, `maintain_person`) VALUES ('TZ-20240901002', '321283124S3001', 2, 'Z010-R101-001', '北区-开水炉', '2024-09-10 17:34:56', '北区/综合楼/一楼开水间', '开水炉除垢', '执行开水炉除垢', '王凯');

-- 告警策略
INSERT INTO `adm_op_alarm_policy` (`area_code`, `policy_code`, `policy_name`, `alarm_obj_type`, `alarm_obj_index`, `alarm_rule_type`, `alarm_threshold_value`, `alarm_code`, `alarm_msg`, `alarm_type`) VALUES ('321283124S3001', '10001', '负荷监测', 2, 'power', 1, 2000, '1001', '负荷超限', 3);
INSERT INTO `adm_op_alarm_policy` (`area_code`, `policy_code`, `policy_name`, `alarm_obj_type`, `alarm_obj_index`, `alarm_rule_type`, `alarm_threshold_value`, `alarm_code`, `alarm_msg`, `alarm_type`) VALUES ('321283124S3001', '10002', '电压检测', 2, 'voltage', 2, 210, '1002', '低压警报', 2);
INSERT INTO `adm_op_alarm_policy` (`area_code`, `policy_code`, `policy_name`, `alarm_obj_type`, `alarm_obj_index`, `alarm_rule_type`, `alarm_threshold_value`, `alarm_code`, `alarm_msg`, `alarm_type`) VALUES ('321283124S3002', '20001', '电压检测', 2, 'power', 1, 2000, '1001', '负荷超限', 3);
INSERT INTO `adm_op_alarm_policy` (`area_code`, `policy_code`, `policy_name`, `alarm_obj_type`, `alarm_obj_index`, `alarm_rule_type`, `alarm_threshold_value`, `alarm_code`, `alarm_msg`, `alarm_type`) VALUES ('321283124S3002', '20002', '电压检测', 2, 'voltage', 2, 210, '1002', '低压警报', 2);

-- 告警数据
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_GF', 1, 'B-107', '特色小吃', '2024-11-14', '2024-11-14 09:12:23', '00001', '北区光伏告警', 1, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_CN', 1, 'B-101', '开水泡面间', '2024-11-14', '2024-11-14 20:15:23', '00002', '北区开水间配电告警', 1, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 2, 'Z101', '照明灯', '2024-11-13', '2024-11-13 12:15:21', '00003', '北区照明设施告警', 2, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 3, 'Z010-R103-001', '空调', '2024-11-12', '2024-11-12 09:17:49', '0004', '北区公共区域空调告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_CN', 2, 'E501', '北区-光伏', '2024-11-15', '2024-11-15 15:02:00', 'E003', '未知告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3002', 'SYS_CN', 2, 'E502', '南区-光伏', '2024-11-15', '2024-11-15 15:03:00', 'Ecc01', '未知告警', 3, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2024-11-15', '2024-11-15 09:33:00', 'E0003', '电流阈值告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2025-06-15', '2025-06-15 15:21:00', 'E003', '配电柜温度告警', 1, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2025-06-24', '2025-06-24 15:21:00', 'E003', '配电柜温度告警', 1, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3002', 'SYS_CN', 2, 'E502', '南区-光伏', '2025-06-24', '2025-06-24 15:03:00', 'Ecc01', '未知告警', 3, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_BA', 3, 'Z010-R103-001', '空调', '2025-06-24', '2025-06-24 09:17:49', '0004', '北区公共区域空调告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3001', 'SYS_CN', 1, 'B-101', '开水泡面间', '2025-05-14', '2025-05-14 20:15:23', '00002', '北区开水间配电告警', 1, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2024-11-15', '2024-11-15 09:33:00', 'E0003', '电流阈值告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2025-06-15', '2025-06-15 15:21:00', 'E003', '配电柜温度告警', 1, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_BA', 4, 'D-B-1001', '综合楼配电间(常泰高速服务区(北区))', '2025-06-24', '2025-06-24 15:21:00', 'E003', '配电柜温度告警', 1, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_CN', 2, 'E502', '主路-光伏', '2025-06-24', '2025-06-24 15:03:00', 'Ecc01', '未知告警', 3, 1);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_BA', 3, 'Z010-R103-001', '空调', '2025-06-24', '2025-06-24 09:17:49', '0004', '北区公共区域空调告警', 2, 2);
INSERT INTO adm_op_alarm(area_code, system_code, obj_type, obj_code, obj_name, alarm_date, alarm_time, alarm_code, alarm_msg, alarm_type, alarm_state)VALUES('321283124S3003', 'SYS_CN', 1, 'B-101', '开水泡面间', '2025-05-14', '2025-05-14 20:15:23', '00002', '北区开水间配电告警', 1, 1);

-- 巡检计划
INSERT INTO `adm_op_inspection_plan` (`area_code`, `task_code`, `task_name`, `task_type`, `start_time`, `executor`, `obj_type`, `obj_code`, `obj_name`) VALUES ('321283124S3001', '250702185440A002', '安全巡检', 1, '2025-07-10 00:00:00', '系统', 2, 'W201', '北区-供电网(常泰高速服务区(北区))');
INSERT INTO `adm_op_inspection_plan` (`area_code`, `task_code`, `task_name`, `task_type`, `start_time`, `executor`, `obj_type`, `obj_code`, `obj_name`) VALUES ('321283124S3002', '250702185514A003', '安全巡检', 1, '2025-07-11 00:00:00', '系统', 2, 'W202', '南区-供电网(常泰高速服务区(南区))');

-- 巡检报告
INSERT INTO `adm_op_inspection_report` (`task_code`, `result_status`, `result_msg`, `finish_time`, `sub_time`, `submitter`) VALUES ('1001', 0, '<p>设施运行正常</p>', '2025-07-12 00:00:00', '2025-07-02 19:08:11', 'admin');
INSERT INTO `adm_op_inspection_report` (`task_code`, `result_status`, `result_msg`, `finish_time`, `sub_time`, `submitter`) VALUES ('1002', 1, '<p>线材破损</p>', '2025-07-10 00:00:00', '2025-07-02 19:08:53', 'admin');