week9之user.sql
时间:2021-07-01 10:21:17
帮助过:25人阅读
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;
week9之user.sql
标签:key bsp char not text logs engine utf8 font