text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 192.168.40.105
   Source Server Type    : MySQL
   Source Server Version : 50721
   Source Host           : 192.168.40.105:3306
   Source Schema         : dinner
  
   Target Server Type    : MySQL
   Target Server Version : 50721
   File Encoding         : 65001
  
   Date: 06/12/2019 11:45:29
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for _mysql_session_store
  -- ----------------------------
  DROP TABLE IF EXISTS `_mysql_session_store`;
  CREATE TABLE `_mysql_session_store`  (
    `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `expires` bigint(20) NULL DEFAULT NULL,
    `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for food
  -- ----------------------------
  DROP TABLE IF EXISTS `food`;
  CREATE TABLE `food`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜品名称',
    `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for hotel
  -- ----------------------------
  DROP TABLE IF EXISTS `hotel`;
  CREATE TABLE `hotel`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    `invoice_type` int(11) NULL DEFAULT NULL COMMENT '发票类型：1=机打，2=定额',
    `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for person
  -- ----------------------------
  DROP TABLE IF EXISTS `person`;
  CREATE TABLE `person`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
    `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
    `work` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位',
    `isAdmin` int(1) NULL DEFAULT NULL COMMENT '是管理员：0=否，1是',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for work
  -- ----------------------------
  DROP TABLE IF EXISTS `work`;
  CREATE TABLE `work`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `pid` int(11) NULL DEFAULT NULL COMMENT '人员id',
    `fid` int(11) NULL DEFAULT NULL COMMENT '菜品id',
    `type` int(1) NULL DEFAULT NULL COMMENT '订餐类型：0=不加班，1=集体订餐，2，自己订餐',
    `date` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加班日期',
    `leave` time(0) NULL DEFAULT NULL COMMENT '打卡时间',
    `invoiceType` int(11) NULL DEFAULT NULL COMMENT '发票类型',
    `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  