/* Navicat MySQL Data Transfer Source Server : chance Source Server Version : 1508 Source Host : localhost:3306 Source Database : oasystem Target Server Type : MYSQL Target Server Version : 110 File Encoding : 65001 Date: 2020-10-22 09:06:50 */
SET FOREIGN_KEY_CHECKS=0;
-- ---------------------------- -- Table structure for t_accessoryfile -- ---------------------------- DROP TABLE IF EXISTS `t_accessoryfile`; CREATE TABLE `t_accessoryfile` ( `t_accessoryfile_id` int(11) NOT NULL, `t_fileinfo_id` int(11) DEFAULT NULL, `t_accessoryfile_name` varchar(50) DEFAULT NULL, `t_accessoryfile_size` int(11) DEFAULT NULL, `t_fileinfo_filetypeid` int(11) DEFAULT NULL, `t_accessoryfile_createdate` datetime DEFAULT NULL, `t_accessoryfile_path` varchar(200) DEFAULT NULL, PRIMARY KEY (`t_accessoryfile_id`), KEY `fk_t_fileinfo_id` (`t_fileinfo_id`), KEY `t_fileinfo_filetypeid` (`t_fileinfo_filetypeid`), CONSTRAINT `fk_t_fileinfo_id` FOREIGN KEY (`t_fileinfo_id`) REFERENCES `t_fileinfo` (`t_fileinfo_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `t_accessoryfile_ibfk_1` FOREIGN KEY (`t_fileinfo_filetypeid`) REFERENCES `t_filetypeinfo` (`t_fileinfo_filetypeid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_accessoryfile -- ---------------------------- INSERT INTO `t_accessoryfile` VALUES ('1', '1', '文档txt', '30', '1', '2017-06-02 15:09:53', 'D://jhojhojknkj'); INSERT INTO `t_accessoryfile` VALUES ('3', '3', '文件excel', '100', '3', '2017-06-02 15:11:03', 'D://jhojhojknkj');
-- ---------------------------- -- Table structure for t_branchinfo -- ---------------------------- DROP TABLE IF EXISTS `t_branchinfo`; CREATE TABLE `t_branchinfo` ( `t_branchinfo_id` int(11) NOT NULL, `t_branchinfo_name` varchar(50) DEFAULT NULL, `t_branchinfo_shortname` varchar(50) DEFAULT NULL, PRIMARY KEY (`t_branchinfo_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_branchinfo -- ---------------------------- INSERT INTO `t_branchinfo` VALUES ('1', '中科院上海微系统所', '微系统所'); INSERT INTO `t_branchinfo` VALUES ('2', '中国科学院声学研究所', '中科声研究所'); INSERT INTO `t_branchinfo` VALUES ('3', '华利达集团', '华利达'); INSERT INTO `t_branchinfo` VALUES ('4', '苗子文化', '苗子');
-- ---------------------------- -- Table structure for t_departinfo -- ---------------------------- DROP TABLE IF EXISTS `t_departinfo`; CREATE TABLE `t_departinfo` ( `t_departinfo_id` int(11) NOT NULL, `t_departinfo_name` varchar(50) DEFAULT NULL, `t_userinfo_id` int(11) DEFAULT NULL, `t_departinfo_tel` bigint(20) DEFAULT NULL, `t_departinfo_mobiletel` bigint(20) DEFAULT NULL, `t_departinfo_faxes` bigint(20) DEFAULT NULL, `t_branchinfo_id` int(11) DEFAULT NULL, PRIMARY KEY (`t_departinfo_id`), KEY `fk_t_userinfo_id` (`t_userinfo_id`), KEY `fk_t_branchinfo_id` (`t_branchinfo_id`), CONSTRAINT `fk_t_branchinfo_id` FOREIGN KEY (`t_branchinfo_id`) REFERENCES `t_branchinfo` (`t_branchinfo_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_t_userinfo_id` FOREIGN KEY (`t_userinfo_id`) REFERENCES `t_userinfo` (`t_userinfo_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_departinfo -- ---------------------------- INSERT INTO `t_departinfo` VALUES ('1', '研发部', '1', '87784070', '18200291077', '87784070', '1'); INSERT INTO `t_departinfo` VALUES ('2', '销售部', '2', '87784000', '18200291076', '87784000', '2'); INSERT INTO `t_departinfo` VALUES ('3', '财务部', '3', '87700000', '18200291075', '87700000', '3'); INSERT INTO `t_departinfo` VALUES ('4', '技术部', '4', '87000000', '18200291074', '8700000', '4');
-- ---------------------------- -- Table structure for t_fileinfo -- ---------------------------- DROP TABLE IF EXISTS `t_fileinfo`; CREATE TABLE `t_fileinfo` ( `t_fileinfo_id` int(11) NOT NULL, `t_fileinfo_name` varchar(50) DEFAULT NULL, `t_fileinfo_filetypeid` int(11) DEFAULT NULL, `t_fileinfo_remark` varchar(50) DEFAULT NULL, `t_fileinfo_owner` varchar(50) DEFAULT NULL, `t_fileinfo_createdate` datetime DEFAULT NULL, `t_fileinfo_parentid` int(11) DEFAULT NULL, `t_fileinfo_filepath` varchar(200) DEFAULT NULL, `t_fileinfo_ifdelete` int(11) DEFAULT NULL, PRIMARY KEY (`t_fileinfo_id`), KEY `t_fileinfo_filetypeid` (`t_fileinfo_filetypeid`), CONSTRAINT `t_fileinfo_ibfk_1` FOREIGN KEY (`t_fileinfo_filetypeid`) REFERENCES `t_filetypeinfo` (`t_fileinfo_filetypeid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_fileinfo -- ---------------------------- INSERT INTO `t_fileinfo` VALUES ('1', 'file1', '1', '备注1', '孙骊超', '2017-06-02 00:00:00', '1', 'C:\\Users\\Administrator\\Desktop\\share小分队\\Office\\OfficeAutomationSystem\\WebRoot\\upload\\航空订票系统权限表.docx', '2'); INSERT INTO `t_fileinfo` VALUES ('3', 'file3', '3', '备注3', '孙骊超', '2017-06-02 00:00:00', '1', 'C:\\Users\\Administrator\\Desktop\\share小分队\\Office\\OfficeAutomationSystem\\WebRoot\\upload\\航空订票系统权限表.docx', '2'); INSERT INTO `t_fileinfo` VALUES ('6', '说明.txt', '1', '78978', '张继彤', '2017-06-07 09:53:27', '1', 'C:\\Users\\Administrator\\Desktop\\share小分队\\Office\\OfficeAutomationSystem\\WebRoot\\upload\\航空订票系统权限表.docx', '2'); INSERT INTO `t_fileinfo` VALUES ('34', '图书推荐.txt', '1', '23423423', '张继彤', '2017-06-08 18:31:45', null, 'D:\\1MyInstall\\apache-tomcat-8.0.33\\wtpwebapps\\OfficeAutomationSystem\\upload\\图书推荐.txt', '1'); INSERT INTO `t_fileinfo` VALUES ('123', '查询.txt', '1', '123', '张继彤', '2017-06-12 17:33:04', null, 'D:\\JavaEE\\apache-tomcat-8.0.33\\wtpwebapps\\OfficeAutomationSystem\\upload\\查询.txt', '2');
-- ---------------------------- -- Table structure for t_filetypeinfo -- ---------------------------- DROP TABLE IF EXISTS `t_filetypeinfo`; CREATE TABLE `t_filetypeinfo` ( `t_fileinfo_filetypeid` int(11) NOT NULL, `t_filetypeinfo_name` varchar(50) DEFAULT NULL, `t_filetypeinfo_image` varchar(50) DEFAULT NULL, `t_filetypeinfo_suffix` varchar(50) DEFAULT NULL, PRIMARY KEY (`t_fileinfo_filetypeid`), KEY `t_fileinfo_filetypeid` (`t_fileinfo_filetypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_filetypeinfo -- ---------------------------- INSERT INTO `t_filetypeinfo` VALUES ('1', 'txt', 'images\\txt.jpg', '.txt'); INSERT INTO `t_filetypeinfo` VALUES ('2', 'word', 'images\\word.jpg', '.word'); INSERT INTO `t_filetypeinfo` VALUES ('3', 'excel', 'images\\excel.jpg', '.sxml');
-- ---------------------------- -- Table structure for t_loginlog -- ---------------------------- DROP TABLE IF EXISTS `t_loginlog`; CREATE TABLE `t_loginlog` ( `t_loginlog_id` int(11) NOT NULL AUTO_INCREMENT, `t_userinfo_id` int(11) DEFAULT NULL, `t_loginlog_time` datetime DEFAULT NULL, `t_loginlog_ifsuccess` int(11) DEFAULT NULL, `t_loginlog_userip` varchar(100) DEFAULT NULL, `t_loginlog_desc` varchar(100) DEFAULT NULL, PRIMARY KEY (`t_loginlog_id`), KEY `t_userinfo_id` (`t_userinfo_id`), CONSTRAINT `t_loginlog_ibfk_1` FOREIGN KEY (`t_userinfo_id`) REFERENCES `t_userinfo` (`t_userinfo_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of t_loginlog -- ---------------------------- INSERT INTO `t_loginlog` VALUES ('1', '2', '2017-06-01 16:24:03', '1', 'shishe', '不存在'); INSERT INTO `t_loginlog` VALUES ('2', '4', '2017-05-29 16:26:24', '0', '232', '不存在'); INSERT INTO `t_loginlog` VALUES ('18', '1', '2017-06-09 18:40:43', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('19', '1', '2017-06-12 09:32:36', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('20', '1', '2017-06-12 09:37:36', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('21', '1', '2017-06-12 14:12:35', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('22', '1', '2017-06-12 15:34:29', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('23', '1', '2017-06-12 15:52:06', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('24', '1', '2017-06-12 15:58:54', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('25', '1', '2017-06-12 17:18:49', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('26', '1', '2017-06-12 17:21:32', null, '127.0.0.1', null); INSERT INTO `t_loginlog` VALUES ('27', '1', '2017-06-12 19:10:25', null, '127.0.0.1', null);
-- ---------------------------- -- Table structure for t_manage -- ---------------------------- DROP TABLE IF EXISTS `t_manage`; CREATE TABLE `t_manage` ( `t_manage_id` int(11) NOT NULL, `t_manage_name` varchar(50) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`t_manage_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ---------------------------- -- Records of t_manage -- ---------------------------- INSERT INTO `t_manage` VALUES ('1', '人事管理 '); INSERT INTO `t_manage` VALUES ('2', '日程管理'); INSERT INTO `t_manage` VALUES ('3', '文档管理'); INSERT INTO `t_manage` VALUES ('4', '消息传递'); INSERT INTO `t_manage` VALUES ('5', '系统管理'); INSERT INTO `t_manage` VALUES ('6', '考勤管理'); INSERT INTO `t_manage` VALUES ('7', '个人考情管理');
