week9之user.sql
标签：key bsp char not text logs engine utf8 font
week9之user.sql
table user(
id int not null auto_increment primary key,
username varchar(30) not null default ‘‘,
pwd char(32) not null default ‘‘,
email varchar(40) not null default ‘‘,
status tinyint(1) not null default 1,
sex enum(‘男‘,‘女‘) not null default ‘男‘,
info text not null default ‘‘,
pic varchar(100) not null default ‘‘,
createTime int(10) not null default 0
)engine=myisam default charset=utf8;