/*
 Navicat Premium Data Transfer

 Source Server         : zhoujie_connection
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : foodweb

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

 Date: 03/01/2022 18:11:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin`  (
  `adminname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `adminpassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_admin
-- ----------------------------
INSERT INTO `tb_admin` VALUES ('admin', 'admin');

-- ----------------------------
-- Table structure for tb_comment
-- ----------------------------
DROP TABLE IF EXISTS `tb_comment`;
CREATE TABLE `tb_comment`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_comment
-- ----------------------------
INSERT INTO `tb_comment` VALUES ('周杰', '扬州炒饭', '2021-06-21 22:16:58');
INSERT INTO `tb_comment` VALUES ('小张', '应该是叫花鸡~', '2021-06-21 22:17:13');
INSERT INTO `tb_comment` VALUES ('小张', '啥都好吃！！！', '2021-06-21 22:17:26');

-- ----------------------------
-- Table structure for tb_food
-- ----------------------------
DROP TABLE IF EXISTS `tb_food`;
CREATE TABLE `tb_food`  (
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pop` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `culture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `step` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_food
-- ----------------------------
INSERT INTO `tb_food` VALUES ('孜然大虾二代', 'images/wan/sql/st2.jpg', '6分钟', '家常菜', '一般', '9步完成', '孜然大虾顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '孜然大虾做法');
INSERT INTO `tb_food` VALUES ('清炒空心菜', 'images/wan/sql/16.3.jpg', '6分钟', '家常菜', '一般', '6步完成', '清炒空心菜顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '清炒空心菜做法');
INSERT INTO `tb_food` VALUES ('炸酱面三代', 'images/wan/sql/16.1.1.jpg', '10分钟', '面食', '一般', '6步完成', '炸酱面三代顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '炸酱面三代做法');
INSERT INTO `tb_food` VALUES ('炸酱面二代', 'images/wan/sql/16.1.jpg', '10分钟', '面食', '一般', '6步完成', '炸酱面二代顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '炸酱面二代做法');
INSERT INTO `tb_food` VALUES ('炸酱面五代', 'images/wan/sql/16.1.2.jpg', '10分钟', '面食', '一般', '7步完成', '炸酱面五代顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '炸酱面五代做法');
INSERT INTO `tb_food` VALUES ('炸酱面六代', 'images/wan/sql/16.1.3.jpg', '10分钟', '面食', '一般', '7步完成', '炸酱面六代顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '炸酱面六代做法');
INSERT INTO `tb_food` VALUES ('炸酱面四代', 'images/wan/sql/16.1.4.jpg', '10分钟', '面食', '一般', '6步完成', '炸酱面四代顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '炸酱面四代做法');
INSERT INTO `tb_food` VALUES ('番茄焗蛋', 'images/wan/sql/4.3.jpg', '6分钟', '家常菜', '一般', '7步完成', '番茄焗蛋顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '番茄焗蛋做法');
INSERT INTO `tb_food` VALUES ('简易版陕西油泼面', 'images/wan/sql/21.2.jpg', '16分钟', '面食', '火热', '15步完成', '简易版陕西油泼面顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '简易版陕西油泼面做法');
INSERT INTO `tb_food` VALUES ('老婆饼', 'images/wan/sql/14.3.jpg', '21分钟', '甜点', '一般', '7步完成', '老婆饼顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '老婆饼做法');
INSERT INTO `tb_food` VALUES ('肉末茄子', 'images/wan/sql/st1.jpg', '9分钟', '家常菜', '火热', '5步完成', '肉末茄子顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '肉末茄子做法');
INSERT INTO `tb_food` VALUES ('自制土家酱香饼', 'images/wan/sql/21.1.jpg', '20分钟', '饼干', '一般', '16步完成', '自制土家酱香饼顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '自制土家酱香饼做法');
INSERT INTO `tb_food` VALUES ('芝麻香酥点心', 'images/wan/sql/14.1.jpg', '17分钟', '甜点', '一般', '10步完成', '芝麻香酥点心顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '芝麻香酥点心做法');
INSERT INTO `tb_food` VALUES ('菜熘酱豆腐', 'images/wan/sql/10.3.jpg', '16分钟', '家常菜', '一般', '9步完成', '菜熘酱豆腐顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '菜熘酱豆腐做法');
INSERT INTO `tb_food` VALUES ('菠萝咕噜肉', 'images/wan/sql/10.2.jpg', '45分钟', '家常菜', '火热', '14步完成', '菠萝咕噜肉顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '菠萝咕噜肉做法');
INSERT INTO `tb_food` VALUES ('葱爆羊肉', 'images/wan/sql/10.1.jpg', '90分钟', '热菜', '火热', '15步完成', '葱爆羊肉顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '葱爆羊肉做法');
INSERT INTO `tb_food` VALUES ('酥脆五香炸薯片', 'images/wan/sql/14.2.jpg', '18分钟', '炸串', '火热', '6步完成', '酥脆五香炸薯片顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '酥脆五香炸薯片做法');
INSERT INTO `tb_food` VALUES ('陕西麻食', 'images/wan/sql/21.3.jpg', '15分钟', '麻食', '一般', '14步完成', '陕西麻食顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '陕西麻食做法');
INSERT INTO `tb_food` VALUES ('青椒紫茄酱肉包', 'images/wan/sql/4.1.jpg', '10分钟', '家常菜', '一般', '4步完成', '孜然大虾顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '青椒紫茄酱肉包做法');
INSERT INTO `tb_food` VALUES ('香菇菜蒸排骨', 'images/wan/sql/16.2.jpg', '11分钟', '家常菜', '一般', '12步完成', '孜然大虾顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶', '香菇菜蒸排骨做法');

-- ----------------------------
-- Table structure for tb_orderedfood
-- ----------------------------
DROP TABLE IF EXISTS `tb_orderedfood`;
CREATE TABLE `tb_orderedfood`  (
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `food_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_orderedfood
-- ----------------------------
INSERT INTO `tb_orderedfood` VALUES ('周杰', '陕西麻食', '2021-03-22 14:06:53');
INSERT INTO `tb_orderedfood` VALUES ('周杰', '老婆饼', '2021-03-22 14:16:52');
INSERT INTO `tb_orderedfood` VALUES ('周杰', '番茄焗蛋', '2021-03-23 19:55:25');
INSERT INTO `tb_orderedfood` VALUES ('周杰', '炸酱面三代', '2021-03-24 20:55:51');
INSERT INTO `tb_orderedfood` VALUES ('小张', '炸酱面', '2021-06-21 22:14:37');
INSERT INTO `tb_orderedfood` VALUES ('小张', '杂酱面六代', '2021-06-21 22:14:46');
INSERT INTO `tb_orderedfood` VALUES ('小张', '清炒空心菜', '2021-06-21 22:15:05');

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(255) NULL DEFAULT NULL,
  `weight` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `height` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1234', '456', '男', 14, '85斤', '160');
INSERT INTO `tb_user` VALUES ('456', '456', '男', 17, '112斤', '175');
INSERT INTO `tb_user` VALUES ('aa', 'aa', '男', 36, '90斤', '185');
INSERT INTO `tb_user` VALUES ('user', '13', '男', 0, '14', '173');
INSERT INTO `tb_user` VALUES ('周杰', 'zhoujie', '男', 21, '108斤', '174');
INSERT INTO `tb_user` VALUES ('小张', '123', '男', 22, '112斤', '192');
INSERT INTO `tb_user` VALUES ('郭运祺', '123', '男', 21, '100斤', '175');

SET FOREIGN_KEY_CHECKS = 1;