· 10 years ago · Apr 07, 2016, 10:15 AM
1--
2-- Tabel structuur voor tabel `authme`
3--
4
5CREATE TABLE IF NOT EXISTS `authme` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `username` varchar(255) NOT NULL,
8 `password` varchar(255) NOT NULL,
9 `ip` varchar(40) NOT NULL DEFAULT '127.0.0.1',
10 `lastlogin` bigint(20) NOT NULL DEFAULT '1446655047082',
11 `x` double NOT NULL DEFAULT '0',
12 `y` double NOT NULL DEFAULT '0',
13 `z` double NOT NULL DEFAULT '0',
14 `world` varchar(255) NOT NULL DEFAULT 'world',
15 `email` varchar(255) DEFAULT 'your@email.com',
16 `isLogged` smallint(6) NOT NULL DEFAULT '0',
17 `realname` varchar(255) NOT NULL DEFAULT 'Player',
18 PRIMARY KEY (`id`),
19 UNIQUE KEY `username` (`username`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=437587 ;
21
22--
23-- Gegevens worden uitgevoerd voor tabel `authme`
24--
25
26INSERT INTO `authme` (`id`, `username`, `password`, `ip`, `lastlogin`, `x`, `y`, `z`, `world`, `email`, `isLogged`, `realname`) VALUES
27(436790, 'cookie_gaming1', 'creeper11', '68.8.58.15', 1459984278346, 0, 0, 0, 'world', 'your@email.com', 0, 'Player'),
28(14082, 'spectacation', 'paulmocha6969', '73.151.235.136', 1455574624503, 0, 0, 0, 'world', 'your@email.com', 0, 'Spectacation'),
29(241515, 'eobrgnciwehwcgrc', 'Jayhawk2002', '74.222.213.229', 1454700935051, 0, 0, 0, 'world', 'your@email.com', 0, 'Player'),
30(14081, 'knightmareplayz1', 'nurseua1', '68.228.220.121', 1447037500618, 0, 0, 0, 'world', 'your@email.com', 0, 'KnightMarePlayz1'),
31(14080, 'vitaly_01', 'fgh457', '190.214.160.112', 1447036604487, 0, 0, 0, 'world', 'your@email.com', 0, 'vitaly_01'),
32(9, 'rcl_', 'rafaCURY2509', '189.33.175.41', 1459974723337, 0, 0, 0, 'world', 'your@email.com', 0, 'RCL_'),
33(10, 'lelefundio', 'fLyingpOtato', '179.183.3.61', 1459990740913, 0, 0, 0, 'world', 'your@email.com', 0, 'Lelefundio'),
34(14078, 'faris68', 'daniswara', '36.88.144.35', 1459732280687, 0, 0, 0, 'world', 'your@email.com', 0, 'Faris68'),
35(12, 'ad_kingzz', 'vince1556789', '180.190.101.34', 1459944680966, 0, 0, 0, 'world', 'your@email.com', 0, 'AD_Kingzz'),
36(13, 'morgwllhd', 'umututku', '78.185.41.40', 1449248773569, 0, 0, 0, 'world', 'your@email.com', 0, 'MorgwllHD'),
37(78, 'milan546', '1260af9a8f0a10a3a4a22f3f9e11a694', '78.30.159.224', 1453216389384, 0, 0, 0, 'world', 'your@email.com', 0, 'Player'),
38(14, 'mr_torti66', '123333', '188.231.144.132', 1446886609940, 0, 0, 0, 'world', 'your@email.com', 0, 'Player'),