sqltables.txt

CREATE TABLE `users` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `email` varchar(255) DEFAULT NULL,
 `password` varchar(255) DEFAULT 'pass',
 `token` varchar(255) DEFAULT NULL,
 `role` varchar(255) DEFAULT 'SCOUTER',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1


CREATE TABLE `scouting` (
 `teamNumber` int(6) DEFAULT NULL,
 `author` varchar(100) DEFAULT NULL,
 `matchNumber` int(6) DEFAULT NULL,
 `powerCellsHighOne` int(6) DEFAULT NULL,
 `powerCellsLowOne` int(6) DEFAULT NULL,
 `radio1` tinyint(1) DEFAULT '0',
 `powerCellsHighTwo` int(6) DEFAULT NULL,
 `powerCellsLowTwo` int(6) DEFAULT NULL,
 `radio2` tinyint(1) NOT NULL DEFAULT '0',
 `powerCellsHighThree` int(6) DEFAULT NULL,
 `powerCellsLowThree` int(6) DEFAULT NULL,
 `radio3` tinyint(1) NOT NULL DEFAULT '0',
 `radio4` tinyint(1) NOT NULL DEFAULT '0',
 `radio5` tinyint(1) NOT NULL DEFAULT '0',
 `finalRP` int(6) DEFAULT NULL,
 `radio6` tinyint(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `pitscouting` (
 `teamNumber` int(6) NOT NULL,
 `radio1` tinyint(1) NOT NULL,
 `radio2` tinyint(1) NOT NULL,
 `driveTeamExperience` int(6) NOT NULL,
 `radio3` tinyint(1) NOT NULL,
 `radio4` tinyint(1) NOT NULL,
 `radio5` tinyint(1) NOT NULL,
 `radio6` tinyint(1) NOT NULL,
 `autonomousAbilities` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1