/*
SQLyog Community v13.1.9 (64 bit)
MySQL - 8.0.26 : Database - pokenman
*********************************************************************
*/

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

USE `pokenman`;

/*Table structure for table `pets` */

DROP TABLE IF EXISTS `pets`;

CREATE TABLE `pets` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `date` date NOT NULL,
  `dept` varchar(20) NOT NULL COMMENT '系别',
  `intimacy` varchar(10) NOT NULL COMMENT '亲密度',
  `talent` varchar(10) NOT NULL COMMENT '种族值',
  `rarity` varchar(20) NOT NULL COMMENT '稀有度',
  `character` varchar(20) NOT NULL COMMENT '性格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3;

/*Data for the table `pets` */

insert  into `pets`(`id`,`name`,`date`,`dept`,`intimacy`,`talent`,`rarity`,`character`) values 
(3,'皮卡丘','2022-08-19','雷电系','101','100','主角专属','活泼'),
(5,'皮卡丘-EX','2022-08-20','雷电系','99','100','主角专属','活泼'),
(6,'杰尼龟','2022-08-18','鳄龟系','90','50','烂大街','胆小'),
(7,'皮卡丘','2022-08-22','雷电系','100','高','主角专属','活泼'),
(8,'皮卡丘','2022-08-22','雷电系','100','高','主角专属','活泼'),
(9,'皮卡丘','2022-08-22','雷电系','100','高','主角专属','活泼'),
(13,'卡比兽','2022-08-01','草系','70','100','稀有','贪睡'),
(15,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(16,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(17,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(18,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(19,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(20,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(21,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(22,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(23,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(24,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(25,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(26,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(27,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(28,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(29,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(30,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(31,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(32,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(33,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(34,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(35,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(36,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(37,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(38,'可达鸭','2022-03-13','精神系','20','50','普通','呆滞'),
(39,'杰尼龟','2022-08-08','鳄龟系','100','50','烂大街','胆小'),
(40,'卡比兽','2022-08-30','草系','100','100','稀有','贪睡');

/*Table structure for table `role` */

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rolename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色',
  `description` varchar(30) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

/*Data for the table `role` */

insert  into `role`(`id`,`rolename`,`description`) values 
(1,'admin','管理员'),
(2,'trainer','训练师'),
(3,'cuser','用户');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nickname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '昵称',
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `password` varchar(30) NOT NULL COMMENT '密码',
  `role` varchar(20) NOT NULL COMMENT '角色',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;

/*Data for the table `user` */

insert  into `user`(`id`,`nickname`,`username`,`password`,`role`) values 
(1,'管理1','admin','admin','admin'),
(2,'神秀','zhushenxiu','zhushenxiu','trainer'),
(3,'管理2','root','root','admin'),
(5,'良','zhuliang','0618','训练师'),
(8,'祖尔','zuber','zuber','训练师'),
(10,'李华1','lihua','1234','cuser'),
(14,'zuber2','zuber2','zuber2','admin');

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