--用戶表

DROP TABLE IF EXISTS imooc_user;

CREATE TABLE imooc_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

);

--相冊表

DROP TABLE IF EXISTS imooc_album;

CREATE TABLE imooc_album(

id int unsigned auto_increment key,

pid int unsigned not null,

albumPath varchar(50) not null,

);