create table orderinfo(
order_id int unsigned auto_increment primary key,
order_sn char(15) not null default '',
user_id int unsigned not null default 0,
username varchar(20) not null default '',
zonevarchar(30) not null default '',
address varchar(30) not null default '',
zipcode char(6) not null default '',
reciver varchar(10) not null default '',
emailvarchar(40) not null default '',
telvarchar(20) not null default '',
mobile char(11) not null default '',
building varchar(30) not null default '',
best_time varchar(10) not null default '',
add_time int unsigned not null default 0,
order_amount decimal(10,2) not null default 0.0,
pay tinyint(1) not null default 0
) engine myisam charset utf8;