· 6 years ago · May 10, 2019, 08:06 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.62-log - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table hw_auth.account
15CREATE TABLE IF NOT EXISTS `account` (
16 `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
17 `username` varchar(32) NOT NULL DEFAULT '',
18 `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
19 `sessionkey` varchar(80) NOT NULL DEFAULT '',
20 `v` varchar(64) NOT NULL DEFAULT '',
21 `s` varchar(64) NOT NULL DEFAULT '',
22 `email` varchar(254) NOT NULL DEFAULT '',
23 `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
24 `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
25 `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
26 `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
27 `lock_country` varchar(2) NOT NULL DEFAULT '00',
28 `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
29 `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
30 `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2',
31 `mutetime` bigint(20) NOT NULL DEFAULT '0',
32 `mutereason` varchar(255) NOT NULL DEFAULT '',
33 `muteby` varchar(50) NOT NULL DEFAULT '',
34 `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
35 `os` int(11) NOT NULL DEFAULT '0',
36 `recruiter` int(10) unsigned NOT NULL DEFAULT '0',
37 `forcePasswordChange` tinyint(4) unsigned DEFAULT '0',
38 `arenachests` int(1) unsigned NOT NULL DEFAULT '45' COMMENT 'Arena Chests remaining of the day',
39 PRIMARY KEY (`id`),
40 UNIQUE KEY `idx_username` (`username`)
41) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='Account System';
42
43-- Dumping data for table hw_auth.account: ~13 rows (approximately)
44/*!40000 ALTER TABLE `account` DISABLE KEYS */;
45INSERT INTO `account` (`id`, `username`, `sha_pass_hash`, `sessionkey`, `v`, `s`, `email`, `joindate`, `last_ip`, `failed_logins`, `locked`, `lock_country`, `last_login`, `online`, `expansion`, `mutetime`, `mutereason`, `muteby`, `locale`, `os`, `recruiter`, `forcePasswordChange`, `arenachests`) VALUES
46 (20, 'Xaps', '371297b8fd27217a02b7fa87b6ed700e29164982', '', '', '', 'xaps@hotmail.com', '2019-04-23 00:00:00', '46.9.77.215', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
47 (21, 'test0x', '8a8af0f45f47245089d794ed70db158adb5f180b', '', '', '', 'test@gmail.com', '2019-04-24 00:00:00', '77.78.34.21', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
48 (22, 'alistar', 'a091b998fca090ec4a9a938550386502a4fbcf3a', '', '', '', 'lordlo0kk@gmail.com', '2019-04-25 00:00:00', '77.78.34.21', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
49 (23, 'Testuer', '5607ebec00c514e80bf163ec6d424684f1bdfe18', '', '', '', 'Testuer@live.no', '2019-04-25 00:00:00', '46.9.77.215', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
50 (24, 'JadaDev', '4fc25c9abfaa275b99bef7b027b9c710fdde9957', '', '', '', 'MohamedMned98@gmail.com', '2019-04-26 00:00:00', '41.227.34.214', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
51 (25, 'Kukata', 'ef8a922c57422ea66b4dec0219e89fcf2be16a82', '', '', '', 'kukatamonsta@gmail.com', '2019-04-26 00:00:00', '79.132.22.56', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
52 (26, 'Solvias3', '88b77a40d7cdd23a0c2025d0a5273a3f2188063e', '', '', '', 'patrick.michnea@gmail.com', '2019-04-26 00:00:00', '178.165.130.12', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
53 (27, 'Toreador', 'a027a00ad531e3e9e6ffa7c6f062874e87845e00', '', '', '', 'cornel_alex12@yahoo.com', '2019-04-26 00:00:00', '90.25.155.149', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
54 (28, 'dewbie', '617072ebc344f581d7d8e7c039d397e3d3475d2e', '', '', '', 'thegamingdewb@gmail.com', '2019-04-28 00:00:00', '98.185.241.249', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
55 (29, 'hordeks', 'd31688b0ccf00b688ed840c8e7b3d6d8922c1a41', '', '', '', 'josifek.sudik@seznam.cz', '2019-04-29 00:00:00', '213.29.3.1', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
56 (30, 'luuk10', '237eaca1d1209276e70dcfb05948ebefca66faaf', '', '', '', 'fak_fak00@hotmail.com', '2019-05-03 00:00:00', '168.194.160.199', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
57 (31, 'vhiper', '247ab6f6162545ca4ce5e0b1859381be2aac3929', '', '', '', 'vhipercode@gmail.com', '2019-05-05 00:00:00', '177.200.81.177', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45),
58 (32, 'donepdo', 'f593cee46e1faa300b6e8a8918623327f40f1145', '', '', '', 'dmiozzo3@gmail.com', '2019-05-07 00:00:00', '95.248.37.253', 0, 0, '00', '0000-00-00 00:00:00', 0, 2, 0, '', '', 0, 0, 0, 0, 45);
59/*!40000 ALTER TABLE `account` ENABLE KEYS */;
60
61/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
62/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
63/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;