/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50520
Source Host           : localhost:3306
Source Database       : ch_huaao

Target Server Type    : MYSQL
Target Server Version : 50520
File Encoding         : 65001

Date: 2017-05-18 17:13:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ch_menu
-- ----------------------------
DROP TABLE IF EXISTS `ch_menu`;
CREATE TABLE `ch_menu` (
  `menu_id` varchar(32) NOT NULL DEFAULT '',
  `menu_name` varchar(32) DEFAULT NULL,
  `as_parent` tinyint(1) DEFAULT NULL,
  `parent_id` varchar(32) DEFAULT '-1',
  `url` varchar(128) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  `menu_order` int(8) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ch_menu
-- ----------------------------
INSERT INTO `ch_menu` VALUES ('31d7165823dd11e79cd53c970efdbee8', '设备管理', '0', null, 'pages/huaao/machine/machine.html', 'icon-dashboard', '4');
INSERT INTO `ch_menu` VALUES ('402880e84eb0e942014eb0f8cc910009', '用户管理', '0', '-1', 'pages/system/user/user.html', 'icon-list', '1');
INSERT INTO `ch_menu` VALUES ('402880e84eb0e942014eb0f94414000b', '角色管理', '0', '-1', 'pages/system/role/role.html', 'icon-edit', '2');
INSERT INTO `ch_menu` VALUES ('402880e84eb0e942014eb0f9e81d000d', '菜单管理', '0', '-1', 'pages/system/menu/menu.html', 'icon-gears', '3');
INSERT INTO `ch_menu` VALUES ('a1751aa42e7711e7a4433c970efdbee8', '反馈意见', '0', null, 'pages/huaao/feedback/feedback.html', 'icon-search', '6');
INSERT INTO `ch_menu` VALUES ('bc3e695a233211e7b0db3c970efdbee8', '客户管理', '0', null, 'pages/huaao/customer/customer.html', 'icon-user', '5');
INSERT INTO `ch_menu` VALUES ('dd8fdd452e7711e7a4433c970efdbee8', '日志管理', '0', null, 'pages/huaao/log/log.html', 'icon-leaf', '7');

-- ----------------------------
-- Table structure for ch_role
-- ----------------------------
DROP TABLE IF EXISTS `ch_role`;
CREATE TABLE `ch_role` (
  `role_id` varchar(32) NOT NULL DEFAULT '',
  `role_name` varchar(32) DEFAULT NULL,
  `role_order` int(8) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ch_role
-- ----------------------------
INSERT INTO `ch_role` VALUES ('402880e84eb0cb1d014eb0d04ded0001', '系统管理员', '1');
INSERT INTO `ch_role` VALUES ('402880e84eb0cb1d014eb0d07dfa0002', '管理员', '2');

-- ----------------------------
-- Table structure for ch_role_menu_map
-- ----------------------------
DROP TABLE IF EXISTS `ch_role_menu_map`;
CREATE TABLE `ch_role_menu_map` (
  `role_menu_map_id` varchar(32) NOT NULL DEFAULT '',
  `role_id` varchar(32) DEFAULT NULL,
  `menu_id` varchar(32) DEFAULT NULL,
  `menu_order` int(8) DEFAULT NULL,
  `role_order` int(8) DEFAULT NULL,
  PRIMARY KEY (`role_menu_map_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ch_role_menu_map
-- ----------------------------
INSERT INTO `ch_role_menu_map` VALUES ('402880e84eb0e942014eb0f8ccd0000a', '402880e84eb0cb1d014eb0d04ded0001', '402880e84eb0e942014eb0f8cc910009', '1', '1');
INSERT INTO `ch_role_menu_map` VALUES ('402880e84eb0e942014eb0f9444c000c', '402880e84eb0cb1d014eb0d04ded0001', '402880e84eb0e942014eb0f94414000b', '2', '1');
INSERT INTO `ch_role_menu_map` VALUES ('402880e84eb0e942014eb0f9e852000e', '402880e84eb0cb1d014eb0d04ded0001', '402880e84eb0e942014eb0f9e81d000d', '3', '1');
INSERT INTO `ch_role_menu_map` VALUES ('a18758222e7711e7a4433c970efdbee8', '402880e84eb0cb1d014eb0d07dfa0002', 'a1751aa42e7711e7a4433c970efdbee8', '6', '2');
INSERT INTO `ch_role_menu_map` VALUES ('daec74cf299011e7b3ec3c970efdbee8', '402880e84eb0cb1d014eb0d07dfa0002', 'bc3e695a233211e7b0db3c970efdbee8', '5', '2');
INSERT INTO `ch_role_menu_map` VALUES ('dd9ce3942e7711e7a4433c970efdbee8', '402880e84eb0cb1d014eb0d07dfa0002', 'dd8fdd452e7711e7a4433c970efdbee8', '7', '2');
INSERT INTO `ch_role_menu_map` VALUES ('e33fb27d299011e7b3ec3c970efdbee8', '402880e84eb0cb1d014eb0d07dfa0002', '31d7165823dd11e79cd53c970efdbee8', '4', '2');

-- ----------------------------
-- Table structure for ch_user
-- ----------------------------
DROP TABLE IF EXISTS `ch_user`;
CREATE TABLE `ch_user` (
  `user_id` varchar(32) NOT NULL DEFAULT '',
  `username` varchar(32) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `nickname` varchar(32) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `userphoto` varchar(255) DEFAULT NULL,
  `locked` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ch_user
-- ----------------------------
INSERT INTO `ch_user` VALUES ('402880f24c4a5b2c014c4a5bbb7f0001', 'admin', '51ca5dff068c393899233251450d95e2', 'chhuang', '123456', 'chhuang@aaa.com', 'Resource/fa23b72c-35e1-4070-b523-bb323fe5ed3c.jpg', '0');
INSERT INTO `ch_user` VALUES ('8d877ef12b4d11e795b23c970efdbee8', 'huaao', '0d9395500c88960076f67c98fc5dd3c7', '华澳管理员', '13813533275', 'liyanghuaao@qq.com', null, '0');

-- ----------------------------
-- Table structure for ch_user_role_map
-- ----------------------------
DROP TABLE IF EXISTS `ch_user_role_map`;
CREATE TABLE `ch_user_role_map` (
  `user_role_map_id` varchar(32) NOT NULL DEFAULT '',
  `user_id` varchar(32) DEFAULT NULL,
  `role_id` varchar(32) DEFAULT NULL,
  `role_order` int(8) DEFAULT NULL,
  PRIMARY KEY (`user_role_map_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ch_user_role_map
-- ----------------------------
INSERT INTO `ch_user_role_map` VALUES ('402881e851130398015113073f220003', '402880f24c4a5b2c014c4a5bbb7f0001', '402880e84eb0cb1d014eb0d04ded0001', '1');
INSERT INTO `ch_user_role_map` VALUES ('402881e85113039801511307405a0004', '402880f24c4a5b2c014c4a5bbb7f0001', '402880e84eb0cb1d014eb0d07dfa0002', '2');
INSERT INTO `ch_user_role_map` VALUES ('8d9905d72b4d11e795b23c970efdbee8', '8d877ef12b4d11e795b23c970efdbee8', '402880e84eb0cb1d014eb0d07dfa0002', '2');

-- ----------------------------
-- Table structure for ha_customer
-- ----------------------------
DROP TABLE IF EXISTS `ha_customer`;
CREATE TABLE `ha_customer` (
  `CUSTOMER_ID` varchar(32) NOT NULL COMMENT '编号',
  `CUSTOMER_ACCOUNT` varchar(255) NOT NULL COMMENT '账号',
  `CUSTOMER_PHONE` varchar(16) NOT NULL COMMENT '手机号',
  `CUSTOMER_PASSWORD` varchar(32) NOT NULL COMMENT '密码',
  `CUSTOMER_NAME` varchar(255) DEFAULT NULL COMMENT '姓名',
  `CUSTOMER_GENDER` int(1) DEFAULT NULL COMMENT '性别',
  `CUSTOMER_COMPANY` varchar(255) DEFAULT NULL COMMENT '公司单位',
  `CUSTOMER_PHOTO` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `DEVICE_SYSTEM` varchar(255) DEFAULT NULL COMMENT '设备系统',
  `DEVICE_MODEL` varchar(255) DEFAULT NULL COMMENT '设备型号',
  `DEVICE_VENDOR` varchar(255) DEFAULT NULL COMMENT '设备生产商',
  `DEVICE_UUID` varchar(255) DEFAULT NULL COMMENT '设备唯一编码',
  `CLIENT_ID` varchar(255) DEFAULT NULL COMMENT '客户端APP推送服务令牌',
  `CLIENT_VERSION` varchar(255) DEFAULT NULL COMMENT '客户端APP版本',
  `LAST_LOGIN_ADDRESS` varchar(255) DEFAULT NULL COMMENT '最后一次登录时定位地址信息',
  `LAST_LOGIN_TIME` datetime DEFAULT NULL COMMENT '最后一次登录时间',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `MODIFY_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `LOCKED` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`CUSTOMER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ha_customer
-- ----------------------------
INSERT INTO `ha_customer` VALUES ('ddf1e5fe29b911e798d93c970efdbee8', '13625119195', '13625119195', '5448f141d7de10cca8bbe56fd7ac4ae2', null, null, null, null, 'Android 5.1', 'MX5', 'Meizu', '867246025582827,867246025582835', '8b72a48b5e216f3b37835e39b5a0918f', '8.1.3', '中国 江苏省 常州市 溧阳市 天目湖大道 ', '2017-05-17 09:28:30', '2017-04-25 21:19:52', '2017-05-17 09:28:30', '0');
INSERT INTO `ha_customer` VALUES ('df8874e72c7311e79b603c970efdbee8', '13861204371', '13861204371', '97ce07930434f65599f915f4a7893dde', null, null, null, null, 'Android 7.0', 'HUAWEI NXT-AL10', 'HUAWEI', '868404026218284,868404028971302', 'fab912a54b1bc6dee9473c642c2f7187', '1.0.0', '中国 江苏省 常州市 溧阳市 腾飞路 ', '2017-04-29 09:22:21', '2017-04-29 08:36:24', '2017-04-29 09:22:21', null);
INSERT INTO `ha_customer` VALUES ('fc9e3d5c2c7211e79b603c970efdbee8', '13813533275', '13813533275', 'd72671d4ac678716b80702982acc138b', '诸建波', '1', '溧阳华澳', 'Resource/c31aa0cf-e10b-4d9a-8959-7ab68ae47521.jpg', 'Android 5.1.1', 'OPPO R9 Plusm A', 'OPPO', '862022039755237,862022039755229', 'e5b2e8adb14ab9fafe769c705cce30eb', '1.0.0', '中国 江苏省 常州市 溧阳市 腾飞路 ', '2017-04-29 09:26:21', '2017-04-29 08:30:03', '2017-04-29 09:26:21', null);

-- ----------------------------
-- Table structure for ha_feedback
-- ----------------------------
DROP TABLE IF EXISTS `ha_feedback`;
CREATE TABLE `ha_feedback` (
  `FEEDBACK_ID` varchar(32) NOT NULL COMMENT '编号',
  `FEEDBACK_CONTENT` text COMMENT '内容',
  `CUSTOMER_ID` varchar(32) NOT NULL COMMENT '客户编号',
  `CUSTOMER_ACCOUNT` varchar(255) DEFAULT NULL COMMENT '客户账号',
  `CUSTOMER_NAME` varchar(255) DEFAULT NULL COMMENT '客户姓名',
  `DEVICE_MODEL` varchar(255) DEFAULT NULL COMMENT '型号',
  `DEVICE_VENDOR` varchar(255) DEFAULT NULL COMMENT '生产商',
  `DEVICE_SYSTEM` varchar(255) DEFAULT NULL COMMENT '设备系统',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`FEEDBACK_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ha_feedback
-- ----------------------------

-- ----------------------------
-- Table structure for ha_log
-- ----------------------------
DROP TABLE IF EXISTS `ha_log`;
CREATE TABLE `ha_log` (
  `LOG_ID` varchar(32) NOT NULL COMMENT '编号',
  `LOG_DESC` text COMMENT '日志描述',
  `MACHINE_ID` varchar(32) NOT NULL COMMENT '机器编号',
  `MACHINE_NUM` varchar(255) DEFAULT NULL COMMENT '机器编码',
  `CUSTOMER_ID` varchar(32) DEFAULT NULL COMMENT '客户编号',
  `CUSTOMER_ACCOUNT` varchar(255) DEFAULT NULL COMMENT '客户账号',
  `CUSTOMER_NAME` varchar(255) DEFAULT NULL COMMENT '客户姓名',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`LOG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ha_log
-- ----------------------------

-- ----------------------------
-- Table structure for ha_machine
-- ----------------------------
DROP TABLE IF EXISTS `ha_machine`;
CREATE TABLE `ha_machine` (
  `MACHINE_ID` varchar(32) NOT NULL COMMENT '编号',
  `MACHINE_NUM` varchar(255) NOT NULL COMMENT '机器编号，需要唯一性检测',
  `MACHINE_ANAME` varchar(255) DEFAULT NULL COMMENT '管理员起的机器别名',
  `MACHINE_CNAME` varchar(255) DEFAULT NULL COMMENT '客户起的机器别名',
  `MACHINE_ONLINE_STATUS` int(4) DEFAULT '0' COMMENT '机器的状态：0表示离线，1表示在线',
  `MACHINE_RUN_STATUS` int(4) DEFAULT '0' COMMENT '机器运行状态：0表示等待开机，1表示开机',
  `MACHINE_RUNING_STATUS` int(4) DEFAULT NULL COMMENT '0预进料，1点火中，2加热中，3关火中，4等待开机，',
  `MACHINE_BIN_STATUS` int(4) DEFAULT '0' COMMENT '料仓状态：0关闭，1开启',
  `MACHINE_STOVE_STATUS` int(4) DEFAULT '0' COMMENT '炉膛状态：0关闭，1开启',
  `MACHINE_BLOWER_STATUS` int(4) DEFAULT '0' COMMENT '鼓风机状态：0关闭，1开启',
  `MACHINE_WIND_STATUS` int(4) DEFAULT '0' COMMENT '引风机状态：0关闭，1开启',
  `MACHINE_PUMP_STATUS` int(4) DEFAULT '0' COMMENT '水泵状态：0关闭，1开启',
  `MACHINE_FIRE_STATUS` int(4) DEFAULT '0' COMMENT '点火棒状态：0关闭，1开启',
  `MACHINE_WATER_TEMP` double DEFAULT NULL COMMENT '实时水温',
  `MACHINE_SMOKE_TEMP` double DEFAULT NULL COMMENT '烟气温度',
  `MACHINE_INLET_WATER_TEMP` double DEFAULT NULL COMMENT '进水温度',
  `MACHINE_HIGHT_TEMP_WARN` tinyint(1) DEFAULT NULL COMMENT '高温报警',
  `MACHINE_LESS_WATER_WARN` tinyint(1) DEFAULT NULL COMMENT '缺水报警',
  `MACHINE_LESS_FUEL_WARN` tinyint(1) DEFAULT NULL COMMENT '6缺料报警',
  `MACHINE_BIN_STALL` int(11) DEFAULT NULL COMMENT '料机档位',
  `MACHINE_TURN_OFF_FIRE_TEMP` int(11) DEFAULT NULL COMMENT '关火温度（1-99）',
  `MACHINE_TURN_ON_FIRE_TEMP` int(11) DEFAULT NULL COMMENT '点火温度（1-99）',
  `MACHINE_TURN_SMOKE_TEMP` int(11) DEFAULT NULL COMMENT '烟气温度（1-99）',
  `MACHINE_TURN_ON_PUMP_TEMP` int(11) DEFAULT NULL COMMENT '开泵温度（1-99）',
  `MACHINE_TURN_OFF_PUMP_TEMP` int(11) DEFAULT NULL COMMENT '停泵温度（1-99）',
  `MACHINE_TURN_ON_TIMEOUT` int(11) DEFAULT NULL COMMENT '点火延时（10-250）秒',
  `MACHINE_TURN_ON_PRE_FEED_TIMEOUT` int(11) DEFAULT NULL COMMENT '点火预进料（10-100）秒',
  `MACHINE_TURN_OFF_BLOWER_TIMEOUT` int(11) DEFAULT NULL COMMENT '停炉鼓风延时（1-15）分',
  `MACHINE_TURN_OFF_WIND_TIMEOUT` int(11) DEFAULT NULL COMMENT '停炉引风延时（1-15）分',
  `MACHINE_WORK_TIME_INTERVAL1` varchar(255) DEFAULT NULL COMMENT '第1时段',
  `MACHINE_WORK_TIME_INTERVAL2` varchar(255) DEFAULT NULL COMMENT '第2时段',
  `MACHINE_WORK_TIME_INTERVAL3` varchar(255) DEFAULT NULL COMMENT '第3时段',
  `MACHINE_WORK_TIME_INTERVAL4` varchar(255) DEFAULT NULL COMMENT '第4时段',
  `MACHINE_WORK_TIME_INTERVAL5` varchar(255) DEFAULT NULL COMMENT '第5时段',
  `MACHINE_WORK_TIME_INTERVAL6` varchar(255) DEFAULT NULL COMMENT '第6时段',
  `MACHINE_WORK_TIME_INTERVAL7` varchar(255) DEFAULT NULL COMMENT '第7时段',
  `MACHINE_WORK_TIME_INTERVAL8` varchar(255) DEFAULT NULL COMMENT '第8时段',
  `MACHINE_ADMIN_DEADLINE` date DEFAULT NULL COMMENT '设备使用期限',
  `MACHINE_ADDRESS` varchar(255) DEFAULT NULL COMMENT '机器的 /IP:PORT',
  `CUSTOMER_ID` varchar(32) DEFAULT NULL COMMENT '客户编号-操作管理员',
  `CUSTOMER_ID1` varchar(32) DEFAULT NULL COMMENT '客户编号-普通管理员',
  `CUSTOMER_ID2` varchar(32) DEFAULT NULL COMMENT '客户编号-普通管理员',
  `CUSTOMER_ID3` varchar(32) DEFAULT NULL COMMENT '客户编号-普通管理员',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `MODIFY_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `HEART_TIME` datetime DEFAULT NULL COMMENT '最近一次心跳时间',
  PRIMARY KEY (`MACHINE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ha_machine
-- ----------------------------
INSERT INTO `ha_machine` VALUES ('3f22af6f2a4111e7941e3c970efdbee8', 'No1234567', '', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '/127.0.0.1:49758', 'fc9e3d5c2c7211e79b603c970efdbee8', null, null, null, '2017-04-26 13:28:57', '2017-05-17 09:21:00', '2017-04-28 12:18:10');
INSERT INTO `ha_machine` VALUES ('9e613c162c7211e79b603c970efdbee8', 'Noabcd', '', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '/127.0.0.1:50872', 'fc9e3d5c2c7211e79b603c970efdbee8', 'df8874e72c7311e79b603c970efdbee8', null, null, '2017-04-29 08:27:25', '2017-05-17 09:21:00', '2017-04-29 08:31:16');
INSERT INTO `ha_machine` VALUES ('de1034bd29b911e798d93c970efdbee8', 'No123456789', '测试设备', null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '/121.231.168.89:52613', 'ddf1e5fe29b911e798d93c970efdbee8', null, null, null, '2017-04-25 21:19:52', '2017-05-17 09:21:00', '2017-05-05 16:46:12');
INSERT INTO `ha_machine` VALUES ('ef1a01fb348111e796ca3c970efdbee8', '0001', null, null, null, '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '/36.16.65.10:49054', null, null, null, null, '2017-05-09 14:37:12', '2017-05-17 09:21:00', '2017-05-12 12:44:09');