CREATE DATABASE IF NOT EXISTS `koth`;
USE `koth`;

CREATE TABLE IF NOT EXISTS `users` (
  `steamID` varchar(50) NOT NULL,
  `discordID` varchar(50) NOT NULL,
  `cash` varchar(50) NOT NULL DEFAULT '0',
  `level` varchar(50) NOT NULL DEFAULT '0',
  `xp` varchar(50) NOT NULL DEFAULT '0',
  `lastLoggedIn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deaths` varchar(50) NOT NULL DEFAULT '0',
  `kills` varchar(50) NOT NULL DEFAULT '0',
  `streak` varchar(50) NOT NULL DEFAULT '0',
  `vehicles` mediumtext,
  `weapons` mediumtext,
  PRIMARY KEY (`steamID`),
  UNIQUE KEY `discordID` (`discordID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1