· 5 years ago · Feb 27, 2020, 03:40 PM
1CREATE TABLE IF NOT EXISTS `users` (\
2 `user_id` int(11) NOT NULL AUTO_INCREMENT, \
3 `user_steamid` varchar(63) NOT NULL, \
4 `user_kills` int(11) NOT NULL DEFAULT 0, \
5 `user_deaths` int(11) NOT NULL DEFAULT 0, \
6 `user_money` int(11) NOT NULL DEFAULT 0, \
7 PRIMARY KEY (`user_id`), \
8 KEY `user_steamid` (`user_steamid`(16))\
9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;