/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.213
 Source Server Type    : MySQL
 Source Server Version : 80024
 Source Host           : 192.168.0.213:3306
 Source Schema         : easy_trans_demo

 Target Server Type    : MySQL
 Target Server Version : 80024
 File Encoding         : 65001

 Date: 25/05/2023 18:07:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school`  (
  `id` int(0) NOT NULL,
  `school_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of school
-- ----------------------------
INSERT INTO `school` VALUES (1, '第一中学', '111', '610100');
INSERT INTO `school` VALUES (2, '高新二小', '222', '610100');
INSERT INTO `school` VALUES (3, '铁一中', '333', '610100');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `age` int(0) NULL DEFAULT NULL,
  `id_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '小明', 3, '371481199201011111');
INSERT INTO `user` VALUES ('2', '小黄', 2, '371481199201011112');
INSERT INTO `user` VALUES ('1658783403885359106', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783424831713281', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783430263336961', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783433564254209', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783436139556865', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783437536260097', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783438324789250', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783439578886146', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783440304500737', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783440971395073', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783441571180546', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783442166771713', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783442829471745', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783443550892034', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783444154871810', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783444888875010', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783445543186434', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783446130388994', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783446851809282', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783447506120705', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783448173015042', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783448823132162', 'wanglei', 10, '37111111111111111');
INSERT INTO `user` VALUES ('1658783449540358145', 'wanglei', 10, '37111111111111111');

SET FOREIGN_KEY_CHECKS = 1;