/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50510
Source Host           : localhost:3306
Source Database       : liuyishou

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

Date: 2017-07-06 23:17:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin_info`
-- ----------------------------
DROP TABLE IF EXISTS `admin_info`;
CREATE TABLE `admin_info` (
  `Username` varchar(10) NOT NULL DEFAULT '',
  `Password` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`Username`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of admin_info
-- ----------------------------
INSERT INTO `admin_info` VALUES ('admin', 'admin');

-- ----------------------------
-- Table structure for `cart_info`
-- ----------------------------
DROP TABLE IF EXISTS `cart_info`;
CREATE TABLE `cart_info` (
  `name` varchar(20) DEFAULT NULL,
  `num` varchar(4) DEFAULT NULL,
  `price` varchar(4) DEFAULT NULL,
  `total` varchar(5) DEFAULT NULL,
  `user` varchar(20) DEFAULT NULL,
  `url` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of cart_info
-- ----------------------------
INSERT INTO `cart_info` VALUES ('鹌鹑蛋', '1', '18', '18', '徐瑜', 'ACD');
INSERT INTO `cart_info` VALUES ('白菜', '1', '10', '10', '徐瑜', 'BC');
INSERT INTO `cart_info` VALUES ('重庆啤酒', '1', '4', '4', '徐瑜', 'CQPJ');

-- ----------------------------
-- Table structure for `goods_info`
-- ----------------------------
DROP TABLE IF EXISTS `goods_info`;
CREATE TABLE `goods_info` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(20) DEFAULT NULL,
  `price` varchar(4) DEFAULT NULL,
  `stock` varchar(4) DEFAULT NULL,
  `url` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`url`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of goods_info
-- ----------------------------
INSERT INTO `goods_info` VALUES ('鹌鹑蛋', '荤', '18', '499', 'ACD');
INSERT INTO `goods_info` VALUES ('白菜', '素', '10', '496', 'BC');
INSERT INTO `goods_info` VALUES ('重庆啤酒', '酒', '4', '500', 'CQPJ');
INSERT INTO `goods_info` VALUES ('春笋', '素', '20', '500', 'CS');
INSERT INTO `goods_info` VALUES ('纯生啤酒', '酒', '5', '499', 'CSPJ');
INSERT INTO `goods_info` VALUES ('冬瓜片', '素', '15', '500', 'DGP');
INSERT INTO `goods_info` VALUES ('蛋煎糍粑', '小吃', '20', '499', 'DJCB');
INSERT INTO `goods_info` VALUES ('豆芽', '素', '14', '500', 'DY');
INSERT INTO `goods_info` VALUES ('贡菜', '素', '18', '500', 'GC');
INSERT INTO `goods_info` VALUES ('黄瓜条', '素', '12', '500', 'HGT');
INSERT INTO `goods_info` VALUES ('红汤', '红汤', '10', '499', 'HT');
INSERT INTO `goods_info` VALUES ('加多宝', '饮料', '3', '500', 'JDB');
INSERT INTO `goods_info` VALUES ('金银馒头', '小吃', '17', '500', 'JYMT');
INSERT INTO `goods_info` VALUES ('金针菇', '素', '13', '500', 'JZG');
INSERT INTO `goods_info` VALUES ('乐堡啤酒', '酒', '4', '500', 'LBPJ');
INSERT INTO `goods_info` VALUES ('醪糟汤圆', '小吃', '10', '500', 'LZTY');
INSERT INTO `goods_info` VALUES ('毛肚', '荤', '14', '499', 'MD');
INSERT INTO `goods_info` VALUES ('木耳', '素', '14', '500', 'ME');
INSERT INTO `goods_info` VALUES ('南瓜饼', '小吃', '13', '500', 'NGB');
INSERT INTO `goods_info` VALUES ('脑花', '荤', '26', '500', 'NH');
INSERT INTO `goods_info` VALUES ('泥鳅', '荤', '25', '500', 'NQ');
INSERT INTO `goods_info` VALUES ('牛肉', '荤', '30', '498', 'NR');
INSERT INTO `goods_info` VALUES ('藕片', '素', '17', '500', 'OP');
INSERT INTO `goods_info` VALUES ('平菇', '素', '18', '500', 'PG');
INSERT INTO `goods_info` VALUES ('青岛啤酒', '酒', '4', '500', 'QDPJ');
INSERT INTO `goods_info` VALUES ('清汤', '清汤', '10', '500', 'QT');
INSERT INTO `goods_info` VALUES ('肉丸', '荤', '20', '500', 'RW');
INSERT INTO `goods_info` VALUES ('生菜', '素', '15', '500', 'SC');
INSERT INTO `goods_info` VALUES ('山城啤酒', '酒', '3', '500', 'SCPJ');
INSERT INTO `goods_info` VALUES ('水晶包', '荤', '18', '500', 'SJB');
INSERT INTO `goods_info` VALUES ('三线肉', '荤', '23', '500', 'SXR');
INSERT INTO `goods_info` VALUES ('土豆粉', '素', '11', '500', 'TDF');
INSERT INTO `goods_info` VALUES ('土豆片', '素', '17', '500', 'TDP');
INSERT INTO `goods_info` VALUES ('无骨凤爪', '荤', '18', '500', 'WGJZ');
INSERT INTO `goods_info` VALUES ('五花肉', '荤', '25', '500', 'WHR');
INSERT INTO `goods_info` VALUES ('唯一（大）', '饮料', '6', '499', 'WYD');
INSERT INTO `goods_info` VALUES ('唯一（小）', '饮料', '2', '500', 'WYX');
INSERT INTO `goods_info` VALUES ('香菜', '素', '16', '500', 'XC');
INSERT INTO `goods_info` VALUES ('鲜豆腐', '素', '19', '500', 'XDF');
INSERT INTO `goods_info` VALUES ('熏制腊肉', '荤', '30', '500', 'XZNR');
INSERT INTO `goods_info` VALUES ('现炸酥肉', '小吃', '20', '500', 'XZSR');
INSERT INTO `goods_info` VALUES ('鸭肠', '荤', '14', '500', 'YC');
INSERT INTO `goods_info` VALUES ('鱼', '荤', '21', '499', 'YU');
INSERT INTO `goods_info` VALUES ('鸳鸯汤', '鸳鸯', '10', '499', 'YYT');
INSERT INTO `goods_info` VALUES ('紫薯饼', '小吃', '18', '500', 'ZSB');

-- ----------------------------
-- Table structure for `join_info`
-- ----------------------------
DROP TABLE IF EXISTS `join_info`;
CREATE TABLE `join_info` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `city` varchar(20) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of join_info
-- ----------------------------
INSERT INTO `join_info` VALUES ('徐瑜', '重庆', '13251347161', '754146655@qq.com');
INSERT INTO `join_info` VALUES ('张三', '上海', '13251347161', '754146655@qq.com');

-- ----------------------------
-- Table structure for `order_info`
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
  `name` varchar(20) DEFAULT NULL,
  `num` varchar(4) DEFAULT NULL,
  `price` varchar(4) DEFAULT NULL,
  `total` varchar(5) DEFAULT NULL,
  `user` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of order_info
-- ----------------------------
INSERT INTO `order_info` VALUES ('鸳鸯汤', '1', '10', '10', '徐瑜');
INSERT INTO `order_info` VALUES ('白菜', '3', '10', '30', '徐瑜');
INSERT INTO `order_info` VALUES ('牛肉', '2', '30', '60', '徐瑜');
INSERT INTO `order_info` VALUES ('鱼', '1', '21', '21', '徐瑜');
INSERT INTO `order_info` VALUES ('毛肚', '1', '14', '14', '徐瑜');
INSERT INTO `order_info` VALUES ('蛋煎糍粑', '1', '20', '20', '徐瑜');
INSERT INTO `order_info` VALUES ('唯一（大）', '1', '6', '6', '徐瑜');
INSERT INTO `order_info` VALUES ('白菜', '1', '10', '10', '张三');
INSERT INTO `order_info` VALUES ('鹌鹑蛋', '1', '18', '18', '张三');
INSERT INTO `order_info` VALUES ('纯生啤酒', '1', '5', '5', '张三');
INSERT INTO `order_info` VALUES ('红汤', '1', '10', '10', '张三');

-- ----------------------------
-- Table structure for `otherstore_info`
-- ----------------------------
DROP TABLE IF EXISTS `otherstore_info`;
CREATE TABLE `otherstore_info` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `address` varchar(20) NOT NULL,
  `boss` varchar(20) NOT NULL,
  `phone` varchar(11) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of otherstore_info
-- ----------------------------
INSERT INTO `otherstore_info` VALUES ('北京刘一手分店', '北京六环', '王二', '13251347162');
INSERT INTO `otherstore_info` VALUES ('河南刘一手分店', '河南区', '王四', '13251347164');
INSERT INTO `otherstore_info` VALUES ('上海刘一手南坪分店', '上海外滩', '王三', '13251347163');
INSERT INTO `otherstore_info` VALUES ('重庆刘一手南坪分店', '重庆南岸区南坪', '王一', '13251347161');

-- ----------------------------
-- Table structure for `others_order_info`
-- ----------------------------
DROP TABLE IF EXISTS `others_order_info`;
CREATE TABLE `others_order_info` (
  `name` varchar(20) NOT NULL,
  `num` varchar(4) NOT NULL,
  `price` varchar(4) NOT NULL,
  `total` varchar(5) NOT NULL,
  `user` varchar(20) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of others_order_info
-- ----------------------------
INSERT INTO `others_order_info` VALUES ('鸳鸯汤', '1', '10', '10', '徐一');
INSERT INTO `others_order_info` VALUES ('白菜', '3', '10', '30', '徐一');
INSERT INTO `others_order_info` VALUES ('牛肉', '2', '30', '60', '徐一');
INSERT INTO `others_order_info` VALUES ('鱼', '1', '21', '21', '徐一');
INSERT INTO `others_order_info` VALUES ('唯一（大）', '1', '6', '6', '徐一');
INSERT INTO `others_order_info` VALUES ('白菜', '1', '10', '10', '张四');
INSERT INTO `others_order_info` VALUES ('鹌鹑蛋', '1', '18', '18', '张四');
INSERT INTO `others_order_info` VALUES ('纯生啤酒', '1', '5', '5', '张四');
INSERT INTO `others_order_info` VALUES ('红汤', '1', '10', '10', '张四');

-- ----------------------------
-- Table structure for `user_info`
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `name` varchar(20) NOT NULL,
  `phone` varchar(11) NOT NULL DEFAULT '',
  `email` varchar(30) NOT NULL,
  `password` varchar(20) NOT NULL,
  PRIMARY KEY (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('徐瑜', '13251347161', '754146655@qq.com', '1');
INSERT INTO `user_info` VALUES ('张三', '13251347162', '754146655@qq.com', 'admin');
INSERT INTO `user_info` VALUES ('张四', '13251347163', '75414@qq.com', 'admin');
INSERT INTO `user_info` VALUES ('李四', '13251347164', '1546465@qq.com', 'admin');