/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1-8
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : apsfc

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

 Date: 01/06/2022 18:02:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `authority` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'sa', '123', '0');
INSERT INTO `admin` VALUES (2, '苏', '123', '0');

-- ----------------------------
-- Table structure for menus
-- ----------------------------
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `typeid` int UNSIGNED NULL DEFAULT NULL,
  `burden` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `brief` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` float UNSIGNED NULL DEFAULT NULL,
  `sums` int UNSIGNED NULL DEFAULT 0,
  `price1` float UNSIGNED NULL DEFAULT NULL,
  `sums1` int UNSIGNED NULL DEFAULT 0,
  `imgpath` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES (12, '粉蒸肉', 10, '米粉、五花肉', '暂无', 26, 0, 23, 0, 'img/m_fenzhengrou.gif');
INSERT INTO `menus` VALUES (14, '糖醋排骨', 2, '排骨、糖、醋', '暂无', 26, 0, 24, 4, 'img/m_tangcupaigu.gif');
INSERT INTO `menus` VALUES (15, '咸肉菜饭', 1, '咸肉、米饭', '暂无', 15, 0, 12, 4, 'img/m_xianroucaifan.gif');
INSERT INTO `menus` VALUES (17, '五香驴肉', 1, '驴肉', '暂无', 25, 0, 21, 1, 'img/m_wuxianglvrou.gif');
INSERT INTO `menus` VALUES (18, '黄瓜拉皮', 1, '黄瓜、拉皮', '暂无', 8, 0, 6, 1, 'img/m_huanggualapi.gif');
INSERT INTO `menus` VALUES (19, '水煮鱼', 11, '鱼，辣椒', '暂无', 38, 0, 32, 1, 'img/m_shuizhuyu.gif');

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `times` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (15, '11111', '111111', '2022-05-23 20:52:55');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int UNSIGNED NULL DEFAULT NULL,
  `menuid` int UNSIGNED NULL DEFAULT NULL,
  `menusum` int UNSIGNED NULL DEFAULT NULL,
  `times` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `delivery` int UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (25, 2, 15, 1, '2015-07-27 20:14:23', 1);
INSERT INTO `orders` VALUES (27, 2, 18, 1, '2015-07-27 20:31:56', 1);
INSERT INTO `orders` VALUES (28, 2, 19, 1, '2015-07-27 20:31:56', 0);
INSERT INTO `orders` VALUES (29, 6, 12, 1, '2022-05-12 17:53:02', 0);
INSERT INTO `orders` VALUES (30, 7, 14, 1, '2022-05-22 14:38:48', 0);
INSERT INTO `orders` VALUES (31, 7, 12, 1, '2022-05-22 14:38:48', 0);
INSERT INTO `orders` VALUES (32, 7, 15, 1, '2022-05-22 14:38:48', 0);
INSERT INTO `orders` VALUES (33, 7, 17, 1, '2022-05-22 14:54:28', 0);
INSERT INTO `orders` VALUES (34, 7, 19, 1, '2022-05-22 14:54:28', 0);
INSERT INTO `orders` VALUES (35, 7, 14, 1, '2022-05-22 14:55:44', 0);
INSERT INTO `orders` VALUES (36, 9, 14, 1, '2022-05-23 20:32:09', 1);
INSERT INTO `orders` VALUES (37, 9, 12, 1, '2022-05-23 20:32:09', 1);
INSERT INTO `orders` VALUES (38, 9, 12, 1, '2022-05-23 20:33:36', 1);
INSERT INTO `orders` VALUES (39, 9, 14, 2, '2022-05-23 20:33:42', 1);
INSERT INTO `orders` VALUES (40, 9, 17, 1, '2022-05-23 20:33:42', 1);
INSERT INTO `orders` VALUES (41, 9, 17, 2, '2022-05-23 20:34:16', 1);
INSERT INTO `orders` VALUES (42, 9, 15, 1, '2022-05-23 20:34:19', 1);
INSERT INTO `orders` VALUES (43, 9, 19, 1, '2022-05-23 20:34:29', 0);
INSERT INTO `orders` VALUES (44, 9, 15, 1, '2022-05-23 20:34:59', 0);
INSERT INTO `orders` VALUES (45, 9, 19, 1, '2022-05-23 20:34:59', 0);
INSERT INTO `orders` VALUES (46, 9, 14, 1, '2022-05-23 20:35:32', 0);
INSERT INTO `orders` VALUES (47, 9, 12, 1, '2022-05-23 20:35:32', 0);
INSERT INTO `orders` VALUES (48, 9, 12, 1, '2022-05-24 09:40:28', 0);
INSERT INTO `orders` VALUES (49, 9, 14, 1, '2022-05-24 09:40:28', 0);
INSERT INTO `orders` VALUES (50, 9, 14, 1, '2022-05-24 09:49:46', 0);
INSERT INTO `orders` VALUES (51, 9, 12, 1, '2022-05-24 09:49:46', 0);
INSERT INTO `orders` VALUES (52, 9, 12, 1, '2022-05-24 20:42:07', 0);
INSERT INTO `orders` VALUES (53, 9, 14, 1, '2022-05-24 20:42:07', 0);
INSERT INTO `orders` VALUES (54, 9, 15, 1, '2022-05-24 20:42:07', 0);
INSERT INTO `orders` VALUES (55, 9, 17, 1, '2022-05-24 20:42:07', 1);
INSERT INTO `orders` VALUES (56, 9, 18, 1, '2022-05-24 20:42:07', 0);
INSERT INTO `orders` VALUES (57, 9, 19, 1, '2022-05-24 20:42:07', 0);
INSERT INTO `orders` VALUES (58, 9, 14, 1, '2022-06-01 10:10:23', 0);
INSERT INTO `orders` VALUES (59, 9, 12, 1, '2022-06-01 10:13:56', 0);
INSERT INTO `orders` VALUES (60, 9, 14, 1, '2022-06-01 10:13:56', 0);

-- ----------------------------
-- Table structure for types
-- ----------------------------
DROP TABLE IF EXISTS `types`;
CREATE TABLE `types`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of types
-- ----------------------------
INSERT INTO `types` VALUES (1, '凉拌菜');
INSERT INTO `types` VALUES (2, '炒菜');
INSERT INTO `types` VALUES (6, '炒饭');
INSERT INTO `types` VALUES (10, '蒸菜');
INSERT INTO `types` VALUES (11, '川菜');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `realname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int UNSIGNED NULL DEFAULT NULL,
  `card` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` int UNSIGNED NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (9, 'gwm', '123456', 'gwm', '男', 23, '360502199906186816', '南昌', '13866666666', '18@qq.com', '330688', NULL);

SET FOREIGN_KEY_CHECKS = 1;