/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50731
Source Host           : 10.201.44.26:3306
Source Database       : scbc_cts

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

Date: 2020-10-28 16:46:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for branch
-- ----------------------------
DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` (
  `name` varchar(255) NOT NULL COMMENT '分支名称',
  `quarter` varchar(255) DEFAULT NULL COMMENT '分支所属季度',
  `address` varchar(255) DEFAULT NULL COMMENT '分支地址(gerrit)',
  `provider` varchar(255) DEFAULT NULL COMMENT '分支供应商',
  `chip` varchar(255) DEFAULT NULL COMMENT '分支机芯方案',
  `type` varchar(255) DEFAULT NULL COMMENT '分支类型：主干、CTS、量产、ODF',
  `status` varchar(255) DEFAULT NULL COMMENT '分支状态：在用、停用',
  `note` varchar(255) DEFAULT NULL COMMENT '分支备注',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for brand
-- ----------------------------
DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand` (
  `name` varchar(255) NOT NULL COMMENT '品牌名称',
  `note` varchar(255) DEFAULT '' COMMENT '品牌备注',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for provider
-- ----------------------------
DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
  `name` varchar(255) NOT NULL COMMENT '供应商',
  `note` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for quarter
-- ----------------------------
DROP TABLE IF EXISTS `quarter`;
CREATE TABLE `quarter` (
  `name` varchar(255) NOT NULL COMMENT '季度名称',
  `scp` varchar(255) DEFAULT NULL COMMENT 'SecurityPatch',
  `note` varchar(255) DEFAULT NULL COMMENT '季度备注',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for server
-- ----------------------------
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
  `name` varchar(255) NOT NULL COMMENT '服务器名称',
  `ip` varchar(255) DEFAULT NULL COMMENT '服务器IP地址',
  `type` varchar(255) DEFAULT NULL COMMENT '服务器类型',
  `user` varchar(255) DEFAULT NULL COMMENT '服务器账号',
  `password` varchar(255) DEFAULT NULL COMMENT '服务器密码',
  `note` varchar(255) DEFAULT NULL COMMENT '服务器备注',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user` varchar(255) NOT NULL COMMENT '软件账号',
  `password` varchar(255) DEFAULT NULL COMMENT '软件账号密码',
  `permission` varchar(255) DEFAULT NULL COMMENT '软件权限',
  PRIMARY KEY (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;