/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50521
Source Host : localhost:3306
Source Database : mybatis
Target Server Type : MYSQL
Target Server Version : 50521
File Encoding : 65001
Date: 2015-04-09 16:03:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- Table structure for orders
DROP TABLE IF EXISTS orders;
CREATE TABLE orders (id int(11) NOT NULL AUTO_INCREMENT,user_id int(11) NOT NULL COMMENT '下单用户id',number varchar(32) NOT NULL COMMENT '订单号',createtime datetime NOT NULL COMMENT '创建订单时间',note varchar(100) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (id),
KEY FK_orders_1 (user_id),
CONSTRAINT FK_orders_id FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- Records of orders
INSERT INTO orders VALUES ('3', '1', '1000010', '2015-02-04 13:22:35', null);
INSERT INTO orders VALUES ('4', '1', '1000011', '2015-02-03 13:22:41', null);
INSERT INTO orders VALUES ('5', '10', '1000012', '2015-02-12 16:13:23', null);
-- Table structure for user
DROP TABLE IF EXISTS user;
CREATE TABLE user (id int(11) NOT NULL AUTO_INCREMENT,username varchar(32) NOT NULL COMMENT '用户名称',birthday date DEFAULT NULL COMMENT '生日',sex char(1) DEFAULT NULL COMMENT '性别',address varchar(256) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
-- Records of user
INSERT INTO user VALUES ('1', '王五', null, '2', null);
INSERT INTO user VALUES ('10', '张三', '2014-07-10', '1', '北京市');
INSERT INTO user VALUES ('16', '张小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('22', '陈小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('24', '张三丰', null, '1', '河南郑州');
INSERT INTO user VALUES ('25', '陈小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('26', '王五', null, null, null);
