text: /*
   Navicat Premium Data Transfer
  
   Source Server         : MySQL
   Source Server Type    : MySQL
   Source Server Version : 80023
   Source Host           : localhost:3306
   Source Schema         : book
  
   Target Server Type    : MySQL
   Target Server Version : 80023
   File Encoding         : 65001
  
   Date: 21/04/2021 17:26:48
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for school_sh
  -- ----------------------------
  DROP TABLE IF EXISTS `school_sh`;
  CREATE TABLE `school_sh`  (
    `schoolid` int NOT NULL AUTO_INCREMENT,
    `schoolname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `schoolguanwang` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`schoolid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
  
  -- ----------------------------
  -- Records of school_sh
  -- ----------------------------
  
  SET FOREIGN_KEY_CHECKS = 1;
  