下面用于创建t_student表的代码正确的是？
A.create table t_student( sid int not null , sname char (10) not null , sdate date, sage int not null, fulltext index index1(sid) )engine=InnoDB default charset=utf8
B.create table t_student( sid int not null , sname char (10) not null , sdate date, sage int not null, fulltext index index1(sname) )engine=InnoDB default charset=utf8;
C.create table t_student( sid int not null , sname char (10) not null , sdate date, sage int not null, fulltext index index1(sdate) )engine=InnoDB default charset=utf8;
D.create table t_student( sid int not null , sname char (10) not null , sdate date, sage int not null, fulltext index index1(sage) )engine=InnoDB default charset=utf8;
正确答案是B