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