-- $RCSfile: comp-stats.sql   $
-- $Author: tgeorgeokstate    $
-- $Revision: 1.0             $
-- $Date: 2003/09/25 19:22:56 $
-- $Comment: Use this to import sportsinteractive.com player stats
-- $ make sure that you change the d/l directory and table names each week

drop table if exists si_week4;
create table si_week4 (
  PlayerName     varchar(50),
  TeamAbbName    varchar(5),
  GP             int,
  PAtt           int,
  PComp          int,
  PYds           int,
  PTD            int,
  PInt           int,
  PLong          int,
  PSack          int,
  PYdsL          int,
  SRush          int,
  SYds           int,
  SLng           int,
  STD            int,
  CRec           int,
  CYds           int,
  CLng           int,
  CYAC           double,
  C1stD          int,
  CTD            int,
  Fum            int,
  FumL           int,
  K00            int,
  K20            int,
  K30            int,
  K40            int,
  K50            int,
  KFGA           int,
  KFGM           int,
  KLng           int,
  XPM            int,
  XPA            int,
  KR             int,
  KRYds          int,
  KRFC           int,
  KRLong         int,
  KRTD           int,
  PR             int,
  PRYds          int,
  PRFC           int,
  PRLong         int,
  PRTD           int,
  Punt           int,
  TYds           int,
  TIn20          int,
  TIn10          int,
  TTB            int,
  TLong          int,
  TkSolo         int,
  TkAst          int,
  TkTotal        int,
  TkSack         int,
  TkYdsL         int,
  IntD           int,
  IntYds         int,
  IntTD          int,
  PD             int,
  Sfty           int,
  stat_id        int not null auto_increment,
  primary key    (stat_id)
);
LOAD DATA INFILE 'c:/games/dev-java/scores/week4/NFL2003Players.csv' INTO TABLE si_week4 FIELDS TERMINATED BY ','  ENCLOSED BY '"' IGNORE 3 LINES;
