大唐任务管理系统(struts+hibernate)

-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.51a-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema cattsoft -- CREATE DATABASE IF NOT EXISTS cattsoft; USE cattsoft; -- -- Definition of table `task` -- DROP TABLE IF EXISTS `task`; CREATE TABLE `task` ( `TID` int(11) NOT NULL auto_increment COMMENT '任务ID', `TNAME` varchar(20) NOT NULL COMMENT '任务名称', `TDESCRIPTION` varchar(50) default NULL COMMENT '任务描述', `TSTART_TIME` date default NULL COMMENT '任务开始时间', `TEND_TIME` date default NULL COMMENT '任务结束时间', `TUID` int(11) default NULL COMMENT '执行员工ID', `TSTATE` int(11) unsigned default NULL COMMENT '‘0’代表未实施，‘1’代表实施中，‘2’代表以完成', `TPID` int(11) default NULL COMMENT '发布人的ID', PRIMARY KEY (`TID`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='任务表'; -- -- Dumping data for table `task` -- /*!40000 ALTER TABLE `task` DISABLE KEYS */; INSERT INTO `task` (`TID`,`TNAME`,`TDESCRIPTION`,`TSTART_TIME`,`TEND_TIME`,`TUID`,`TSTATE`,`TPID`) VALUES (24,'111','111','2009-08-04','2009-08-04',0,0,25), (25,'222','222','2009-08-04','2009-08-04',29,0,25), (26,'333','333','2009-08-05','2009-08-05',28,0,25), (27,'444','444','2009-08-01','2009-08-02',30,0,25), (28,'555','555','2009-08-01','2009-08-01',29,2,25); /*!40000 ALTER TABLE `task` ENABLE KEYS */; -- -- Definition of table `tscheme` -- DROP TABLE IF EXISTS `tscheme`; CREATE TABLE `tscheme` ( `SID` int(11) NOT NULL auto_increment COMMENT '计划ID', `SNAME` varchar(20) NOT NULL COMMENT '计划名称', `SDESCRIPTION` varchar(50) default NULL COMMENT '计划描述', `START_TIME` date default NULL COMMENT '计划开始时间', `SEND_TIME` date default NULL COMMENT '计划结束时间', `STATE` char(1) default NULL COMMENT '计划状态，‘0’代表未实施，‘1’代表实施中，‘2’代表已完成', `SIS_FEEDBACK` int(11) unsigned default NULL COMMENT '0代表没有,1代表有', `FEEDBACK` varchar(50) default NULL COMMENT '反馈信息', `STID` int(11) default NULL COMMENT '任务ID', PRIMARY KEY (`SID`), KEY `FK_scheme_taskid` (`STID`), CONSTRAINT `FK_scheme_taskid` FOREIGN KEY (`STID`) REFERENCES `task` (`TID`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='计划'; -- -- Dumping data for table `tscheme` -- /*!40000 ALTER TABLE `tscheme` DISABLE KEYS */; INSERT INTO `tscheme` (`SID`,`SNAME`,`SDESCRIPTION`,`START_TIME`,`SEND_TIME`,`STATE`,`SIS_FEEDBACK`,`FEEDBACK`,`STID`) VALUES (1,'动脑经想','这个任务很复杂','2009-11-02','2009-11-14','1',1,'嘎嘎',25), (2,'天下第二','你就是二','2009-08-04','2009-08-05','2',1,'baichi',25); /*!40000 ALTER TABLE `tscheme` ENABLE KEYS */; -- -- Definition of table `tuser` -- DROP TABLE IF EXISTS `tuser`; CREATE TABLE `tuser` ( `UID` int(11) NOT NULL auto_increment COMMENT '用户ID', `USERNAME` varchar(20) NOT NULL COMMENT '用户名', `UPASSWORD` varchar(16) NOT NULL COMMENT '密码', `UMANAGER` int(11) default NULL COMMENT '主管ID', `UNAME` varchar(30) default NULL COMMENT '真实姓名', `USEX` char(1) character set ucs2 default NULL COMMENT '性别', `UBIRTHDAY` date default NULL COMMENT '生日', `UJOB` varchar(10) default NULL COMMENT '职位', `UWORKTIME` date default NULL COMMENT '入职时间', `UPART` varchar(10) default NULL COMMENT 'admin代表管理员，comp代表主管，staff代表员工', `UGEGREE` varchar(10) default NULL COMMENT '学历', `USPECIALITY` varchar(10) default NULL COMMENT '专业', `ULIVE` text COMMENT '工作经历', PRIMARY KEY (`UID`), KEY `FK_tuser_MGR` (`UMANAGER`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='用户表'; -- -- Dumping data for table `tuser` -- /*!40000 ALTER TABLE `tuser` DISABLE KEYS */; INSERT INTO `tuser` (`UID`,`USERNAME`,`UPASSWORD`,`UMANAGER`,`UNAME`,`USEX`,`UBIRTHDAY`,`UJOB`,`UWORKTIME`,`UPART`,`UGEGREE`,`USPECIALITY`,`ULIVE`) VALUES (1,'admin','adminPwd',0,'张文君','男','1988-03-02','将军','1999-09-09','admin','叫兽','统治+暴政','宁要我负天下人,莫要天下人负我'), (2,'boss','bossPwd',1,'胡禁掏','男','1961-01-08','主管','2000-01-01','comp','博士','土木','锄禾日当午,汗滴禾下土'), (25,'zhangjie','111111',0,'张杰','男','2009-08-04','仓库主管','2009-08-04','comp','高中','看门','看你的门吧'), (28,'zhangsan','222222',25,'张三','男','2009-08-04','仓库工人','2009-08-05','staff','小学','扫地','扫地扫地'), (29,'lisi','111111',2,'李四','女','2009-08-03','人事部员工','2009-08-04','staff','小学','星探','招人用的'), (30,'wulinlin','111111',25,'吴琳琳','女','2009-08-03','秘书','2009-08-04','staff','中学','打字','小秘书'), (31,'pangdongzi','22222',33,'潘冬子','女','2009-08-01','卫生员','2009-08-04','staff','文盲','拖地','拖地不错'), (32,'lixiangyang','333333',2,'李向阳','男','2009-08-03','人事部员工','2009-08-01','staff','文盲','擦玻璃','俺是土匪出身'), (33,'chenyan','123456',0,'陈妍','女','1999-10-13','企划部部长','2008-04-01','comp','大学','商业企划','她是趁眼'); /*!40000 ALTER TABLE `tuser` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;