oa/相关文档/YOUTONG/邮通项目管理系统数据库版本更新.sql

ALTER TABLE TMS_PROJECT_INFO ADD proj_book_id VARCHAR(50) ;
ALTER TABLE TMS_PROJECT_INFO ADD proj_big_class BIGINT ;
ALTER TABLE TMS_PROJECT_INFO ADD proj_small_class BIGINT ;
ALTER TABLE TMS_PROJECT_INFO ADD proj_identification VARCHAR(100) ;
ALTER TABLE TMS_PROJECT_INFO ADD act_create_date DATETIME ;
ALTER TABLE TMS_PROJECT_INFO ADD is_temporary INT;
ALTER TABLE TMS_PROJECT_INFO ADD import_project_number INT ;

ALTER TABLE TMS_PROJECT_MANAGE_DEPT ADD level INT;
ALTER TABLE TMS_PROJECT_MANAGE_DEPT ADD is_allocated INT;
ALTER TABLE TMS_PROJECT_MANAGE_DEPT ADD manage_order INT;
ALTER TABLE TMS_PROJECT_MANAGE_DEPT ADD create_date DATETIME;
ALTER TABLE TMS_PROJECT_MANAGE_DEPT ADD distribution_date DATETIME;


ALTER TABLE TMS_PROJECT_HIS_INFO ADD proj_book_id VARCHAR(50) ;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD proj_big_class BIGINT ;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD proj_small_class BIGINT ;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD proj_identification VARCHAR(100) ;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD act_create_date DATETIME ;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD is_temporary INT;
ALTER TABLE TMS_PROJECT_HIS_INFO ADD import_project_number INT ;

ALTER TABLE TMS_WORK_DIARY ADD correct_remark VARCHAR(800) ;
ALTER TABLE TMS_WORK_DIARY ADD correct_detail VARCHAR(200);
ALTER TABLE TMS_WORK_DIARY ADD is_sys_correct_confirm INT ;
ALTER TABLE TMS_WORK_DIARY ADD correct_confirm_time DATETIME ;		

DROP TABLE IF EXISTS `tms_work_diary_log`;
CREATE TABLE `tms_work_diary_log` (
  `universalid` bigint(32) NOT NULL,
  `diary_user_id` bigint(32) NOT NULL,
  `diary_date` datetime NOT NULL,
  `task_id` bigint(32) NOT NULL,
  `normal_flag` int(11) NOT NULL default '0',
  `task_finish_per` int(11) NOT NULL,
  `man_hour` float(11,1) NOT NULL,
  `act_diary_date` datetime NOT NULL,
  `remark` varchar(2000) ,
  `if_au` int(11) NOT NULL default '0',
  `au_user_id` bigint(32) ,
  `au_date` datetime ,
  `au_note` varchar(200) ,
  `task_state` varchar(2) NOT NULL,
  `proj_id` bigint(32) NOT NULL,
  `log_remark` varchar(200) ,
  `work_diary_id` bigint(20) ,
  `correct_remark` varchar(800) ,
  `correct_detail` varchar(200) ,
  `is_sys_correct_confirm` int(11) ,
  PRIMARY KEY  (`universalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tms_project_type`;
CREATE TABLE `tms_project_type` (
  `universalid` bigint(32) NOT NULL,
  `parent_id` bigint(32) NOT NULL,
  `create_date` datetime NOT NULL,
  `type_name` varchar(32) NOT NULL,
  `create_user_id` bigint NOT NULL default '0',
  `remark` varchar(200) ,
  `type_order` int ,
  `lose_flag` int NOT NULL default '0',
  PRIMARY KEY  (`universalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `tms_project_item`;
CREATE TABLE `tms_project_item` (
	`universalid` bigint(20) NOT NULL DEFAULT '0',
	`item_id` varchar(100) ,
	`item_remark` varchar(500) NOT NULL DEFAULT '0',
	`proj_id` bigint(20) NOT NULL DEFAULT '0',
	`create_date` date NOT NULL,
	`item_count` int NOT NULL DEFAULT '0',
	`item_identification` varchar(50) NOT NULL DEFAULT '0',
	`lose_flag` int NOT NULL default '0',
	`create_user_id` bigint(32) NOT NULL,
  PRIMARY KEY (`universalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tms_project_his_item`;
CREATE TABLE `tms_project_his_item`(
	`universalid` bigint(20) NOT NULL DEFAULT '0',
	`item_id` varchar(100) ,
	`item_remark` varchar(500) NOT NULL DEFAULT '0',
	`proj_id` bigint(20) NOT NULL DEFAULT '0',
	`create_date` date NOT NULL ,
	`item_count` int NOT NULL DEFAULT '0',
	`item_identification` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`universalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

------2013-120