/*
Navicat MySQL Data Transfer

Source Server         : lrn
Source Server Version : 50153
Source Host           : localhost:3306
Source Database       : cqxm

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

Date: 2016-09-05 10:26:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `adminUser` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('kepler', '202cb962ac59075b964b07152d234b70');

-- ----------------------------
-- Table structure for food
-- ----------------------------
DROP TABLE IF EXISTS `food`;
CREATE TABLE `food` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `pic` varchar(255) NOT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of food
-- ----------------------------
INSERT INTO `food` VALUES ('0', '重庆小面', '9.00', 'banner.jpg');
INSERT INTO `food` VALUES ('1', '鸡丝凉面', '10.00', 'banner1.jpg');
INSERT INTO `food` VALUES ('2', '豌杂面', '10.00', 'banner2.jpg');
INSERT INTO `food` VALUES ('3', '清汤丸子面', '10.00', 'banner3.jpg');
INSERT INTO `food` VALUES ('4', '原味鸡汤面', '6.00', 'banner4.jpg');
INSERT INTO `food` VALUES ('5', '清汤炖鸡面', '11.00', 'banner5.jpg');
INSERT INTO `food` VALUES ('6', '宜宾燃面', '10.00', 'banner6.jpg');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `oid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `fids` varchar(255) NOT NULL,
  `numbers` varchar(255) NOT NULL,
  `totalprice` decimal(10,2) NOT NULL,
  `address` varchar(255) NOT NULL,
  `times` varchar(255) NOT NULL,
  PRIMARY KEY (`oid`),
  KEY `uid` (`uid`),
  CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('26', '1', '0,1,2', '15200000000', '29.00', '大连东软', '2016-09-02 09:36:08am');
INSERT INTO `orders` VALUES ('27', '1', '0,1,2', '15200000000', '29.00', '大连东软', '2016-09-02 09:36:52am');
INSERT INTO `orders` VALUES ('28', '1', '1,2', '15200000000', '20.00', '大连东软是', '2016-09-02 09:38:25am');
INSERT INTO `orders` VALUES ('29', '1', '0,1,2,3,4', '15200000000', '45.00', 'dalinadjishfafaasf', '2016-09-05 07:25:38am');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `sex` int(11) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'lrn', '0', '698d51a19d8a121ce581499d7b701668', '15200000000');
INSERT INTO `user` VALUES ('2', '233', '0', 'bcbe3365e6ac95ea2c0343a2395834dd', '2323');
INSERT INTO `user` VALUES ('3', '葫芦娃', '1', '202cb962ac59075b964b07152d234b70', '13300000000');
INSERT INTO `user` VALUES ('4', 'XXX', '1', '202cb962ac59075b964b07152d234b70', '13000001111');