· 7 years ago · Jan 27, 2019, 03:32 PM
1-- DROP TABLE IF EXISTS `webig`.`players`;
2
3CREATE TABLE `webig`.`players` (
4 `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
5 `cid` int(32) unsigned NOT NULL DEFAULT '0',
6 `name` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '0',
7 `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
8 `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
9 `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;