Target Server Version : 50732
File Encoding : 65001
Date: 12/10/2021 10:24:21
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for mx_jzy_device_data
DROP TABLE IF EXISTS mxsk.mx_data;
CREATE TABLE mxsk.mx_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
ent_plt_user_id bigint(20) NOT NULL COMMENT ‘核心企业平台用户id’,
device_mac_flag varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘设备标识’,
product_key varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘产品唯一Key’,
product_name varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘产品名称’,
device_status int(11) DEFAULT NULL COMMENT ‘设备状态：0:下线，1:上线’,
data_statistics_time varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘数据统计时间’,
data_statistics_hour int(11) DEFAULT NULL COMMENT ‘数据统计按照小时，取值范围：0-23，默认-1’,
data_statistics_value int(11) DEFAULT NULL COMMENT ‘统计值’,
data_statistics_type varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘数据统计类型：取值：status:设备状态，day:天,hour:小时’,
add_record_time bigint(20) DEFAULT NULL COMMENT ‘数据入库创建时间’,
event_send_time bigint(20) DEFAULT NULL COMMENT ‘事件发生时间’,
uniqueness_key varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT ‘保证数据唯一性（幂等处理）’,
PRIMARY KEY (id),
UNIQUE KEY uniqueness_key_index (uniqueness_key)
) ENGINE=InnoDB AUTO_INCREMENT=30035 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of mx_jzy_device_data
BEGIN;
INSERT INTO mx_jzy_device_data VALUES (30001, ‘7’, ‘861193046118106’, ‘3472e0d07f2d4435a197e202c9988199’, ‘玻璃厂切割机’, 0, ‘20211006’, -1, 0, ‘status’, 1633948536036, 1633391979, ‘7456b36a25b44c606536dd56202983d0’);
INSERT INTO mx_jzy_device_data VALUES (30002, ‘7’, ‘861193046114212’, ‘3472e0d07f2d4435a197e202c9988199’, ‘玻璃厂切割机’, 0, ‘20211006’, -1, 0, ‘status’, 1633948536036, 1633311173, ‘0d42b6940aec8b80465ea6b4f8be0266’);
INSERT INTO mx_jzy_device_data VALUES (30003, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211005’, 15, 2025, ‘hour’, 1633948536036, 1633503634, ‘0c1135a7305f08fe0112c79bfbe7a07e’);
INSERT INTO mx_jzy_device_data VALUES (30004, ‘7’, ‘861193046114212’, ‘3472e0d07f2d4435a197e202c9988199’, ‘玻璃厂切割机’, 0, ‘20211003’, -1, 0, ‘status’, 1633948536525, 1633311303, ‘c1233180160c3201a4358b8ca21b552d’);
INSERT INTO mx_jzy_device_data VALUES (30005, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211002’, 16, 2139, ‘hour’, 1633948536527, 1633507291, ‘eadeec98df5b75698127d31a94dc4e76’);
INSERT INTO mx_jzy_device_data VALUES (30006, ‘7’, ‘861193046114212’, ‘3472e0d07f2d4435a197e202c9988199’, ‘玻璃厂切割机’, 0, ‘20211001’, -1, 0, ‘status’, 1633948536547, 1633311490, ‘f8bc7e4eddda1d41e7d292563c5d1152’);
INSERT INTO mx_jzy_device_data VALUES (30007, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210928’, 17, 2103, ‘hour’, 1633948536550, 1633510933, ‘c3d4183dbc599d663cc4cebda94c737b’);
INSERT INTO mx_jzy_device_data VALUES (30008, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210924’, 18, 1962, ‘hour’, 1633948536572, 1633514605, ‘872ebb7b5b059527b1df558014b597e3’);
INSERT INTO mx_jzy_device_data VALUES (30010, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210920’, 19, 1308, ‘hour’, 1633948536594, 1633518082, ‘d92461219e11db9fa45fee16cf99a9e1’);
INSERT INTO mx_jzy_device_data VALUES (30012, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210918’, 20, 1659, ‘hour’, 1633948536618, 1633521739, ‘363ab59f72e1187fa7781d49427ae9fa’);
INSERT INTO mx_jzy_device_data VALUES (30013, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210914’, 21, 1800, ‘hour’, 1633948536659, 1633525576, ‘4c8b5fee5bfe1f3ba7f2ee05f24ee67e’);
INSERT INTO mx_jzy_device_data VALUES (30014, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210904’, 22, 1854, ‘hour’, 1633948536682, 1633528855, ‘d030afb74051ac26cbd9153fa1ba9c0e’);
INSERT INTO mx_jzy_device_data VALUES (30015, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210906’, 23, 2082, ‘hour’, 1633948536705, 1633532548, ‘5872919a69f495de2e255e76012f351e’);
INSERT INTO mx_jzy_device_data VALUES (30016, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210807’, 0, 0, ‘hour’, 1633948536728, 1633536025, ‘b77f813123c4c35298e27a9d1dd86449’);
INSERT INTO mx_jzy_device_data VALUES (30017, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210607’, -1, 49941, ‘day’, 1633948536750, 1633536025, ‘09bca1c523e95658144eb143f83623af’);
INSERT INTO mx_jzy_device_data VALUES (30018, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210907’, 1, 2061, ‘hour’, 1633948536773, 1633539682, ‘2f62895ac679c827d3dedaaa8cd5441c’);
INSERT INTO mx_jzy_device_data VALUES (30019, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210807’, 2, 2133, ‘hour’, 1633948536796, 1633543375, ‘5a49d96bf824977d20c43d77107eab47’);
INSERT INTO mx_jzy_device_data VALUES (30020, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210907’, 3, 1983, ‘hour’, 1633948536819, 1633546852, ‘659cd739490a2b5e2a033deb418bcb6c’);
INSERT INTO mx_jzy_device_data VALUES (30021, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210907’, 4, 2319, ‘hour’, 1633948536843, 1633550473, ‘b13b3fc1436ac5821ed94486c0fbaf6d’);
INSERT INTO mx_jzy_device_data VALUES (30022, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210807’, 5, 2196, ‘hour’, 1633948536866, 1633554149, ‘6b896e0b41a0456134cca37213e2e916’);
INSERT INTO mx_jzy_device_data VALUES (30023, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210807’, 6, 2070, ‘hour’, 1633948536889, 1633557607, ‘421259500540c86661c9cdfbdd094415’);
INSERT INTO mx_jzy_device_data VALUES (30024, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210507’, 7, 2175, ‘hour’, 1633948536911, 1633561246, ‘5fcd93d44323b9da075d9579f7deefdf’);
INSERT INTO mx_jzy_device_data VALUES (30025, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210407’, 8, 2103, ‘hour’, 1633948536934, 1633564885, ‘7b3f5a95ed5dd25ef5073fcd01998e4c’);
INSERT INTO mx_jzy_device_data VALUES (30026, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210407’, 9, 2148, ‘hour’, 1633948536956, 1633568489, ‘b7e8b75fd93e8b67b399955948b179b9’);
INSERT INTO mx_jzy_device_data VALUES (30027, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20210817’, 10, 1818, ‘hour’, 1633948536979, 1633572154, ‘8f23dcaf3823f19c7e38d0ce37598568’);
INSERT INTO mx_jzy_device_data VALUES (30028, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211007’, 11, 2016, ‘hour’, 1633948537001, 1633575630, ‘83b854ada71c7d698808dbd318c58884’);
INSERT INTO mx_jzy_device_data VALUES (30029, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211008’, 12, 1917, ‘hour’, 1633948537024, 1633579323, ‘1c46f2f5353f779b6e368cc53664bb5c’);
INSERT INTO mx_jzy_device_data VALUES (30030, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211009’, 13, 1488, ‘hour’, 1633948537047, 1633582962, ‘5d7d306717cd311c45f3d4c6651f3c98’);
INSERT INTO mx_jzy_device_data VALUES (30031, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 1, ‘20211010’, 14, 1410, ‘hour’, 1633948537070, 1633586421, ‘d27122bafeb95e70c1e42692c7875e90’);
INSERT INTO mx_jzy_device_data VALUES (30032, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 0, ‘20211011’, -1, 0, ‘status’, 1633948537092, 1633679740, ‘2d4db0a2aaca3e8cd3f6fc836039c2b6’);
INSERT INTO mx_jzy_device_data VALUES (30033, ‘7’, ‘863293057714724’, ‘5acaa1f064974c20bef2fcbd8fecd6ac’, ‘玻璃厂智能电表’, 0, ‘20211012’, -1, 0, ‘status’, 1633948537115, 1633919617, ‘253864ae3d6f9b9ea8399467cf6088bd’);
INSERT INTO mx_jzy_device_data VALUES (30034, ‘7’, ‘861193046114212’, ‘3472e0d07f2d4435a197e202c9988199’, ‘玻璃厂切割机’, 0, ‘20211013’, -1, 0, ‘status’, 1633996496779, 1633996496, ‘0b03ab9b4c4f3eaedceae854077ff079’);
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
加了commit，没有用，是不是我配置表哪里有问题