/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50540
Source Host           : 127.0.0.1:3306
Source Database       : pushmanagerserver

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

Date: 2017-04-14 22:17:11
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tab_server
-- ----------------------------
DROP TABLE IF EXISTS `tab_server`;
CREATE TABLE `tab_server` (
  `server_id` int(10) NOT NULL AUTO_INCREMENT,
  `host` varchar(15) NOT NULL COMMENT 'ip地址',
  `name` varchar(50) DEFAULT NULL COMMENT '服务器名称',
  `port` int(10) DEFAULT NULL COMMENT 'mima的端口',
  `weight` int(1) DEFAULT NULL COMMENT '权重',
  `state` int(1) DEFAULT NULL COMMENT '状态 1：可用；0：不可用；',
  `http_port` int(10) DEFAULT NULL COMMENT 'http服务的端口',
  `server_name` varchar(50) DEFAULT NULL COMMENT '项目部署名称',
  `servlet_data_request_name` varchar(50) DEFAULT NULL COMMENT '数据请求servlet的名称',
  `reserve` varchar(128) DEFAULT NULL COMMENT '备用字段',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tab_server
-- ----------------------------
INSERT INTO `tab_server` VALUES ('1', '192.168.253.1', '服务器1', '7070', '1', '1', '8080', 'push-server', 'mobiledata', null);
INSERT INTO `tab_server` VALUES ('2', '192.168.253.1', '服务器2', '7070', '2', '0', '8080', 'push-server', 'mobiledata', null);
INSERT INTO `tab_server` VALUES ('3', '192.168.253.1', '服务器3', '7070', '3', '0', '8080', 'push-server', 'mobiledata', null);
INSERT INTO `tab_server` VALUES ('4', '192.168.253.1', '服务器4', '7070', '4', '0', '8080', 'push-server', 'mobiledata', null);
INSERT INTO `tab_server` VALUES ('5', '192.168.253.1', '服务器5', '7070', '5', '0', '8080', 'push-server', 'mobiledata', null);
INSERT INTO `tab_server` VALUES ('6', '192.168.253.1', '服务器6', '7070', '6', '0', '8080', 'push-server', 'mobiledata', null);