SHARE
TWEET

Untitled

deanomax Aug 19th, 2019 104 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top