/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1_3306
 Source Server Type    : MySQL
 Source Server Version : 80033
 Source Host           : 127.0.0.1:3306
 Source Schema         : db_ordering

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

 Date: 25/05/2023 00:12:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_cart
-- ----------------------------
DROP TABLE IF EXISTS `tb_cart`;
CREATE TABLE `tb_cart` (
  `cart_id` varchar(100) NOT NULL,
  `cs_id` varchar(100) NOT NULL,
  `ds_id` varchar(100) NOT NULL,
  `ds_count` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`cart_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_cart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_cuisine
-- ----------------------------
DROP TABLE IF EXISTS `tb_cuisine`;
CREATE TABLE `tb_cuisine` (
  `cs_id` varchar(100) NOT NULL,
  `cs_name` varchar(100) DEFAULT NULL,
  `cs_img` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`cs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_cuisine
-- ----------------------------
BEGIN;
INSERT INTO `tb_cuisine` VALUES ('03818981', '川菜', 'http://117.50.174.3/prod-api/dishesImg/川菜.jpg', '以麻辣、口味浓重、火候独特为特点，善用各种调味料，时常采用切片、切块等刀法，重视色香味形俱佳的效果。');
INSERT INTO `tb_cuisine` VALUES ('04875068', '粤菜', 'http://117.50.174.3/prod-api/dishesImg/粤菜.jpg', '以清淡细腻、品种丰富为特点，烹调方式繁多，食材讲究新鲜、质优价廉。主要特点是追求色、香、味、形的完美统一。');
INSERT INTO `tb_cuisine` VALUES ('30817130', '鲁菜', 'http://117.50.174.3/prod-api/dishesImg/鲁菜.jpg', '以色香味俱佳、口感独特和花样繁多为特点，依托当地的酸、辣、鲜、香特色调料，味道清新微辣，咸鲜适口。');
INSERT INTO `tb_cuisine` VALUES ('32900847', '闽菜', 'http://117.50.174.3/prod-api/dishesImg/闽菜.jpg', '以轻淡、细腻、清鲜、酥脆和秀丽风格为主要特点，强调原汁原味、讲究烹调技术和刀工，擅长蒸、烤、煨、羹等烹调方法。');
INSERT INTO `tb_cuisine` VALUES ('50415204', '湘菜', 'http://117.50.174.3/prod-api/dishesImg/湘菜.jpg', '以天然、健康、营养、美味为主要特点，对食材的选择比较讲究，常用的菜品有卤味、签子肉、酿豆腐等，口味以酸甜为主，颇为清淡。');
COMMIT;

-- ----------------------------
-- Table structure for tb_customer
-- ----------------------------
DROP TABLE IF EXISTS `tb_customer`;
CREATE TABLE `tb_customer` (
  `user_name` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `real_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `head_img` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_customer
-- ----------------------------
BEGIN;
INSERT INTO `tb_customer` VALUES ('17273323', '123456', '文强', '17502538479', '盐城师范学院通榆校区', 'http://117.50.174.3/prod-api/CustomerHeadImg/文强.jpg', NULL);
INSERT INTO `tb_customer` VALUES ('2012630134', '123456', '阿强', NULL, NULL, 'http://117.50.174.3/prod-api/CustomerHeadImg/阿强.jpg', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_dishes
-- ----------------------------
DROP TABLE IF EXISTS `tb_dishes`;
CREATE TABLE `tb_dishes` (
  `ds_id` varchar(100) NOT NULL,
  `ds_name` varchar(100) DEFAULT NULL,
  `cs_id` varchar(100) NOT NULL,
  `ds_price` varchar(100) DEFAULT NULL,
  `ds_description` varchar(100) DEFAULT NULL,
  `ds_img` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ds_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_dishes
-- ----------------------------
BEGIN;
INSERT INTO `tb_dishes` VALUES ('06844682', '红烧肉', '30817130', '38', '这是山东的传统名菜之一，选用五花肉为主料，慢慢炖煮至烂糯入味，肉质鲜嫩，色泽金红，口感浓郁。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-红烧肉.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('07244948', '水煮鱼', '03818981', '68', '这是一道中国著名的麻辣菜肴，以鱼片、豆芽、青菜等为主要食材，味道鲜美且麻辣可口。', 'http://117.50.174.3/prod-api/dishesImg/川菜-水煮鱼.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('08724515', '糖醋里脊', '30817130', '35', '这是一道传统的山东家常菜，选用猪里脊肉切片，油炸后拌入糖醋汁中，外酥里嫩、甜酸适口。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-糖醋里脊.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('19235005', '爆炒腰花', '50415204', '38', '这是一道湖南地方特色小炒菜品，将猪腰花经过切片、焯水处理后，用爆炒的方式加入鲜辣的辣椒和豆瓣酱等调料，肉质细嫩、香辣可口。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-爆炒腰花.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('38776677', '回锅肉', '03818981', '35', '此菜以猪后臀肉为主料，红油调制，鲜香辣口，色泽金红鲜亮，表皮微脆，入口肉嫩多汁。', 'http://117.50.174.3/prod-api/dishesImg/川菜-回锅肉.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('42858120', '麻辣香锅', '03818981', '88', '这道川菜属于火锅的一种，选用各类食材如肉片、腰花、豆皮、莲藕、木耳等，配以麻辣香味的调味汁加热而成，味道浓郁。', 'http://117.50.174.3/prod-api/dishesImg/川菜-麻辣香锅.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('43487070', '叉烧饭', '04875068', '25', '这是粤菜常见的一道主食菜品，将叉烧切成薄片，摆在蒸饭上，一口下去，甜咸可口。', 'http://117.50.174.3/prod-api/dishesImg/粤菜-叉烧饭.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('43980086', '葱爆羊肉', '30817130', '58', '这是粤菜常见的一道主食菜品，将叉烧切成薄片，摆在蒸饭上，一口下去，甜咸可口。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-葱爆羊肉.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('46972133', '爆炒腰花', '30817130', '38', '这是一道常见的山东小炒菜品，选用猪腰花为主料，加入鲜辣的豆酱、豆瓣酱等调料，经过爆炒烹制而成，口感香辣可口。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-爆炒腰花.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('47876117', '口味虾', '50415204', '68', '这是湘菜中著名的一道小吃，采用新鲜大虾，配以特制辣汁和芝麻等调料，口感鲜香辣爽。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-口味虾.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('63193559', '爆炒大虾', '30817130', '88', '这是一道鲁菜小炒，选用新鲜大虾为主料，配以鲜蔬、特制酱汁等调味，色泽鲜艳、肉质鲜嫩、味道浓郁。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-爆炒大虾.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('66547588', '干烧排骨', '03818981', '38', '这是一道香辣可口的川菜小炒，以猪排骨为主要材料，经过多种中草药烹制而成，口感鲜嫩，肉质略带甜味，酱汁浓郁。', 'http://117.50.174.3/prod-api/dishesImg/川菜-干烧排骨.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('70641648', '川味牛肉面', '03818981', '25', '这道标志性的川菜主食，以手工拉面为主，加入煮熟的牛肉、黄豆芽、香菜等配料，带有浓郁的酱油香味。', 'http://117.50.174.3/prod-api/dishesImg/川菜-川味牛肉面.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('71108933', '清蒸桂鱼', '04875068', '68', '此菜以清爽的牛肚丝为主料，搭配麻辣辣椒和花椒调味，口感鲜香辣爽，是一道较为具有特色的', 'http://117.50.174.3/prod-api/dishesImg/粤菜-清蒸桂鱼.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('72257891', '麻辣牛肚丝', '30817130', '38', '此菜以清爽的牛肚丝为主料，搭配麻辣辣椒和花椒调味，口感鲜香辣爽，是一道较为具有特色的山东小炒。', 'http://117.50.174.3/prod-api/dishesImg/鲁菜-麻辣牛肚丝.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('75816002', '龙虾炒饭', '04875068', '88', '这道粤菜主菜以龙虾、鸡蛋、米饭为主要食材，搭配适量青红椒和特制酱汁，口味鲜美、香气四溢。', 'http://117.50.174.3/prod-api/dishesImg/粤菜-龙虾炒饭.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('76767985', '瑶柱芙蓉蟹粉汤', '04875068', '68', '此菜是广东地区传统的汤菜之一，由瑶柱、蟹黄、鸡蛋等食材制成，清雅鲜美，营养丰富。', 'http://117.50.174.3/prod-api/dishesImg/粤菜-瑶柱芙蓉蟹粉汤.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('76809175', '东安子鸡', '50415204', '68', '此菜是湘菜中的传统名菜之一，选用嫩鸡，加入多种药材、佐料烹饪而成，汤浓味美，口感极佳。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-东安子鸡.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('79938276', '口水鸡', '03818981', '28', '这是一道口感鲜美、辣味十足的川菜经典，主要由鸡肉、花生、香菜等食材组成，配以特制的麻辣调味汁，爽口开胃。', 'http://117.50.174.3/prod-api/dishesImg/川菜-口水鸡.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('84087416', '蒸水蛋', '04875068', '10', '水蛋是粤港地区的特色小吃，简单易做，口感鲜美，香味扑鼻。', 'http://117.50.174.3/prod-api/dishesImg/粤菜-蒸水蛋.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('84807066', '海鲜五味', '04875068', '98', '这是一道以新鲜海鲜为主料的粤菜小炒，用明虾、墨鱼丝、鲍鱼、鱼肚、乌贼等多种食材，烹制出独特的五味口感。', 'http://117.50.174.3/prod-api/dishesImg/粤菜-海鲜五味.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('85219897', '剁椒鱼头', '50415204', '58', '此菜是湖南省衡山县的传统名菜，以草鱼头为主料，搭配豆腐皮、泡菜等辅料入锅烹制，成菜口感鲜美可口。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-剁椒鱼头.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('96883504', '毛氏红烧肉', '50415204', '48', '此菜是湖南的地方名菜之一，选用肥瘦相间的五花肉为主要材料，通过白糖色、豆瓣酱等多种调味手法，制成外焦里嫩、鲜嫩可口的糖色肉块。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-毛氏红烧肉.jpg', NULL);
INSERT INTO `tb_dishes` VALUES ('99172936', '酸辣土豆丝', '50415204', '18', '这是一道传统的湘菜小菜，选用新鲜的土豆为主料，经过切丝、焯水、沥干，混合泡椒、醋、味精等调料制成，味道酸辣开胃。', 'http://117.50.174.3/prod-api/dishesImg/湘菜-酸辣土豆丝.jpg', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_manager
-- ----------------------------
DROP TABLE IF EXISTS `tb_manager`;
CREATE TABLE `tb_manager` (
  `user_name` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `real_name` varchar(100) NOT NULL,
  `head_img` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_manager
-- ----------------------------
BEGIN;
INSERT INTO `tb_manager` VALUES ('17273323', '123456', '李文强', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `order_id` varchar(100) NOT NULL,
  `order_number` varchar(100) DEFAULT NULL,
  `cs_id` varchar(100) DEFAULT NULL,
  `ds_id` varchar(100) DEFAULT NULL,
  `ds_count` varchar(100) DEFAULT NULL,
  `total_price` varchar(100) DEFAULT NULL,
  `create_time` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  `logic_del` int DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of tb_order
-- ----------------------------
BEGIN;
INSERT INTO `tb_order` VALUES ('03113550', '20230524122455207', '2012630134', '06844682', '3', '114.0', '2023-05-24 12:24:55', 'PENDING', NULL, 0);
INSERT INTO `tb_order` VALUES ('20533755', '20230524095643095', '17273323', '07244948', '3', '204.0', '2023-05-24 09:56:43', 'PENDING', NULL, 0);
INSERT INTO `tb_order` VALUES ('39005878', '20230524095643111', '17273323', '08724515', '3', '105.0', '2023-05-24 09:56:43', 'PENDING', NULL, 0);
INSERT INTO `tb_order` VALUES ('68279484', '20230524122455177', '2012630134', '07244948', '1', '68.0', '2023-05-24 12:24:55', 'PENDING', NULL, 0);
INSERT INTO `tb_order` VALUES ('86655398', '20230524095643064', '17273323', '06844682', '2', '76.0', '2023-05-24 09:56:43', 'PENDING', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;