订餐库系统

订餐库系统创建表和插入数据

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50556
Source Host           : localhost:3306
Source Database       : book_dinner

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

Date: 2017-10-22 21:51:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_customer
-- ----------------------------
DROP TABLE IF EXISTS `t_customer`;
CREATE TABLE `t_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) NOT NULL,
  `tel` varchar(225) NOT NULL,
  `address` varchar(225) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_customer
-- ----------------------------
INSERT INTO `t_customer` VALUES ('1', '张中天', '13702858114', '江苏省南通市 ');
INSERT INTO `t_customer` VALUES ('2', '陆佳楠', '15728594769', '江苏省南京市 ');
INSERT INTO `t_customer` VALUES ('3', '张三', '15392761852', '江苏省苏州市 ');
INSERT INTO `t_customer` VALUES ('4', '李四', '13286283423', '江苏省扬州市 ');
INSERT INTO `t_customer` VALUES ('5', '王五', '13286283425', '江苏省连云港市');
INSERT INTO `t_customer` VALUES ('6', '钱二', '13286283423', '江苏省徐州市');
INSERT INTO `t_customer` VALUES ('7', '小明', '13286241413', '江苏省无锡市');
INSERT INTO `t_customer` VALUES ('8', '小红', '13425245455', '江苏省宿迁市');
INSERT INTO `t_customer` VALUES ('9', '赵六', '13445213411', '江苏省泰州市');
INSERT INTO `t_customer` VALUES ('10', '小强', '18093439144', '江苏省常州市');

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` int(11) NOT NULL,
  `dish` varchar(225) NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES ('1', '1', '麻辣小龙虾', '50');
INSERT INTO `t_menu` VALUES ('2', '2', '宫保鸡丁', '20');
INSERT INTO `t_menu` VALUES ('3', '3', '牛杂汤', '40');
INSERT INTO `t_menu` VALUES ('4', '4', '美味酸菜鱼', '35');
INSERT INTO `t_menu` VALUES ('5', '5', '北京烤鸭', '30');
INSERT INTO `t_menu` VALUES ('6', '6', '孜然羊肉', '60');
INSERT INTO `t_menu` VALUES ('7', '7', '果汁', '15');
INSERT INTO `t_menu` VALUES ('8', '8', '鱼香肉丝', '30');
INSERT INTO `t_menu` VALUES ('9', '9', '回锅肉', '35');
INSERT INTO `t_menu` VALUES ('10', '10', '鱼翅', '200');

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_number` varchar(225) NOT NULL,
  `order_number` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `time` datetime NOT NULL,
  `restaurant_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_restaurant` (`restaurant_id`),
  KEY `fk_order_content` (`order_id`),
  KEY `fk_customer` (`customer_id`),
  CONSTRAINT `fk_customer` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`),
  CONSTRAINT `fk_order_content` FOREIGN KEY (`order_id`) REFERENCES `t_order_content` (`id`),
  CONSTRAINT `fk_restaurant` FOREIGN KEY (`restaurant_id`) REFERENCES `t_restaurant` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order
-- ----------------------------
INSERT INTO `t_order` VALUES ('1', 'A1', '2017101801', '1', '1', '4', '2017-10-18 17:17:58', '1');
INSERT INTO `t_order` VALUES ('2', 'A1', '2017101801', '2', '1', '4', '2017-10-18 17:19:49', '1');
INSERT INTO `t_order` VALUES ('3', 'A1', '2017101801', '3', '1', '4', '2017-10-18 17:20:43', '1');
INSERT INTO `t_order` VALUES ('4', 'B1', '2017101802', '5', '2', '2', '2017-10-18 17:26:32', '9');
INSERT INTO `t_order` VALUES ('5', 'B1', '2017101802', '6', '2', '2', '2017-10-18 17:27:11', '9');
INSERT INTO `t_order` VALUES ('6', 'C1', '2017101803', '1', '3', '3', '2017-10-18 17:27:40', '3');
INSERT INTO `t_order` VALUES ('7', 'C1', '2017101803', '3', '3', '3', '2017-10-18 17:28:20', '3');
INSERT INTO `t_order` VALUES ('8', 'D1', '2017101804', '2', '4', '1', '2017-10-18 17:29:01', '7');
INSERT INTO `t_order` VALUES ('9', 'D1', '2017101804', '6', '4', '1', '2017-10-18 17:31:28', '7');
INSERT INTO `t_order` VALUES ('10', 'D1', '2017101804', '2', '4', '1', '2017-10-18 17:31:50', '7');

-- ----------------------------
-- Table structure for t_order_content
-- ----------------------------
DROP TABLE IF EXISTS `t_order_content`;
CREATE TABLE `t_order_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` int(11) NOT NULL,
  `piece` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_menu` (`m_id`),
  CONSTRAINT `fk_menu` FOREIGN KEY (`m_id`) REFERENCES `t_menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order_content
-- ----------------------------
INSERT INTO `t_order_content` VALUES ('1', '1', '2', '50');
INSERT INTO `t_order_content` VALUES ('2', '2', '1', '20');
INSERT INTO `t_order_content` VALUES ('3', '3', '1', '40');
INSERT INTO `t_order_content` VALUES ('4', '4', '1', '35');
INSERT INTO `t_order_content` VALUES ('5', '5', '2', '30');
INSERT INTO `t_order_content` VALUES ('6', '6', '2', '60');
INSERT INTO `t_order_content` VALUES ('7', '7', '10', '15');
INSERT INTO `t_order_content` VALUES ('8', '8', '8', '30');
INSERT INTO `t_order_content` VALUES ('9', '9', '6', '35');
INSERT INTO `t_order_content` VALUES ('10', '10', '2', '0');

-- ----------------------------
-- Table structure for t_restaurant
-- ----------------------------
DROP TABLE IF EXISTS `t_restaurant`;
CREATE TABLE `t_restaurant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) NOT NULL,
  `tel` varchar(225) NOT NULL,
  `address` varchar(225) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_restaurant
-- ----------------------------
INSERT INTO `t_restaurant` VALUES ('1', '南通大饭店', '1399144388', '建设路');
INSERT INTO `t_restaurant` VALUES ('2', '王子饭店', '1425623562', '文化宫');
INSERT INTO `t_restaurant` VALUES ('3', '三德大酒店', '1355446279', '圆融广场');
INSERT INTO `t_restaurant` VALUES ('4', '有斐饭店', '1355446276', '南大街');
INSERT INTO `t_restaurant` VALUES ('5', '江海大酒店', '1385446279', '江海大道');
INSERT INTO `t_restaurant` VALUES ('6', '必胜客', '1355443343', '大润发');
INSERT INTO `t_restaurant` VALUES ('7', '麦当劳', '1353324781', '八佰伴');
INSERT INTO `t_restaurant` VALUES ('8', '肯德基', '1801417878', '通大附院');
INSERT INTO `t_restaurant` VALUES ('9', '外婆家', '1355347381', '易初莲花');
INSERT INTO `t_restaurant` VALUES ('10', '刘巧儿', '1355347321', '环西文化广场');