/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 8.0.20 : Database - webdb
*********************************************************************
*/

/*!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*/`webdb` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `webdb`;

/*Table structure for table `tuser` */

DROP TABLE IF EXISTS `tuser`;

CREATE TABLE `tuser` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `password` varchar(128) DEFAULT NULL,
  `user_name` varchar(200) DEFAULT NULL,
  `nick_name` varchar(200) DEFAULT NULL,
  `birth` varchar(12) DEFAULT NULL,
  `gender` int DEFAULT NULL,
  `grade` float DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

/*Data for the table `tuser` */

insert  into `tuser`(`id`,`user_id`,`password`,`user_name`,`nick_name`,`birth`,`gender`,`grade`,`create_time`,`last_update_time`) values (1,'test','111111','测试用户',NULL,NULL,1,NULL,'2021-01-21 00:00:00','2021-01-30 00:00:00'),(4,'test2','222222','测试2','','2021-01-19',1,NULL,'2021-01-22 17:50:39','2021-01-22 17:50:39'),(9,'test7','777777','测试7','','2021-01-26',1,NULL,'2021-01-22 18:17:59','2021-01-22 18:17:59'),(15,'daqiao','daqiao','大乔',NULL,'2021-01-12',1,NULL,'2021-01-22 22:28:44','2021-01-22 22:28:44'),(16,'houzi','houzihouzi','猴子',NULL,'2021-01-06',1,NULL,'2021-01-22 23:56:00','2021-01-22 23:56:00'),(17,'libai','libailibai','李白',NULL,'2021-01-12',1,NULL,'2021-01-22 23:56:19','2021-01-22 23:56:19'),(18,'zhangliang','zhangliang','张良',NULL,'2021-01-06',1,NULL,'2021-01-22 23:56:51','2021-01-22 23:56:51'),(19,'zhugeliang','zhugeliang','诸葛亮',NULL,'2021-01-01',0,NULL,'2021-01-23 00:02:07','2021-01-23 00:02:07'),(20,'zhangfei','zhangfei','张飞',NULL,'2021-01-20',1,NULL,'2021-01-23 00:02:27','2021-01-23 00:02:27');

/*!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 */;