You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
93 lines
4.0 KiB
93 lines
4.0 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80035
|
|
Source Host : localhost:3306
|
|
Source Schema : project
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80035
|
|
File Encoding : 65001
|
|
|
|
Date: 02/06/2024 16:17:49
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for book
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `book`;
|
|
CREATE TABLE `book` (
|
|
`student_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`server_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`order_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`order_money` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`order_way` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`student_phone`, `server_id`) USING BTREE,
|
|
INDEX `server_id`(`server_id`) USING BTREE,
|
|
CONSTRAINT `book_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `server` (`server_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of book
|
|
-- ----------------------------
|
|
INSERT INTO `book` VALUES ('12345', '1', '1', '10', '外卖');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for courier
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `courier`;
|
|
CREATE TABLE `courier` (
|
|
`courier_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`courier_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`courier_phone` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`foodshop_shop_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`courier_id`) USING BTREE,
|
|
INDEX `foodshop_shop_name`(`foodshop_shop_name`) USING BTREE,
|
|
CONSTRAINT `courier_ibfk_1` FOREIGN KEY (`foodshop_shop_name`) REFERENCES `foodshop` (`shop_name`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of courier
|
|
-- ----------------------------
|
|
INSERT INTO `courier` VALUES ('1', '张三', '123456', '烤鸭店');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for foodshop
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `foodshop`;
|
|
CREATE TABLE `foodshop` (
|
|
`shop_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`salenum` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`shop_name`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of foodshop
|
|
-- ----------------------------
|
|
INSERT INTO `foodshop` VALUES ('烤鸭店', '1235');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for server
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `server`;
|
|
CREATE TABLE `server` (
|
|
`server_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`server_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`foodshop_shop_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
PRIMARY KEY (`server_id`) USING BTREE,
|
|
INDEX `foodshop_shop_name`(`foodshop_shop_name`) USING BTREE,
|
|
CONSTRAINT `server_ibfk_1` FOREIGN KEY (`foodshop_shop_name`) REFERENCES `foodshop` (`shop_name`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of server
|
|
-- ----------------------------
|
|
INSERT INTO `server` VALUES ('1', '李四', '烤鸭店');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|