CREATE TABLE `dotastats` (
`id` INT NOT NULL ,
`name` VARCHAR( 15 ) NOT NULL ,
`realmid` INT NOT NULL ,
`kills` INT NOT NULL ,
`deaths` INT NOT NULL ,
`creepkills` INT NOT NULL ,
`creepdenies` INT NOT NULL ,
`assists` INT NOT NULL ,
`neutralkills` INT NOT NULL ,
`towerkills` INT NOT NULL ,
`raxkills` INT NOT NULL ,
`courierills` INT NOT NULL ,
`games` INT NOT NULL ,
`wins` INT NOT NULL ,
`losses` INT NOT NULL ,
`created_at` INT NOT NULL ,
`updated_at` INT NOT NULL ,
PRIMARY KEY ( `id` )
);
ALTER TABLE `dotastats` ADD INDEX ( `name` );
ALTER TABLE `dotastats` ADD INDEX ( `realmid` );