/*
Navicat MySQL Data Transfer
Source Host     : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database : ars
Target Host     : bcxin366.mysql.rds.aliyuncs.com:3306
Target Database : ars
Date: 2017/4/4 17:36:13
*/

CREATE TABLE `task_team_person` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `person_id` int(11) DEFAULT NULL COMMENT '人员ID',
  `incharge` bit(1) DEFAULT NULL COMMENT '是否负责人',
  `company_id` int(11) DEFAULT NULL COMMENT '公司ID',
  PRIMARY KEY (`id`),
  KEY `temp_person_temp` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

ALTER TABLE `task`
MODIFY COLUMN `company_id`  int(11) NULL AFTER `native_code`,
MODIFY COLUMN `task_level`  int(11) NULL AFTER `company_id`,
MODIFY COLUMN `task_catalog`  int(11) NULL AFTER `task_type`,
ADD COLUMN `urgenttype`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '紧急程度 1 一般 2 较大 3 重大 4 特别重大' AFTER `end_date`,
ADD COLUMN `neednum`  int(10) NULL DEFAULT NULL COMMENT '需要人数' AFTER `urgenttype`,
ADD COLUMN `urgentdegree`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '紧急程度 1 一般 2 较大 3 重大 4 特别重大' AFTER `neednum`,
ADD COLUMN `peopletype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `urgentdegree`;

