

/*
create table players (
  ID varchar(128) primary key,
  firstname varchar(128),
  lastname varchar(64),
  position varchar(64),
  firstseason varchar(32),
  lastseason char(64),
  h_feet		int(10),
  h_inches		int(10),
  weight		int(10),
  college		varchar(30),
  birthdate		varchar(30)
) engine=InnoDB default charset=utf8;


load data local infile '504/players.csv' into table players
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
(ID, firstname, lastname, position, firstseason, lastseason, h_feet, h_inches, weight, college, birthdate);


create table player_playoffs (
  Id varchar(128) primary key,
  year int(12),
  firstname varchar(64),
  lastname 	varchar(64),
  team 	varchar(10),
  leag 	   	char(32),
  gp   		int(10),
  minutes	int(10),
  pts		int(10),
  dreb		int(10),
  oreb		int(10),
  reb		int(10),
  asts		int(10),
  stl		int(10),
  blk		int(10),
  turnover	int(10),
  pf		int(10),
  fga		int(10),
  fgm		int(10),
  fta		int(10),
  ftm		int(10),	
  tpa		int(10),
  tpm		int(10)
) engine=InnoDB default charset=utf8;


load data local infile '504/player_playoffs.csv' into table player_playoffs
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
(Id,	year,	firstname,	lastname,	team,	leag,	gp,	minutes,	pts,	dreb,	oreb,	reb,	asts,	stl,	blk,	turnover,	
pf,	fga,	fgm,	fta,	ftm,	tpa,	tpm)




create table teams (
  team 		varchar(128) primary key,
  location 	varchar(128),	
  name		varchar(128),	
  leag		char(10)
) engine=InnoDB default charset=utf8;


load data local infile '504/teams.csv' into table teams
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
(team,	location,	name,	leag)			
*/


load data local infile '504/data.csv' into table patientdata
fields terminated by ','
enclosed by '"'
lines terminated by '\r'
(First, Last, date_of_birth, Med Rec No, Diag Loc, Diag Date, Diag Code)	


