-- phpMyAdmin SQL Dump -- version 2.6.2-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 10, 2006 at 11:30 AM -- Server version: 4.1.20 -- PHP Version: 4.3.11 -- -- Database: `SportsForge` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXBaseball` -- CREATE TABLE `SectionXBaseball` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `AB` int(11) NOT NULL default '0', `Hits` int(11) NOT NULL default '0', `2B` int(11) NOT NULL default '0', `3B` int(11) NOT NULL default '0', `HR` int(11) NOT NULL default '0', `RBI` int(11) NOT NULL default '0', `Runs` int(11) NOT NULL default '0', `BB` int(11) NOT NULL default '0', `SB` int(11) NOT NULL default '0', `SO` int(11) NOT NULL default '0', `Played` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5818 ; -- -- Dumping data for table `SectionXBaseball` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXBaseballPitcher` -- CREATE TABLE `SectionXBaseballPitcher` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `IP` decimal(5,1) NOT NULL default '0.0', `W` int(11) NOT NULL default '0', `L` int(11) NOT NULL default '0', `H` int(11) NOT NULL default '0', `R` int(11) NOT NULL default '0', `ER` int(11) NOT NULL default '0', `SV` int(11) NOT NULL default '0', `K` int(11) NOT NULL default '0', `BB` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1900 ; -- -- Dumping data for table `SectionXBaseballPitcher` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXBasketball` -- CREATE TABLE `SectionXBasketball` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `FGA` int(11) NOT NULL default '0', `FGM` int(11) NOT NULL default '0', `XFGA` int(11) NOT NULL default '0', `XFGM` int(11) NOT NULL default '0', `FTA` int(11) NOT NULL default '0', `FTM` int(11) NOT NULL default '0', `Rebounds` int(11) NOT NULL default '0', `Assists` int(11) NOT NULL default '0', `Blocks` int(11) NOT NULL default '0', `Steals` int(11) NOT NULL default '0', `Turnovers` int(11) NOT NULL default '0', `Played` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12463 ; -- -- Dumping data for table `SectionXBasketball` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXClass` -- CREATE TABLE `SectionXClass` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(5) NOT NULL default '', `Sort` int(11) NOT NULL default '0', `SportID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ; -- -- Dumping data for table `SectionXClass` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXCoach` -- CREATE TABLE `SectionXCoach` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(50) default NULL, `CareerRecord` varchar(15) default NULL, `Years` int(11) default NULL, `Description` text, `Email` varchar(50) default NULL, `SchoolID` int(11) default NULL, `Photo` varchar(50) NOT NULL default 'spacer.gif', `SportID` int(11) default NULL, `JV` int(11) default '0', `Username` varchar(50) default NULL, `Password` varchar(50) default NULL, `Role` varchar(5) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=382 ; -- -- Dumping data for table `SectionXCoach` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXCrossCountry` -- CREATE TABLE `SectionXCrossCountry` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `MeetID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Place` int(11) NOT NULL default '0', `Minutes` int(11) NOT NULL default '0', `Seconds` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2257 ; -- -- Dumping data for table `SectionXCrossCountry` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXDivision` -- CREATE TABLE `SectionXDivision` ( `ID` int(11) NOT NULL auto_increment, `Name` char(50) default NULL, `SportID` int(11) default NULL, `Section` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ; -- -- Dumping data for table `SectionXDivision` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXFootball` -- CREATE TABLE `SectionXFootball` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `PassAtt` int(11) NOT NULL default '0', `PassComp` int(11) NOT NULL default '0', `PassYds` int(11) NOT NULL default '0', `Rush` int(11) NOT NULL default '0', `RushYds` int(11) NOT NULL default '0', `Reception` int(11) NOT NULL default '0', `RecYds` int(11) NOT NULL default '0', `TD` int(11) NOT NULL default '0', `IntOffense` int(11) NOT NULL default '0', `Tackles` int(11) NOT NULL default '0', `FumForce` int(11) NOT NULL default '0', `FumRec` int(11) NOT NULL default '0', `Sack` int(11) NOT NULL default '0', `IntDefense` int(11) NOT NULL default '0', `RetPunt` int(11) NOT NULL default '0', `RetPuntYds` int(11) NOT NULL default '0', `RetKick` int(11) NOT NULL default '0', `RetKickYds` int(11) NOT NULL default '0', `Punt` int(11) NOT NULL default '0', `PuntYds` int(11) NOT NULL default '0', `FGA` int(11) NOT NULL default '0', `FGM` int(11) NOT NULL default '0', `PATA` int(11) NOT NULL default '0', `PATM` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4506 ; -- -- Dumping data for table `SectionXFootball` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXGolf` -- CREATE TABLE `SectionXGolf` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `MatchID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Score` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=912 ; -- -- Dumping data for table `SectionXGolf` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXHockey` -- CREATE TABLE `SectionXHockey` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Goals` int(11) NOT NULL default '0', `Assists` int(11) NOT NULL default '0', `Saves` int(11) NOT NULL default '0', `GoalsAllowed` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7967 ; -- -- Dumping data for table `SectionXHockey` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXLacrosse` -- CREATE TABLE `SectionXLacrosse` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Goals` int(11) NOT NULL default '0', `Assists` int(11) NOT NULL default '0', `Saves` int(11) NOT NULL default '0', `GoalsAllowed` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2822 ; -- -- Dumping data for table `SectionXLacrosse` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPhoto` -- CREATE TABLE `SectionXPhoto` ( `ID` int(11) NOT NULL auto_increment, `OriginalName` varchar(25) NOT NULL default '', `SiteName` varchar(10) NOT NULL default '', `Caption` varchar(200) NOT NULL default '', `PhotoBy` varchar(25) NOT NULL default '', `GameID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `SectionXPhoto` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPlayerPhoto` -- CREATE TABLE `SectionXPlayerPhoto` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `PhotoID` int(11) NOT NULL default '0', `GameID` int(11) NOT NULL default '0', `SportID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `SectionXPlayerPhoto` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPlayerReport` -- CREATE TABLE `SectionXPlayerReport` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `ReportID` int(11) NOT NULL default '0', `SportID` int(11) NOT NULL default '0', `Status` varchar(20) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `SectionXPlayerReport` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPlayerSport` -- CREATE TABLE `SectionXPlayerSport` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `SportID` int(11) NOT NULL default '0', `SchoolSportID` int(11) NOT NULL default '0', `Number` int(11) NOT NULL default '0', `PositionID` int(11) NOT NULL default '0', `Active` int(11) NOT NULL default '0', `AllNorthern` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `SectionXPlayerSport` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPlayers` -- CREATE TABLE `SectionXPlayers` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(100) default NULL, `Nickname` varchar(50) NOT NULL default '', `Height` varchar(25) default NULL, `Weight` varchar(25) default NULL, `Year` varchar(10) default NULL, `Photo` varchar(100) default 'spacer.gif', `JV` int(11) NOT NULL default '0', `Active` int(11) NOT NULL default '0', `Section` int(11) NOT NULL default '0', `League` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6275 ; -- -- Dumping data for table `SectionXPlayers` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXPoints` -- CREATE TABLE `SectionXPoints` ( `ID` int(11) NOT NULL auto_increment, `Team1` char(2) NOT NULL default '', `Team2` char(2) NOT NULL default '', `Points` int(2) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ; -- -- Dumping data for table `SectionXPoints` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXReport` -- CREATE TABLE `SectionXReport` ( `ID` int(11) NOT NULL auto_increment, `Headline` varchar(200) default NULL, `Body` text, `GameID` int(11) default NULL, `Status` int(11) default '0', `AuthorID` int(11) default NULL, `SportID` int(11) default NULL, `Special` int(11) NOT NULL default '0', `UpdateDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `SubmitDate` timestamp NOT NULL default '0000-00-00 00:00:00', `PhotoCount` int(11) default '0', `Section` int(11) NOT NULL default '0', `League` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2405 ; -- -- Dumping data for table `SectionXReport` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXReportPlayer` -- CREATE TABLE `SectionXReportPlayer` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `GameID` int(11) NOT NULL default '0', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `SectionXReportPlayer` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXReportSchool` -- CREATE TABLE `SectionXReportSchool` ( `ID` int(11) NOT NULL auto_increment, `ReportID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4782 ; -- -- Dumping data for table `SectionXReportSchool` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXResults` -- CREATE TABLE `SectionXResults` ( `ID` int(11) NOT NULL auto_increment, `Home1` int(11) default NULL, `Away1` int(11) default NULL, `Home2` int(11) default NULL, `Away2` int(11) default NULL, `Home3` int(11) default NULL, `Away3` int(11) default NULL, `Home4` int(11) default NULL, `Away4` int(11) default NULL, `Home5` int(11) default '0', `Away5` int(11) default '0', `Home6` int(11) default NULL, `Away6` int(11) default NULL, `Home7` int(11) default NULL, `Away7` int(11) default NULL, `Home8` int(11) default NULL, `Away8` int(11) default NULL, `Home9` int(11) default NULL, `Away9` int(11) default NULL, `Home10` int(11) default NULL, `Away10` int(11) default NULL, `HomeTotal` int(11) default NULL, `AwayTotal` int(11) default NULL, `GameID` int(11) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2527 ; -- -- Dumping data for table `SectionXResults` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSchedule` -- CREATE TABLE `SectionXSchedule` ( `ID` int(11) NOT NULL auto_increment, `HomeID` int(11) default NULL, `AwayID` int(11) default NULL, `Location` varchar(100) default NULL, `DateTime` datetime default NULL, `NonLeague` varchar(5) NOT NULL default 'false', `Won` int(11) default '-1', `SportID` int(11) default NULL, `ScoreUpdate` int(11) NOT NULL default '0', `HomeUpdate` int(11) NOT NULL default '0', `AwayUpdate` int(11) NOT NULL default '0', `Section` int(11) NOT NULL default '0', `League` int(11) NOT NULL default '0', `MeetID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2922 ; -- -- Dumping data for table `SectionXSchedule` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXScheduleSchool` -- CREATE TABLE `SectionXScheduleSchool` ( `ID` int(11) NOT NULL auto_increment, `SchoolID` int(11) NOT NULL default '0', `ScheduleID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `SectionXScheduleSchool` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSchool` -- CREATE TABLE `SectionXSchool` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(50) default NULL, `Team` varchar(50) default NULL, `Logo` varchar(50) default 'spacer.gif', `Address` varchar(100) default NULL, `Division` int(11) default NULL, `Class` varchar(5) default NULL, `SportID` int(11) default NULL, `SchoolID` int(11) NOT NULL default '0', `Photo` varchar(100) NOT NULL default 'spacer.gif', `StateRank` int(11) NOT NULL default '0', `XPoints` int(11) NOT NULL default '0', `WinPercent` decimal(4,3) NOT NULL default '0.000', `Section` varchar(5) NOT NULL default '10', `Record` varchar(15) NOT NULL default '0-0', `League` int(4) default '0', `AltName` varchar(50) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=552 ; -- -- Dumping data for table `SectionXSchool` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSoccer` -- CREATE TABLE `SectionXSoccer` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Goals` int(11) NOT NULL default '0', `Assists` int(11) NOT NULL default '0', `Saves` int(11) NOT NULL default '0', `GoalsAllowed` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30391 ; -- -- Dumping data for table `SectionXSoccer` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSoftball` -- CREATE TABLE `SectionXSoftball` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `AB` int(11) NOT NULL default '0', `Hits` int(11) NOT NULL default '0', `2B` int(11) NOT NULL default '0', `3B` int(11) NOT NULL default '0', `HR` int(11) NOT NULL default '0', `RBI` int(11) NOT NULL default '0', `Runs` int(11) NOT NULL default '0', `BB` int(11) NOT NULL default '0', `SB` int(11) NOT NULL default '0', `SO` int(11) NOT NULL default '0', `Played` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5648 ; -- -- Dumping data for table `SectionXSoftball` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSoftballPitcher` -- CREATE TABLE `SectionXSoftballPitcher` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `IP` decimal(5,1) NOT NULL default '0.0', `W` int(11) NOT NULL default '0', `L` int(11) NOT NULL default '0', `H` int(11) NOT NULL default '0', `R` int(11) NOT NULL default '0', `ER` int(11) NOT NULL default '0', `SV` int(11) NOT NULL default '0', `K` int(11) NOT NULL default '0', `BB` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1045 ; -- -- Dumping data for table `SectionXSoftballPitcher` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSports` -- CREATE TABLE `SectionXSports` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(50) default NULL, `Season` int(11) NOT NULL default '0', `AltName` varchar(50) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ; -- -- Dumping data for table `SectionXSports` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSwimming` -- CREATE TABLE `SectionXSwimming` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `EventID` int(11) NOT NULL default '0', `Minutes` int(11) NOT NULL default '0', `Seconds` int(11) NOT NULL default '0', `MSeconds` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2735 ; -- -- Dumping data for table `SectionXSwimming` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXSwimmingEvents` -- CREATE TABLE `SectionXSwimmingEvents` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `SectionXSwimmingEvents` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXTPOW` -- CREATE TABLE `SectionXTPOW` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `Photo` varchar(100) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ; -- -- Dumping data for table `SectionXTPOW` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXUserPref` -- CREATE TABLE `SectionXUserPref` ( `ID` int(11) NOT NULL auto_increment, `UserID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `SportID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=395 ; -- -- Dumping data for table `SectionXUserPref` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXUsers` -- CREATE TABLE `SectionXUsers` ( `ID` int(11) NOT NULL auto_increment, `FullName` varchar(50) NOT NULL default '', `Username` varchar(25) NOT NULL default '', `Password` varchar(25) NOT NULL default '', `Email` varchar(50) NOT NULL default '', `Description` text NOT NULL, `Photo` varchar(100) NOT NULL default 'spacer.gif', `Role` varchar(10) NOT NULL default '', `Author` char(1) NOT NULL default '', `SchoolID` int(11) NOT NULL default '0', `SignUpDate` datetime NOT NULL default '0000-00-00 00:00:00', `Section` int(11) NOT NULL default '0', `League` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=162 ; -- -- Dumping data for table `SectionXUsers` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXVolleyball` -- CREATE TABLE `SectionXVolleyball` ( `ID` int(11) NOT NULL auto_increment, `GameID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `PlayerID` int(11) NOT NULL default '0', `Aces` int(11) NOT NULL default '0', `Kills` int(11) NOT NULL default '0', `Blocks` int(11) NOT NULL default '0', `Assists` int(11) NOT NULL default '0', `PtsServed` int(11) NOT NULL default '0', `Sets` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3127 ; -- -- Dumping data for table `SectionXVolleyball` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXWrestling` -- CREATE TABLE `SectionXWrestling` ( `ID` int(11) NOT NULL auto_increment, `PlayerID` int(11) NOT NULL default '0', `SchoolID` int(11) NOT NULL default '0', `MeetID` int(11) NOT NULL default '0', `WeightID` int(11) NOT NULL default '0', `TypeID` int(11) NOT NULL default '0', `OpponentID` int(11) NOT NULL default '0', `Win` int(11) NOT NULL default '0', `Loss` int(11) NOT NULL default '0', `TimeScore` varchar(20) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=393 ; -- -- Dumping data for table `SectionXWrestling` -- -- -------------------------------------------------------- -- -- Table structure for table `SectionXWrestlingType` -- CREATE TABLE `SectionXWrestlingType` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `SectionXWrestlingType` --