text: -- MySQL dump 10.13  Distrib 5.7.18, for Linux (x86_64)
  --
  -- Host: localhost    Database: nobly
  -- ------------------------------------------------------
  -- Server version	5.7.18
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `auth_group`
  --
  
  DROP TABLE IF EXISTS `auth_group`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_group` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(80) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `auth_group_permissions`
  --
  
  DROP TABLE IF EXISTS `auth_group_permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_group_permissions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `group_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_group_permissions_group_id_0cd325b0_uniq` (`group_id`,`permission_id`),
    KEY `auth_group_permissi_permission_id_84c5c92e_fk_auth_permission_id` (`permission_id`),
    CONSTRAINT `auth_group_permissi_permission_id_84c5c92e_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
    CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `auth_permission`
  --
  
  DROP TABLE IF EXISTS `auth_permission`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_permission` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `content_type_id` int(11) NOT NULL,
    `codename` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_permission_content_type_id_01ab375a_uniq` (`content_type_id`,`codename`),
    CONSTRAINT `auth_permissi_content_type_id_2f476e4b_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `auth_user`
  --
  
  DROP TABLE IF EXISTS `auth_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `password` varchar(128) NOT NULL,
    `last_login` datetime(6) DEFAULT NULL,
    `is_superuser` tinyint(1) NOT NULL,
    `username` varchar(150) NOT NULL,
    `first_name` varchar(30) NOT NULL,
    `last_name` varchar(30) NOT NULL,
    `email` varchar(254) NOT NULL,
    `is_staff` tinyint(1) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `date_joined` datetime(6) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `auth_user_groups`
  --
  
  DROP TABLE IF EXISTS `auth_user_groups`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_user_groups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_user_groups_user_id_94350c0c_uniq` (`user_id`,`group_id`),
    KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
    CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
    CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `auth_user_user_permissions`
  --
  
  DROP TABLE IF EXISTS `auth_user_user_permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `auth_user_user_permissions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `auth_user_user_permissions_user_id_14a6b632_uniq` (`user_id`,`permission_id`),
    KEY `auth_user_user_perm_permission_id_1fbb5f2c_fk_auth_permission_id` (`permission_id`),
    CONSTRAINT `auth_user_user_perm_permission_id_1fbb5f2c_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
    CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `django_content_type`
  --
  
  DROP TABLE IF EXISTS `django_content_type`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `django_content_type` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app_label` varchar(100) NOT NULL,
    `model` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `django_content_type_app_label_76bd3d3b_uniq` (`app_label`,`model`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `django_migrations`
  --
  
  DROP TABLE IF EXISTS `django_migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `django_migrations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `app` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `applied` datetime(6) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `django_session`
  --
  
  DROP TABLE IF EXISTS `django_session`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `django_session` (
    `session_key` varchar(40) NOT NULL,
    `session_data` longtext NOT NULL,
    `expire_date` datetime(6) NOT NULL,
    PRIMARY KEY (`session_key`),
    KEY `django_session_de54fa62` (`expire_date`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_configwarning`
  --
  
  DROP TABLE IF EXISTS `hosts_configwarning`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_configwarning` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) NOT NULL DEFAULT '0',
    `diskwarning` smallint(6) NOT NULL DEFAULT '0',
    `networkwarning` tinyint(4) NOT NULL DEFAULT '0' COMMENT '网速警告百分比',
    `networkwarningtime` varchar(50) NOT NULL DEFAULT '0',
    `cpuwarning` smallint(6) NOT NULL DEFAULT '0',
    `cpuwarningtime` varchar(50) NOT NULL DEFAULT '0',
    `memorywarning` tinyint(4) NOT NULL DEFAULT '0',
    `memorywarningtime` varchar(50) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='被监控主机警告设置';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_information`
  --
  
  DROP TABLE IF EXISTS `hosts_information`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_information` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) DEFAULT NULL,
    `system` varchar(50) DEFAULT NULL COMMENT '系统类型版本',
    `state` varchar(50) DEFAULT NULL COMMENT '是否监听',
    `key` varchar(50) DEFAULT NULL,
    `group` varchar(50) DEFAULT NULL,
    `disk` varchar(50) DEFAULT NULL,
    `cpu` varchar(50) DEFAULT NULL,
    `memmory` varchar(50) DEFAULT NULL,
    `bandwidth` int(11) DEFAULT NULL COMMENT '网络，单位MB',
    `time` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 COMMENT='被监控主机列表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_normal`
  --
  
  DROP TABLE IF EXISTS `hosts_normal`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_normal` (
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT '0',
    `bandwidth` varchar(50) DEFAULT '0',
    `memmory` varchar(50) DEFAULT '0',
    `cpu` varchar(50) DEFAULT '0',
    `newtime` date DEFAULT NULL,
    PRIMARY KEY (`ip`)
  ) ENGINE=InnoDB DEFAULT CHARSET=gb18030 ROW_FORMAT=DYNAMIC;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_normal_all`
  --
  
  DROP TABLE IF EXISTS `hosts_normal_all`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_normal_all` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT '0',
    `bandwidth` varchar(50) DEFAULT '0',
    `memmory` varchar(50) DEFAULT '0',
    `cpu` varchar(50) DEFAULT '0',
    `newtime` date DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=gb18030 ROW_FORMAT=DYNAMIC;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_user`
  --
  
  DROP TABLE IF EXISTS `hosts_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_user` (
    `username` varchar(50) NOT NULL DEFAULT '0',
    `userpass` varchar(50) NOT NULL DEFAULT '0',
    `changepassword` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `level` tinyint(3) unsigned zerofill DEFAULT NULL,
    PRIMARY KEY (`username`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='搁置，没有用';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_userlog`
  --
  
  DROP TABLE IF EXISTS `hosts_userlog`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_userlog` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(50) DEFAULT NULL,
    `Trypass` varchar(50) DEFAULT NULL,
    `time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='监控平台登录记录';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_whoerror`
  --
  
  DROP TABLE IF EXISTS `hosts_whoerror`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_whoerror` (
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT NULL COMMENT '单位M',
    `bandwidth` varchar(50) DEFAULT NULL COMMENT '单位kb',
    `memmory` varchar(50) DEFAULT NULL COMMENT '单位M',
    `cpu` varchar(50) DEFAULT NULL COMMENT '单位百分比',
    `newtime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`ip`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='监控主机警告/错误信息记录';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_whoerror_all`
  --
  
  DROP TABLE IF EXISTS `hosts_whoerror_all`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_whoerror_all` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT NULL COMMENT '单位M',
    `bandwidth` varchar(50) DEFAULT NULL COMMENT '单位kb',
    `memmory` varchar(50) DEFAULT NULL COMMENT '单位M',
    `cpu` varchar(50) DEFAULT NULL COMMENT '单位百分比',
    `newtime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `ip` (`ip`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='监控主机警告/错误信息记录';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_wholesale`
  --
  
  DROP TABLE IF EXISTS `hosts_wholesale`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_wholesale` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) DEFAULT NULL,
    `network` varchar(50) DEFAULT NULL COMMENT '单位kb',
    `cpu` varchar(50) DEFAULT NULL COMMENT '单位百分比',
    `mem` varchar(50) DEFAULT NULL COMMENT 'free:311M,usage:82.9%',
    `disk` varchar(100) DEFAULT NULL COMMENT '单位M',
    `newtime` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `ip` (`ip`)
  ) ENGINE=InnoDB AUTO_INCREMENT=83623 DEFAULT CHARSET=latin1 COMMENT='监控主机信息记录';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_whowarning`
  --
  
  DROP TABLE IF EXISTS `hosts_whowarning`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_whowarning` (
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT '0',
    `bandwidth` varchar(50) DEFAULT '0',
    `memmory` varchar(50) DEFAULT '0',
    `cpu` varchar(50) DEFAULT '0',
    `newtime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`ip`)
  ) ENGINE=InnoDB DEFAULT CHARSET=gb18030;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `hosts_whowarning_all`
  --
  
  DROP TABLE IF EXISTS `hosts_whowarning_all`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `hosts_whowarning_all` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip` varchar(50) NOT NULL,
    `disk` varchar(50) DEFAULT '0',
    `bandwidth` varchar(50) DEFAULT '0',
    `memmory` varchar(50) DEFAULT '0',
    `cpu` varchar(50) DEFAULT '0',
    `newtime` date DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb18030 ROW_FORMAT=DYNAMIC;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2017-07-04 16:23:58
  