CREATE TABLE `dle_users` (
    `email` VARCHAR(50) NOT NULL DEFAULT '',
    `password` VARCHAR(255) NOT NULL DEFAULT '',
    `name` VARCHAR(40) NOT NULL DEFAULT '',
    `referer` VARCHAR(255) NULL DEFAULT NULL,
    `user_id` INT(11) NOT NULL AUTO_INCREMENT,
    `news_num` MEDIUMINT(8) NOT NULL DEFAULT '0',
    `comm_num` MEDIUMINT(8) NOT NULL DEFAULT '0',
    `user_group` SMALLINT(5) NOT NULL DEFAULT '4',
    `lastdate` VARCHAR(20) NOT NULL DEFAULT '',
    `reg_date` VARCHAR(20) NOT NULL DEFAULT '',
    `banned` VARCHAR(5) NOT NULL DEFAULT '',
    `allow_mail` TINYINT(1) NOT NULL DEFAULT '1',
    `info` TEXT NOT NULL,
    `signature` TEXT NOT NULL,
    `foto` VARCHAR(255) NOT NULL DEFAULT '',
    `fullname` VARCHAR(100) NOT NULL DEFAULT '',
    `land` VARCHAR(100) NOT NULL DEFAULT '',
    `favorites` TEXT NOT NULL,
    `pm_all` SMALLINT(5) NOT NULL DEFAULT '0',
    `pm_unread` SMALLINT(5) NOT NULL DEFAULT '0',
    `time_limit` VARCHAR(20) NOT NULL DEFAULT '',
    `xfields` TEXT NOT NULL,
    `allowed_ip` VARCHAR(255) NOT NULL DEFAULT '',
    `hash` VARCHAR(32) NOT NULL DEFAULT '',
    `logged_ip` VARCHAR(40) NOT NULL DEFAULT '',
    `restricted` TINYINT(1) NOT NULL DEFAULT '0',
    `restricted_days` SMALLINT(4) NOT NULL DEFAULT '0',
    `restricted_date` VARCHAR(15) NOT NULL DEFAULT '',
    `timezone` VARCHAR(100) NOT NULL DEFAULT '',
    `news_subscribe` TINYINT(1) NOT NULL DEFAULT '0',
    `comments_reply_subscribe` TINYINT(1) NOT NULL DEFAULT '0',
    `twofactor_auth` TINYINT(1) NOT NULL DEFAULT '0',
    `money` DOUBLE NOT NULL DEFAULT '0',
    `chests` DOUBLE NOT NULL DEFAULT '0',
    `bonus_count` INT(11) NOT NULL DEFAULT '0',
    `ban_count` DOUBLE NOT NULL DEFAULT '0',
    `hd_skin` TINYINT(1) NOT NULL DEFAULT '0',
    `vk_uid` TEXT NOT NULL COLLATE 'utf8_general_ci',
    `uuid` CHAR(36) NULL DEFAULT NULL,
    `accessToken` CHAR(32) NULL DEFAULT NULL,
    `serverID` VARCHAR(41) NULL DEFAULT NULL,
    PRIMARY KEY (`user_id`),
    UNIQUE INDEX `name` (`name`),
    UNIQUE INDEX `email` (`email`),
    UNIQUE INDEX `uuid` (`uuid`)
)