deanomax

Untitled

Aug 19th, 2019
111
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `stats_player_discord` (
  2. `id` bigint(20) NOT NULL,
  3. `steamid` varchar(50) NOT NULL,
  4. `discordid` varchar(50) NOT NULL
  5. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  6.  
  7.  
  8. ALTER TABLE `stats_player_discord`
  9. ADD PRIMARY KEY (`id`),
  10. ADD UNIQUE KEY `steamid` (`steamid`),
  11. ADD UNIQUE KEY `discordid` (`discordid`);
  12.  
  13.  
  14. ALTER TABLE `stats_player_kill` ADD `online` TINYINT(1) NOT NULL DEFAULT '0';
  15.  
  16.  
  17. ALTER TABLE `stats_player_discord`
  18. MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
RAW Paste Data