扫一扫,关注我们
微信号:375279829
数据库脚本:
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50561
Source Host : localhost:3306
Source Database : ssmgxxqhzpthsg2825cg
Target Server Type : MYSQL
Target Server Version : 50561
File Encoding : 65001
Date: 2022-02-28 16:04:44
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`pwd` varchar(50) DEFAULT NULL,
`cx` varchar(50) DEFAULT '普通管理员',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `banjixinxi`
-- ----------------------------
DROP TABLE IF EXISTS `banjixinxi`;
CREATE TABLE `banjixinxi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`banji` varchar(50) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of banjixinxi
-- ----------------------------
INSERT INTO `banjixinxi` VALUES ('2', 'A02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('3', 'A03', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('4', 'E02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('5', 'E01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('6', 'C01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('7', 'B02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('8', 'B01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('9', '计算机一班', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `jiaoxuedagang`
-- ----------------------------
DROP TABLE IF EXISTS `jiaoxuedagang`;
CREATE TABLE `jiaoxuedagang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kecheng` varchar(50) DEFAULT NULL,
`jiaoxuemubiao` text,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of jiaoxuedagang
-- ----------------------------
INSERT INTO `jiaoxuedagang` VALUES ('2', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('3', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('4', '软件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('5', '软件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('6', '软件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('7', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('8', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('9', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('10', '线性代数', '我确认', '2022-02-28 15:39:35');
-- ----------------------------
-- Table structure for `kaikejihua`
-- ----------------------------
DROP TABLE IF EXISTS `kaikejihua`;
CREATE TABLE `kaikejihua` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`zhuti` varchar(50) DEFAULT NULL,
`kecheng` varchar(50) DEFAULT NULL,
`jihua` text,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kaikejihua
-- ----------------------------
INSERT INTO `kaikejihua` VALUES ('2', '', '数学', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('3', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('4', '', '语文', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('5', '', '线性代数', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('6', '', '软件工程', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('7', '', '计算机', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('8', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('9', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('10', 'rwr完全', '线性代数', '我确认w\'q', '2022-02-28 15:39:40');
-- ----------------------------
-- Table structure for `kechengchengjidan`
-- ----------------------------
DROP TABLE IF EXISTS `kechengchengjidan`;
CREATE TABLE `kechengchengjidan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kecheng` varchar(50) DEFAULT NULL,
`xuehao` varchar(50) DEFAULT NULL,
`xingming` varchar(50) DEFAULT NULL,
`banji` varchar(50) DEFAULT NULL,
`chengji` varchar(50) DEFAULT NULL,
`xueqi` varchar(50) DEFAULT NULL,
`beizhu` varchar(500) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengchengjidan
-- ----------------------------
INSERT INTO `kechengchengjidan` VALUES ('2', '线性代数', '001', '马庆炳', '计算机一班', '55', '2022上半学期', '我确认', '2022-02-28 15:39:49');
-- ----------------------------
-- Table structure for `kechengxiaojie`
-- ----------------------------
DROP TABLE IF EXISTS `kechengxiaojie`;
CREATE TABLE `kechengxiaojie` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kecheng` varchar(50) DEFAULT NULL,
`zongjie` text,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengxiaojie
-- ----------------------------
INSERT INTO `kechengxiaojie` VALUES ('2', '计算机', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('3', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('4', '英语', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('5', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('6', '计算机', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('7', '语文', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('8', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('9', '英语', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('10', '线性代数', '我去热武器', '2022-02-28 15:39:58');
-- ----------------------------
-- Table structure for `kechengxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `kechengxinxi`;
CREATE TABLE `kechengxinxi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kecheng` varchar(50) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengxinxi
-- ----------------------------
INSERT INTO `kechengxinxi` VALUES ('2', '计算机', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('3', '软件工程', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('4', '法律', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('5', '数学', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('6', '政治', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('7', '语文', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('8', '英语', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('9', '线性代数', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `peiyangfangan`
-- ----------------------------
DROP TABLE IF EXISTS `peiyangfangan`;
CREATE TABLE `peiyangfangan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`zhuti` varchar(50) DEFAULT NULL,
`fangan` text,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of peiyangfangan
-- ----------------------------
INSERT INTO `peiyangfangan` VALUES ('2', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('3', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('4', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('5', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('6', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('7', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('8', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('9', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('10', '我确认我确认w\'q', '<p style=\"text-align:center;\">\r\n 请问人情味\r\n</p>\r\n<p style=\"text-align:left;\">\r\n <table style=\"width:100%;\" cellpadding=\"2\" cellspacing=\"0\" border=\"1\" bordercolor=\"#000000\">\r\n <tbody>\r\n <tr>\r\n <td>\r\n <br />\r\n </td>\r\n <td>\r\n <br />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <br />\r\n </td>\r\n <td>\r\n <br />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <br />\r\n </td>\r\n <td>\r\n <br />\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n<br />\r\n<span id=\"__kindeditor_bookmark_start_4__\"></span>\r\n</p>', '2022-02-28 15:39:27');
-- ----------------------------
-- Table structure for `qiye`
-- ----------------------------
DROP TABLE IF EXISTS `qiye`;
CREATE TABLE `qiye` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`qiyehao` varchar(50) DEFAULT NULL,
`mima` varchar(50) DEFAULT NULL,
`qiyemingcheng` varchar(50) DEFAULT NULL,
`suoshuxingye` varchar(50) DEFAULT NULL,
`fuzeren` varchar(50) DEFAULT NULL,
`lianxidianhua` varchar(50) DEFAULT NULL,
`qiyedizhi` varchar(50) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of qiye
-- ----------------------------
INSERT INTO `qiye` VALUES ('2', '006', '001', '星河网络有限公司', '教育行业', '005', '13623256544', '鑫和锦园2栋', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('3', '009', '001', '南京医药股份有限公司', '餐饮行业', '011', '13025896548', '人民路57号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('4', '013', '001', '苍南仪表有限公司', '行政行业', '034', '13748589658', '方城丽圆11幢201室', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('5', '011', '001', '华莱士有限公司', '服务行业', '032', '13587835380', '上江小区2幢', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('6', '020', '001', '九州通医药集团股份有限公司', '教育行业', '027', '18956482221', '龙翔路11号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('7', '021', '001', '广州医药有限公司', '餐饮行业', '033', '13910215489', '复兴街27号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('8', '023', '001', '上海市医药股份有限公司', '医药行业', '010', '17505772420', '泰兴路22号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('9', '001', '001', '中国医药集团总公司', '行政行业', '001', '13052154877', '河滨东路139号', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `xuefenzhihuan`
-- ----------------------------
DROP TABLE IF EXISTS `xuefenzhihuan`;
CREATE TABLE `xuefenzhihuan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`leixing` varchar(50) DEFAULT NULL,
`xuehao` varchar(50) DEFAULT NULL,
`xingming` varchar(50) DEFAULT NULL,
`banji` varchar(50) DEFAULT NULL,
`fudaoyuanxingming` varchar(50) DEFAULT NULL,
`xuefen` varchar(50) DEFAULT NULL,
`beizhu` varchar(500) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of xuefenzhihuan
-- ----------------------------
INSERT INTO `xuefenzhihuan` VALUES ('2', '华为考证', '008', '乔维', 'A02', 'fudaoyuan赵小型', '1', '没问题', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('3', '华为考证', '027', '梅西', 'B02', 'fudaoyuan连小云', '5', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('4', '华为考证', '001', '马庆炳', 'B03', 'fudaoyuan科比', '5', '无', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('5', '华为考证', '006', '赵小型', 'A02', 'fudaoyuan黄行阳', '4', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('6', '华为考证', '019', '鲁艾弈', 'C01', 'fudaoyuan吴官本', '1', 'ok', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('7', '华为考证', '013', '邱建彰', 'E02', 'fudaoyuan詹姆斯', '4', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('8', '课程学分', '001', '马庆炳', 'B03', 'fudaoyuan温宗达', '4', '无', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('9', '华为考证', '001', '马庆炳', 'B03', 'fudaoyuan陈小巧', '4', '没问题', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('10', '课程学分', '001', '马庆炳', '计算机一班', 'fudaoyuan马庆炳', '5', '', '2022-02-28 15:43:09');
INSERT INTO `xuefenzhihuan` VALUES ('11', '华为考证', '001', '马庆炳', '计算机一班', 'fudaoyuan马庆炳', '10', 'qwrwq', '2022-02-28 15:43:15');
-- ----------------------------
-- Table structure for `xuesheng`
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`xuehao` varchar(50) DEFAULT NULL,
`mima` varchar(50) DEFAULT NULL,
`xingming` varchar(50) DEFAULT NULL,
`xingbie` varchar(50) DEFAULT NULL,
`banji` varchar(50) DEFAULT NULL,
`fudaoyuanxingming` varchar(50) DEFAULT NULL,
`zhaopian` varchar(50) DEFAULT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of xuesheng
-- ----------------------------
INSERT INTO `xuesheng` VALUES ('2', '008', '001', '乔维', '女', 'A02', 'fudaoyuan乔维', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('3', '006', '001', '赵小型', '女', 'A02', 'fudaoyuan赵小型', 'upload/xuesheng7.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('4', '019', '001', '鲁艾弈', '女', 'C01', 'fudaoyuan鲁艾弈', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('5', '027', '001', '梅西', '男', 'B02', 'fudaoyuan梅西', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('6', '016', '001', '方之明', '女', 'C01', 'fudaoyuan方之明', 'upload/xuesheng4.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('7', '012', '001', '霍建华', '女', 'B03', 'fudaoyuan霍建华', 'upload/xuesheng1.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('8', '013', '001', '邱建彰', '女', 'E02', 'fudaoyuan邱建彰', 'upload/xuesheng5.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('9', '001', '001', '马庆炳', '女', '计算机一班', 'fudaoyuan马庆炳', 'upload/xuesheng5.jpg', '2022-02-28 15:30:39');