CREATE TABLE `stats_player_discord` (
  `id` bigint(20) NOT NULL,
  `steamid` varchar(50) NOT NULL,
  `discordid` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `stats_player_discord`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `steamid` (`steamid`),
  ADD UNIQUE KEY `discordid` (`discordid`);


ALTER TABLE `stats_player_kill` ADD `online` TINYINT(1) NOT NULL DEFAULT '0';


ALTER TABLE `stats_player_discord`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;