那里有錯啊，，，，來個大神指點一下。。。

CREATE?DATABASE?IF?NOT?EXISTS?'shopImooc';--創建數據庫
USE?'shopImooc';--選擇數據庫
--管理員表
DROP?TABLE?IF?EXISTS?'imooc_anmin';--刪除一個表?如果有刪除
CREATE?TABLE?'imooc_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?'imooc_cate';
CREATE?TABLE?'imooc_cate'(
'id'?smallint?unsigned?auto_increment?key,
'cName'?varchar(50)?unique
);

--商品表
DROP?TABLE?IF?EXISTS?'imooc_pro';
CREATE?TABLE?'imooc_pro'(
'id'?int?unsigned?auto_increment?key,
'pName'?varchar(50)?not?null?unique,
'pSn'???varchar(50)?not?null,?
'pNum'?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?0,
'cId'?smallint?unsigned?not?null,
);

--用戶表
DROP?TABLE?IF?EXISTS?'imooc_user';
CREATE?TABLE?'imooc_user'()
'id'?int?unsigned?auto_increment?key,
'username'?varchar?not?null?unique,
'password'?char(32)?not?null,
'sex'?ecum("男"，"女"?,"保密")?not?null?default"保密",
'face'?varchar(50)?not?null,
'regTime'?int?unsigned?not?null
);

--相冊表
DROP?TABLE?IF?EXISTS?'inooc_album';
CREATE?TABLE?'imooc_user'(
'id'??int?unsigned?auto_increment?key,
'pid'??int?unsigned?not?null,
'albumPath'?varchar(50)?not?null
);