/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50144
 Source Host           : 127.0.0.1
 Source Database       : manage_system_team

 Target Server Type    : MySQL
 Target Server Version : 50144
 File Encoding         : utf-8

 Date: 07/29/2014 13:33:25 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `db_department`
-- ----------------------------
DROP TABLE IF EXISTS `db_department`;
CREATE TABLE `db_department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ctime` datetime NOT NULL,
  `mtime` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `db_department`
-- ----------------------------
BEGIN;
INSERT INTO `db_department` VALUES ('1', '2014-07-26 17:34:24', '2014-07-26 17:34:25', '开发'), ('2', '2014-07-26 17:34:49', '2014-07-26 17:34:51', '测试'), ('3', '2014-07-26 17:35:01', '2014-07-26 17:35:03', '运营'), ('4', '2014-07-28 21:12:49', '2014-07-28 21:12:51', '产品');
COMMIT;

-- ----------------------------
--  Table structure for `db_issue`
-- ----------------------------
DROP TABLE IF EXISTS `db_issue`;
CREATE TABLE `db_issue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `ctime` datetime NOT NULL COMMENT '创建时间',
  `mtime` datetime NOT NULL COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '需求名称',
  `description` text NOT NULL COMMENT '需求描述',
  `needer` int(11) NOT NULL COMMENT '需求人',
  `developer` int(11) NOT NULL COMMENT '需求开发负责人',
  `tester` int(11) NOT NULL COMMENT '测试人',
  `require_time` datetime NOT NULL COMMENT '需求提出时间',
  `require_confirm_time` datetime NOT NULL COMMENT '需求确认时间',
  `cancel_require_time` datetime NOT NULL COMMENT '需求取消时间',
  `develop_time` datetime NOT NULL COMMENT '开始开发时间',
  `submit_test_time` datetime NOT NULL COMMENT '提交测试时间',
  `wait_online_time` datetime NOT NULL COMMENT '等待上线时间',
  `online_time` datetime NOT NULL COMMENT '上线时间',
  `jira_url` varchar(1000) NOT NULL COMMENT 'jira对应的url',
  `status` int(11) NOT NULL,
  `critical` tinyint(3) NOT NULL DEFAULT '2' COMMENT '1 低 绿 2 中 黄 3 高 红',
  `server_code` text NOT NULL COMMENT '该功能点对应的服务端代码位置',
  `possible_effect` text NOT NULL COMMENT '该功能点的可能影响的功能',
  `self_test_content` text NOT NULL COMMENT '自测内容',
  `self_test_problem` text NOT NULL COMMENT '自测中发现的问题',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `db_issue`
-- ----------------------------

-- ----------------------------
--  Table structure for `db_issue_status`
-- ----------------------------
DROP TABLE IF EXISTS `db_issue_status`;
CREATE TABLE `db_issue_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ctime` datetime NOT NULL COMMENT '创建时间',
  `mtime` datetime NOT NULL COMMENT '修改时间',
  `status` int(11) NOT NULL COMMENT '状态码',
  `description` varchar(100) NOT NULL COMMENT '状态描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `db_issue_status`
-- ----------------------------
BEGIN;
INSERT INTO `db_issue_status` VALUES ('1', '2014-07-26 16:33:51', '2014-07-26 16:33:53', '1', '提出需求'), ('2', '2014-07-26 16:34:31', '2014-07-26 16:34:33', '2', '取消需求'), ('3', '2014-07-26 16:34:42', '2014-07-26 16:34:44', '3', '需求已确认'), ('4', '2014-07-26 16:35:10', '2014-07-26 16:35:13', '4', '正在开发'), ('5', '2014-07-26 16:35:23', '2014-07-26 16:35:25', '5', '提交测试'), ('6', '2014-07-26 16:35:54', '2014-07-26 16:35:56', '6', '等待上线'), ('7', '2014-07-26 16:36:05', '2014-07-26 16:36:07', '7', '已上线'), ('8', '2014-07-26 19:24:27', '2014-07-26 19:24:29', '8', '删除');
COMMIT;

-- ----------------------------
--  Table structure for `db_people`
-- ----------------------------
DROP TABLE IF EXISTS `db_people`;
CREATE TABLE `db_people` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `ctime` datetime NOT NULL COMMENT '创建时间',
  `mtime` datetime NOT NULL COMMENT '修改时间',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `email` varchar(256) NOT NULL COMMENT '邮件地址',
  `department` int(11) NOT NULL COMMENT '部门id',
  `nickname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;