CREATE TABLE IF NOT EXISTS `dfl`.`available` (
  `Rank` INT(11) NOT NULL,
  `Pick` DOUBLE NULL DEFAULT NULL,
  `Name` TEXT NULL DEFAULT NULL,
  `Pos` TEXT NULL DEFAULT NULL,
  `Team` TEXT NULL DEFAULT NULL,
  `Bye` INT(11) NULL DEFAULT NULL,
  `Overall` DOUBLE NULL DEFAULT NULL,
  `Std. Dev` DOUBLE NULL DEFAULT NULL,
  `High` DOUBLE NULL DEFAULT NULL,
  `Low` DOUBLE NULL DEFAULT NULL,
  `Times Drafted` INT(11) NULL DEFAULT NULL,
  `dflteam` TEXT NULL DEFAULT NULL,
  `dflcount` INT(11) NULL DEFAULT NULL,
  `dflround` INT(11) NULL DEFAULT NULL,
  `proj` INT(11) NULL DEFAULT NULL,
  `nrank` TINYINT NULL DEFAULT NULL,
  PRIMARY KEY (`Rank`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1


CREATE TABLE IF NOT EXISTS `dfl`.`dflteams` (
  `draftorder` INT(11) NOT NULL,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  `coach` VARCHAR(45) NULL DEFAULT NULL,
  `last season rank` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`draftorder`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1


IMPORT FROM \VAR\LIB\MYSQL-FILES

LOAD DATA INFILE '/var/lib/mysql-files/dflavailable.csv' INTO TABLE available FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
LOAD DATA INFILE '/var/lib/mysql-files/dflteams.csv' INTO TABLE dflteams FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';



MISSING
qb
ELI MANNING
rb
M. Davis
W. SMallwood
WR
M. Sanu
D. Thomas
C. Beasley
T. Gabriel
A. Roberts
C. Rodgers
R. Switzer
J. Grant
D. Amendola
J. Gordon
M. Crabtree
W. Snead BAL
D. Montcrief PIT
A Erickson CIN
K Bourne SF
R higgins CLE
A Wilson MIA
M Valdes-Scantling GB
S Roberts BAL
D MOORe SEA
J Doctson WAS
J Reynolds LAR
J Ross III CIN
C Conley JAX
M Gallup DAL