#创建订单表
create table hy_order_20170410 (id varchar(100),order_money float,memeber_id int,create_time datetime,status int);


insert into hy_order_20170410 values ('A001',100.15,1,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A001',100.15,1,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A002',100.0,2,'2017-04-01 14:23:12',2); 
insert into hy_order_20170410 values ('A003',12.1,3,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A004',200.15,4,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A005',1200.15,5,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A006',0.15,11,'2017-01-01 17:23:12',2); 
insert into hy_order_20170410 values ('A007',1215.1,31,'2017-01-01 10:23:12',2); 
insert into hy_order_20170410 values ('A008',100.75,15,'2017-01-01 14:23:12',2); 
insert into hy_order_20170410 values ('A009',100.15,8,'2017-01-01 15:23:12',2); 
insert into hy_order_20170410 values ('A010',20.15,9,'2017-01-01 16:23:12',2); 
insert into hy_order_20170410 values ('A011',110.15,21,'2017-01-01 14:23:12',2); 
insert into hy_order_20170410 values ('A012',1.15,13,'2017-01-01 13:03:12',2); 
insert into hy_order_20170410 values ('A013',20.15,14,'2017-02-01 13:53:12',2); 
insert into hy_order_20170410 values ('A014',30.15,15,'2017-03-01 13:23:12',2); 
insert into hy_order_20170410 values ('A015',40.5,13,'2017-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A016',65.0,1,'2016-01-01 13:23:12',2); 
insert into hy_order_20170410 values ('A017',78.15,1,'2016-03-01 09:23:12',);
insert into hy_order_20170410 values ('A018',88.15,1,'2016-11-01 20:23:12',2); 
insert into hy_order_20170410 values ('A019',99.0,12,'2017-02-11 13:23:12',1); 
insert into hy_order_20170410 values ('A020',10.3,13,'2017-04-01 13:23:12',2); 





#创建订单明细表
create table hy_orderitem_20170410 (id varchar(100),order_id varchar(100),item_id int,item_name varchar(200), price float,item_num int);

insert into hy_orderitem_20170410 values('AB001','A001',1001,'A',0.15,1);
insert into hy_orderitem_20170410 values('AB002','A001',1002,'B',20,1);
insert into hy_orderitem_20170410 values('AB003','A001',1003,'C',40,2);
insert into hy_orderitem_20170410 values('AB004','A005',1001,'A',0.15,1);
insert into hy_orderitem_20170410 values('AB005','A005',1004,'D',200,6);
insert into hy_orderitem_20170410 values('AB0015','A015',1005,'E',40.5,1);
insert into hy_orderitem_20170410 values('AB0016','A019',1006,'F',50,1);
insert into hy_orderitem_20170410 values('AB0017','A019',1007,'G',24.5,2);
insert into hy_orderitem_20170410 values('AB0018','A020',1008,'H',10.3,1);