Create database PTTest

DROP TABLE IF EXISTS PushUpScoreChartMale22to26
CREATE TABLE IF NOT EXISTS PushUpScoreChartMale22to26 (
  Repetitions int(11) NOT NULL,
  Score int(11) NOT NULL,
  PRIMARY KEY (Repetitions)
) 


DROP TABLE IF EXISTS RunScoreChartMale22to26;
CREATE TABLE IF NOT EXISTS RunScoreChartMale22to26 (
  Time time NOT NULL,
  Score int(11) NOT NULL,
  PRIMARY KEY (Time)
) 


DROP TABLE IF EXISTS SitUpScoreChartMale22to26;
CREATE TABLE IF NOT EXISTS SitUpScoreChartMale22to26 (
  repetitions int(11) NOT NULL,
  score int(11) NOT NULL,
  PRIMARY KEY (repetitions)
) 
DROP TABLE IF EXISTS SoldierData;
CREATE TABLE IF NOT EXISTS SoldierData (
  LastName varchar(20) NOT NULL,
  FirstName varchar(20) NOT NULL,
  SSN varchar(9) NOT NULL,
  Height int(11) NOT NULL,
  Weight int(11) NOT NULL,
  Age int(11) NOT NULL,
  PushUpCount int(11) NOT NULL,
  SitUpCount int(11) NOT NULL,
  RunTime time NOT NULL,
  PTScore int(3) NOT NULL,
  PRIMARY KEY (SSN),
  KEY Height_idxfk (Height),
  KEY PushUpCount_idxfk (PushUpCount),
  KEY SitUpCount_idxfk (SitUpCount),
  KEY RunTime_idxfk (RunTime)
) 


DROP TABLE IF EXISTS WeightRequirements;
CREATE TABLE IF NOT EXISTS WeightRequirements (
  Height int(11) NOT NULL,
  Weight int(11) NOT NULL,
  PRIMARY KEY (Height)
)