DB_51Aspx/360pince_structure_and_data.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL5.7
 Source Server Type    : MySQL
 Source Server Version : 50739 (5.7.39)
 Source Host           : localhost:3306
 Source Schema         : 360pince

 Target Server Type    : MySQL
 Target Server Version : 50739 (5.7.39)
 File Encoding         : 65001

 Date: 14/08/2023 22:41:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for __efmigrationshistory
-- ----------------------------
DROP TABLE IF EXISTS `__efmigrationshistory`;
CREATE TABLE `__efmigrationshistory`  (
  `MigrationId` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `ProductVersion` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`MigrationId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of __efmigrationshistory
-- ----------------------------
INSERT INTO `__efmigrationshistory` VALUES ('20191209085308_InitialCreate', '2.2.6-servicing-10079');

-- ----------------------------
-- Table structure for mapinfo
-- ----------------------------
DROP TABLE IF EXISTS `mapinfo`;
CREATE TABLE `mapinfo`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `parentcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `depth` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4325 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mapinfo
-- ----------------------------
INSERT INTO `mapinfo` VALUES (1, '110000', '100000', '1', '北京');
INSERT INTO `mapinfo` VALUES (2, '510113', '510100', '3', '青白江区');
INSERT INTO `mapinfo` VALUES (3, '510114', '510100', '3', '新都区');
INSERT INTO `mapinfo` VALUES (4, '510115', '510100', '3', '温江区');
INSERT INTO `mapinfo` VALUES (5, '510116', '510100', '3', '双流区');
INSERT INTO `mapinfo` VALUES (6, '510117', '510100', '3', '郫都区');
INSERT INTO `mapinfo` VALUES (7, '510121', '510100', '3', '金堂县');
INSERT INTO `mapinfo` VALUES (8, '510129', '510100', '3', '大邑县');
INSERT INTO `mapinfo` VALUES (9, '510131', '510100', '3', '蒲江县');
INSERT INTO `mapinfo` VALUES (10, '510132', '510100', '3', '新津县');