/*
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’);