DROP TABLE IF EXISTS `accounts`; CREATE TABLE `accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uuid` varchar(128) NOT NULL, `password` varchar(256) NOT NULL, `name` varchar(64) NOT NULL DEFAULT 'DEFAULT', `rank` int(11) NOT NULL DEFAULT '0', `namechosen` tinyint(1) NOT NULL DEFAULT '0', `verified` tinyint(1) NOT NULL DEFAULT '1', `guild` int(11) NOT NULL, `guildRank` int(11) NOT NULL, `vaultCount` int(11) NOT NULL DEFAULT '1', `maxCharSlot` int(11) NOT NULL DEFAULT '2', `regTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `guest` tinyint(1) NOT NULL DEFAULT '0', `banned` tinyint(1) NOT NULL DEFAULT '0', `locked` varchar(512) NOT NULL, `ignored` varchar(512) NOT NULL, `guildFame` varchar(512) NOT NULL, `bonuses` varchar(512) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
`regTime` varchar(256) NOT NULL DEFAULT '0000-00-00 00:00:00',