//
 //  SQL tables for Bloodbowl Ladder
 //
 //

 $sql = 'CREATE TABLE `Skills` ('
        . ' `Name` VARCHAR(20) NOT NULL, '
        . ' `Type` VARCHAR(10) NOT NULL,'
        . ' UNIQUE (`Name`)'
        . ' )';


        CREATE TABLE `Members` (
		`Position` VARCHAR( 15 ) NOT NULL ,
		`Team` VARCHAR( 15 ) NOT NULL ,
		`Quantity` TINYINT( 1 ) NOT NULL ,
		`Ma` TINYINT( 1 ) NOT NULL ,
		`St` TINYINT( 1 ) NOT NULL ,
		`Ag` TINYINT( 1 ) NOT NULL ,
		`Av` TINYINT( 1 ) NOT NULL ,
		`Skills` VARCHAR( 1 ) NOT NULL ,
		`Cost` INT( 3 ) NOT NULL ,
		`Getgen` ENUM( 'n', 'y' ) NOT NULL ,
		`Getstr` ENUM( 'n', 'y' ) NOT NULL ,
		`Getpas` ENUM( 'n', 'y' ) NOT NULL ,
		`Getagi` ENUM( 'n', 'y' ) NOT NULL ,
		`Getmut` ENUM( 'n', 'y' ) NOT NULL
);

CREATE TABLE `Players` (
`Teamname` VARCHAR( 30 ) NOT NULL ,
`Number` SMALLINT( 2 ) NOT NULL ,
`Name` VARCHAR( 30 ) NOT NULL ,
`Position` VARCHAR( 20 ) NOT NULL ,
`MA` SMALLINT( 2 ) NOT NULL ,
`ST` SMALLINT( 2 ) NOT NULL ,
`AG` SMALLINT( 2 ) NOT NULL ,
`AV` SMALLINT( 2 ) NOT NULL ,
`Startingskills` VARCHAR( 95 ) NOT NULL ,
`Newskills` VARCHAR( 95 ) NOT NULL ,
`Injuries` VARCHAR( 3 ) NOT NULL ,
`COMP` SMALLINT( 2 ) NOT NULL ,
`TD` SMALLINT( 2 ) NOT NULL ,
`INT` SMALLINT( 2 ) NOT NULL ,
`CAS` SMALLINT( 2 ) NOT NULL ,
`MVP` SMALLINT( 2 ) NOT NULL ,
`SPP` SMALLINT( 3 ) NOT NULL ,
`Cost` SMALLINT( 3 ) NOT NULL ,
`Deceased` ENUM( 'y', 'n' ) NOT NULL
);