完结正确数据库的所有代码，字段不要给单引号，sex要设置一下字符集。所有代码要拷贝到mysql控制台远行，在phpmyadmin全部报错的，win建议使用wampserver。

set name uft8;

DROP DATABASE mk_www;

CREATE DATABASE IF NOT EXISTS mk_www;

USE mk_www;

--管理员表--

DROP TABLE IF EXISTS mk_admin;

CREATE TABLE mk_admin(

id tinyint unsigned auto_increment key,

userName varchar(20) not null unique,

passWord char(32) not null,

email varchar(50) not null

);

--分类表--

DROP TABLE IF EXISTS mk_cate;

CREATE TABLE mk_cate(

id smallint unsigned auto_increment key,

cName varchar(50) unique

);

--产品表--

DROP TABLE IF EXISTS mk_pro;

CREATE TABLE mk_pro(

id int unsigned auto_increment key,

pName varchar(50) not null unique,

pSn int unsigned default 1,

mPrice decimal(10,2) not null,

iPrice decimal(10,2) not null,

pDesc text,

pImg varchar(50) not null,

puBTime int unsigned not null,

isShow tinyint(1) default 1,

isHot tinyint(1) default 1,

cId smallint unsigned not null

);

--用户表----

DROP TABLE IF EXISTS mk_user;

CREATE TABLE mk_user(

id int unsigned auto_increment key,

userName varchar(20) not null unique,

passWord char(32) not null,

sex enum("保密","男","女") not null default "保密",

face varchar(50) not null,

regTime int unsigned not null

)engine=innodb default charset=utf8;;

--相册表--

DROP TABLE IF EXISTS mk_album;

CREATE TABLE mk_album(

id int unsigned auto_increment key,

pid int unsigned not null,

albumPath varchar(50) not null

);