/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50162
Source Host : localhost:3306
Source Database : mealsystem
Target Server Type : MYSQL
Target Server Version : 50162
File Encoding : 65001
Date: 2016-11-20 18:08:28
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for affiche
-- ----------------------------
DROP TABLE IF EXISTS `affiche`;
CREATE TABLE `affiche` (
`a_id` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '随机产生的三位数字或字母加上时间',
`a_content` text COLLATE utf8_bin COMMENT '公告内容',
`a_name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '发布者',
`a_time` datetime DEFAULT NULL COMMENT '发布时间',
PRIMARY KEY (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of affiche
-- ----------------------------
-- ----------------------------
-- Table structure for meal
-- ----------------------------
DROP TABLE IF EXISTS `meal`;
CREATE TABLE `meal` (
`m_id` int(11) NOT NULL COMMENT '菜品id',
`m_name` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '菜名',
`m_piece` double NOT NULL COMMENT '单价',
`m_describe` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '菜品描述',
`m_sale` int(11) DEFAULT NULL COMMENT '销售量',
`m_data` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '菜品材料，以$号分割',
PRIMARY KEY (`m_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of meal
-- ----------------------------
-- ----------------------------
-- Table structure for orecord
-- ----------------------------
DROP TABLE IF EXISTS `orecord`;
CREATE TABLE `orecord` (
`o_id` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '订单id',
`o_dt` datetime DEFAULT NULL COMMENT '下单时间',
`o_number` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '桌号',
`o_detail` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '下单菜品id',
`o_piece` double DEFAULT NULL COMMENT '总价',
`o_pay` int(11) NOT NULL DEFAULT '' COMMENT '默认为'''',0为未买单，1为买单',
PRIMARY KEY (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of orecord
-- ----------------------------
-- ----------------------------
-- Table structure for userdetails
-- ----------------------------
DROP TABLE IF EXISTS `userdetails`;
CREATE TABLE `userdetails` (
`userid` int(11) NOT NULL COMMENT '用户ID',
`username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户名',
`name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of userdetails
-- ----------------------------
-- ----------------------------
-- Table structure for userload
-- ----------------------------
DROP TABLE IF EXISTS `userload`;
CREATE TABLE `userload` (
`username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户名',
`password` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户密码',
`usertype` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户类型',
`authority` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '权限',
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of userload
-- ----------------------------