ALTER TABLE `bs_projects_defects`  ADD COLUMN `name` varchar(100)  AFTER `id`;
ALTER TABLE `bs_task_records`  ADD COLUMN `exec_date` int(10)  AFTER `type`;

CREATE TABLE `bs_members_score_record` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `score_value` int(11) NOT NULL DEFAULT '0',
  `score_info` varchar(255) DEFAULT NULL,
  `dateline` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `score_type` int(11) DEFAULT NULL COMMENT '1-考勤 2-绩效 3-其他',
  `score_year` int(11) DEFAULT '0' COMMENT '积分日期',
  `score_step` int(11) DEFAULT '1',
  `score_balance` int(11) DEFAULT '0' COMMENT '余额',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;



ALTER TABLE `bs_members`  ADD COLUMN `score` int(11)  AFTER `modified`;
ALTER TABLE `bs_members`  ADD COLUMN `level` int(11)  AFTER `score`;
ALTER TABLE `bs_members`  ADD COLUMN `score_total` int(11)  AFTER `level`;

ALTER TABLE `bs_projects`  ADD COLUMN `content` text  AFTER `type`;

CREATE TABLE `bs_projects_task_attachment` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务编号',
  `att_name` varchar(255) DEFAULT NULL COMMENT '附件名称',
  `att_url` varchar(255) DEFAULT NULL COMMENT '附件地址',
  `dateline` int(10) DEFAULT NULL COMMENT '上传时间',
  `user_id` int(11) DEFAULT NULL COMMENT '用户',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


ALTER TABLE `bs_projects_task`  ADD COLUMN `category` int(11)  AFTER `projects_id`  DEFAULT '0' comment '任务类别 0任务 1缺陷';

CREATE TABLE `bs_work_logs` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户编号',
  `content` text COMMENT '日志内容',
  `dateline` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='工作日志';

CREATE TABLE `bs_work_logs_attachment` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `log_id` int(11) NOT NULL DEFAULT '0' COMMENT '日志编号',
  `att_name` varchar(255) DEFAULT NULL COMMENT '附件名称',
  `att_url` varchar(255) DEFAULT NULL COMMENT '附件地址',
  `dateline` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL COMMENT '用户',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='工作日志附件';

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`127.0.0.1` SQL SECURITY DEFINER VIEW `bs_view_records` AS select `t1`.`id` AS `id`,`t1`.`tid` AS `tid`,`t1`.`mid` AS `mid`,`t1`.`description` AS `description`,`t1`.`content` AS `content`,`t1`.`dateline` AS `dateline`,`t1`.`type` AS `type`,`t1`.`exec_date` AS `exec_date`,`t2`.`task_name` AS `task_name`,`t2`.`members_id` AS `user_id`,`t3`.`name` AS `proname` from ((`bs_task_records` `t1` join `bs_projects_task` `t2` on(((`t1`.`tid` = `t2`.`id`) and (`t1`.`type` = 2)))) join `bs_projects` `t3` on((`t2`.`projects_id` = `t3`.`id`)));