电子商城项目笔录研讨.docVIP

电子商城项目笔录 后台用户的控制访问权限 1.1建立管理员表 #管理员表 drop table if exists admin; create table admin( id mediumint unsigned key auto_increment, name varchar(50) unique not null, password varchar(32) not null ); insert into admin (name,password)value(admin,md5(admin)); insert into admin (name,password)value(vip,md5(123456)); 1.2建立用户表 #用户表 drop table if exists userInfo; create table userInfo( userId mediumint unsigned key auto_increment, username varchar(50) unique not null, password varchar(32) not null, sex enum(man,women,secret) default man, name varchar(60), age tinyint(3) unsigned not null, email varchar(50