CREATE TABLE players (
  id int unsigned not null primary key auto_increment,
  school_id int unsigned,
  first_name varchar(255) not null,
  last_name varchar(255) not null,
  gender enum('m', 'f') not null,
  date_of_birth date not null,
  registration_date date not null,
  email varchar(255),
  unique(email),
  unique(first_name,last_name,date_of_birth,school_id),
  index (school_id),
  index (date_of_birth),
  index (registration_date),
  index (gender)
);