/*
SQLyog Community v13.1.7 (64 bit)
MySQL - 5.7.19 : Database - teacher_system
*********************************************************************
*/
/*!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*/`teacher_system` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `teacher_system`;
/*Table structure for table `a_login` */
DROP TABLE IF EXISTS `a_login`;
CREATE TABLE `a_login` (
`adId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`adPhone` varchar(60) NOT NULL,
`adPassword` varchar(60) NOT NULL,
`adName` varchar(60) NOT NULL,
PRIMARY KEY (`adId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `a_login` */
insert into `a_login`(`adId`,`adPhone`,`adPassword`,`adName`) values
(1,'13227066995','123456','刘恒');
/*Table structure for table `t_login` */
DROP TABLE IF EXISTS `t_login`;
CREATE TABLE `t_login` (
`teacherId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`teacherPhone` varchar(60) NOT NULL,
`teacherPassword` varchar(60) NOT NULL,
`teacherName` varchar(60) NOT NULL,
`teacherBrith` varchar(60) NOT NULL,
`teacherCity` varchar(60) NOT NULL,
`teacherSchool` varchar(1000) NOT NULL,
`teacherZhuanYe` varchar(1000) NOT NULL,
`teacherXueLi` varchar(1000) NOT NULL,
`teacherShengFen` varchar(1000) NOT NULL,
`teacherQu` varchar(1000) NOT NULL,
`sex` varchar(60) NOT NULL,
`experience` text NOT NULL,
`picture` longtext NOT NULL,
PRIMARY KEY (`teacherId`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*Data for the table `t_login` */
insert into `t_login`(`teacherId`,`teacherPhone`,`teacherPassword`,`teacherName`,`teacherBrith`,`teacherCity`,`teacherSchool`,`teacherZhuanYe`,`teacherXueLi`,`teacherShengFen`,`teacherQu`,`sex`,`experience`,`picture`) values
(1,'132222222222','123456','刘恒','2022-05-03','西安','西安邮电大学','电子信息科学与技术','本科','陕西省','长安区','男','222','data:image/jpeg;base64,/9j/4QCORXhpZgAATU0AKgAAAAgABQEAAAMAAAABA0cAAAEBAAMAAAABBG4AAIdpAAQAAAABAAAASgESAAMAAAABAAAAAAEyAAIAAAABAAAAAAAAAAAAAZIIAAQAAAABAAAAAAAAAAAAAwEAAAMAAAABA0cAAAEBAAMAAAABBG4AAAEyAAIAAAABAAAAAAAAAAD/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wgARCARuA0cDASIAAhEBAxEB/8QAHAABAAMBAQEBAQAAAAAAAAAAAAECAwQFBgcI/8QAGgEBAQEBAQEBAAAAAAAAAAAAAAECAwQFBv/aAAwDAQACEAMQAAAB4h+k/KAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABUSkgRMAJIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACkwgwm9p8vl4+n3XzNefX6h85az6F4F7PceX0dOXay068pQuJmsyAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABl5fH1etl89h5fb9K+Wc9/VafKzZ9D8/nXj6EaPN6cY2S4tqmaaySrardvDTePpPQ+J09fj+3fO+37/n9EHfzSgzIgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABNRMM27+Zw8XzvrXyZ/P+jnlvTNrrnaWOqPSPLi/OdNsdLL1mCImkREVLUtBnGkFZiCdMr6z7ns/Gae3xfaPM9L6Xy7DfEiWAAAAAUAAAAAAAAAAAAAAAAAAAAAAAAAACYAck7PntI+R9utJz8vqcyM2t63stWZi/oef7LXjcfveUnPpTQvNr2QsMq3sc7bIiI0KtKxWbXM73rVvT8+/Xl9Tb573/r/ABbjv5JgZIEgARIABQAAAAAAAAAAAAAAAAAAAAAAAABnN4+Fo+P92lZ5PL7JpNjGu0SYzFxEWOj1PE7Gvb8P6DDOvmsu/iuGmOtmxKVzRbFoqRSxL3x0XVa61tUlNb5l+vjnpj6m3h+39r4Uk9fNWYliJgSAAQSFAAAAAAAAAAAAAAAAAAAAAAgWJgswTUeL0eX87614tz/O+mi9oil4XPnSit4GOuZTq59s33fR8j6Cb+Z8v3/IueW1b3MX1VCkGVenMpMDWtuow1rK3i0pjrGRab4HR7Hg7ejh9Q5Oz7PwYmJ3xgEhAgAFAAAAAAAAAAAAAAAAAAAAAAgUJajHbwvP6uW2dfjfdkZtrZUjXGLLWJgzhBpjqMNSa9b6L5z6jOsPmvqfnDxs+utxXaGopvkY00oRetxpMmqCzfKEtSal2dylmZ3fQ/K+n7vD7c1n6vxZiYuQZkQACgAAAAAAAAAAAAAAAAAAAAAQLSYb4Pneng+L93a/Pv5fVqjInKlzW+XQTXfI5cOnmi0pMtNDXoex5PoY37vld1F+X4va4NYxuzuaZ742ZRNiusaGkyEKlazkTOdTS2VTuzroZ9PHc+n7fmvoPs/E1Hq8AMgAAAoAAAAAAAAAAAAAAAAAAAAEJXTzPR+a8vt82lJ+L9vffm6ljLTMrEDffkg6p5eszx2mb5enp3zrm19b1JvxPZ6+vO+enfieF5X1nJc/Gx9L5+seNj6PJc87SLl05bWQtRK5aYk0gYtMTTOLkdfBodvPeTb3PmfR78fqGen3PzwlzBAAUAAAAAAAAAAAAAAAAAAAAACBenJ8j7Hz/wAb7czTfx+zToxtVqaZFJnmJikx1dvH2ze+u/tzp5Hu+j18+vNt26S8fXvonNTtk8zn9fM8bL2qHyvB9phb8HxfovPc/n1fr/I3jx8+vl1ywx0wYRSK2zQRaloUuL7ctzS+avpvV+S+p+t8bQe758oslUpBCASAAFAAAAAAAAAAAAAAAAABYz08vn6Pn+HTP4X6Cd8pxq2+Kt8bZDMiuj0JvH2ev6Ln6M/Wv3Z1lv0aSYX2VXSRC0mLQmDaFwr0l48+2E87k9kvzHkfd89fmHl/qXl6x+Z5/aeBvl5a1bylaBNbFaa5pN8pXr+j+W9b0+f6cn7f59JcglQJRJJBKBIUAAAAAAAAAAAAAAAAAGq/K/SfG/P+rzTD5n1LImE1tGmc724dXR9Rjt5H0Hrehz7cPo7dUZ9E3sTabmJuKLQQFAmBYixM40qRXZHPTozrlx7c483yPpOa6/Mvn/1n4vfL5mbZb4X1w0S1NsjKt6l+jl1r7Hs8H3vu/AlE9/JKJSpIIQAAFAAAAAAkQAAAAAAAAAADfk/Ke74HxfvEPJ6pRNTEST6PN9hjt2/TU6+XdrOsW1jTci0WZtMXCRAKRMKAmJUmUotCAlc9KLnTWpjj1Zy8HnevzTX5/wDL/q3wW8eDpWvTzbaZXsxjXMppQex9V8P9n9P5e0xP0vlSgyIAQAAFAAAAAAkQAAAAAAAAAgtVty47fM+Z083wP0UInGpTUaU9GX2/uPP9nj6dta3mtdctTW1Z1J0z0LXpapIRW1YiJLAAJAFgJWl6zWdb0GelI5+fqxa4vD+h5Zfyvg+5+R7efkvnOuG2VpXOJqa/X/G/Tezye4PsfCC8wUEAAABQAAAAJEAAAAAAAAAQmLXl+p4Xn9nztL5/C+7WYlbUWXX6Pwfq87+p9Lj7+Pe+lLy6656WXmrV0vnolr0vQIiYiqYVEiASALlMSVpejVKaUK1mMymG+bXPz9WEeb8d935On5ln6nl9fK0y0uYrME+x43Z15/cTS/3vzoa5QEAAAAABQAQFAkQAAAAAAAAADcfMfRfJ+H6Pn0mvyfrxMSi1br3fa/I/f47+t1Za8+t9M7xrfLStLVtVrReybRLKEKmpZQllUSgWiBaYXMwEVvUzreNWlbVzKZa5y4Y9GMc/J2Yr8T8n+ifB9OPFesb42rapOmdrPuenzfT+/wDnYHXgDIAAAAAAAAALIgAAAAAAAAAQ3z/IfU/H/L+vlS1fn/RTEpa9dJfd+/8Ak/seXr6tcb51rfPKuyfFzX3LeFpqe7t4K4+in5/pl9eeDaN2clppZZmoIEoEznU3jmys78/Nw09TPyR6OfDjHq6eFSb97Hg75MufrwTzfz39I+E1j57How6ee1ZhGmeh9D9B8v8AUfa+GHq8IXIAAAAAAAAALIgAAAAAAAACJg35nyX0/wAv8f7dEx4/bFlymmO8ff8A0vh+9x9ml4tNc3B606eJv7W2p5Nvetefh19zml82e2svPeZmp3w0Ou/Pomqkk1tUTSCvPpjLXPUnO6r6cM+lvc+LX34r5vm+lwzr5zq9TKWImqcXyH2Hy9nxNLU6+atphmLRau37T4H7r6fytJifo/LgMAAAAAAAAAAsiAAAAAAAAAIDfgfO+94HxPvxEvN6Ztr67XzvXh1SfpHt+J7nL2aXiZNNcdNNNcr2bzjZNslJa0tEZpS0XK1z0svKxWl6FaqrFLVJtWYvplazXTmvZtnTNL51q0x0yStLUOb5n6b5k+Ey2x6+a9Zqk3y0S/2fxn2Hu8HePr/FBgAAAAAAAAAFkQAAAAAAAAAras38t43p+Z8H9ImOnl1/SvC9P5Xl6/F12np5/wBD9vw/e5enSZvlS9K2bzzec17HN8dlZ9Vn8bprH2/b+N+xL+n28P1cb6WOtl7UuaaUvrNKa0jGl6LFbVlM/Nmu7xvDx6cu/X5TW5+26vE4c9PsdPl/X59PQjG2sa56Us5Pm/pfm7Pg42rvz/Vettvz9X5vyfR/OdfLb6j5f6j2eD2Cfs/CQXAAAAAAAAAALIgAAAAAAAAEVtWdfj/O9Hzvgfo7Vvljp954vb6nH1/PW+lrud3v+L7fPW14vllw+nzW+Lz+5Wb8H6HS/Xl8Z5v3fxWuXjexj9fqW17vG59vZ1pblvXWm1mmka6zjl0Yyc+W2TWaZODztJa7PzL9T8Dr5/h4+m9ia9XzPXTXx3R9Hhz78Pq07M4U3z1nh+e+k8PU+b7PS90+X8/6Tws9fnvN6+br430nznuevxfRzE/b/PwLgAAAAAAAAFAkQAAAAAABAsTEqpamenyPn9/B8D9JbLXLG+v9V/IPtuff6+ezkx2y9TzfTTa9NC0WGTaUprUTy9GRxx0Vus8uy8Ra9iukzJtpne5jDbBcEzVK7JeON6LivC22y0TXG453QTBrVc6a5px+T7Hl1Ps+V6UeJ879H8g385Wtuviv7Xjer6PP9Patvu/nYF5gAAAAAAAAASJQAAAAAAIFgKras6fHcXZx/n/0immfPc+54nvZ3+pef6Pn8fY9TzvS1jXTPQ0tFxpNkpTWDHPppXM3jVx01vJk1rlRI0vS1kY6ZRnaLNRetyM9ic8dCsb6SZ3tJSusHLTfIyy1zXk8j2PJMfX8rs59MfzL9H/Ke3nnSl9+fT0fM9rtx+itTT7356ExeQAAAAAAAAKCSJQAAAAAAIFiYkUvnOnxvJ0c35/9Lal689393w/Wm/1fh7fO4e3o7efo1z6NcdTW+dzW9b3MReClbwVWBeTPPWq0rekt7UuzXn6MFz1x0XS0WS0rVUBIJkpW+ZTLbExx2wl5/N9HiMds9cdfN/Lf078x7+O162vK3teN6/o4/S3rb7v51ExcCSAgAAAAAKACSJQAAAAAAIFgDPTPPb4rn6Of4H6O0xfnq9olv9dfK/W8fXHVz6nTvhsml6WTfTHSy4KxIhJUxBNIzJpES66U1uaYb4Lz2rEvXfk6DXTG6STUAkVFLZVXG+OFMb5Lz8HZxxXrtwTp8r8d6Xm9/FratmZ9bzPV78Ppx+g/OxJMAQEAAAABQAASRKAAAAAAAABGWuc6/Fc/Rh8D9G2x2xu6Jjb9P/KfpM9vuteXTHf0tuToTe2dze+OppEEtE1pFWbNYzWuKIvfPWzfWm2s5YdNI4sd8JvLfKF79Obok1nK2peYEoiyuV8SmVssqc+mK8evDusfM+t+e3HJTTPp5tNMtkn0vL9Lty+tH6D84DmBCYAAAAUAAAEkSgAAAAAAAARS9Jv4rDp5/gfpadXL1Y2hMTemi/b+z8f9fz9Ppb8m811aY6muvPqaTWUsVtVRmxjfJcNOXpi2mQ7NvP2uejLLCpzpObMXxXfo497Oqcr1rbKyTnNEZKLTG+cY8+vLXHrTyI+U4EdvLlTSkl9M9LI9Hg7enP6+a2/Q/mwcwETAAAACgAAAkiUAAAAAAAABnejfx/L1c35/9LTpx2xuJRDXLaur9D/L
