/*
 Navicat MySQL Data Transfer

 Source Server         : Localhost
 Source Server Version : 50505
 Source Host           : localhost
 Source Database       : yx_iot

 Target Server Version : 50505
 File Encoding         : utf-8

 Date: 10/30/2018 21:47:06 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `yx_iot_device`
-- ----------------------------
DROP TABLE IF EXISTS `yx_iot_device`;
CREATE TABLE `yx_iot_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deviceClass` int(11) DEFAULT NULL,
  `deviceId` varchar(32) DEFAULT NULL COMMENT '自有系统自动生成',
  `deviceName` varchar(32) DEFAULT NULL,
  `wxDeviceId` varchar(32) DEFAULT NULL COMMENT '微信设备ID',
  `wxDeviceType` varchar(32) DEFAULT NULL COMMENT '微信公众号ID',
  `wxOpenId` varchar(32) DEFAULT NULL COMMENT '微信用户的绑定者（主人身份）',
  `mqttBaidu` text COMMENT '百度云的连接配置信息\n{\n    "tcpEndpoint": "tcp://test.baidu.iot.com",\n    "sslEndpoint": "ssl://test.baidu.iot.com",\n    "username": "endpointName/deviceName",\n    "key":"bWwCxGwaw3boV48NqsuG+XVaHpxfKdMPvmdJzNObvbY="\n}',
  `mqttTopic` text COMMENT '百度云的MQTT主题信息\n{\n	"topicSub":[\n		"$baidu/iot/xxxx/xxxx",\n		"$baidu/iot/xxxx/xxxx"\n		],\n	"topicPub":"$baidu/iot/xxx/xxx"	\n}',
  `writeStatus` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `yx_iot_device`
-- ----------------------------
BEGIN;
INSERT INTO `yx_iot_device` VALUES ('1', null, 'yx_abcde', '柜式新风机【公共测试】', 'gh_0ddfb722a565_c9edd422aafdc95f', 'gh_0ddfb722a565', 'oLSaX0w5y9fETXgBaoghtl3EhcAk', '{\"tcpEndpoint\": \"5ei8cmq.mqtt.iot.gz.baidubce.com\",\"username\": \"5ei8cmq/T01\",\"key\":\"xicPejPU38Y2vh8j\"}', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;