grant select,insert,update,delete on tenk.* to tenk;

create database tenk;

use tenk;

create table funrun ( 
  firstname varchar(40) not null,
  lastname varchar(40) not null,
  prints int(5) default '0',
  primary key (firstname,lastname) );

create table mainrun (
  firstname varchar(40) not null,
  lastname varchar(40) not null,
  prints int(5) default '0',
  bib int(5) not null,
  time int(11) not null,
  age int(5),
  gender char(1),
  primary key (bib) );