10-20 餐厅订餐SQL语句

/*
Navicat MySQL Data Transfer

Source Server : ntqn_94
Source Server Version : 50556
Source Host : localhost:3306
Source Database : ntqn-96

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

Date: 2017-10-20 17:09:51
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for t_connection1

---

DROP TABLE IF EXISTS t_connection1;
CREATE TABLE t_connection1 (
o_id varchar(255) DEFAULT NULL,
m_id int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of t_connection1

---

INSERT INTO t_connection1 VALUES (‘1’, ‘1’);
INSERT INTO t_connection1 VALUES (‘1’, ‘2’);
INSERT INTO t_connection1 VALUES (‘2’, ‘3’);
INSERT INTO t_connection1 VALUES (‘2’, ‘4’);

---

– Table structure for t_connection2

---

DROP TABLE IF EXISTS t_connection2;
CREATE TABLE t_connection2 (
v_id int(11) NOT NULL,
o_id int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of t_connection2

---

INSERT INTO t_connection2 VALUES (‘1’, ‘1’);
INSERT INTO t_connection2 VALUES (‘2’, ‘2’);

---

– Table structure for t_food_list

---

DROP TABLE IF EXISTS t_food_list;
CREATE TABLE t_food_list (
id int(11) NOT NULL AUTO_INCREMENT,
food_code varchar(255) DEFAULT NULL,
food_name varchar(255) DEFAULT NULL,
food_piece int(11) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of t_food_list

---

INSERT INTO t_food_list VALUES (‘1’, ‘f001’, ‘土豆丝’, ‘10’);
INSERT INTO t_food_list VALUES (‘2’, ‘f002’, ‘炒鸡蛋’, ‘8’);
INSERT INTO t_food_list VALUES (‘3’, ‘f003’, ‘炒肉’, ‘20’);
INSERT INTO t_food_list VALUES (‘4’, ‘f004’, ‘米饭’, ‘10’);
INSERT INTO t_food_list VALUES (‘5’, ‘f005’, ‘炒饭’, ‘11’);
INSERT INTO t_food_list VALUES (‘6’, ‘f006’, ‘糖酥排骨’, ‘38’);
INSERT INTO t_food_list VALUES (‘7’, ‘f007’, ‘鱼香肉丝’, ‘25’);
INSERT INTO t_food_list VALUES (‘8’, ‘f008’, ‘韭菜炒蛋’, ‘15’);
INSERT INTO t_food_list VALUES (‘9’, ‘f009’, ‘口水鸡’, ‘45’);
INSERT INTO t_food_list VALUES (‘10’, ‘f010’, ‘手撕包菜’, ‘38’);

---

– Table structure for t_menu

---

DROP TABLE IF EXISTS t_menu;
CREATE TABLE t_menu (
id int(255) NOT NULL AUTO_INCREMENT,
food_name varchar(255) DEFAULT NULL,
food_code varchar(255) DEFAULT NULL,
count int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of t_menu

---

INSERT INTO t_menu VALUES (‘1’, ‘土豆丝’, ‘f001’, ‘1’);
INSERT INTO t_menu VALUES (‘2’, ‘炒鸡蛋’, ‘f002’, ‘1’);
INSERT INTO t_menu VALUES (‘3’, ‘米饭’, ‘f004’, ‘2’);
INSERT INTO t_menu VALUES (‘4’, ‘炒肉’, ‘f003’, ‘1’);
INSERT INTO t_menu VALUES (‘5’, ‘糖酥排骨’, ‘f006’, ‘1’);
INSERT INTO t_menu VALUES (‘6’, ‘鱼香肉丝’, ‘f007’, ‘1’);
INSERT INTO t_menu VALUES (‘7’, ‘鱼香肉丝’, ‘f008’, ‘2’);
INSERT INTO t_menu VALUES (‘8’, ‘韭菜炒蛋’, ‘f008’, ‘3’);
INSERT INTO t_menu VALUES (‘9’, ‘口水鸡’, ‘f009’, ‘1’);
INSERT INTO t_menu VALUES (‘10’, ‘手撕包菜’, ‘f010’, ‘1’);

---

– Table structure for t_order

---

DROP TABLE IF EXISTS t_order;
CREATE TABLE t_order (
id int(11) NOT NULL AUTO_INCREMENT,
order_code varchar(255) DEFAULT NULL,
order_time datetime DEFAULT NULL,
finish_time datetime DEFAULT NULL,
table_code int(11) DEFAULT NULL,
n_money int(255) DEFAULT NULL,
paid_money int(255) DEFAULT NULL,
people int(255) DEFAULT NULL,
other text,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of t_order

---

INSERT INTO t_order VALUES (‘1’, ‘x01010’, ‘2017-10-10 16:42:27’, ‘2017-10-10 17:42:42’, ‘5’, ‘100’, ‘80’, ‘2’, ‘加辣’);
INSERT INTO t_order VALUES (‘2’, ‘x02020’, ‘2017-10-12 16:43:15’, ‘2017-10-12 16:22:19’, ‘8’, ‘150’, ‘120’, ‘2’, ‘不要香菜’);
INSERT INTO t_order VALUES (‘3’, ‘x03030’, ‘2017-10-15 00:00:00’, ‘2017-10-15 18:30:00’, ‘10’, ‘85’, ‘80’, ‘3’, ‘ssss’);
INSERT INTO t_order VALUES (‘4’, ‘x04040’, ‘2017-10-15 00:00:00’, ‘2017-10-15 19:30:00’, ‘9’, ‘80’, ‘75’, ‘1’, ‘5656’);
INSERT INTO t_order VALUES (‘5’, ‘x05050’, ‘2017-10-15 00:00:00’, ‘2017-10-15 20:30:00’, ‘12’, ‘99’, ‘90’, ‘4’, ‘97558’);
INSERT INTO t_order VALUES (‘6’, ‘x06589’, ‘2017-10-19 22:05:15’, ‘2017-10-19 22:05:18’, ‘6’, ‘200’, ‘180’, ‘6’, ‘sdaa’);
INSERT INTO t_order VALUES (‘7’, ‘x58586’, ‘2017-10-18 22:05:50’, ‘2017-10-18 22:05:54’, ‘12’, ‘165’, ‘165’, ‘8’, ’ ‘);
INSERT INTO t_order VALUES (‘8’, ‘x89898’, ‘2017-10-17 22:06:29’, ‘2017-10-17 22:06:36’, ‘16’, ‘145’, ‘135’, ‘5’, ’ ‘);
INSERT INTO t_order VALUES (‘9’, ‘x25056’, ‘2017-10-18 22:07:06’, ‘2017-10-20 22:07:10’, ‘11’, ‘135’, ‘132’, ‘6’, ’ ‘);
INSERT INTO t_order VALUES (‘10’, ‘x89826’, ‘2017-10-24 22:08:06’, ‘2017-10-23 22:08:10’, ‘17’, ‘189’, ‘186’, ‘9’, null);

---

– Table structure for vip_info

---

DROP TABLE IF EXISTS vip_info;
CREATE TABLE vip_info (
id int(11) NOT NULL AUTO_INCREMENT,
vip_account varchar(50) DEFAULT NULL,
vip_name varchar(50) DEFAULT NULL,
contact_way varchar(50) DEFAULT NULL,
vip_times int(11) DEFAULT NULL,
closest_time datetime DEFAULT NULL,
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of vip_info

---

INSERT INTO vip_info VALUES (‘1’, ‘S010’, ‘张三’, ‘188556555’, ‘5’, ‘2018-10-10 18:30:00’);
INSERT INTO vip_info VALUES (‘2’, ‘S020’, ‘王五’, ‘135666952’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘3’, ‘S030’, ‘是多少’, ‘18565852’, ‘8’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘4’, ‘S040’, ‘二饿’, ‘1899856852’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘5’, ‘S050’, ‘格是’, ‘456482255’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘6’, ‘S060’, ‘特问问’, ‘12345678’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘7’, ‘S030’, ‘张柳’, ‘18565852’, ‘8’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘8’, ‘S040’, ‘莉莉’, ‘1899856852’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘9’, ‘S050’, ‘王哦’, ‘456482255’, ‘2’, ‘2018-10-12 15:30:00’);
INSERT INTO vip_info VALUES (‘10’, ‘S060’, ‘王老师’, ‘12345678’, ‘2’, ‘2018-10-12 15:30:00’);