1 /*
2 Navicat MySQL Data Transfer
3
4 Source Server : localhost
5 Source Server Version : 50162
6 Source Host : localhost:3306
7 Source Database : mealsystem
8
9 Target Server Type : MYSQL
10 Target Server Version : 50162
11 File Encoding : 65001
12
13 Date: 2016-11-20 18:08:28
14 */
15
16 SET FOREIGN_KEY_CHECKS=0;
17
18 -- ----------------------------
19 -- Table structure for affiche
20 -- ----------------------------
21 DROP TABLE IF EXISTS `affiche`;
22 CREATE TABLE `affiche` (
23 `a_id` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '随机产生的三位数字或字母加上时间',
24 `a_content` text COLLATE utf8_bin COMMENT '公告内容',
25 `a_name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '发布者',
26 `a_time` datetime DEFAULT NULL COMMENT '发布时间',
27 PRIMARY KEY (`a_id`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
29
30 -- ----------------------------
31 -- Records of affiche
32 -- ----------------------------
33
34 -- ----------------------------
35 -- Table structure for meal
36 -- ----------------------------
37 DROP TABLE IF EXISTS `meal`;
38 CREATE TABLE `meal` (
39 `m_id` int(11) NOT NULL COMMENT '菜品id',
40 `m_name` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '菜名',
41 `m_piece` double NOT NULL COMMENT '单价',
42 `m_describe` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '菜品描述',
43 `m_sale` int(11) DEFAULT NULL COMMENT '销售量',
44 `m_data` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '菜品材料，以$号分割',
45 PRIMARY KEY (`m_id`)
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
47
48 -- ----------------------------
49 -- Records of meal
50 -- ----------------------------
51
52 -- ----------------------------
53 -- Table structure for orecord
54 -- ----------------------------
55 DROP TABLE IF EXISTS `orecord`;
56 CREATE TABLE `orecord` (
57 `o_id` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '订单id',
58 `o_dt` datetime DEFAULT NULL COMMENT '下单时间',
59 `o_number` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '桌号',
60 `o_detail` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '下单菜品id',
61 `o_piece` double DEFAULT NULL COMMENT '总价',
62 `o_pay` int(11) NOT NULL DEFAULT '0' COMMENT '默认为''0'',0为未买单，1为买单',
63 PRIMARY KEY (`o_id`)
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
65
66 -- ----------------------------
67 -- Records of orecord
68 -- ----------------------------
69
70 -- ----------------------------
71 -- Table structure for userdetails
72 -- ----------------------------
73 DROP TABLE IF EXISTS `userdetails`;
74 CREATE TABLE `userdetails` (
75 `userid` int(11) NOT NULL COMMENT '用户ID',
76 `username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户名',
77 `name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
78 PRIMARY KEY (`userid`)
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
80
81 -- ----------------------------
82 -- Records of userdetails
83 -- ----------------------------
84
85 -- ----------------------------
86 -- Table structure for userload
87 -- ----------------------------
88 DROP TABLE IF EXISTS `userload`;
89 CREATE TABLE `userload` (
90 `username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户名',
91 `password` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '账户密码',
92 `usertype` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户类型',
93 `authority` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '权限',
94 PRIMARY KEY (`username`)
95 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
96
97 -- ----------------------------
98 -- Records of userload
99 -- ----------------------------
