dataBase.sql

/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.5.49 : Database - wcgxy
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`wcgxy` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `wcgxy`;

/*Table structure for table `cj` */

DROP TABLE IF EXISTS `cj`;

CREATE TABLE `cj` (
  `xh` varchar(10) CHARACTER SET utf8mb4 NOT NULL COMMENT '序号',
  `zkzh` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '准考证号',
  `name` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '名字',
  `gender` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '性别',
  `id` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '身份证号',
  `password` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '查询成绩密码',
  `bkmajor` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '报考专业',
  `km1` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '考试科目1',
  `km1f` float(20,0) NOT NULL COMMENT '科目1分数',
  `km1b` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
  `km2` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '考试科目2',
  `km2f` float(20,0) NOT NULL COMMENT '考试科目2分数',
  `km2b` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
  `total` varchar(20) CHARACTER SET utf8mb4 NOT NULL COMMENT '总分',
  `lq` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '是否录取;三种情况：录取、预录取、未录取、还没有出结果留空',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `cj` */

insert  into `cj`(`xh`,`zkzh`,`name`,`gender`,`id`,`password`,`bkmajor`,`km1`,`km1f`,`km1b`,`km2`,`km2f`,`km2b`,`total`,`lq`) values 
('1201','201612001','张梦茹','','130730199405281821','281821','环境设计','结构素描',92,'','环境设计基础知识',91,'','183',''),
('0430','201604001','吕昕','','130921199311281040','281040','工程管理','计算机应用基础',70,'','工程管理项目',71,'','141','预录取'),
('0169','201601001','赵莹','','131127199402120029','120029','会计学','应用文写作',62,'','会计学原理',54,'','116',NULL),
('0910','201609002','黄磊','','140105199411251832','251832','电子信息工程','计算机应用基础',64,'','数字电路',45,'','109',NULL),
('0134','201601002','杨一超','','140424199408156434','156434','会计学','应用文写作',77,'','会计学原理',62,'','139',NULL),
('0217','201602001','孙颂尧','','142702199503141564','141564','人力资源管理','应用文写作',69,'','管理学原理',62,'','131',NULL),
('0167','201601003','刘星嘉','','150422199410020025','020025','会计学','应用文写作',42,'','会计学原理',75,'','117',NULL),
('0822','201608001','张剑豪','','15232119950906241X','06241X','计算机科学与技术','计算机应用基础',64,'','C语言程序设计',52,'','116',NULL),
('0503','201605001','叶金','','210323199606300413','300413','土木工程','计算机应用基础',85,'','建筑工程施工',65,'','150',NULL),
('0172','201601004','孙枫','','231024199502246832','246832','会计学','应用文写作',39,'','会计学原理',73,'','112',NULL),
('1007','201610001','徐晨斌','','330127199501113111','113111','食品质量与安全','计算机应用基础',82,'','无机化学',62,'','144',NULL),
('0109','201601005','严频','','330206199409014624','014624','会计学','应用文写作',68,'','会计学原理',88,'','156',NULL),
('0611','201606001','李飞达','','330226199310132415','132415','机械设计制造及其自动化','计算机应用基础',72,'','机械设计基础',54,'','126',NULL),
('0151','201601006','金静雯','','330226199407022423','022423','会计学','应用文写作',57,'','会计学原理',70,'','127',NULL),
('0301','201603001','王媛媛','','330326199309076124','076124','工商管理','应用文写作',80,'','管理学原理',75,'','155',NULL),
('1210','201612002','梁瑞芳','','330328199311071122','071122','环境设计','结构素描',84,'','环境设计基础知识',77,'','161',NULL),
('0117','201601058','丁宇航','','330624199405160936','160936','会计学','应用文写作',79,'','会计学原理',71,'','150',NULL),
('0131','201601007','宓圣福','','330681199506281531','281531','会计学','应用文写作',58,'','会计学原理',82,'','140',NULL),
('0815','201608002','石恭宇','','331003199503010014','010014','计算机科学与技术','计算机应用基础',68,'','C语言程序设计',70,'','138',NULL),
('0112','201601008','郑露瑩','','332501199402120228','120228','会计学','应用文写作',70,'','会计学原理',85,'','155',NULL),
('0107','201601010','成相','','332624199411134613','134613','会计学','应用文写作',80,'','会计学原理',80,'','160',NULL),
('1005','201607001','金嘉奇','','339005199507205118','205118','食品质量与安全','计算机应用基础',78,'','无机化学',69,'','147',NULL),
('0310','201603002','程立宇','','350402199510270031','270031','工商管理','应用文写作',57,'','管理学原理',79,'','136',NULL),
('0813','201608004','陈凯航','','362301199504091012','091012','计算机科学与技术','计算机应用基础',76,'','C语言程序设计',72,'','148',NULL),
('0620','201606003','赵仕雄','','362527199507100011','100011','机械设计制造及其自动化','计算机应用基础',76,'','机械设计基础',39,'','115',NULL),
('0457','201604002','刘昊田','','370102199309134131','134131','工程管理','计算机应用基础',62,'','工程管理项目',48,'','110',NULL),
('0230','201602002','刘友彬','','370282199504234215','234215','人力资源管理','应用文写作',54,'','管理学原理',60,'','114',NULL),
('0324','201603042','许展','','410224199409260019','260019','工商管理','应用文写作',57,'','管理学原理',64,'','121',NULL),
('0136','201601014','尚鑫','','411323199409013827','013827','会计学','应用文写作',58,'','会计学原理',79,'','137',NULL),
('0312','201603003','曾冠超','','42010119941013701X','13701X','工商管理','应用文写作',63,'','管理学原理',72,'','135',NULL),
('0420','201604004','吉翔','','420102199501252431','252431','工程管理','计算机应用基础',60,'','工程管理项目',88,'','148',NULL),
('0511','201605002','徐畅','','420102199502211033','211033','土木工程','计算机应用基础',76,'','建筑工程施工',60,'','136',NULL),
('0328','201603032','董付强','','42010219950406281x','06281x','工商管理','应用文写作',57,'','管理学原理',52,'','109',NULL),
('0154','201601015','黄厚源','','420102199505211418','211418','会计学','应用文写作',55,'','会计学原理',68,'','123',NULL),
('0170','201601111','邓瑾','','420102199510221223','221223','会计学','应用文写作',62,'','会计学原理',54,'','116',NULL),
('0409','201604005','汪家欣','','420103199503262015','262015','工程管理','计算机应用基础',68,'','工程管理项目',88,'','156',NULL),
('0331','201603005','张梦媛','','420103199507300429','300429','工商管理','应用文写作',51,'','管理学原理',57,'','108',NULL),
('0622','201606004','李一涵','','420103199510262419','262419','机械设计制造及其自动化','计算机应用基础',64,'','机械设计基础',13,'','77',NULL),
('0907','201609003','马鋆鑫','','420104199506201214','201214','电子信息工程','计算机应用基础',74,'','数字电路',55,'','129',NULL),
('0302','201603033','金芯宇','','420104199506282026','282026','工商管理','应用文写作',76,'','管理学原理',77,'','153',NULL),
('0809','201608005','吴攸','','420104199509211215','211215','计算机科学与技术','计算机应用基础',80,'','C语言程序设计',76,'','156',NULL),
('0431','201604006','周家民','','420106199412134412','134412','工程管理','计算机应用基础',72,'','工程管理项目',69,'','141',NULL),
('0517','201605003','陈仲韬','','420106199503170435','170435','土木工程','计算机应用基础',60,'','建筑工程施工',65,'','125',NULL),
('0226','201602004','李珏婷','','420106199505088427','088427','人力资源管理','应用文写作',57,'','管理学原理',65,'','122',NULL),
('0315','201603006','张依','','420106199506220880','220880','工商管理','应用文写作',63,'','管理学原理',67,'','130',NULL),
('0451','201604007','金睿','','420106199506264453','264453','工程管理','计算机应用基础',62,'','工程管理项目',56,'','118',NULL),
('0455','201604008','王羽茜','','420106199508182822','182822','工程管理','计算机应用基础',52,'','工程管理项目',59,'','111',NULL),
('0181','201601018','傅骁','','420107199503170511','170511','会计学','应用文写作',50,'','会计学原理',51,'','101',NULL),
('0174','201601019','张雪霁','','420111199501125535','125535','会计学','应用文写作',58,'','会计学原理',52,'','110',NULL),
('0516','201605004','彭成涛','','420111199508111814','111814','土木工程','计算机应用基础',58,'','建筑工程施工',67,'','125',NULL),
('0333','201603007','王荞丹','','420111199510235541','235541','工商管理','应用文写作',39,'','管理学原理',62,'','101',NULL),
('1103','201611002','刘晴云','','420112199508012724','012724','英语','英语阅读',60,'','英语写作',73,'','133',NULL),
('0814','201608006','沈翊','','420112199509143312','143312','计算机科学与技术','计算机应用基础',82,'','C语言程序设计',61,'','143',NULL),
('0618','201606005','胡家亮','','420113199408181711','181711','机械设计制造及其自动化','计算机应用基础',68,'','机械设计基础',51,'','119',NULL),
('0303','201603008','李贝','','42011419940203002X','03002X','工商管理','应用文写作',70,'','管理学原理',79,'','149',NULL),
('0423','201604009','李劲','','420114199501112813','112813','工程管理','计算机应用基础',60,'','工程管理项目',86,'','146',NULL),
('0163','201601021','李晗','','420114199505290019','290019','会计学','应用文写作',61,'','会计学原理',58,'','119',NULL),
('0816','201608007','郑黎黎','','420114199508220526','220526','计算机科学与技术','计算机应用基础',76,'','C语言程序设计',61,'','137',NULL),
('0104','201601109','左娜','','420114199509060026','060026','会计学','应用文写作',73,'','会计学原理',91,'','164',NULL),
('0615','201606006','谌云静','','420115199407110922','110922','机械设计制造及其自动化','计算机应用基础',62,'','机械设计基础',61,'','123',NULL),
('0439','201604010','李奥琪','','420115199412030935','030935','工程管理','计算机应用基础',52,'','工程管理项目',85,'','137',NULL),
('1003','201610002','王堃','','420115199512090513','090513','食品质量与安全','计算机应用基础',72,'','无机化学',82,'','154',NULL),
('0818','201608027','唐顿','','42011619931117731X','17731X','计算机科学与技术','计算机应用基础',74,'','C语言程序设计',62,'','136',NULL),
('0305','201603009','梅达','','420116199402073313','073313','工商管理','应用文写作',66,'','管理学原理',81,'','147',NULL),
('0421','201604011','丁国辉','','420116199402150411','150411','工程管理','计算机应用基础',70,'','工程管理项目',78,'','148',NULL),
('0515','201605005','余刚','','420116199403047635','047635','土木工程','计算机应用基础',54,'','建筑工程施工',72,'','126',NULL),
('0909','201609004','王子伦','','420116199409013399','013399','电子信息工程','计算机应用基础',60,'','数字电路',54,'','114',NULL),
('0419','201604012','郭泽','','420116199409193318','193318','工程管理','计算机应用基础',54,'','工程管理项目',95,'','149',NULL),
('0506','201605006','王彪','','420117199402140818','140818','土木工程','计算机应用基础',70,'','建筑工程施工',73,'','143',NULL),
('0234','201602005','潘向琳','','420117199407077520','077520','人力资源管理','应用文写作',48,'','管理学原理',61,'','109',NULL),
('0908','201609005','熊飞','','420117199408050813','050813','电子信息工程','计算机应用基础',60,'','数字电路',66,'','126',NULL),
('1202','201612003','沈熠','','420117199409025513','025513','环境设计','结构素描',90,'','环境设计基础知识',93,'','183',NULL),
('1010','201610011','张立强','','420117199409123535','123535','食品质量与安全','计算机应用基础',68,'','无机化学',68,'','136',NULL),
('1102','201611003','于静','','420117199505062728','062728','英语','英语阅读',67,'','英语写作',75,'','142',NULL),
('0601','201606007','耿兴','','420123199309142015','142015','机械设计制造及其自动化','计算机应用基础',74,'','机械设计基础',86,'','160',NULL),
('0231','201602043','涂晟','','420202199404060011','060011','人力资源管理','应用文写作',50,'','管理学原理',63,'','113',NULL),
('0323','201603010','陈松昀','','420202199507071215','071215','工商管理','应用文写作',54,'','管理学原理',68,'','122',NULL),
('0158','201601023','王熙云','','420204199412114561','114561','会计学','应用文写作',45,'','会计学原理',76,'','121',NULL),
('0204','201602006','石金明','','42022219940929383X','29383X','人力资源管理','应用文写作',67,'','管理学原理',83,'','150',NULL),
('0319','201603011','樊中一','','420222199506300026','300026','工商管理','应用文写作',50,'','管理学原理',78,'','128',NULL),
('0156','201601076','程怡希','','420222199507102048','102048','会计学','应用文写作',45,'','会计学原理',77,'','122',NULL),
('0148','201601025','张莹莹','','420281199308020023','020023','会计学','应用文写作',57,'','会计学原理',74,'','131',NULL),
('0152','201601034','王阳','','42028119931025542X','25542X','会计学','应用文写作',52,'','会计学原理',73,'','125',NULL),
('0129','201601027','吴智','','42028119950202081x','02081x','会计学','应用文写作',63,'','会计学原理',79,'','142',NULL),
('0307','201603012','魏征','','420302199409121253','121253','工商管理','应用文写作',68,'','管理学原理',77,'','145',NULL),
('0232','201602009','李博','','420302199410060056','060056','人力资源管理','应用文写作',52,'','管理学原理',59,'','111',NULL),
('0410','201604014','彭沛','','42030219941114127X','14127X','工程管理','计算机应用基础',70,'','工程管理项目',85,'','155',NULL),
('0236','201602010','段智强','','420302199502040917','040917','人力资源管理','应用文写作',44,'','管理学原理',57,'','101',NULL),
('0142','201601026','蔺岚','','420302199510100940','100940','会计学','应用文写作',57,'','会计学原理',77,'','134',NULL),
('0405','201604015','薛俊杨','','420302199511171273','171273','工程管理','计算机应用基础',74,'','工程管理项目',95,'','169',NULL),
('0327','201603013','郭钊炜','','420303199212142815','142815','工商管理','应用文写作',51,'','管理学原理',59,'','110',NULL),
('1101','201611004','郭嘉慧','','420303199407192847','192847','英语','英语阅读',72,'','英语写作',73,'','145',NULL),
('0189','201601038','王二萌','','420303199411112547','112547','会计学','应用文写作',56,'','会计学原理',25,'','81',NULL),
('0309','201603014','袁冶','','420303199504112036','112036','工商管理','应用文写作',65,'','管理学原理',72,'','137',NULL),
('0322','201603040','王天一','','420303199505202818','202818','工商管理','应用文写作',56,'','管理学原理',67,'','123',NULL),
('0210','201602012','杨昱筱','','420303199509042524','042524','人力资源管理','应用文写作',69,'','管理学原理',71,'','140',NULL),
('0520','201605007','朱政通','','420321199408050018','050018','土木工程','计算机应用基础',48,'','建筑工程施工',72,'','120',NULL),
('0101','201601029','高翔','','420321199411050035','050035','会计学','应用文写作',85,'','会计学原理',91,'','176','未录取'),
('0116','201601030','田敏','','420322199307265729','265729','会计学','应用文写作',62,'','会计学原理',88,'','150',NULL),
('0135','201601031','蒋晓蕾','','420322199410090023','090023','会计学','应用文写作',65,'','会计学原理',73,'','138',NULL),
('0606','201606008','翟正伟','','420322199503077215','077215','机械设计制造及其自动化','计算机应用基础',74,'','机械设计基础',64,'','138',NULL),
('0317','201603016','陈良','','42032319940424001x','24001x','工商管理','应用文写作',50,'','管理学原理',79,'','129',NULL),
('1006','201610003','孙浩然','','420325199307110013','110013','食品质量与安全','计算机应用基础',80,'','无机化学',65,'','145',NULL),
('0139','201601033','宋城希','','420381199312060015','060015','会计学','应用文写作',59,'','会计学原理',76,'','135',NULL),
('0612','201606009','田野','','420381199412020619','020619','机械设计制造及其自动化','计算机应用基础',76,'','机械设计基础',50,'','126',NULL),
('0820','201608009','朱智鸿','','420381199509270614','270614','计算机科学与技术','计算机应用基础',72,'','C语言程序设计',58,'','130',NULL),
('0183','201601116','黄焯昀','','420502199510086510','086510','会计学','应用文写作',47,'','会计学原理',49,'','96',NULL),
('1208','201612004','刘青鹏','','420503199409252314','252314','环境设计','结构素描',80,'','环境设计基础知识',81,'','161',NULL),
('0424','201604016','王康阳','','420521199302130010','130010','工程管理','计算机应用基础',80,'','工程管理项目',66,'','146',NULL),
('1009','201610012','王若宇','','42052119950802001X','02001X','食品质量与安全','计算机应用基础',74,'','无机化学',65,'','139',NULL),
('0444','201604067','林瀚','','420526199401180015','180015','工程管理','计算机应用基础',64,'','工程管理项目',65,'','129',NULL),
('0313','201603018','刘金荣','','420527199505243021','243021','工商管理','应用文写作',65,'','管理学原理',70,'','135',NULL),
('0222','201602045','林元阳','','42058219910803065X','03065X','人力资源管理','应用文写作',67,'','管理学原理',60,'','127',NULL),
('0436','201604017','王婷','','420582199502010067','010067','工程管理','计算机应用基础',60,'','工程管理项目',79,'','139',NULL),
('0811','201608010','吴凡','','420582199601220019','220019','计算机科学与技术','计算机应用基础',82,'','C语言程序设计',73,'','155',NULL),
('0458','201604018','代华强','','420583199410081059','081059','工程管理','计算机应用基础',62,'','工程管理项目',46,'','108',NULL),
('0176','201601035','欧阳祖光','','420602199202290515','290515','会计学','应用文写作',42,'','会计学原理',67,'','109',NULL),
('0178','201601036','刘子阳','','420602199408211018','211018','会计学','应用文写作',43,'','会计学原理',64,'','107',NULL),
('0140','201601037','胡智宇','','420602199508311024','311024','会计学','应用文写作',54,'','会计学原理',81,'','135',NULL),
('1105','201611006','马冬羽','','420606199412122013','122013','英语','英语阅读',55,'','英语写作',67,'','122',NULL),
('1204','201612005','段文君','','420606199504201018','201018','环境设计','结构素描',85,'','环境设计基础知识',85,'','170',NULL),
('0417','201604054','李芮婷','','420606199510222528','222528','工程管理','计算机应用基础',60,'','工程管理项目',90,'','150',NULL),
('0150','201601039','王楚喻','','420607199507275326','275326','会计学','应用文写作',58,'','会计学原理',71,'','129',NULL),
('0125','201601040','刘雅洁','','420621199508271885','271885','会计学','应用文写作',62,'','会计学原理',82,'','144',NULL),
('0905','201609007','孙光瑜','','420621199607216312','216312','电子信息工程','计算机应用基础',78,'','数字电路',77,'','155',NULL),
('0306','201603021','郭日新','','420625199504070010','070010','工商管理','应用文写作',71,'','管理学原理',76,'','147',NULL),
('0446','201604019','李展','','420625199603140918','140918','工程管理','计算机应用基础',58,'','工程管理项目',63,'','121',NULL),
('1104','201611007','郭思佳','','420682199501060025','060025','英语','英语阅读',65,'','英语写作',61,'','126',NULL),
('0508','201605009','张栋洋','','420682199501100576','100576','土木工程','计算机应用基础',66,'','建筑工程施工',72,'','138',NULL),
('0132','201601041','李田','','420683199504021247','021247','会计学','应用文写作',58,'','会计学原理',82,'','140',NULL),
('0311','201603022','陈秀越','','420683199508182814','182814','工商管理','应用文写作',65,'','管理学原理',71,'','136',NULL),
('0185','201601043','杨康','','420683199510150512','150512','会计学','应用文写作',55,'','会计学原理',39,'','94',NULL),
('0159','201601044','胡家慧','','420684199501280020','280020','会计学','应用文写作',54,'','会计学原理',67,'','121',NULL),
('0168','201601045','张无忌','','420684199503266038','266038','会计学','应用文写作',49,'','会计学原理',68,'','117',NULL),
('0801','201608011','王鹏昊','','420684199507200079','200079','计算机科学与技术','计算机应用基础',94,'','C语言程序设计',93,'','187',NULL),
('0143','201601046','桂梦婷','','420684199510080047','080047','会计学','应用文写作',62,'','会计学原理',72,'','134',NULL),
('0514','201605010','金静','','420702199409208000','208000','土木工程','计算机应用基础',70,'','建筑工程施工',58,'','128',NULL),
('0146','201601047','闵琳','','420703199603183368','183368','会计学','应用文写作',56,'','会计学原理',76,'','132',NULL),
('0607','201606011','万楚雄','','420704199307191431','191431','机械设计制造及其自动化','计算机应用基础',78,'','机械设计基础',55,'','133',NULL),
('0435','201604066','程俊雄','','420704199402126590','126590','工程管理','计算机应用基础',74,'','工程管理项目',66,'','140',NULL),
('0147','201601050','夏璐','','420704199508200322','200322','会计学','应用文写作',65,'','会计学原理',67,'','132',NULL),
('0519','201605011','吴垦','','420704199510170011','170011','土木工程','计算机应用基础',60,'','建筑工程施工',64,'','124',NULL),
('0201','201602014','马庭辉','','420801199503260111','260111','人力资源管理','应用文写作',81,'','管理学原理',83,'','164',NULL),
('0141','201601051','杨雪媛','','420802199601080647','080647','会计学','应用文写作',59,'','会计学原理',76,'','135',NULL),
('0184','201601052','付雷','','420821199308305658','305658','会计学','应用文写作',63,'','会计学原理',32,'','95',NULL),
('0137','201601053','周悦','','420821199407240060','240060','会计学','应用文写作',71,'','会计学原理',66,'','137',NULL),
('0218','201602015','张建超','','420821199410130436','130436','人力资源管理','应用文写作',61,'','管理学原理',69,'','130',NULL),
('0233','201602046','梅志操','','420821199411152311','152311','人力资源管理','应用文写作',48,'','管理学原理',62,'','110',NULL),
('0433','201604022','许晓帆','','420821199412300013','300013','工程管理','计算机应用基础',64,'','工程管理项目',76,'','140',NULL),
('0114','201601054','马佳杰','','420821199501240083','240083','会计学','应用文写作',69,'','会计学原理',83,'','152',NULL),
('0160','201601055','张瑾蓉','','420821199502010044','010044','会计学','应用文写作',55,'','会计学原理',66,'','121',NULL),
('0177','201601056','王倩','','420821199503112325','112325','会计学','应用文写作',55,'','会计学原理',52,'','107',NULL),
('0224','201602016','王琛','','420821199503132318','132318','人力资源管理','应用文写作',57,'','管理学原理',67,'','124',NULL),
('0130','201601057','陈莹','','42082119950513152X','13152X','会计学','应用文写作',63,'','会计学原理',79,'','142',NULL),
('0223','201602013','何哲','','420821199506070079','070079','人力资源管理','应用文写作',65,'','管理学原理',59,'','124',NULL),
('1008','201610004','周夏伊琳','','420821199507110044','110044','食品质量与安全','计算机应用基础',74,'','无机化学',65,'','139',NULL),
('0227','201602017','刘晓聪','','420821199509070023','070023','人力资源管理','应用文写作',56,'','管理学原理',62,'','118',NULL),
('0128','201601059','施雨','','42082119950926002X','26002X','会计学','应用文写作',58,'','会计学原理',85,'','143',NULL),
('0904','201609008','宋星宇','','420822199406124558','124558','电子信息工程','计算机应用基础',74,'','数字电路',87,'','161',NULL),
('0126','201601061','冯平洋','','420822199503266857','266857','会计学','应用文写作',60,'','会计学原理',84,'','144',NULL),
('0432','201604023','黄冯洋','','420822199508053754','053754','工程管理','计算机应用基础',72,'','工程管理项目',69,'','141',NULL),
('0407','201604024','丁泽平','','420822199509305511','305511','工程管理','计算机应用基础',76,'','工程管理项目',86,'','162',NULL),
('0459','201604068','陈云','','420881199405155416','155416','工程管理','计算机应用基础',72,'','工程管理项目',31,'','103',NULL),
('0235','201602047','朱洁莹','','420881199408216528','216528','人力资源管理','应用文写作',49,'','管理学原理',56,'','105',NULL),
('0118','201601063','吴晨光','','420881199411044050','044050','会计学','应用文写作',58,'','会计学原理',92,'','150',NULL),
('0806','201608012','李旺鑫','','42088119950126441x','26441x','计算机科学与技术','计算机应用基础',88,'','C语言程序设计',78,'','166',NULL),
('0164','201601064','肖立豪','','420881199503118416','118416','会计学','应用文写作',54,'','会计学原理',64,'','118',NULL),
('0422','201604026','温鑫','','420881199506260274','260274','工程管理','计算机应用基础',62,'','工程管理项目',86,'','148',NULL),
('0165','201601065','王雨婷','','420881199508278427','278427','会计学','应用文写作',53,'','会计学原理',65,'','118',NULL),
('0425','201604027','蒋壮','','420881199512258111','258111','工程管理','计算机应用基础',70,'','工程管理项目',76,'','146',NULL),
('0402','201604029','陈飞扬','','420881199608130032','130032','工程管理','计算机应用基础',90,'','工程管理项目',89,'','179',NULL),
('0326','201603023','黄博淇','','420902199407260017','260017','工商管理','应用文写作',43,'','管理学原理',70,'','113',NULL),
('0320','201603024','胡维峰','','420902199510230836','230836','工商管理','应用文写作',59,'','管理学原理',69,'','128',NULL),
('0122','201601066','邓洁','','420922199509125321','125321','会计学','应用文写作',60,'','会计学原理',86,'','146',NULL),
('0208','201602018','李豆','','420922199509180064','180064','人力资源管理','应用文写作',69,'','管理学原理',73,'','142',NULL),
('0105','201601110','郭心畅','','420922199601060049','060049','会计学','应用文写作',75,'','会计学原理',89,'','164',NULL),
('0411','201604030','姚立','','420923199401081917','081917','工程管理','计算机应用基础',74,'','工程管理项目',81,'','155',NULL),
('0212','201602019','陈思琪','','42098219950823002x','23002x','人力资源管理','应用文写作',69,'','管理学原理',69,'','138',NULL),
('0144','201601068','李自硕','','42098219950927004X','27004X','会计学','应用文写作',60,'','会计学原理',73,'','133',NULL),
('0502','201605012','吴畅','','420984199408130032','130032','土木工程','计算机应用基础',82,'','建筑工程施工',70,'','152',NULL),
('0807','201608013','王文啸','','420984199408170317','170317','计算机科学与技术','计算机应用基础',86,'','C语言程序设计',79,'','165',NULL),
('0803','201608014','谢世亮','','420984199409262010','262010','计算机科学与技术','计算机应用基础',88,'','C语言程序设计',87,'','175',NULL),
('0228','201602020','左磊','','420984199508300019','300019','人力资源管理','应用文写作',50,'','管理学原理',67,'','117',NULL),
('0321','201603025','窦元心','','421002199210184518','184518','工商管理','应用文写作',63,'','管理学原理',63,'','126',NULL),
('0219','201602021','刘静','','421002199309292420','292420','人力资源管理','应用文写作',58,'','管理学原理',71,'','129',NULL),
('0161','201601070','邵思雨','','421002199410105044','105044','会计学','应用文写作',50,'','会计学原理',70,'','120',NULL),
('0175','201601072','宋哲伦','','42100219950316051X','16051X','会计学','应用文写作',54,'','会计学原理',56,'','110',NULL),
('0203','201602022','黄小菲','','421002199505164549','164549','人力资源管理','应用文写作',83,'','管理学原理',71,'','154',NULL),
('0182','201601073','游侠安康','','421002199609125077','125077','会计学','应用文写作',54,'','会计学原理',47,'','101',NULL),
('0119','201601074','向金金','','421003199405142322','142322','会计学','应用文写作',71,'','会计学原理',79,'','150',NULL),
('0149','201601075','谢宏宇','','421003199502180064','180064','会计学','应用文写作',51,'','会计学原理',79,'','130',NULL),
('0449','201604062','李博玮','','421022199405140035','140035','工程管理','计算机应用基础',66,'','工程管理项目',53,'','119',NULL),
('1209','201612006','袁顺','','421022199406180039','180039','环境设计','结构素描',81,'','环境设计基础知识',80,'','161',NULL),
('0127','201601077','陈蓉','','421022199411184827','184827','会计学','应用文写作',64,'','会计学原理',80,'','144',NULL),
('0443','201604032','魏强','','421022199503300039','300039','工程管理','计算机应用基础',62,'','工程管理项目',69,'','131',NULL),
('0460','201604033','罗余辉','','421023199309166135','166135','工程管理','计算机应用基础',62,'','工程管理项目',20,'','82',NULL),
('0213','201602025','曾磊','','421023199404180031','180031','人力资源管理','应用文写作',66,'','管理学原理',71,'','137',NULL),
('0447','201604034','庄永哲','','42102319940427007X','27007X','工程管理','计算机应用基础',70,'','工程管理项目',51,'','121',NULL),
('0603','201606012','徐奇','','421023199405252017','252017','机械设计制造及其自动化','计算机应用基础',62,'','机械设计基础',87,'','149',NULL),
('0821','201608015','沈淼','','421023199410208731','208731','计算机科学与技术','计算机应用基础',70,'','C语言程序设计',54,'','124',NULL),
('0110','201601078','王慧君','','421023199501096640','096640','会计学','应用文写作',66,'','会计学原理',90,'','156',NULL),
('0162','201601079','张梓昂','','421023199502080034','080034','会计学','应用文写作',50,'','会计学原理',70,'','120',NULL),
('0608','201606026','杨硕','','421023199503226613','226613','机械设计制造及其自动化','计算机应用基础',72,'','机械设计基础',61,'','133',NULL),
('0509','201605024','杜德瑞','','421024199405040811','040811','土木工程','计算机应用基础',62,'','建筑工程施工',76,'','138',NULL),
('0903','201609010','佘嘉文','','421081199309216036','216036','电子信息工程','计算机应用基础',80,'','数字电路',93,'','173',NULL),
('1002','201610005','周安然','','42108119940306063X','06063X','食品质量与安全','计算机应用基础',92,'','无机化学',69,'','161',NULL),
('0123','201601081','郑康','','421081199404142979','142979','会计学','应用文写作',61,'','会计学原理',85,'','146',NULL),
('0221','201602026','王宇芬','','421081199509062983','062983','人力资源管理','应用文写作',58,'','管理学原理',69,'','127',NULL),
('0448','201604036','夏梓良','','421083199312065614','065614','工程管理','计算机应用基础',70,'','工程管理项目',49,'','119',NULL),
('0505','201605013','罗浩','','421083199405295611','295611','土木工程','计算机应用基础',68,'','建筑工程施工',79,'','147',NULL),
('0401','201604037','蔡嘉','','421083199407161633','161633','工程管理','计算机应用基础',92,'','工程管理项目',89,'','181',NULL),
('0403','201604038','涂一帆','','421083199508180059','180059','工程管理','计算机应用基础',88,'','工程管理项目',83,'','171',NULL),
('0819','201608016','李思忆','','421083199509045334','045334','计算机科学与技术','计算机应用基础',74,'','C语言程序设计',59,'','133',NULL),
('0206','201602027','王绵君','','421083199510197028','197028','人力资源管理','应用文写作',69,'','管理学原理',76,'','145',NULL),
('0191','201601082','艾松','','421087199404297610','297610','会计学','应用文写作',52,'','会计学原理',0,'','52',NULL),
('0215','201602028','尤艺','','421087199409141308','141308','人力资源管理','应用文写作',67,'','管理学原理',66,'','133',NULL),
('0412','201604039','王磊','','421087199411150035','150035','工程管理','计算机应用基础',63,'','工程管理项目',92,'','155',NULL),
('1206','201612009','邓锐','','421102199402160479','160479','环境设计','结构素描',83,'','环境设计基础知识',84,'','167',NULL),
('0173','201601012','张家豪','','421102199405240597','240597','会计学','应用文写作',55,'','会计学原理',55,'','110',NULL),
('0408','201604040','曾启','','421102199408140516','140516','工程管理','计算机应用基础',72,'','工程管理项目',90,'','162',NULL),
('0115','201601084','张志新','','421121199309077311','077311','会计学','应用文写作',70,'','会计学原理',81,'','151',NULL),
('0308','201603027','马骏飞','','421121199506290031','290031','工商管理','应用文写作',61,'','管理学原理',79,'','140',NULL),
('0824','201608028','韩帅','','421122199309074213','074213','计算机科学与技术','计算机应用基础',64,'','C语言程序设计',22,'','86',NULL),
('0823','201608018','刘柯','','421122199408100034','100034','计算机科学与技术','计算机应用基础',73,'','C语言程序设计',43,'','116',NULL),
('0304','201603028','李玉琳','','421122199501180083','180083','工商管理','应用文写作',74,'','管理学原理',74,'','148',NULL),
('0453','201604041','秦亚伦','','421122199502261029','261029','工程管理','计算机应用基础',52,'','工程管理项目',60,'','112',NULL),
('0209','201602030','熊镇东','','421122199503120017','120017','人力资源管理','应用文写作',76,'','管理学原理',66,'','142',NULL),
('0623','201606013','吕金华','','421123199406257210','257210','机械设计制造及其自动化','计算机应用基础',44,'','机械设计基础',14,'','58',NULL),
('0225','201602031','王天溢','','421123199506215253','215253','人力资源管理','应用文写作',59,'','管理学原理',64,'','123',NULL),
('0179','201601089','严罗佳','','421123199507260021','260021','会计学','应用文写作',57,'','会计学原理',50,'','107',NULL),
('0413','201604042','王宇豪','','421123199511040013','040013','工程管理','计算机应用基础',72,'','工程管理项目',83,'','155',NULL),
('1004','201610006','徐孙','','421123199512057255','057255','食品质量与安全','计算机应用基础',82,'','无机化学',72,'','154',NULL),
('0314','201603029','宁蓝锦','','421125199401016170','016170','工商管理','应用文写作',65,'','管理学原理',66,'','131',NULL),
('0113','201601090','郭益夫','','421125199407055517','055517','会计学','应用文写作',62,'','会计学原理',91,'','153',NULL),
('0166','201601091','龚信洋','','421125199410120017','120017','会计学','应用文写作',64,'','会计学原理',54,'','118',NULL),
('0216','201602032','胡锦川','','421125199810110053','110053','人力资源管理','应用文写作',77,'','管理学原理',56,'','133',NULL),
('0609','201606023','孟成','','421126199501233152','233152','机械设计制造及其自动化','计算机应用基础',72,'','机械设计基础',60,'','132',NULL),
('0229','201602033','张耀华','','42112619950723253x','23253x','人力资源管理','应用文写作',51,'','管理学原理',64,'','115',NULL),
('0415','201604044','王骁','','421126199602030012','030012','工程管理','计算机应用基础',72,'','工程管理项目',81,'','153',NULL),
('0108','201601092','吕圻','','421126199604170027','170027','会计学','应用文写作',69,'','会计学原理',89,'','158',NULL),
('1211','201612010','夏杰','','421127199308213930','213930','环境设计','结构素描',82,'','环境设计基础知识',66,'','148',NULL),
('0211','201602034','许逸夫','','421127199410270034','270034','人力资源管理','应用文写作',65,'','管理学原理',74,'','139',NULL),
('0416','201604045','吴思军','','421181199305256212','256212','工程管理','计算机应用基础',68,'','工程管理项目',82,'','150',NULL),
('0445','201604046','胡巍','','421181199308099494','099494','工程管理','计算机应用基础',62,'','工程管理项目',63,'','125',NULL),
('0426','201604047','刘全球','','421181199401293136','293136','工程管理','计算机应用基础',62,'','工程管理项目',84,'','146',NULL),
('0621','201606014','占冠群','','421181199406129474','129474','机械设计制造及其自动化','计算机应用基础',66,'','机械设计基础',49,'','115',NULL),
('0610','201606015','郑宏辉','','421181199411094456','094456','机械设计制造及其自动化','计算机应用基础',70,'','机械设计基础',57,'','127',NULL),
('0138','201601093','赵雨萌','','421182199502160363','160363','会计学','应用文写作',52,'','会计学原理',85,'','137',NULL),
('0318','201603037','何宁','','421202199411080011','080011','工商管理','应用文写作',57,'','管理学原理',72,'','129',NULL),
('0902','201609012','熊靖','','421202199411124715','124715','电子信息工程','计算机应用基础',78,'','数字电路',97,'','175',NULL),
('0810','201608019','汪强','','421202199412180057','180057','计算机科学与技术','计算机应用基础',62,'','C语言程序设计',94,'','156',NULL),
('1203','201612011','陈颖','','42120219950107052X','07052X','环境设计','结构素描',86,'','环境设计基础知识',87,'','173',NULL),
('0157','201601095','严梦露','','421202199501240023','240023','会计学','应用文写作',61,'','会计学原理',61,'','122',NULL),
('0316','201603036','胡天沛','','421202199508261230','261230','工商管理','应用文写作',54,'','管理学原理',76,'','130',NULL),
('0504','201605016','陈天宇','','421221199401145650','145650','土木工程','计算机应用基础',82,'','建筑工程施工',66,'','148',NULL),
('0427','201604048','谌洋','','421221199511230039','230039','工程管理','计算机应用基础',66,'','工程管理项目',80,'','146',NULL),
('0106','201601096','胡倩','','421222199505191228','191228','会计学','应用文写作',68,'','会计学原理',93,'','161',NULL),
('0188','201601097','王凯','','421224199604100056','100056','会计学','应用文写作',39,'','会计学原理',52,'','91',NULL),
('0812','201608020','龚谦','','421281199405270017','270017','计算机科学与技术','计算机应用基础',68,'','C语言程序设计',84,'','152',NULL),
('0145','201601098','宋成程','','42130219930629462X','29462X','会计学','应用文写作',52,'','会计学原理',81,'','133',NULL),
('0190','201601048','徐灿','','421302199401250449','250449','会计学','应用文写作',67,'','会计学原理',14,'','81',NULL),
('0507','201605017','谢沛','','42130219941105867X','05867X','土木工程','计算机应用基础',66,'','建筑工程施工',74,'','140',NULL),
('0442','201604049','王子胤','','421302199502110410','110410','工程管理','计算机应用基础',74,'','工程管理项目',60,'','134',NULL),
('0102','201601100','李玟蓓','','421302199502170448','170448','会计学','应用文写作',79,'','会计学原理',91,'','170','预录取'),
('1205','201612012','牛俊','','421302199509150431','150431','环境设计','结构素描',85,'','环境设计基础知识',84,'','169',NULL),
('0428','201604050','曹新','','421381199302281317','281317','工程管理','计算机应用基础',66,'','工程管理项目',80,'','146',NULL),
('0804','201608021','高翔宇','','421381199311103213','103213','计算机科学与技术','计算机应用基础',88,'','C语言程序设计',86,'','174',NULL),
('0406','201604051','尚红波','','421381199405174717','174717','工程管理','计算机应用基础',78,'','工程管理项目',88,'','166',NULL),
('0602','201606016','左洋','','421381199602278814','278814','机械设计制造及其自动化','计算机应用基础',68,'','机械设计基础',84,'','152',NULL),
('0414','201604052','洪伟','','422130199503210056','210056','工程管理','计算机应用基础',76,'','工程管理项目',79,'','155',NULL),
('0454','201604053','杨雨笛','','422202199412240014','240014','工程管理','计算机应用基础',60,'','工程管理项目',52,'','112',NULL),
('0325','201603038','石佳维','','422202199501240032','240032','工商管理','应用文写作',50,'','管理学原理',64,'','114',NULL),
('0180','201601102','陈可','','422202199508150021','150021','会计学','应用文写作',47,'','会计学原理',59,'','106',NULL),
('0329','201603039','陈子爵','','422202199509285235','285235','工商管理','应用文写作',44,'','管理学原理',65,'','109',NULL),
('1207','201612014','毛韵','','422301199412101080','101080','环境设计','结构素描',82,'','环境设计基础知识',85,'','167',NULL),
('0171','201601103','王学舜','','422301199501121075','121075','会计学','应用文写作',60,'','会计学原理',54,'','114',NULL),
('0186','201601104','阮兴兴','','422326199410110036','110036','会计学','应用文写作',56,'','会计学原理',36,'','92',NULL),
('0121','201601105','夏雪','','422326199506010021','010021','会计学','应用文写作',77,'','会计学原理',71,'','148',NULL),
('0133','201601106','段其慧','','422432199504062525','062525','会计学','应用文写作',65,'','会计学原理',75,'','140',NULL),
('0202','201602036','牟东升','','422802199601011352','011352','人力资源管理','应用文写作',80,'','管理学原理',77,'','157',NULL),
('0434','201604055','胡倩','','422828199308024721','024721','工程管理','计算机应用基础',60,'','工程管理项目',80,'','140',NULL),
('0513','201605018','余汪洋','','429001199308253279','253279','土木工程','计算机应用基础',60,'','建筑工程施工',70,'','130',NULL),
('0207','201602037','黄琼','','429001199409076347','076347','人力资源管理','应用文写作',70,'','管理学原理',73,'','143',NULL),
('0120','201601107','肖逸飞','','429001199508120075','120075','会计学','应用文写作',72,'','会计学原理',78,'','150',NULL),
('0103','201601108','李怡萱','','429001199508120446','120446','会计学','应用文写作',90,'','会计学原理',80,'','170','录取'),
('0214','201602038','光明杰','','429004199402231147','231147','人力资源管理','应用文写作',59,'','管理学原理',77,'','136',NULL),
('0805','201608022','黄诚','','429004199410202995','202995','计算机科学与技术','计算机应用基础',84,'','C语言程序设计',86,'','170',NULL),
('0501','201605019','汪壮','','429004199412240055','240055','土木工程','计算机应用基础',76,'','建筑工程施工',77,'','153',NULL),
('0429','201604056','龚含雨','','429004199501280737','280737','工程管理','计算机应用基础',64,'','工程管理项目',80,'','144',NULL),
('1011','201610010','罗威','','429004199502272915','272915','食品质量与安全','计算机应用基础',60,'','无机化学',67,'','127',NULL),
('0604','201606017','彭根','','429004199503122556','122556','机械设计制造及其自动化','计算机应用基础',68,'','机械设计基础',76,'','144',NULL),
('0817','201608017','石权','','42900419950410291X','10291X','计算机科学与技术','计算机应用基础',68,'','C语言程序设计',68,'','136',NULL),
('0512','201605020','张浩','','429004199506180313','180313','土木工程','计算机应用基础',74,'','建筑工程施工',59,'','133',NULL),
('0437','201604057','叶朗','','429004199507150351','150351','工程管理','计算机应用基础',62,'','工程管理项目',76,'','138',NULL),
('0438','201604058','别业环','','429004199510011037','011037','工程管理','计算机应用基础',60,'','工程管理项目',78,'','138',NULL),
('0440','201604059','宋阳','','42900419951101511X','01511X','工程管理','计算机应用基础',72,'','工程管理项目',63,'','135',NULL),
('0613','201606018','朱灿','','429004199602033110','033110','机械设计制造及其自动化','计算机应用基础',64,'','机械设计基础',61,'','125',NULL),
('0510','201605021','位笑','','429004199602293887','293887','土木工程','计算机应用基础',64,'','建筑工程施工',73,'','137',NULL),
('0153','201601109','肖予希','','429004199609202562','202562','会计学','应用文写作',57,'','会计学原理',68,'','125',NULL),
('0808','201608023','王琦','','429005199407150019','150019','计算机科学与技术','计算机应用基础',82,'','C语言程序设计',77,'','159',NULL),
('0220','201602040','鲍韵帆','','429005199503217682','217682','人力资源管理','应用文写作',55,'','管理学原理',74,'','129',NULL),
('0614','201606019','刘声权','','429005199505044711','044711','机械设计制造及其自动化','计算机应用基础',62,'','机械设计基础',62,'','124',NULL),
('0802','201608024','刘靖铭','','429005199508010197','010197','计算机科学与技术','计算机应用基础',94,'','C语言程序设计',83,'','177',NULL),
('0418','201604060','杨燚','','42900519950806825X','06825X','工程管理','计算机应用基础',72,'','工程管理项目',78,'','150',NULL),
('1012','201610008','严文静','','429005199508113022','113022','食品质量与安全','计算机应用基础',66,'','无机化学',59,'','125',NULL),
('0332','201603041','邓婉婷','','429005199508240064','240064','工商管理','应用文写作',48,'','管理学原理',59,'','107',NULL),
('0619','201606020','陈晗','','429006199211080676','080676','机械设计制造及其自动化','计算机应用基础',66,'','机械设计基础',50,'','116',NULL),
('0906','201609013','郭媞','','429006199403235126','235126','电子信息工程','计算机应用基础',60,'','数字电路',70,'','130',NULL),
('0901','201609014','倪泽文','','429006199407025118','025118','电子信息工程','计算机应用基础',88,'','数字电路',91,'','179',NULL),
('0187','201601110','王雪琪','','429006199408018745','018745','会计学','应用文写作',46,'','会计学原理',46,'','92',NULL),
('0124','201601112','张敏','','429006199502091244','091244','会计学','应用文写作',69,'','会计学原理',76,'','145',NULL),
('0111','201601113','黄雨','','429006199505107029','107029','会计学','应用文写作',67,'','会计学原理',89,'','156',NULL),
('0330','201603034','宋超逸','','429006199507292117  ','292117','工商管理','应用文写作',54,'','管理学原理',54,'','108',NULL),
('0911','201609015','罗俊龙','','429006199508091851','091851','电子信息工程','计算机应用基础',77,'','数字电路',32,'','109',NULL),
('0404','201604061','胡迪','','429006199508175182','175182','工程管理','计算机应用基础',76,'','工程管理项目',95,'','171',NULL),
('0616','201606021','张文杰','','429006199509280611','280611','机械设计制造及其自动化','计算机应用基础',68,'','机械设计基础',55,'','123',NULL),
('0205','201602042','胡梦蝶','','429006199511221549','221549','人力资源管理','应用文写作',76,'','管理学原理',70,'','146',NULL),
('0605','201606025','付胜','','42900619960107241X','07241X','机械设计制造及其自动化','计算机应用基础',80,'','机械设计基础',63,'','143',NULL),
('0441','201604070','林彬彬','','43052819960120053X','20053X','工程管理','计算机应用基础',60,'','工程管理项目',75,'','135',NULL),
('1001','201610009','曹晟','','430903199403180018','180018','食品质量与安全','计算机应用基础',80,'','无机化学',96,'','176',NULL),
('0456','201604069','王文强','','46000219930228001X','28001X','工程管理','计算机应用基础',53,'','工程管理项目',57,'','110',NULL),
('0155','201601115','钟欲飞','','460102199309060015','060015','会计学','应用文写作',53,'','会计学原理',70,'','123',NULL),
('0450','201604063','李钰','','520103199404075226','075226','工程管理','计算机应用基础',72,'','工程管理项目',47,'','119',NULL),
('0617','201606022','袁伟梁','','520114199408230034','230034','机械设计制造及其自动化','计算机应用基础',72,'','机械设计基础',50,'','122',NULL),
('0452','201604064','刘永桢','','620104199505110553','110553','工程管理','计算机应用基础',64,'','工程管理项目',51,'','115',NULL),
('0518','201605023','陈赞','','654221199510095010','095010','土木工程','计算机应用基础',46,'','建筑工程施工',78,'','124',NULL);

/*Table structure for table `course` */

DROP TABLE IF EXISTS `course`;

CREATE TABLE `course` (
  `cid` varchar(10) NOT NULL COMMENT '专业的代码',
  `cname` varchar(100) CHARACTER SET utf8mb4 NOT NULL COMMENT '专业的名字',
  `km1` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '考试科目1的名字',
  `km1_time` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '考试科目1的时间',
  `km2` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '考试科目2',
  `km2_time` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '科目2考试时间',
  `km3` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '考试科目3',
  `km3_time` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '科目3考试时间',
  `km4` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `km4_time` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='这是用于记录专业和对应的考试科目名称，以及考试时间的表。';

/*Data for the table `course` */

insert  into `course`(`cid`,`cname`,`km1`,`km1_time`,`km2`,`km2_time`,`km3`,`km3_time`,`km4`,`km4_time`) values 
('050201','英语',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('080301','机械设计制造及其自动化\r\n','','2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('080302','材料成型及控制工程',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('080603','电子信息工程',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('080605','计算机科学与技术','c语言','2019-6-3 9:00-11:00','计算机基础','2019-6-3 13:30-15:30','',NULL,NULL,NULL),
('080703','土木工程',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('081407W','食品质量与安全',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('110104','工程管理',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('120201K','工商管理',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('120203K','会计学',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('120206','人力资源管理',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL),
('130503','环境设计',NULL,'2019-6-3 9:00-11:00',NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `persistent_logins` */

DROP TABLE IF EXISTS `persistent_logins`;

CREATE TABLE `persistent_logins` (
  `username` varchar(64) NOT NULL,
  `series` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`series`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `persistent_logins` */

/*Table structure for table `qrtz_blob_triggers` */

DROP TABLE IF EXISTS `qrtz_blob_triggers`;

CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_blob_triggers` */

/*Table structure for table `qrtz_calendars` */

DROP TABLE IF EXISTS `qrtz_calendars`;

CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_calendars` */

/*Table structure for table `qrtz_cron_triggers` */

DROP TABLE IF EXISTS `qrtz_cron_triggers`;

CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_cron_triggers` */

/*Table structure for table `qrtz_fired_triggers` */

DROP TABLE IF EXISTS `qrtz_fired_triggers`;

CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_fired_triggers` */

/*Table structure for table `qrtz_job_details` */

DROP TABLE IF EXISTS `qrtz_job_details`;

CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_job_details` */

/*Table structure for table `qrtz_locks` */

DROP TABLE IF EXISTS `qrtz_locks`;

CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_locks` */

/*Table structure for table `qrtz_paused_trigger_grps` */

DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;

CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_paused_trigger_grps` */

/*Table structure for table `qrtz_scheduler_state` */

DROP TABLE IF EXISTS `qrtz_scheduler_state`;

CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_scheduler_state` */

/*Table structure for table `qrtz_simple_triggers` */

DROP TABLE IF EXISTS `qrtz_simple_triggers`;

CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_simple_triggers` */

/*Table structure for table `qrtz_simprop_triggers` */

DROP TABLE IF EXISTS `qrtz_simprop_triggers`;

CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_simprop_triggers` */

/*Table structure for table `qrtz_triggers` */

DROP TABLE IF EXISTS `qrtz_triggers`;

CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `qrtz_triggers` */

/*Table structure for table `sc` */

DROP TABLE IF EXISTS `sc`;

CREATE TABLE `sc` (
  `sid` varchar(6) NOT NULL,
  `cid` varchar(4) NOT NULL,
  `mark` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `sc` */

insert  into `sc`(`sid`,`cid`,`mark`) values 
('032501','1000',70);

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `sid` varchar(6) NOT NULL,
  `sname` varchar(16) CHARACTER SET gb2312 NOT NULL,
  `gender` varchar(4) CHARACTER SET gb2312 NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student` */

insert  into `student`(`sid`,`sname`,`gender`) values 
('032501','张三','男');

/*Table structure for table `t_dept` */

DROP TABLE IF EXISTS `t_dept`;

CREATE TABLE `t_dept` (
  `DEPT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `PARENT_ID` bigint(20) NOT NULL COMMENT '上级部门ID',
  `DEPT_NAME` varchar(100) NOT NULL COMMENT '部门名称',
  `ORDER_NUM` bigint(20) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`DEPT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table `t_dept` */

insert  into `t_dept`(`DEPT_ID`,`PARENT_ID`,`DEPT_NAME`,`ORDER_NUM`,`CREATE_TIME`) values 
(1,0,'教务处',0,'2019-04-05 03:59:01'),
(7,0,'学工处',0,'2019-04-03 03:59:18');

/*Table structure for table `t_dict` */

DROP TABLE IF EXISTS `t_dict`;

CREATE TABLE `t_dict` (
  `DICT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典ID',
  `KEYY` bigint(20) NOT NULL COMMENT '键',
  `VALUEE` varchar(100) NOT NULL COMMENT '值',
  `FIELD_NAME` varchar(100) NOT NULL COMMENT '字段名称',
  `TABLE_NAME` varchar(100) NOT NULL COMMENT '表名',
  PRIMARY KEY (`DICT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

/*Data for the table `t_dict` */

insert  into `t_dict`(`DICT_ID`,`KEYY`,`VALUEE`,`FIELD_NAME`,`TABLE_NAME`) values 
(1,0,'男','ssex','t_user'),
(2,1,'女','ssex','t_user'),
(3,2,'保密','ssex','t_user'),
(4,1,'有效','status','t_user'),
(5,0,'锁定','status','t_user'),
(6,0,'菜单','type','t_menu'),
(7,1,'按钮','type','t_menu'),
(30,0,'正常','status','t_job'),
(31,1,'暂停','status','t_job'),
(32,0,'成功','status','t_job_log'),
(33,1,'失败','status','t_job_log');

/*Table structure for table `t_job` */

DROP TABLE IF EXISTS `t_job`;

CREATE TABLE `t_job` (
  `JOB_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `BEAN_NAME` varchar(100) NOT NULL COMMENT 'spring bean名称',
  `METHOD_NAME` varchar(100) NOT NULL COMMENT '方法名',
  `PARAMS` varchar(200) DEFAULT NULL COMMENT '参数',
  `CRON_EXPRESSION` varchar(100) NOT NULL COMMENT 'cron表达式',
  `STATUS` char(2) NOT NULL COMMENT '任务状态  0：正常  1：暂停',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`JOB_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `t_job` */

insert  into `t_job`(`JOB_ID`,`BEAN_NAME`,`METHOD_NAME`,`PARAMS`,`CRON_EXPRESSION`,`STATUS`,`REMARK`,`CREATE_TIME`) values 
(1,'testTask','test','mrbird','0/1 * * * * ?','1','有参任务调度测试','2018-02-24 16:26:14'),
(2,'testTask','test1',NULL,'0/10 * * * * ?','1','无参任务调度测试','2018-02-24 17:06:23'),
(3,'testTask','test','hello world','0/1 * * * * ?','1','有参任务调度测试,每隔一秒触发','2018-02-26 09:28:26'),
(11,'testTask','test2',NULL,'0/5 * * * * ?','1','测试异常','2018-02-26 11:15:30');

/*Table structure for table `t_job_log` */

DROP TABLE IF EXISTS `t_job_log`;

CREATE TABLE `t_job_log` (
  `LOG_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `JOB_ID` bigint(20) NOT NULL COMMENT '任务id',
  `BEAN_NAME` varchar(100) NOT NULL COMMENT 'spring bean名称',
  `METHOD_NAME` varchar(100) NOT NULL COMMENT '方法名',
  `PARAMS` varchar(200) DEFAULT NULL COMMENT '参数',
  `STATUS` char(2) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `ERROR` text COMMENT '失败信息',
  `TIMES` decimal(11,0) DEFAULT NULL COMMENT '耗时(单位：毫秒)',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`LOG_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2485 DEFAULT CHARSET=utf8;

/*Data for the table `t_job_log` */

insert  into `t_job_log`(`LOG_ID`,`JOB_ID`,`BEAN_NAME`,`METHOD_NAME`,`PARAMS`,`STATUS`,`ERROR`,`TIMES`,`CREATE_TIME`) values 
(2448,3,'testTask','test','hello world','0',NULL,0,'2018-03-20 15:31:50'),
(2449,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:31:51'),
(2450,3,'testTask','test','hello world','0',NULL,2,'2018-03-20 15:31:52'),
(2451,3,'testTask','test','hello world','0',NULL,0,'2018-03-20 15:31:53'),
(2452,3,'testTask','test','hello world','0',NULL,2,'2018-03-20 15:31:54'),
(2453,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:31:55'),
(2454,3,'testTask','test','hello world','0',NULL,0,'2018-03-20 15:31:56'),
(2455,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:31:57'),
(2456,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:31:59'),
(2457,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:31:59'),
(2458,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:32:00'),
(2459,3,'testTask','test','hello world','0',NULL,0,'2018-03-20 15:32:01'),
(2460,3,'testTask','test','hello world','0',NULL,5,'2018-03-20 15:32:02'),
(2461,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:32:03'),
(2462,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:32:04'),
(2463,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:32:05'),
(2464,3,'testTask','test','hello world','0',NULL,1,'2018-03-20 15:32:06'),
(2465,11,'testTask','test2',NULL,'1','java.lang.NoSuchMethodException: cc.mrbird.job.task.TestTask.test2()',0,'2018-03-20 15:32:26'),
(2466,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 15:26:40'),
(2467,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 15:26:50'),
(2468,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 15:27:20'),
(2469,2,'testTask','test1',NULL,'0',NULL,3,'2018-04-02 17:29:20'),
(2470,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 17:29:30'),
(2471,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 17:29:40'),
(2472,2,'testTask','test1',NULL,'0',NULL,14,'2018-04-02 17:29:50'),
(2473,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 17:30:00'),
(2474,2,'testTask','test1',NULL,'0',NULL,0,'2018-04-02 17:30:10'),
(2475,2,'testTask','test1',NULL,'0',NULL,1,'2018-04-02 17:30:20'),
(2476,3,'testTask','test','hello world','0',NULL,4,'2018-09-06 14:15:40'),
(2477,11,'testTask','test2',NULL,'1','java.lang.NoSuchMethodException: cc.mrbird.quartz.task.TestTask.test2()',11,'2018-09-06 14:15:50'),
(2478,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:10'),
(2479,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:19'),
(2480,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:20'),
(2481,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:30'),
(2482,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:40'),
(2483,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:16:50'),
(2484,2,'testTask','test1',NULL,'0',NULL,1,'2018-09-06 14:17:00');

/*Table structure for table `t_log` */

DROP TABLE IF EXISTS `t_log`;

CREATE TABLE `t_log` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `USERNAME` varchar(50) DEFAULT NULL COMMENT '操作用户',
  `OPERATION` text COMMENT '操作内容',
  `TIME` decimal(11,0) DEFAULT NULL COMMENT '耗时',
  `METHOD` text COMMENT '操作方法',
  `PARAMS` text COMMENT '方法参数',
  `IP` varchar(64) DEFAULT NULL COMMENT '操作者IP',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `location` varchar(50) DEFAULT NULL COMMENT '操作地点',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_log` */

/*Table structure for table `t_menu` */

DROP TABLE IF EXISTS `t_menu`;

CREATE TABLE `t_menu` (
  `MENU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单/按钮ID',
  `PARENT_ID` bigint(20) NOT NULL COMMENT '上级菜单ID',
  `MENU_NAME` varchar(50) NOT NULL COMMENT '菜单/按钮名称',
  `URL` varchar(100) DEFAULT NULL COMMENT '菜单URL',
  `PERMS` text COMMENT '权限标识',
  `ICON` varchar(50) DEFAULT NULL COMMENT '图标',
  `TYPE` char(2) NOT NULL COMMENT '类型 0菜单 1按钮',
  `ORDER_NUM` bigint(20) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;

/*Data for the table `t_menu` */

insert  into `t_menu`(`MENU_ID`,`PARENT_ID`,`MENU_NAME`,`URL`,`PERMS`,`ICON`,`TYPE`,`ORDER_NUM`,`CREATE_TIME`,`MODIFY_TIME`) values 
(1,0,'系统管理',NULL,NULL,'zmdi zmdi-settings','0',1,'2017-12-27 16:39:07',NULL),
(2,0,'系统监控',NULL,NULL,'zmdi zmdi-shield-security','0',2,'2017-12-27 16:45:51','2018-01-17 17:08:28'),
(3,1,'用户管理','user','user:list','','0',1,'2017-12-27 16:47:13','2018-04-25 09:00:01'),
(4,1,'角色管理','role','role:list','','0',2,'2017-12-27 16:48:09','2018-04-25 09:01:12'),
(5,1,'菜单管理','menu','menu:list','','0',3,'2017-12-27 16:48:57','2018-04-25 09:01:30'),
(6,1,'部门管理','dept','dept:list','','0',4,'2017-12-27 16:57:33','2018-04-25 09:01:40'),
(8,2,'在线用户','session','session:list','','0',1,'2017-12-27 16:59:33','2018-04-25 09:02:04'),
(10,2,'系统日志','log','log:list','','0',3,'2017-12-27 17:00:50','2018-04-25 09:02:18'),
(11,3,'新增用户',NULL,'user:add',NULL,'1',NULL,'2017-12-27 17:02:58',NULL),
(12,3,'修改用户',NULL,'user:update',NULL,'1',NULL,'2017-12-27 17:04:07',NULL),
(13,3,'删除用户',NULL,'user:delete',NULL,'1',NULL,'2017-12-27 17:04:58',NULL),
(14,4,'新增角色',NULL,'role:add',NULL,'1',NULL,'2017-12-27 17:06:38',NULL),
(15,4,'修改角色',NULL,'role:update',NULL,'1',NULL,'2017-12-27 17:06:38',NULL),
(16,4,'删除角色',NULL,'role:delete',NULL,'1',NULL,'2017-12-27 17:06:38',NULL),
(17,5,'新增菜单',NULL,'menu:add',NULL,'1',NULL,'2017-12-27 17:08:02',NULL),
(18,5,'修改菜单',NULL,'menu:update',NULL,'1',NULL,'2017-12-27 17:08:02',NULL),
(19,5,'删除菜单',NULL,'menu:delete',NULL,'1',NULL,'2017-12-27 17:08:02',NULL),
(20,6,'新增部门',NULL,'dept:add',NULL,'1',NULL,'2017-12-27 17:09:24',NULL),
(21,6,'修改部门',NULL,'dept:update',NULL,'1',NULL,'2017-12-27 17:09:24',NULL),
(22,6,'删除部门',NULL,'dept:delete',NULL,'1',NULL,'2017-12-27 17:09:24',NULL),
(23,8,'踢出用户','','session:kickout','','1',NULL,'2017-12-27 17:11:13','2018-09-06 18:45:27'),
(24,10,'删除日志',NULL,'log:delete',NULL,'1',NULL,'2017-12-27 17:11:45',NULL),
(58,0,'网络资源',NULL,NULL,'zmdi zmdi-globe-alt','0',NULL,'2018-01-12 15:28:48','2018-01-22 19:49:26'),
(59,58,'天气查询','weather','weather:list','','0',NULL,'2018-01-12 15:40:02','2018-04-25 09:02:57'),
(61,58,'每日一文','article','article:list','','0',NULL,'2018-01-15 17:17:14','2018-04-25 09:03:08'),
(64,1,'字典管理','dict','dict:list','','0',NULL,'2018-01-18 10:38:25','2018-09-07 21:23:58'),
(65,64,'新增字典',NULL,'dict:add',NULL,'1',NULL,'2018-01-18 19:10:08',NULL),
(66,64,'修改字典',NULL,'dict:update',NULL,'1',NULL,'2018-01-18 19:10:27',NULL),
(67,64,'删除字典',NULL,'dict:delete',NULL,'1',NULL,'2018-01-18 19:10:47',NULL),
(81,58,'影视资讯',NULL,NULL,NULL,'0',NULL,'2018-01-22 14:12:59',NULL),
(82,81,'正在热映','movie/hot','movie:hot','','0',NULL,'2018-01-22 14:13:47','2018-04-25 09:03:48'),
(83,81,'即将上映','movie/coming','movie:coming','','0',NULL,'2018-01-22 14:14:36','2018-04-25 09:04:05'),
(101,0,'任务调度',NULL,NULL,'zmdi zmdi-alarm','0',NULL,'2018-02-24 15:52:57',NULL),
(102,101,'定时任务','job','job:list','','0',NULL,'2018-02-24 15:53:53','2018-04-25 09:05:12'),
(103,102,'新增任务',NULL,'job:add',NULL,'1',NULL,'2018-02-24 15:55:10',NULL),
(104,102,'修改任务',NULL,'job:update',NULL,'1',NULL,'2018-02-24 15:55:53',NULL),
(105,102,'删除任务',NULL,'job:delete',NULL,'1',NULL,'2018-02-24 15:56:18',NULL),
(106,102,'暂停任务',NULL,'job:pause',NULL,'1',NULL,'2018-02-24 15:57:08',NULL),
(107,102,'恢复任务',NULL,'job:resume',NULL,'1',NULL,'2018-02-24 15:58:21',NULL),
(108,102,'立即执行任务',NULL,'job:run',NULL,'1',NULL,'2018-02-24 15:59:45',NULL),
(109,101,'调度日志','jobLog','jobLog:list','','0',NULL,'2018-02-24 16:00:45','2018-04-25 09:05:25'),
(110,109,'删除日志',NULL,'jobLog:delete',NULL,'1',NULL,'2018-02-24 16:01:21',NULL),
(113,2,'Redis监控','redis/info','redis:list','','0',NULL,'2018-06-28 14:29:42',NULL),
(114,2,'Redis终端','redis/terminal','redis:terminal','','0',NULL,'2018-06-28 15:35:21',NULL);

/*Table structure for table `t_role` */

DROP TABLE IF EXISTS `t_role`;

CREATE TABLE `t_role` (
  `ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `ROLE_NAME` varchar(100) NOT NULL COMMENT '角色名称',
  `REMARK` varchar(100) DEFAULT NULL COMMENT '角色描述',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `t_role` */

insert  into `t_role`(`ROLE_ID`,`ROLE_NAME`,`REMARK`,`CREATE_TIME`,`MODIFY_TIME`) values 
(1,'管理员','管理员','2017-12-27 16:23:11','2018-02-24 16:01:45'),
(2,'注册用户','注册用户','2018-09-04 16:23:09','2018-09-15 14:56:53');

/*Table structure for table `t_role_menu` */

DROP TABLE IF EXISTS `t_role_menu`;

CREATE TABLE `t_role_menu` (
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID',
  `MENU_ID` bigint(20) NOT NULL COMMENT '菜单/按钮ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_role_menu` */

insert  into `t_role_menu`(`ROLE_ID`,`MENU_ID`) values 
(1,59),
(1,2),
(1,3),
(1,67),
(1,1),
(1,4),
(1,5),
(1,6),
(1,20),
(1,21),
(1,22),
(1,10),
(1,8),
(1,58),
(1,66),
(1,11),
(1,12),
(1,64),
(1,13),
(1,14),
(1,65),
(1,15),
(1,16),
(1,17),
(1,18),
(1,23),
(1,81),
(1,82),
(1,83),
(1,19),
(1,24),
(1,61),
(1,101),
(1,102),
(1,103),
(1,104),
(1,105),
(1,106),
(1,107),
(1,108),
(1,109),
(1,110),
(1,113),
(1,114),
(2,1),
(2,3),
(2,4),
(2,2),
(2,8),
(2,11),
(2,14),
(2,5),
(2,17),
(2,6),
(2,20),
(2,64),
(2,65),
(2,10),
(2,113),
(2,114),
(2,58),
(2,59),
(2,61),
(2,81),
(2,82),
(2,83),
(2,101),
(2,102),
(2,103),
(2,109);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `USER_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `USERNAME` varchar(50) NOT NULL COMMENT '用户名',
  `PASSWORD` varchar(128) NOT NULL COMMENT '密码',
  `DEPT_ID` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `EMAIL` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `MOBILE` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `STATUS` char(1) NOT NULL COMMENT '状态 0锁定 1有效',
  `CRATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  `LAST_LOGIN_TIME` datetime DEFAULT NULL COMMENT '最近访问时间',
  `SSEX` char(1) DEFAULT NULL COMMENT '性别 0男 1女',
  `THEME` varchar(10) DEFAULT NULL COMMENT '主题',
  `AVATAR` varchar(100) DEFAULT NULL COMMENT '头像',
  `DESCRIPTION` varchar(100) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`USER_ID`,`USERNAME`,`PASSWORD`,`DEPT_ID`,`EMAIL`,`MOBILE`,`STATUS`,`CRATE_TIME`,`MODIFY_TIME`,`LAST_LOGIN_TIME`,`SSEX`,`THEME`,`AVATAR`,`DESCRIPTION`) values 
(1,'a','$2a$10$WRUqPfZUAhRgwaiuBPE0XeUoPZKFgGTkRjaU04dHnL99leE4kBv1W',1,'mrbird@qq.com','17788888888','1','2018-08-22 11:37:47','2018-09-15 14:53:52','2018-08-27 21:27:18','2','green','20180414165909.jpg','我是创始人'),
(2,'b','$2a$10$vtf0gsIpFnzs3x9kA/2fW.oV41aAXFt4e4S0vBURGuFdLJ5F7xx2W',2,'scott@qq.com','','1','2018-08-22 11:37:47','2018-09-15 14:54:36','2018-08-27 21:27:18','1','red','20180414170003.jpg',''),
(16,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:14',NULL,NULL,NULL,NULL,NULL,NULL),
(17,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL),
(18,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL),
(19,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL),
(20,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL),
(21,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL),
(22,'tete','123456',2,NULL,NULL,'1','2019-05-05 16:03:15',NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `t_user_role` */

DROP TABLE IF EXISTS `t_user_role`;

CREATE TABLE `t_user_role` (
  `USER_ID` bigint(20) NOT NULL COMMENT '用户ID',
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='该表是用户关联角色的。';

/*Data for the table `t_user_role` */

insert  into `t_user_role`(`USER_ID`,`ROLE_ID`) values 
(1,1),
(2,2);

/*Table structure for table `t_userconnection` */

DROP TABLE IF EXISTS `t_userconnection`;

CREATE TABLE `t_userconnection` (
  `userId` varchar(255) NOT NULL,
  `providerId` varchar(255) NOT NULL,
  `providerUserId` varchar(255) NOT NULL,
  `rank` int(11) NOT NULL,
  `displayName` varchar(255) DEFAULT NULL,
  `profileUrl` varchar(512) DEFAULT NULL,
  `imageUrl` varchar(512) DEFAULT NULL,
  `accessToken` varchar(512) NOT NULL,
  `secret` varchar(512) DEFAULT NULL,
  `refreshToken` varchar(512) DEFAULT NULL,
  `expireTime` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`userId`,`providerId`,`providerUserId`),
  UNIQUE KEY `UserConnectionRank` (`userId`,`providerId`,`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_userconnection` */

/*Table structure for table `user1` */

DROP TABLE IF EXISTS `user1`;

CREATE TABLE `user1` (
  `id` varchar(18) CHARACTER SET gb2312 NOT NULL,
  `password` varchar(16) CHARACTER SET gb2312 NOT NULL,
  `tswt` varchar(20) NOT NULL,
  `mmda` varchar(20) NOT NULL,
  `email` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user1` */

/*Table structure for table `user2` */

DROP TABLE IF EXISTS `user2`;

CREATE TABLE `user2` (
  `id` varchar(18) CHARACTER SET gb2312 NOT NULL,
  `sid` varchar(20) CHARACTER SET gb2312 NOT NULL,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `birthd` varchar(8) CHARACTER SET gb2312 NOT NULL,
  `gender` varchar(2) NOT NULL,
  `mz` varchar(2) NOT NULL,
  `zzmm` varchar(4) NOT NULL,
  `tel` varchar(15) CHARACTER SET gb2312 NOT NULL,
  `address` varchar(20) NOT NULL,
  `school` varchar(10) NOT NULL,
  `schoolc` varchar(10) NOT NULL,
  `major` varchar(10) CHARACTER SET gb2312 NOT NULL,
  `gkbmh` varchar(20) CHARACTER SET gb2312 NOT NULL,
  `bkschool` varchar(10) CHARACTER SET gb2312 NOT NULL,
  `bkcode` varchar(10) CHARACTER SET gb2312 NOT NULL,
  `bkmajor` varchar(10) NOT NULL,
  `mcode` varchar(10) CHARACTER SET gb2312 NOT NULL,
  `jl` varchar(50) DEFAULT NULL,
  `tc` varchar(50) DEFAULT NULL,
  `lxaddress` varchar(20) NOT NULL,
  `state` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `user2_ibfk_2` FOREIGN KEY (`id`) REFERENCES `user1` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user2` */

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `systemId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '系统默认id',
  `id` varchar(18) NOT NULL DEFAULT '0' COMMENT '身份证号',
  `password` varchar(20) NOT NULL DEFAULT 'sdfeafeasdfasfasd' COMMENT '密码',
  `tswt` varchar(20) DEFAULT NULL COMMENT '提示问题',
  `mmda` varchar(20) DEFAULT NULL COMMENT '问题答案',
  `email` varchar(100) NOT NULL DEFAULT 'NULL' COMMENT '邮箱',
  `sid` varchar(20) DEFAULT '2' COMMENT '用户的角色id，1为管理员，2为普通用户',
  `name` varchar(20) DEFAULT NULL COMMENT '姓名',
  `birthd` varchar(20) DEFAULT NULL COMMENT '生日',
  `gender` varchar(20) DEFAULT NULL COMMENT '性别',
  `mz` varchar(20) DEFAULT NULL COMMENT '民族',
  `zzmm` varchar(20) DEFAULT NULL COMMENT '政治面貌',
  `tel` varchar(20) DEFAULT NULL COMMENT '电话号',
  `address` varchar(40) DEFAULT NULL COMMENT '地址',
  `school` varchar(20) DEFAULT NULL COMMENT '大专学校',
  `schoolc` varchar(20) DEFAULT NULL COMMENT '学校代码',
  `major` varchar(20) DEFAULT NULL COMMENT '主修科目',
  `gkbmh` varchar(20) DEFAULT NULL COMMENT '高考报名号',
  `bkmajor` varchar(20) DEFAULT NULL COMMENT '报考科目',
  `mcode` varchar(40) DEFAULT NULL COMMENT '报考专业的代码',
  `jl` varchar(40) DEFAULT NULL COMMENT '登陆次数记录',
  `tc` varchar(40) DEFAULT NULL COMMENT '退出',
  `lxaddress` varchar(40) DEFAULT NULL COMMENT '联系地址',
  `yb` varchar(20) DEFAULT NULL COMMENT '邮编',
  `state` varchar(40) DEFAULT NULL COMMENT '状态',
  `sj` varchar(50) DEFAULT '' COMMENT '时间',
  `zkzh` varchar(20) DEFAULT NULL COMMENT '准考证号',
  `sf` varchar(20) DEFAULT NULL COMMENT '省份',
  `creat_time` datetime NOT NULL DEFAULT '0000-01-01 00:00:00' COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最近访问时间',
  `theme` varchar(10) DEFAULT NULL COMMENT '主题',
  `avatar` varchar(100) DEFAULT NULL COMMENT '头像',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `account_status` int(1) DEFAULT '1' COMMENT '账号状态:0锁定 1有效',
  `isDelete` tinyint(1) DEFAULT '1' COMMENT '是否被删除:0=删除;1=没有',
  `kskm1` varchar(10) DEFAULT NULL COMMENT '考试科目1',
  `kskm2` varchar(10) DEFAULT NULL COMMENT '考试科目2',
  `kskm3` varchar(10) DEFAULT NULL COMMENT '考试科目3',
  `kskm4` varchar(10) DEFAULT NULL COMMENT '考试科目4',
  PRIMARY KEY (`systemId`),
  KEY `systemId` (`systemId`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`systemId`,`id`,`password`,`tswt`,`mmda`,`email`,`sid`,`name`,`birthd`,`gender`,`mz`,`zzmm`,`tel`,`address`,`school`,`schoolc`,`major`,`gkbmh`,`bkmajor`,`mcode`,`jl`,`tc`,`lxaddress`,`yb`,`state`,`sj`,`zkzh`,`sf`,`creat_time`,`modify_time`,`last_login_time`,`theme`,`avatar`,`description`,`account_status`,`isDelete`,`kskm1`,`kskm2`,`kskm3`,`kskm4`) values 
(1,'111111111111111111','123456','1','1','admin@admin','1','张小凡','1995/01/01','男','1','党员','1','1','1','1','1','11111111111111','会计学','120203K','68','1','1','1','审核通过','2017-03-24 14:10:29','201601001','湖北省','2019-04-16 19:00:02',NULL,'2019-05-07 14:48:38',NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL),
(37,'421127199909098888','123456','提示问题','问题答案','hi@gobyte.cn','2','张三',NULL,'男','民族','党员','18627758335','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','计算机科学与技术','080605','126',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-04-24 15:25:32','2019-05-05 05:45:06','2019-05-05 14:48:15',NULL,NULL,NULL,1,1,'c语言','计算机基础',NULL,NULL),
(38,'130730199405281821','123456','提示问题','问题答案','hi@goby156te.cn','2','赵四',NULL,'男','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','计算机科学与技术','080605','6',NULL,'联系地址','邮编','审核失败',NULL,NULL,NULL,'2019-04-26 17:42:15',NULL,'2019-04-26 19:01:25',NULL,NULL,NULL,1,1,'c语言','计算机基础',NULL,NULL),
(40,'421127199909098123','1','提示问题','问题答案','hi@go23byte.cn','2','尼古拉',NULL,'男','民族','团员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工程管理','110104','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:36:27',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(41,'421127199909098812','1','提示问题','问题答案','hi@gobdyte.cn','2','天明',NULL,'男','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工程管理','110104','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:36:53',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(42,'421127199909098833','1','提示问题','问题答案','hi@go232byte.cn','2','名字',NULL,'男','民族','团员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工商管理','120201K','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:39:31',NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL),
(43,'421127199909098324','1','提示问题','问题答案','hi@gobdfyte.cn','2','欧阳锋',NULL,'男','民族','预备党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','材料成型及控制工程','080302','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:40:38',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(44,'421127199909098824','1','提示问题','问题答案','hi@goby12te.cn','2','步惊云',NULL,'男','民族','预备党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工商管理','120201K','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:42:56',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(45,'421127199011010236','166666','我是谁','2222','h123i@gobyte.cn','2','小风',NULL,'男','汉族','党员','15727135764','湖北省武汉市洪山区青菱街道武汉科技大学','武昌工学院','020202','网络工程','00000000000000','土木工程','080703','0',NULL,'湖北省黄冈市','435500','未审核',NULL,NULL,NULL,'2019-05-05 14:52:36',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(46,'421127199609098888','888888','hi','hi','45454hi@gobyte.cn','2','大牛',NULL,'男','汉族','党员','15166663322','黑龙江省大庆市','武昌工学院','5665656','计算机科学','00000000000000','工程管理','110104','0',NULL,'湖北省黄梅县','4666222','未审核',NULL,NULL,NULL,'2019-05-05 14:54:09',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(47,'421127199909098827','1','提示问题','问题答案','hi@gobyte232cn','2','哪吒',NULL,'男','民族','群众','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','材料成型及控制工程','080302','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:56:01',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(48,'421127199909094868','1','提示问题','问题答案','hi@go123byte.cn','2','孙悟空',NULL,'男','民族','团员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','计算机科学与技术','080605','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:56:17',NULL,NULL,NULL,NULL,NULL,1,1,'c语言','计算机基础',NULL,NULL),
(49,'421127199909095656','1','提示问题','问题答案','hi@gobyte2415.cn','2','白龙马',NULL,'男','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工商管理','120201K','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:56:47',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(50,'421127199909098546','1','提示问题','问题答案','hi@go999byte.cn','2','沙僧',NULL,'男','民族','群众','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','土木工程','080703','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:57:06',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(51,'421127199909099888','1','提示问题','问题答案','hi@gosasabyte.cn','2','三藏',NULL,'女','民族','其它','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','英语','050201','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:57:27',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(52,'421127199409098888','1','提示问题','问题答案','hi@gob6ayte.cn','2','段誉',NULL,'女','民族','预备党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工程管理','110104','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:57:45',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(53,'421127197909098888','1','提示问题','问题答案','hi@goa8yte.cn','2','托尼-史塔克',NULL,'男','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','人力资源管理','120206','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:58:08',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(54,'421127199909045888','1','提示问题','问题答案','hi@gob31yte.cn','2','强森',NULL,'男','民族','其它','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','食品质量与安全','081407W','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:58:28',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(55,'421127199909096688','1','提示问题','问题答案','hi@goby66te.cn','2','格鲁特',NULL,'女','民族','预备党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','计算机科学与技术','080605','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 14:58:42',NULL,NULL,NULL,NULL,NULL,1,1,'c语言','计算机基础',NULL,NULL),
(56,'421127199611082814','1','提示问题','问题答案','h46i@gobyte.cn','2','火箭',NULL,'男','汉族','团员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工程管理','110104','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 15:00:48',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(57,'421127199609096188','1','提示问题','问题答案','yyhi@gobyte.cn','2','灭霸',NULL,'女','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','英语','050201','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-05 15:01:14',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(58,'421127199909098866','1','提示问题','问题答案','hi@godfbyte.cn','2','绿巨人',NULL,'男','民族','预备党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','人力资源管理','120206','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-07 02:33:56',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(159,'421127199909098235','1','提示问题','问题答案','hi@gobdfdyte.cn','2','名扬',NULL,'男','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','工商管理','120201K','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-07 04:44:33',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(160,'421127199909098880','1','提示问题','问题答案','hi@gob323yte.cn','2','碧瑶',NULL,'女','民族','党员','电话手机号','家庭地址','大专就读学校','大专学校代码','大专专业','00000000000000','英语','050201','0',NULL,'联系地址','邮编','未审核',NULL,NULL,NULL,'2019-05-07 04:49:56',NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;