saxno

gjh
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`steamid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`steamid64` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`trade_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`accessToken` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`money` double(8,2) NOT NULL,
`votes` int(11) NOT NULL,
`is_admin` tinyint(1) NOT NULL,
`is_moderator` tinyint(1) NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`lang` text COLLATE utf8_unicode_ci NOT NULL,
`ban` int(11) NOT NULL,
`banchat` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_steamid_unique` (`steamid`),
UNIQUE KEY `users_steamid64_unique` (`steamid64`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4095 ;