DROP TABLE IF EXISTS `spusers`;
CREATE TABLE `spusers`(`email` VARCHAR(50) ,`group` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,`password` VARCHAR(50) ,`username` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `spschedule`;
CREATE TABLE `spschedule`(`ID` INT NOT NULL AUTO_INCREMENT,`sDate` DATE ,`Place` VARCHAR(50) ,`Score` VARCHAR(50) ,`Team1` VARCHAR(50) ,`Team2` VARCHAR(50) ,`sTime` VARCHAR(50),PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `spstandings`;
CREATE TABLE `spstandings`(`GoalsAllowed` INT ,`GoalsScored` INT ,`Losses` INT ,`OvertimeLosses` INT ,`Points` INT ,`Team` VARCHAR(50) ,`TeamLogo` LONGTEXT ,`Wins` INT ,PRIMARY KEY (`Team`));
INSERT INTO `spusers`(`ID`,`username`,`password`,`group`,`email`) VALUES(1,'admin','admin','admin',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(1,'2007-5-8 0:0:0','Minnesota Wild','Chicago Blackhawks',NULL,'7:00 PM CST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(2,'2007-6-14 0:0:0','Edmonton Oilers','Minnesota Wild',NULL,'7:30 PM PST',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(4,'2007-2-10 0:0:0','Buffalo Sabres','Minnesota Wild','1:5','8:00 PM EST',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(5,'2007-4-10 0:0:0','Minnesota Wild','Calgary Flames','2:3','7:00 PM CST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(6,'2007-1-4 0:0:0','Minnesota Wild','Colorado Avalanche','2:1','7:00 PM CST','Xcel Eergy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(7,'2007-7-9 0:0:0','Minnesota Wild','Phoenix Coyotes',NULL,'7:00 PM MST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(9,'2007-8-2 0:0:0','New York Islanders','Minnesota Wild',NULL,'7:00 PM EST',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(10,'2007-9-23 0:0:0','San Jose Sharks','Minnesota Wild',NULL,'8:30 PM PST',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(11,'2007-10-4 0:0:0','Minnesota Wild','Nashville Predators',NULL,'7:30 PM CST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(12,'2007-11-14 0:0:0','Vancouver Canucks','Minnesota Wild',NULL,'6:30 PM CST',NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(13,'2007-12-2 0:0:0','Minnesota Wild','Dallas Stars',NULL,'8:00 PM CST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(14,'2007-3-1 0:0:0','Minnesota Wild','Edmonton Oilers','4:2','7:45 PM CST','Xcel Energy Center');
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(16,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(18,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `spschedule`(`ID`,`sDate`,`Team1`,`Team2`,`Score`,`sTime`,`Place`) VALUES(19,'2008-2-22 0:0:0','Buffalo Sabres','Edmonton Oilers','1:1',NULL,NULL);
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Buffalo Sabres',7,5,1,15,23,21,'http://wild.com/images/gamecenter/teams/Buffalo\_Sabres.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Calgary Flames',7,5,0,14,25,21,'http://wild.com/images/gamecenter/teams/Calgary\_Flames.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Chicago Blackhawks',3,9,1,7,15,32,'http://wild.com/images/gamecenter/teams/chicago\_Blackhawks.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Colorado Avalanche',8,4,0,16,27,25,'http://wild.com/images/gamecenter/teams/Colorado\_Avalanche.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Dallas Stars',6,7,0,12,18,19,'http://wild.com/images/gamecenter/teams/Dallas\_Stars.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Edmonton Oilers',4,5,1,9,18,32,'http://wild.com/images/gamecenter/teams/Edmonton\_Oilers.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Minnesota Wild',10,2,1,21,27,9,'http://www.wild.com/images/gamecenter/teams/Minnesota\_Wild.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Nashville Predators',7,3,2,16,25,18,'http://wild.com/images/gamecenter/teams/Nashville\_Predators.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('New York Islanders',2,9,2,6,7,27,'http://wild.com/images/gamecenter/teams/New\_York\_Islanders.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Phoenix Coyotes',2,10,1,5,11,27,'http://wild.com/images/gamecenter/teams/Phoenix\_Coyotes.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('San Jose Sharks',6,5,1,13,14,15,'http://wild.com/images/gamecenter/teams/San\_Jose\_Sharks.gif');
INSERT INTO `spstandings`(`Team`,`Wins`,`Losses`,`OvertimeLosses`,`Points`,`GoalsScored`,`GoalsAllowed`,`TeamLogo`) VALUES('Vancouver Canucks',9,3,0,18,22,7,'http://wild.com/images/gamecenter/teams/Vancouver\_Canucks.gif');
