· 5 years ago · Nov 25, 2020, 05:18 AM
1-- Adminer 4.7.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `users`;
11CREATE TABLE `users` (
12 `id` int(11) NOT NULL AUTO_INCREMENT,
13 `invited_by` int(11) DEFAULT NULL,
14 `email` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
15 `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
16 `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
17 `registered_on` datetime NOT NULL,
18 `subscription_end` datetime DEFAULT NULL,
19 `hwid` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
20 `register_ip` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
21 `last_ip` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
22 `local_country` tinyint(1) NOT NULL,
23 `banned` tinyint(1) NOT NULL DEFAULT '0',
24 `recovery_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
25 `activation_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
26 `title` set('Admin','Beta user','User','Moderator') COLLATE utf8mb4_unicode_ci DEFAULT 'User',
27 `is_requested` int(11) DEFAULT NULL,
28 `dc_invite` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29 `dc_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
30 `dc_username` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
31 `ow_bans` int(11) DEFAULT '0',
32 `custom_ow_bans` int(11) DEFAULT '0',
33 `vac_bans` int(11) DEFAULT '0',
34 `last_vac` datetime DEFAULT NULL,
35 `avatar` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
36 `signature` text COLLATE utf8mb4_unicode_ci,
37 `cheat_status` int(11) NOT NULL DEFAULT '0',
38 `ban_reason` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
39 `gr_points` int(11) NOT NULL DEFAULT '0',
40 `last_invite` datetime DEFAULT NULL,
41 `inv_ban` tinyint(1) NOT NULL DEFAULT '0',
42 `inv_ban_reason` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
43 `hourboost_slots` tinyint(3) unsigned NOT NULL DEFAULT '0',
44 `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
45 `2fa` tinyint(1) unsigned NOT NULL DEFAULT '0',
46 PRIMARY KEY (`id`),
47 UNIQUE KEY `recovery_key` (`recovery_key`),
48 UNIQUE KEY `activation_key` (`activation_key`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
50