drop table if exists roster;
create table roster (
  team varchar(30),
  pno integer(2),
  fname varchar(30),
  lname varchar(30),
  position varchar(20),
  url varchar(100),
  heightft integer(1),
  heightin integer(2),
  weight integer(3),
  primary key (team,pno)
);