电子公文传输系统-冲刺5
任务进度概况
数据库相关代码
点击查看代码
/*
MySQL Data Transfer
Source Host: localhost
Source Database: filedb
Target Host: localhost
Target Database: filedb
Date: 2020-11-25 10:27:33
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_department
-- ----------------------------
CREATE TABLE `t_department` (
`id` int(4) NOT NULL auto_increment,
`departmentname` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_file
-- ----------------------------
CREATE TABLE `t_file` (
`id` int(4) NOT NULL auto_increment,
`title` varchar(50) default NULL,
`remark` varchar(1000) default NULL,
`url` varchar(200) default NULL,
`inputdate` varchar(50) default NULL,
`fromuser` int(4) default NULL,
`touser` int(4) default NULL,
`status` int(4) default NULL,
`typeid` int(4) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_filetype
-- ----------------------------
CREATE TABLE `t_filetype` (
`id` int(4) NOT NULL auto_increment,
`typename` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
CREATE TABLE `t_user` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(50) default NULL,
`password` varchar(50) default NULL,
`realname` varchar(50) default NULL,
`role` varchar(50) default NULL,
`departmentid` int(4) default NULL,
`zhiwei` varchar(50) default NULL,
`tel` varchar(50) default NULL,
`email` varchar(50) default NULL,
`zuzhiid` int(4) default NULL,
`sex` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_zuzhi
-- ----------------------------
CREATE TABLE `t_zuzhi` (
`id` int(4) NOT NULL auto_increment,
`zuzhiname` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `t_department` VALUES ('1', 'A系');
INSERT INTO `t_department` VALUES ('2', 'B系');
INSERT INTO `t_department` VALUES ('3', 'C系');
INSERT INTO `t_department` VALUES ('4', 'D系');
INSERT INTO `t_filetype` VALUES ('1', '绝密');
INSERT INTO `t_filetype` VALUES ('2', '机密');
INSERT INTO `t_filetype` VALUES ('3', '秘密');
INSERT INTO `t_user` VALUES ('1', 'admin', '1', '管理员', '0', null, '', '10000000000', 'admin@163.com', null, '男');
INSERT INTO `t_user` VALUES ('2', '20191308', '1', '初凯旋', '1', '1', '', '13800008888', '1270790453@qq.com', '1', '女');
INSERT INTO `t_user` VALUES ('3', '20191315', '1', '郝嘉乐', '2', '1', '初级职员', '13800000000', 'hjltyom@163.com', '1', '女');
INSERT INTO `t_user` VALUES ('4', '20191316', '1', '王秋雨', '2', '1', '', '13800000000', 'xiaowangwangwang@163.com', '1', '女');
INSERT INTO `t_user` VALUES ('5', '20191329', '1', '马静怡', '1', '2', '初级职员', '13800000000', 'xiugou@163.com', '1', '女');
INSERT INTO `t_user` VALUES ('6', '20191322', '1', '吴泳淋', '2', '1', '工程师', '10010', 'wuxiuxiu@163.com', '2', '男');
INSERT INTO `t_zuzhi` VALUES ('1', '学生会');
INSERT INTO `t_zuzhi` VALUES ('2', '团委');
明日任务计划
