Hello,
I need some help. Does anyone see what I'm doing wrong here:
create table MeetScores (
MeetScoresId default 100 not null auto_increment,
meet varchar(5) not null default '',
sess varchar(3) not null default '',
GymnastNumber integer not null default 0,
Gymnast varchar(30) not null default '',
VaultScore varchar(6) not null default '0',
VaultPlace varchar(6) not null default '0',
BarScore varchar(6) not null default '0',
BarPlace varchar(6) not null default '0',
BeamScore varchar(6) not null default '0',
BeamPlace varchar(6) not null default '0',
FloorScore varchar(6) not null default '0',
FloorPlace varchar(6) not null default '0',
AAScore varchar(6) not null default '0',
AAPlace varchar(6) not null default '0',
primary key (MeetScoresId),
index (meet,sess),
index (Gymnast),
index (GymnastNumber)
)
Thanks!
