use donutpool; insert into members (passwd, email, name, type) values (password('password'),'christopher.l.george@census.gov','Chris George','admin'); insert into members (passwd, email, name, type) values (password('password'),'deanna.l.wilson@census.gov','Deanna Wilson','admin'); insert into members(passwd,email,name,type) values (password('password'),'wilso364', 'Deanna Wilson','admin'); insert into members(passwd,email,name,type) values(password('password'),'georg011','Chris George','admin'); insert into pools (league) values ('nfl'); insert into pools (league) values ('ncaa'); insert into pools (league) values ('ncaa16'); insert into players values ('',1,4,'Chris is cool','yes'); insert into players values ('',2,4,'Deanna Rules','yes'); insert into players values ('',1,3,'Wombat','yes'); insert into players values ('',2,3,'Dolphin','yes'); insert into teams (name, shortname, seed, pool_id) values ('Pittsburgh Panthers', 'PIT', 1, 2); insert into teams (name, shortname, seed, pool_id) values ('Duke','DUK', 2,2); insert into teams (name, shortname, seed, pool_id) values ('Stanford','Sta', 3,2); insert into teams (name, shortname, seed, pool_id) values ('Conneticut','Con',4,2); insert into games (home_id, away_id,pool_id) values (1,2,2); insert into games (home_id, away_id, pool_id) values (3,4,2);