create database easybuy /*易买网数据库*/
use easybuy
go
/*用户表,用于存放用户基本信息*/
create table easybuy_user(
eu_user_id varchar(10) not null primary key,--用户名
eu_user_name varchar(20) not null,--真实姓名
eu_password varchar(20) not null,--密码
eu_sex char(1) not null,--性别
eu_birthday date,--出生日期
eu_identity_code varchar(60),--身份证号
eu_email varchar(80),--电子邮件
eu_mobile varchar(11),--手机
eu_address varchar(200) not null,--地址
eu_staus int --类型,1普通用户,2管理员
)
insert into easybuy_user values ('10010','aaa','aaa','1','1990-01-01','500212345678945656','123465@qq.com','12345698752','重庆',1)
insert into easybuy_user values ('10011','bbb','bbb','0','1991-01-01','500212564678945656','128965@qq.com','12340123752','重庆',1)
insert into easybuy_user values ('10012','ccc','ccc','1','1992-01-01','500212345678998756','126875@qq.com','12698728752','重庆',2)
insert into easybuy_user values ('10013','ddd','ddd','1','1993-01-01','500214658978945656','123465@qq.c