/*
Navicat Premium Data Transfer
Source Server : nx_system
Source Server Type : MySQL
Source Server Version : 50730
Source Host : localhost:3306
Source Schema : chengjifenxi
Target Server Type : MySQL
Target Server Version : 50730
File Encoding : 65001
Date: 18/03/2021 20:14:59
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP DATABASE IF EXISTS `chengjifenxi`;
CREATE DATABASE `chengjifenxi`;
use `chengjifenxi`;
set global innodb_large_prefix=on;
set global innodb_file_per_table=on;
set global innodb_file_format=BARRACUDA;
-- ----------------------------
-- Table structure for admin_info
-- ----------------------------
DROP TABLE IF EXISTS `admin_info`;
CREATE TABLE `admin_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
`nickName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '昵称',
`sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '性别',
`age` int(10) NULL DEFAULT NULL COMMENT '年龄',
`birthday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '生日',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '手机号',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '编号',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
`cardId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '身份证',
`level` int(10) NOT NULL DEFAULT 1 COMMENT '权限等级',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_info
-- ----------------------------
INSERT INTO `admin_info` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 22, '2021-03-01 16:55:45', '18843232356', '上海市', '111', 'aa@163.com', '342425199001116372', 1);
INSERT INTO `admin_info` VALUES (2, 'admin2', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 23, '2021-03-01 16:55:45', '18843232356', '北京市', '222', 'bb@163.com', '342425199001116376', 1);
INSERT INTO `admin_info` VALUES (3, 'admin3', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', 32, '2021-03-01 16:55:45', '18843232356', '合肥市', '333', 'cc@163.com', '342425199001116323', 1);
INSERT INTO `admin_info` VALUES (4, 'admin4', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', 24, '2021-03-01 16:55:45', '18843232356', '北京市', '444', 'hahaha@126.com', '342425199001116837', 1);
INSERT INTO `admin_info` VALUES (5, 'admin5', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 25, '2021-03-01 16:55:45', '18843232356', '合肥市', '555', 'hello@126.com', '342425199001116309', 1);
INSERT INTO `admin_info` VALUES (6, 'admin6', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 26, '2021-03-01 16:55:45', '18843232356', '北京市', '666', '1212@qq.com', '342425199001116984', 1);
INSERT INTO `admin_info` VALUES (7, 'admin7', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 21, '2021-03-01 16:55:45', '18843232356', '合肥市', '777', '8765@qq.com', '342425199001116303', 1);
INSERT INTO `admin_info` VALUES (8, 'admin8', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 31, '2021-03-01 16:55:45', '18843232356', '北京市', '888', '9080@qq.com', '342425199001116910', 1);
INSERT INTO `admin_info` VALUES (9, 'admin9', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '男', 34, '2021-03-01 16:55:45', '18843232356', '合肥市', '999', 'shjs@126.com', '342425199001116345', 1);
INSERT INTO `admin_info` VALUES (10, 'admin10', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', 33, '2021-03-01 16:55:45', '18843232356', '深圳市', '000', '666@qq.com', '342425199001116234', 1);
-- ----------------------------
-- Table structure for advertiser_info
-- ----------------------------
DROP TABLE IF EXISTS `advertiser_info`;
CREATE TABLE `advertiser_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '公告名称',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '公告内容',
`time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '公告时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '公告信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of advertiser_info
-- ----------------------------
INSERT INTO `advertiser_info` VALUES (1, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (2, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (3, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (4, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (5, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (6, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (7, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (8, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (9, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
INSERT INTO `advertiser_info` VALUES (10, '系统公告', '这是系统公告，管理员可以在后台修改', '2021-03-01 16:55:45');
-- ----------------------------
-- Table structure for chengji_info
-- ----------------------------
DROP TABLE IF EXISTS `chengji_info`;
CREATE TABLE `chengji_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',
`score` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '分数',
`studentName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '学生姓名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '成绩信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of chengji_info
-- ----------------------------
INSERT INTO `chengji_info` VALUES (1, '语文课', '80', '张大嘴');
INSERT INTO `chengji_info` VALUES (2, '语文课', '85', '赵二狗');
INSERT INTO `chengji_info` VALUES (3, '数学课', '90', '张大嘴');
-- ----------------------------
-- Table structure for kecheng_info
-- ----------------------------
DROP TABLE IF EXISTS `kecheng_info`;
CREATE TABLE `kecheng_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLA
