/*
Navicat MySQL Data Transfer

Source Server         : test
Source Server Version : 50638
Source Host           : localhost:3306
Source Database       : foodserver

Target Server Type    : MYSQL
Target Server Version : 50638
File Encoding         : 65001

Date: 2018-06-06 10:18:16
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admins`
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES ('3', '1', '1');

-- ----------------------------
-- Table structure for `dingdan`
-- ----------------------------
DROP TABLE IF EXISTS `dingdan`;
CREATE TABLE `dingdan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `myid` int(11) DEFAULT NULL,
  `totle` double DEFAULT NULL,
  `dates` datetime DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `state` varchar(10) DEFAULT '未发货',
  `pj` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of dingdan
-- ----------------------------
INSERT INTO `dingdan` VALUES ('6', '16', '11', '2012-05-20 21:37:59', '18897678', '2383', '网银直接支付', '已发货', null);
INSERT INTO `dingdan` VALUES ('7', '18', '11', '2012-05-20 21:45:33', '1221432425', '234235+', '网银直接支付', '已发货', '非常满意5分');

-- ----------------------------
-- Table structure for `dingdanmore`
-- ----------------------------
DROP TABLE IF EXISTS `dingdanmore`;
CREATE TABLE `dingdanmore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dingdanid` int(11) DEFAULT NULL,
  `gname` varchar(30) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of dingdanmore
-- ----------------------------
INSERT INTO `dingdanmore` VALUES ('10', '6', '1', '1');
INSERT INTO `dingdanmore` VALUES ('11', '7', '1', '1');

-- ----------------------------
-- Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gname` varchar(30) DEFAULT NULL,
  `gurl` varchar(100) DEFAULT NULL,
  `gprice` double DEFAULT NULL,
  `gcount` int(11) DEFAULT NULL,
  `gtype` varchar(10) DEFAULT NULL,
  `lx` varchar(30) DEFAULT NULL,
  `gs` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1', '麻辣鱼', 'http://10.129.55.66:8091/FoodServer/goods/1.jpg', '11', '10', '1', '', '');
INSERT INTO `goods` VALUES ('2', '湖南酱板鸭 ', 'http://10.129.55.66:8091/FoodServer/goods/2.jpg', '14', '22', '1', '1', '');
INSERT INTO `goods` VALUES ('3', '油炸香菇', 'http://10.129.55.66:8091/FoodServer/goods/3.jpg', '16', '11', '1', null, null);
INSERT INTO `goods` VALUES ('4', '红烧茄子', 'http://10.129.55.66:8091/FoodServer/goods/4.jpg', '17', '10', '1', null, null);
INSERT INTO `goods` VALUES ('5', '肉丁荷包蛋', 'http://10.129.55.66:8091/FoodServer/goods/5.jpg', '35', '10', '1', null, null);
INSERT INTO `goods` VALUES ('6', '酸辣鸡翅', 'http://10.129.55.66:8091/FoodServer/goods/6.jpg', '37', '10', '2', null, null);
INSERT INTO `goods` VALUES ('7', '海鲜', 'http://10.129.55.66:8091/FoodServer/goods/7.jpg', '38', '38', '3', null, null);
INSERT INTO `goods` VALUES ('8', '红烧牛肉', 'http://10.129.55.66:8091/FoodServer/goods/8.jpg', '20', '20', '4', null, null);
INSERT INTO `goods` VALUES ('9', '地三鲜', 'http://10.129.55.66:8091/FoodServer/goods/9.jpg', '21', '21', '5', null, null);
INSERT INTO `goods` VALUES ('10', '乌鸡汤', 'http://10.129.55.66:8091/FoodServer/goods/10.jpg', '22', '22', '6', null, null);
INSERT INTO `goods` VALUES ('11', '啤酒', 'http://10.129.55.66:8091/FoodServer/goods/11.jpg', '23', '23', '7', null, null);

-- ----------------------------
-- Table structure for `goodsorder`
-- ----------------------------
DROP TABLE IF EXISTS `goodsorder`;
CREATE TABLE `goodsorder` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `userId` int(255) DEFAULT NULL,
  `tableNo` int(255) DEFAULT NULL,
  `eatNum` int(255) DEFAULT NULL,
  `goodsName` varchar(255) DEFAULT NULL,
  `goodsNum` int(255) DEFAULT NULL,
  `goodsPrice` float(255,0) DEFAULT NULL,
  `goodsState` varchar(255) DEFAULT NULL,
  `payState` varchar(255) DEFAULT NULL,
  `creatTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goodsorder
-- ----------------------------

-- ----------------------------
-- Table structure for `gwc`
-- ----------------------------
DROP TABLE IF EXISTS `gwc`;
CREATE TABLE `gwc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `goodsName` varchar(30) DEFAULT NULL,
  `gcount` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of gwc
-- ----------------------------
INSERT INTO `gwc` VALUES ('16', '18', 'huangMenJi', '1');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userName` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `rname` varchar(30) DEFAULT NULL,
  `banlance` float(30,0) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '111', 'admin', '111', 'admin', '管理员', '0');
INSERT INTO `users` VALUES ('2', '123', '123', '2325tter+', '12345678+', '张三', '72');