📄 edu.sql
字号:
#
CREATE TABLE `grade` (
`grade_id` int(10) NOT NULL auto_increment COMMENT '学历编号',
`grade` varchar(20) collate gbk_bin default NULL COMMENT '高一/初一年级',
PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;
#
# Dumping data for table grade
#
INSERT INTO `grade` (`grade_id`,`grade`) VALUES (1,'高中');
INSERT INTO `grade` (`grade_id`,`grade`) VALUES (2,'初中');
INSERT INTO `grade` (`grade_id`,`grade`) VALUES (3,'小学');
#
# Table structure for table help
#
CREATE TABLE `help` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(60) default NULL COMMENT '主题',
`content` text COMMENT '内容',
`time` varchar(50) default NULL COMMENT '发表时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='帮助';
#
# Dumping data for table help
#
INSERT INTO `help` (`id`,`title`,`content`,`time`) VALUES (1,'帮助','测试测试11111','2006-12-24 23:31:57');
INSERT INTO `help` (`id`,`title`,`content`,`time`) VALUES (2,'帮助帮助帮助帮助帮助','帮助帮助帮助帮助帮助!!!!!','2006-12-24 23:31:57');
#
# Table structure for table note
#
CREATE TABLE `note` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(60) default NULL COMMENT '主题',
`content` text COMMENT '内容',
`time` varchar(50) default NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='公告';
#
# Dumping data for table note
#
INSERT INTO `note` (`id`,`title`,`content`,`time`) VALUES (1,'公告:公告:公告:公告:公告:',' 测试测试ServletnoteServletnoteServletnoteServletnoteServletnoteServletnote','2006-12-24 23:31:57');
#
# Table structure for table subject
#
CREATE TABLE `subject` (
`subject_id` int(10) NOT NULL auto_increment COMMENT '学科编号',
`class_id` int(11) default NULL COMMENT '年级编号',
`grade_id` int(11) default NULL COMMENT '学历编号',
`subject` varchar(20) collate gbk_bin default NULL COMMENT '科目名称',
PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;
#
# Dumping data for table subject
#
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (1,1,1,'英语');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (2,1,1,'语文');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (3,1,1,'数学');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (4,2,1,'英语');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (5,2,1,'语文');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (6,2,1,'数学');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (7,3,1,'英语');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (8,3,1,'语文');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (9,3,1,'数学');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (10,4,2,'语文');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (11,4,2,'数学');
INSERT INTO `subject` (`subject_id`,`class_id`,`grade_id`,`subject`) VALUES (12,4,2,'英语');
#
# Table structure for table teacher
#
CREATE TABLE `teacher` (
`t_id` int(10) NOT NULL auto_increment COMMENT '编号',
`t_teacher` varchar(50) collate gbk_bin default NULL COMMENT '教师名字',
`t_psw` varchar(50) collate gbk_bin default NULL COMMENT '密码',
`t_age` int(10) default NULL COMMENT '年龄',
`t_sex` varchar(50) collate gbk_bin default NULL COMMENT '性别',
`class_id` int(10) default NULL COMMENT '高中/初中/小学',
`grade_id` int(10) default NULL COMMENT '年级',
`subject_id` int(10) default NULL COMMENT '科目',
`t_address` varchar(50) collate gbk_bin default NULL COMMENT '地址',
`t_idcard` varchar(30) collate gbk_bin default NULL COMMENT '身份证号码',
`t_mobile` varchar(13) collate gbk_bin default NULL COMMENT '手机号码',
`t_email` varchar(50) collate gbk_bin default NULL COMMENT 'e-mail',
`t_photo` varchar(50) collate gbk_bin default NULL COMMENT '照片地址',
`t_allow` tinyint(1) NOT NULL default '0' COMMENT '是否有效',
`t_ask` varchar(50) collate gbk_bin default NULL COMMENT '密码问题',
`t_answer` varchar(50) collate gbk_bin default NULL COMMENT '密码答案',
`t_day` varchar(50) collate gbk_bin default NULL COMMENT '注册时间',
PRIMARY KEY (`t_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;
#
# Dumping data for table teacher
#
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (1,'xdf','1AB5EFB86F0F82515A57B839A7650DBA',25,'男',1,1,1,'杭州','3306821984','1363451246','xdf@163.com',NULL,1,'密码问题','密码答案',NULL);
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (2,'xdf001','1AB5EFB86F0F82515A57B839A7650DBA',24,'男',1,1,1,'杭州','5465456465','5467676','xdf008@163.com',NULL,1,'aaaa','aaaa',NULL);
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (3,'老师','1AB5EFB86F0F82515A57B839A7650DBA',45,'男',1,1,2,'asdrwe','565886','876','4hf@452.com',NULL,0,'密码问题','密码答案',NULL);
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (4,'aaaewr','0B4E7A0E5FE84AD35FB5F95B9CEEAC79',24,'女',1,1,1,'','56786+7867','','asrfar@dsraw.com',NULL,0,'aaaa','aaaa','2007-1-24 23:37:40');
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (5,'dddd','0B4E7A0E5FE84AD35FB5F95B9CEEAC79',22,'男',4,2,10,'','7867686967','','sdrfs@erwer.com',NULL,0,'sdfsdf','sdfsdfs','2007-1-24 23:40:25');
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (6,'ggggggggg','E10ADC3949BA59ABBE56E057F20F883E',22,'男',2,1,5,'','7676','','asrfar@dsraw.com',NULL,0,'awrwer','r3wrwr','2007-1-24 23:47:33');
INSERT INTO `teacher` (`t_id`,`t_teacher`,`t_psw`,`t_age`,`t_sex`,`class_id`,`grade_id`,`subject_id`,`t_address`,`t_idcard`,`t_mobile`,`t_email`,`t_photo`,`t_allow`,`t_ask`,`t_answer`,`t_day`) VALUES (7,'aaaaaaaaaa','0B4E7A0E5FE84AD35FB5F95B9CEEAC79',45,'男',1,1,2,'杭州','56786+7867','','asrfar@dsraw.com',NULL,0,'saf','afaf','2007-1-25 20:10:00');
#
# Table structure for table user
#
CREATE TABLE `user` (
`u_id` int(10) NOT NULL auto_increment COMMENT '用户编号',
`u_name` varchar(50) collate gbk_bin default NULL COMMENT '用户名',
`u_psw` varchar(50) collate gbk_bin default NULL COMMENT '密码',
`u_day` varchar(50) collate gbk_bin default NULL COMMENT '剩下的有效时间',
`u_age` varchar(10) collate gbk_bin default NULL COMMENT '年龄',
`u_sex` varchar(50) collate gbk_bin default NULL COMMENT '性别',
`u_address` varchar(50) collate gbk_bin default NULL COMMENT '地址',
`u_email` varchar(50) collate gbk_bin default NULL COMMENT 'email',
`u_allowday` varchar(50) collate gbk_bin default NULL COMMENT '有效期',
`u_photo` varchar(50) collate gbk_bin default NULL COMMENT '照片地址',
`u_ask` varchar(50) collate gbk_bin default NULL COMMENT '密码找回问题',
`u_answer` varchar(50) collate gbk_bin default NULL COMMENT '密码找回问题答案',
`u_forbid` tinyint(1) NOT NULL default '0' COMMENT '是否被封号',
PRIMARY KEY (`u_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;
#
# Dumping data for table user
#
INSERT INTO `user` (`u_id`,`u_name`,`u_psw`,`u_day`,`u_age`,`u_sex`,`u_address`,`u_email`,`u_allowday`,`u_photo`,`u_ask`,`u_answer`,`u_forbid`) VALUES (9,'xdf008','1AB5EFB86F0F82515A57B839A7650DBA',NULL,'22','男','浙江','xdf008@163.com','2007-06-28 16:46:44',NULL,'密码问题','密码答案',0);
INSERT INTO `user` (`u_id`,`u_name`,`u_psw`,`u_day`,`u_age`,`u_sex`,`u_address`,`u_email`,`u_allowday`,`u_photo`,`u_ask`,`u_answer`,`u_forbid`) VALUES (10,'xdf','1AB5EFB86F0F82515A57B839A7650DBA',NULL,'23','男','杭州','xdf008@163.com',NULL,NULL,'ggggg','ggggg',0);
INSERT INTO `user` (`u_id`,`u_name`,`u_psw`,`u_day`,`u_age`,`u_sex`,`u_address`,`u_email`,`u_allowday`,`u_photo`,`u_ask`,`u_answer`,`u_forbid`) VALUES (14,'1245','1AB5EFB86F0F82515A57B839A7650DBA','2007-1-6 18:46:05','','男','','xdf008@455.com',NULL,NULL,'aaaa','aaaa',0);
INSERT INTO `user` (`u_id`,`u_name`,`u_psw`,`u_day`,`u_age`,`u_sex`,`u_address`,`u_email`,`u_allowday`,`u_photo`,`u_ask`,`u_answer`,`u_forbid`) VALUES (15,'798797','D41D8CD98F00B204E9800998ECF8427E','2007-1-6 18:52:22','','男','','utuyt@452.jg',NULL,NULL,'fghff','uytuyt',0);
#
# Table structure for table uteacher
#
CREATE TABLE `uteacher` (
`id` int(11) NOT NULL auto_increment,
`t_id` int(10) default NULL COMMENT '教师编号',
`t_about` text collate gbk_bin COMMENT '简介',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;
#
# Dumping data for table uteacher
#
INSERT INTO `uteacher` (`id`,`t_id`,`t_about`) VALUES (1,1,'时度毫时毫度 ');
INSERT INTO `uteacher` (`id`,`t_id`,`t_about`) VALUES (2,2,'ihi');
INSERT INTO `uteacher` (`id`,`t_id`,`t_about`) VALUES (3,4,'rwaw45');
#
# Table structure for table uuser
#
CREATE TABLE `uuser` (
`id` int(11) NOT NULL auto_increment,
`u_id` int(11) default NULL COMMENT '学生编号',
`u_about` text COMMENT '简介',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
#
# Dumping data for table uuser
#
INSERT INTO `uuser` (`id`,`u_id`,`u_about`) VALUES (1,15,'463w6w');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -