Setup
DATA.SQL
CREATE TABLE `tm1_tournaments` (
`identifier` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
`modality` INT(11) NOT NULL,
`maxTeams` INT(11) NOT NULL,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`wins` INT(11) NULL DEFAULT '0',
`kills` INT(11) NULL DEFAULT '0',
`deaths` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`identifier`, `modality`, `maxTeams`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;Last updated