完結正確數據庫的所有代碼，字段不要給單引號，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

);