/*
Navicat MySQL Data Transfer

Source Server         : 天翼云
Source Server Version : 100119
Source Host           : 42.123.125.171:3306
Source Database       : dockercluster_paas

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

Date: 2017-05-22 12:36:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for alert_item_table
-- ----------------------------
DROP TABLE IF EXISTS `alert_item_table`;
CREATE TABLE `alert_item_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL DEFAULT '',
  `unit` varchar(16) NOT NULL DEFAULT '',
  `type` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of alert_item_table
-- ----------------------------
INSERT INTO `alert_item_table` VALUES ('3', '内存使用率', '%', 'mem');
INSERT INTO `alert_item_table` VALUES ('4', 'cpu使用率', '%', 'cpu');

-- ----------------------------
-- Table structure for alert_object_table
-- ----------------------------
DROP TABLE IF EXISTS `alert_object_table`;
CREATE TABLE `alert_object_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alert_rule_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `namespace` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of alert_object_table
-- ----------------------------

-- ----------------------------
-- Table structure for alert_rule_object_table
-- ----------------------------
DROP TABLE IF EXISTS `alert_rule_object_table`;
CREATE TABLE `alert_rule_object_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alert_rule_id` int(11) NOT NULL DEFAULT '0',
  `alert_item_id` int(11) NOT NULL DEFAULT '0',
  `max` int(11) NOT NULL DEFAULT '0',
  `min` int(11) NOT NULL DEFAULT '0',
  `opts` varchar(255) NOT NULL DEFAULT '',
  `unit` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '',
  `type_description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of alert_rule_object_table
-- ----------------------------

-- ----------------------------
-- Table structure for alert_rule_table
-- ----------------------------
DROP TABLE IF EXISTS `alert_rule_table`;
CREATE TABLE `alert_rule_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cluster_i_d` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `phone` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `user_name` varchar(255) NOT NULL DEFAULT '',
  `create_time` bigint(20) NOT NULL DEFAULT '0',
  `tenant` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of alert_rule_table
-- ----------------------------

-- ----------------------------
-- Table structure for application_key
-- ----------------------------
DROP TABLE IF EXISTS `application_key`;
CREATE TABLE `application_key` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `public_key` varchar(2550) NOT NULL,
  `private_key` varchar(2550) NOT NULL,
  `passphrase` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of application_key
-- ----------------------------
INSERT INTO `application_key` VALUES ('1', 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCSEmRYA3EXybwzfCG9t0uqsAcLCoUD9lAIzCWaZ3jv58S1slMfShxPZksXIcXs17Zt8+Iohxq21gGX3mxRvOIr95TBwg7mathK4jX1PrpBLha7KiWFUWA5IQ+ojJldc07zGt5onqF3Sm8SPE7IHbG7HUfHTc5lmL/Hx7u6FjbxslHSR9gjxg43NplHucfOQWfGTqoqygRM5D3b23OwzFiHM2kP5BD79TR7/aBug/NOKm7aWX0CfyGsq5SDQgQk0rjo9krVdi+Kj0cU2TAfiQoN8s9zLOZKIOtFaoS9+o6jBsNAI3mHKXtyrk98AinhdTm2vuZR1jCRjVDbdUMjgebH keybox@global_key\n', 'x0wV008oMDazSB7UH8wrvUyIK/prqgDFMHKLNF5GKxPB+b2xBskaPuWBudDKe2RycYGDr+f612WwVjUm4jzUMyvpBRhERvqR8vqoiKGpSJSQuB5nlCfcsX+cdNDS4H3F2oPOgb7NeBv1pJAjBHE+zgJwhkeXD3uYEXHMKUttam4gQukDRk6CAr6rvnoD3Pb3HzDo5+H5gzxwIZ5Yg75Zz2vaOGvc83kj42UzrutbG7WngygSAIHYl7H+rHz6BemrminXX4S8XmmL+7xzX6K3ckpm2rX+gigjGDJQbXYgYHjEwtFhknTbg2GVoKaDBSN6YgjgSsy6M+nCCoB5ZYkDL+jQx/ASb5Tlw82bFc+RhUk+X2TcrtXrL4nHc9XCjNblI2JzjCDgRvgu+y96QO/+rF48irTPBdnpniOW+s085w4UZdCHhGSKcCW6tQxgDqqidyiAx2tAXbsHV7dtXwP8GQoh/IRIYDUhvB7tkB3WEUXXd7uU20VE/xuIownjC1CYSku0HMDrQl9xREaIpLtclVwbmlc8j9cseLjAqcJkld7KgLazUz/FTjYR6lp4M0wGM17QCAu8imLtUfnaLvts57eokRu71vQDVaSxjhQMzz1RYtD6pgBP2i2i61E1oe3TubwKkzNrLjMySNLptO8ozgnCtPJgGZRSf4DIvLL7ZXLiGTQqCDFzQsJilvH3Zd4KJsCKRSxOQFcDYpsr/r+Tanx6SYS3XRaKsDdOjgiqe3LmxjPdy/egmTHp13riyCbke3Bp32oFonRYgpkrOAPwpfyCmilhPM8JQZzkDVAhn0SmOuD7hjO7ol9UcULcAVoruxdnbnDp8QI/5K6mUwXye9/zrGlCxcwxX3HKBo+ojRhvxciv1Z89wQ7cgiL9Hu7wvwOC+sHoLnIQ0K4de7nice6+BL1mSpVY+TVg1mvN/qMWItRs0PZR2UtvIJ/1sQKOPXqf8wdyZieMxmT2nQ69JkYqGQK3gLQ6bnQ2kjZ9gByvBgjrMKb9eg/eZyR+ESFpOjzUO/AuGd8tTiX8kUWhxrHYCZKpkYjn4C4HGgnAVIORLSOlHIvV/WqU5NeaP0xLa1caswUX40mgW4IdahgkREV0jMZndQLxyMuEk7eMMT27YvvURsvHJejPLrjd0a0tlO6DtTjM7+sjveFDO7zx/d7CP+S7zVdYzgTpv762YUNtUlf/D1xZFPAC1bqlrUU3TMFR7Y40u+YXMJLXcYZlXby5spzLDqx5Fqq5ks4wx7pCdjJoHTrcrQ/jRXSQPkpebyV8mmjwOXIPnxcUc0AyX3x2DWhKpdQmLRHGdMMRsAvzxAPzKcqYewb69xAR3arIzhn3TaYvoPRa1JIj0G4dJUyQPNE4VaJjv2xhKYo5maX3xICL92p6Vvc/+nS3UugX+hbW7y68NdyF3Qlou8KMivPuGYSV/JaiTFyWAkHrd/Zjw2X9um67amKFt9fYh37VSDmMOITUEEjS+HnCFgQH+74/Ps/gwuU6VU3upfoOCfW4WwgF8v4uhV3yNWeq4CfTeMeY9ate+XFUMVl3QC5oW92dHyV36Hbn0C6gS+Q0K5C9OUTdjOudfWcdz/SQHIIW5KhbAH6J2HZA4DhdjB/uv1cFByjgOu+3AGUVjpCoGc93kxEq3yuT3lz5yyuXszOjT2k94D9E+pv68M8xNas7sAtVKT4kXew/E96GeEs5duRbD4fov/YSUMwmNADrucqcU4yIU/qfcoo9qWkm+P2++byv0ITwMVZyiv1xVmRs8GI/A/BihvUTZ9d8YkuzqDynJiA5PKHH2PQx3cv+t06/nIufjazQctgfXLlFwUkzQuCLUhQaheqxF96O4v3FuanbXS2eNhoh5dfqb8N594R3kaTzYJoGsHhhQRKPcsQVAt+44hAsMovDu/YL1M230oX/ixHvQx3dwd5D7Gv16y6GegIU1XnsZR+7Xdt37Z3eD06oHymtfMuXizHxxYb0eWJMnrUUFAC4MAw4HH9Z7XnKVnWjy7aIA4IfJnz3XCgPQhFTsFCzguQEdQjs59WfgKShEpRWA7ICToiVlaScxTRo2gAwqfvyUD5Jq1c2fmUW0Ac8v+8v87PZq4U0iCV1F51Qk3YBX1RJ2qiWG5u+X2WjcYNRnygIdociWbt1pH/G0A+bjcA8UL97P8t8g6DRq30DVNBsgWCSl25s/1uyigNyWyOuq3vKKwwiUiJFy0zL+JDbUF5kcYqf2NzRb3V9lZp0MnnfeduAUEy2C3UJ7INFcfAzuCxKhlK26WV2x283WkUgG1i7XZjLMFF0NTvatfj8Sfg4CWZn8rnDIRCBFbxf1kQ7BTxqeDgdrpL6U2Q8FDQ=', 'qhSaT2N7ds7mFDTQ6yYwe/UmBuJf4lXTkX+ZcMeYFmmgH2ukP/kyUSM9g9mSBPpz');

-- ----------------------------
-- Table structure for cluster_config
-- ----------------------------
DROP TABLE IF EXISTS `cluster_config`;
CREATE TABLE `cluster_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cluster_code` varchar(50) DEFAULT NULL COMMENT '集群代码',
  `cluster_name` varchar(100) DEFAULT NULL COMMENT '集群名称',
  `cluster_desc` varchar(200) DEFAULT NULL COMMENT '集群描述',
  `api_server_url` varchar(50) DEFAULT NULL COMMENT 'k8s的master的地址',
  `monitor_url` varchar(50) DEFAULT NULL COMMENT '监控集群的url，包括ip和端口',
  `lvs_url` varchar(50) DEFAULT NULL COMMENT 'lvs平台的ip',
  `state` varchar(3) DEFAULT NULL COMMENT '状态，(保留字段,后续可能会用到)',
  `tenant_code` varchar(50) DEFAULT NULL COMMENT '租户编码',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='集群监控配置表';

-- ----------------------------
-- Records of cluster_config
-- ----------------------------
INSERT INTO `cluster_config` VALUES ('37', 'CTG_DOCKER_ctg_ecloud', '天翼云集群3', null, '42.123.125.171:9090', '42.123.125.170:10002', '42.123.125.173', null, null, '2', '2017-05-17 22:10:31');

-- ----------------------------
-- Table structure for ctg_docker_ctg_ecloud_alert_deal_table
-- ----------------------------
DROP TABLE IF EXISTS `ctg_docker_ctg_ecloud_alert_deal_table`;
CREATE TABLE `ctg_docker_ctg_ecloud_alert_deal_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_occur_time` bigint(20) NOT NULL DEFAULT '0',
  `event_deal_time` bigint(20) NOT NULL DEFAULT '0',
  `alert_type` varchar(16) NOT NULL DEFAULT '',
  `content` varchar(32) NOT NULL DEFAULT '',
  `message` varchar(512) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ctg_docker_ctg_ecloud_alert_deal_table
-- ----------------------------

-- ----------------------------
-- Table structure for ctg_docker_ctg_ecloud_alert_info_table
-- ----------------------------
DROP TABLE IF EXISTS `ctg_docker_ctg_ecloud_alert_info_table`;
CREATE TABLE `ctg_docker_ctg_ecloud_alert_info_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `insert_time` bigint(20) NOT NULL DEFAULT '0',
  `level` varchar(16) NOT NULL DEFAULT '',
  `alert_type` varchar(16) NOT NULL DEFAULT '',
  `namespace` varchar(32) NOT NULL DEFAULT '',
  `content` varchar(64) NOT NULL DEFAULT '',
  `per_num` int(11) NOT NULL DEFAULT '0',
  `rule` varchar(128) NOT NULL DEFAULT '',
  `message` varchar(1024) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ctg_docker_ctg_ecloud_alert_info_table
-- ----------------------------

-- ----------------------------
-- Table structure for docker_image_file
-- ----------------------------
DROP TABLE IF EXISTS `docker_image_file`;
CREATE TABLE `docker_image_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `project_name` varchar(100) DEFAULT NULL COMMENT '项目名称',
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '所属租户编码',
  `app_name` varchar(100) DEFAULT NULL COMMENT '应用名',
  `tite_desc` varchar(200) DEFAULT NULL COMMENT '标题描述',
  `imagepath` varchar(100) DEFAULT NULL COMMENT '图片路径',
  `content` longtext COMMENT '概述',
  `version` varchar(20) DEFAULT NULL COMMENT '最新版本',
  `state` varchar(3) DEFAULT NULL COMMENT '001:正常 002:删除',
  `ntype` varchar(3) DEFAULT NULL COMMENT '001:公共  002:租户',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docker_image_file
-- ----------------------------
INSERT INTO `docker_image_file` VALUES ('4', null, '0', 'tomcat', '', 'tomcat.png', '基础镜像', '7.0.77jdk1.8', '001', '001', null, '2016-11-24 20:24:45', null, '2016-11-24 20:24:45');
INSERT INTO `docker_image_file` VALUES ('340', null, 'ctg-ae', 'demo4', null, 'default.png', null, 'v1.0', '001', '002', '2', '2017-05-16 05:37:37', '2', '2017-05-16 05:38:18');

-- ----------------------------
-- Table structure for docker_image_index
-- ----------------------------
DROP TABLE IF EXISTS `docker_image_index`;
CREATE TABLE `docker_image_index` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `docker_pserver_id` bigint(20) DEFAULT NULL COMMENT '私库资源ID',
  `docker_image_file_id` bigint(20) DEFAULT NULL COMMENT '镜像文件信息ID',
  `image_name` varchar(100) DEFAULT NULL COMMENT '镜像名称',
  `version` varchar(20) DEFAULT NULL COMMENT '版本标识',
  `service_port` varchar(10) DEFAULT NULL COMMENT '服务端口',
  `size` double DEFAULT NULL COMMENT '大小',
  `state` varchar(3) DEFAULT NULL COMMENT '000:不稳定 001:正常 002:删除 003:损坏',
  `content` longtext COMMENT '概述',
  `down_num` bigint(20) DEFAULT NULL COMMENT '申请下载次数',
  `dockerfile` longtext COMMENT '每个镜像版本构建时的dockerfile',
  `source` varchar(3) DEFAULT NULL COMMENT '镜像来源。001：build、002：upload、003：others',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=403 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docker_image_index
-- ----------------------------
INSERT INTO `docker_image_index` VALUES ('3', '19', '4', 'tomcat', '7.0.77jdk1.8', '8080', null, '000', null, null, null, null, null, '2016-11-09 15:11:31', null, '2016-11-09 15:11:31');
INSERT INTO `docker_image_index` VALUES ('402', '19', '340', 'ctg-ae/demo4', 'v1.0', '8080', null, '000', null, null, 'FROM 192.168.0.8:8555/tomcat:7.0.77jdk1.8\n# 此处可添加自定义命令\n#--- Files ---#\nADD buildfiles/ctg-ae/1494941948303/demo4.war /usr/local/apache-tomcat-7.0.77/webapps/\n# 此处可添加自定义命令\nRUN echo \"#!/bin/bash\" > /bin/krun.sh\n# 此处可添加自定义命令\nRUN echo \"source /etc/profile\" >> /bin/krun.sh\nRUN echo \"/usr/local/apache-tomcat-7.0.77/bin/startup.sh &\" >> /bin/krun.sh\nRUN echo \"tail -f /dev/null\" >> /bin/krun.sh\nRUN chmod u+x /bin/krun.sh\n# 此处可添加自定义命令\nCMD [\"/bin/krun.sh\"]', '001', '2', '2017-05-16 05:37:37', '2', '2017-05-16 05:38:18');

-- ----------------------------
-- Table structure for docker_micro_app
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_app`;
CREATE TABLE `docker_micro_app` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `k8s_code` varchar(100) DEFAULT NULL,
  `namespace` varchar(100) DEFAULT NULL COMMENT '租户编码',
  `tenant_code` varchar(100) DEFAULT NULL,
  `create_user_id` bigint(20) DEFAULT NULL,
  `create_time` varchar(100) DEFAULT NULL,
  `last_update_user_id` bigint(20) DEFAULT NULL,
  `last_update_time` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docker_micro_app
-- ----------------------------
INSERT INTO `docker_micro_app` VALUES ('38', 'demo41', 'demo41', 'demo41', 'CTG_DOCKER_ctg_ecloud', 'wupiao-a', null, '2', '2017-05-21 19:16:55', '2', '2017-05-21 19:16:55');

-- ----------------------------
-- Table structure for docker_micro_app_refer
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_app_refer`;
CREATE TABLE `docker_micro_app_refer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(100) DEFAULT NULL COMMENT '分组名',
  `desc_json` longtext COMMENT '依赖描述JSON',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='微服务依赖';

-- ----------------------------
-- Records of docker_micro_app_refer
-- ----------------------------

-- ----------------------------
-- Table structure for docker_micro_group
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_group`;
CREATE TABLE `docker_micro_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `k8s_code` varchar(100) DEFAULT NULL COMMENT '部署集群编码',
  `group_code` varchar(100) DEFAULT NULL COMMENT '分组Code',
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '所属租户code',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='微服务调度分组';

-- ----------------------------
-- Records of docker_micro_group
-- ----------------------------

-- ----------------------------
-- Table structure for docker_micro_group_detail
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_group_detail`;
CREATE TABLE `docker_micro_group_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `docker_micro_group_id` bigint(20) DEFAULT NULL COMMENT '微服务调度分组ID',
  `node_name` varchar(100) DEFAULT NULL COMMENT '节点名称',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='微服务调度分组明细';

-- ----------------------------
-- Records of docker_micro_group_detail
-- ----------------------------

-- ----------------------------
-- Table structure for docker_micro_image
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_image`;
CREATE TABLE `docker_micro_image` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '所属租户code',
  `docker_image_index_id` bigint(20) DEFAULT NULL COMMENT '镜像文件索引ID',
  `build_image_state` varchar(3) DEFAULT NULL COMMENT '构建镜像状态 (000:构建中 001:构建成功 002:构建失败)',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COMMENT='微应用镜像信息表';

-- ----------------------------
-- Records of docker_micro_image
-- ----------------------------
INSERT INTO `docker_micro_image` VALUES ('207', 'ctg-ae', '402', '001', '2', '2017-05-16 05:37:37', '2', '2017-05-16 05:38:18');

-- ----------------------------
-- Table structure for docker_micro_image_content
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_image_content`;
CREATE TABLE `docker_micro_image_content` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '所属租户code',
  `docker_micro_image_id` bigint(20) DEFAULT NULL COMMENT '应用镜像信息id',
  `upload_file` varchar(250) DEFAULT NULL COMMENT '上传文件',
  `container_path` varchar(250) DEFAULT NULL COMMENT '存放容器路径',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=328 DEFAULT CHARSET=utf8 COMMENT='微应用镜像内容表';

-- ----------------------------
-- Records of docker_micro_image_content
-- ----------------------------
INSERT INTO `docker_micro_image_content` VALUES ('327', 'ctg-ae', '207', 'demo4.war', '/usr/local/apache-tomcat-7.0.77/webapps/', '2', '2017-05-16 05:37:37', '2', '2017-05-16 05:37:37');

-- ----------------------------
-- Table structure for docker_micro_service
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_service`;
CREATE TABLE `docker_micro_service` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL COMMENT '编码',
  `docker_micro_app_id` varchar(100) DEFAULT NULL COMMENT '应用名称',
  `url` varchar(100) DEFAULT NULL,
  `lvs_service_name` varchar(100) DEFAULT NULL,
  `k8s_code` varchar(100) DEFAULT NULL,
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '所属租户code',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(100) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='微应用管理表';

-- ----------------------------
-- Records of docker_micro_service
-- ----------------------------
INSERT INTO `docker_micro_service` VALUES ('90', 'service1', '38', null, '2-demo41-service1', 'CTG_DOCKER_ctg_ecloud', null, '2', '2017-05-21 19:16:55', '2', '2017-05-21 19:16:55');

-- ----------------------------
-- Table structure for docker_micro_version
-- ----------------------------
DROP TABLE IF EXISTS `docker_micro_version`;
CREATE TABLE `docker_micro_version` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `docker_micro_service_id` bigint(20) DEFAULT NULL COMMENT '应用管理ID',
  `docker_image_index_id` bigint(20) DEFAULT NULL COMMENT '应用镜像信息ID',
  `rc_name` varchar(100) DEFAULT NULL COMMENT 'rc名称',
  `k8s_code` varchar(100) DEFAULT NULL,
  `namespace` varchar(100) DEFAULT NULL,
  `replicas` int(11) DEFAULT NULL,
  `yaml_content` longtext,
  `state` varchar(3) DEFAULT NULL,
  `release_state` varchar(3) DEFAULT NULL,
  `release_desc` text,
  `is_auto_elastic` int(1) DEFAULT NULL COMMENT '是否启用自动伸缩(0否    1启用)',
  `elastic_indicator` varchar(3) DEFAULT NULL COMMENT '伸缩指标（001时间周期，002 CPU使用量，003内存使用量）',
  `min_pod_num` int(11) DEFAULT NULL COMMENT 'POD实例数',
  `max_pod_num` int(11) DEFAULT NULL,
  `max_cpu` int(11) DEFAULT NULL,
  `elastic_start_time` varchar(100) DEFAULT NULL COMMENT '自动伸缩开始时间',
  `elastic_end_time` varchar(100) DEFAULT NULL COMMENT '自动伸缩结束时间',
  `time_rate` varchar(3) DEFAULT NULL COMMENT '时间频率（001一次，002每日，003每周，004每月，005每年）',
  `elastic_state` varchar(3) DEFAULT NULL,
  `tenant_code` varchar(100) DEFAULT NULL COMMENT '发布状态(001：创建中 002：发布成功 003：发布失败)',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(100) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=utf8 COMMENT='微应用管理明细表';

-- ----------------------------
-- Records of docker_micro_version
-- ----------------------------
INSERT INTO `docker_micro_version` VALUES ('438', '90', '402', '2-service1-438', 'CTG_DOCKER_ctg_ecloud', 'wupiao-a', '1', 'apiVersion: v1\nkind: ReplicationController\nmetadata:\n  name: 2-service1-438\n  namespace: wupiao-a\nspec:\n  replicas: 1\n  selector:\n    name: 2-service1-438\n  template:\n    metadata:\n      labels:\n        name: 2-service1-438\n        servicename: 2-demo41-service1\n        source: console\n        serviceport: \'8080\'\n    spec:\n      containers:\n        - image: \'192.168.0.8:8555/ctg-ae/demo4:v1.0\'\n          name: 2-service1-438\n          resources:\n            limits:\n              memory: 1111M\n              cpu: \'0.2\'\n            requests:\n              cpu: \'0.2\'\n', '001', '002', 'deploy success', '0', null, null, null, null, null, null, null, null, null, '2', '2017-05-21 19:16:55', '2', '2017-05-21 19:16:55');

-- ----------------------------
-- Table structure for docker_pserver
-- ----------------------------
DROP TABLE IF EXISTS `docker_pserver`;
CREATE TABLE `docker_pserver` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `ipaddress` varchar(100) DEFAULT NULL COMMENT '服务IP地址',
  `port` varchar(10) DEFAULT NULL COMMENT '服务端口',
  `volume` double DEFAULT NULL COMMENT '容量',
  `groups_id` bigint(20) DEFAULT NULL COMMENT '分组id',
  `content` longtext COMMENT '概述',
  `state` varchar(3) DEFAULT NULL COMMENT '001：正常  002：暂停 003：故障 004：移除',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '最后更新人',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docker_pserver
-- ----------------------------
INSERT INTO `docker_pserver` VALUES ('19', '192.168.0.8', '192.168.0.8', '8555', '20', '17', null, '001', null, '2016-11-01 17:13:02', null, '2016-11-01 17:13:02');

-- ----------------------------
-- Table structure for docker_server_groups
-- ----------------------------
DROP TABLE IF EXISTS `docker_server_groups`;
CREATE TABLE `docker_server_groups` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `cnum` int(11) DEFAULT NULL COMMENT '复制数',
  `state` varchar(3) DEFAULT NULL COMMENT '启用状态 001:只读  002:读写',
  `volume` double DEFAULT NULL COMMENT '容量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of docker_server_groups
-- ----------------------------
INSERT INTO `docker_server_groups` VALUES ('17', '读写组1', '1', '002', '50');

-- ----------------------------
-- Table structure for k8s_namespace
-- ----------------------------
DROP TABLE IF EXISTS `k8s_namespace`;
CREATE TABLE `k8s_namespace` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cluster_code` varchar(50) NOT NULL COMMENT '集群编码',
  `namespace_name` varchar(100) DEFAULT NULL COMMENT '命名空间名称',
  `namespace_code` varchar(100) DEFAULT NULL COMMENT '命名空间编码',
  `cpu_quota` int(11) DEFAULT NULL COMMENT 'cpu配额',
  `memory_quota` int(11) DEFAULT NULL COMMENT '内存配额',
  `pod_quota` int(11) DEFAULT NULL COMMENT 'pod配额，即该namespace下最大的pod数',
  `rc_quota` int(11) DEFAULT NULL COMMENT 'rc配额，即该namespace下最大的rc数',
  `namespace_yaml` longtext COMMENT '命名空间yaml内容',
  `quota_yaml` longtext COMMENT '资源配额yaml内容',
  `limits_yaml` longtext COMMENT '资源限制yaml内容',
  `status` varchar(3) DEFAULT NULL COMMENT '状态。001创建中  002创建成功 003创建失败 ',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建用户id',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_user_id` bigint(20) DEFAULT NULL COMMENT '更新用户id',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of k8s_namespace
-- ----------------------------
INSERT INTO `k8s_namespace` VALUES ('19', 'CTG_DOCKER_ctg_ecloud', 'wupiao-a', 'wupiao-a', '2', '2000', '111', '111', 'apiVersion: v1\nkind: Namespace\nmetadata:\n  name: wupiao-a\n', 'apiVersion: v1\nkind: ResourceQuota\nmetadata:\n  name: quota-wupiao-a\nspec:\n  hard:\n    resourcequotas: \'1\'\n    limits.cpu: \'2\'\n    limits.memory: 2000M\n    persistentvolumeclaims: \'40\'\n    pods: \'111\'\n    services: \'20\'\n    replicationcontrollers: \'111\'\n    secrets: \'40\'\n', 'apiVersion: v1\nkind: LimitRange\nmetadata:\n  name: limits-wupiao-a\nspec:\n  limits:\n    - default:\n        memory: 512M\n        cpu: \'100\'\n      type: Container\n', '002', '2', '2017-05-18 02:36:42', '2', '2017-05-18 02:36:42');
INSERT INTO `k8s_namespace` VALUES ('20', 'CTG_DOCKER_ctg_ecloud', 'wupiao-b', 'wupiao-b', '2', '2000', '111', '111', 'apiVersion: v1\nkind: Namespace\nmetadata:\n  name: wupiao-b\n', 'apiVersion: v1\nkind: ResourceQuota\nmetadata:\n  name: quota-wupiao-b\nspec:\n  hard:\n    resourcequotas: \'1\'\n    limits.cpu: \'2\'\n    limits.memory: 2000M\n    persistentvolumeclaims: \'40\'\n    pods: \'111\'\n    services: \'20\'\n    replicationcontrollers: \'111\'\n    secrets: \'40\'\n', 'apiVersion: v1\nkind: LimitRange\nmetadata:\n  name: limits-wupiao-b\nspec:\n  limits:\n    - default:\n        memory: 512M\n        cpu: \'100\'\n      type: Container\n', '002', '2', '2017-05-18 02:36:59', '2', '2017-05-18 02:36:59');

-- ----------------------------
-- Table structure for k8s_operation_record
-- ----------------------------
DROP TABLE IF EXISTS `k8s_operation_record`;
CREATE TABLE `k8s_operation_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `k8s_url` varchar(100) NOT NULL COMMENT '集群master的地址',
  `namespace` varchar(50) NOT NULL COMMENT 'k8s的命名空间，默认是default',
  `operation_object` varchar(20) NOT NULL COMMENT '操作类型，例如 rc、pod、node',
  `operation_id` varchar(100) NOT NULL COMMENT '操作id  ，可能包括rc名称、pod名称',
  `operation_type` varchar(50) NOT NULL COMMENT '操作类型，例如 重启、扩缩容、删除',
  `replicas` int(5) DEFAULT NULL COMMENT '实例数',
  `status` varchar(3) NOT NULL COMMENT '执行状态。001执行中 002执行成功 003执行失败',
  `create_time` varchar(19) DEFAULT NULL COMMENT '创建时间',
  `last_update_time` varchar(19) DEFAULT NULL COMMENT '最后一次更新时间',
  `lock_version` int(11) DEFAULT NULL COMMENT '乐观锁版本',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='操作记录表，包括rc、pod、node的一些操作。';

-- ----------------------------
-- Records of k8s_operation_record
-- ----------------------------

-- ----------------------------
-- Table structure for session_log
-- ----------------------------
DROP TABLE IF EXISTS `session_log`;
CREATE TABLE `session_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `session_tm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1027 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of session_log
-- ----------------------------

-- ----------------------------
-- Table structure for status
-- ----------------------------
DROP TABLE IF EXISTS `status`;
CREATE TABLE `status` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `status_cd` varchar(255) NOT NULL DEFAULT 'INITIAL',
  PRIMARY KEY (`id`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of status
-- ----------------------------
INSERT INTO `status` VALUES ('2', '1', 'SUCCESS');

-- ----------------------------
-- Table structure for system
-- ----------------------------
DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `display_nm` varchar(255) DEFAULT NULL,
  `user` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `host` varchar(255) NOT NULL,
  `port` int(11) NOT NULL,
  `authorized_keys` varchar(255) NOT NULL,
  `status_cd` varchar(255) NOT NULL DEFAULT 'INITIAL',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of system
-- ----------------------------

-- ----------------------------
-- Table structure for system_notice
-- ----------------------------
DROP TABLE IF EXISTS `system_notice`;
CREATE TABLE `system_notice` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `notice_type` varchar(50) DEFAULT NULL COMMENT '通知类型',
  `notice_type_name` varchar(100) DEFAULT NULL COMMENT '通知类型中文名称',
  `notice_content` varchar(1000) DEFAULT NULL COMMENT '通知内容',
  `notice_user_id` bigint(20) DEFAULT NULL COMMENT '需要被通知的用户的id',
  `notice_state` varchar(3) DEFAULT NULL COMMENT '通知状态。001代表未读、002已读',
  `notice_time` varchar(19) DEFAULT NULL COMMENT '产生此条通知的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of system_notice
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) NOT NULL COMMENT '姓名',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `auth_token` varchar(255) DEFAULT NULL COMMENT 'token',
  `status` varchar(3) NOT NULL COMMENT '状态。001有效 002无效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'root', 'root', '01b9ba37-b65e-4d86-962c-0c5c344c2a1f', '001');
SET FOREIGN_KEY_CHECKS=1;