easybuy源码_easybuy数据库设计

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