· 10 years ago · Jan 28, 2016, 04:45 PM
1DROP TABLE IF EXISTS `accounts`;
2CREATE TABLE `accounts` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(13) NOT NULL DEFAULT '',
5 `password` varchar(128) NOT NULL DEFAULT '',
6 `salt` varchar(32) DEFAULT NULL,
7 `2ndpassword` varchar(134) DEFAULT NULL,
8 `salt2` varchar(32) DEFAULT NULL,
9 `loggedin` tinyint(1) unsigned NOT NULL DEFAULT '0',
10 `lastlogin` timestamp NULL DEFAULT NULL,
11 `createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 `birthday` date NOT NULL DEFAULT '0000-00-00',
13 `banned` tinyint(1) NOT NULL DEFAULT '0',
14 `banreason` text,
15 `gm` tinyint(1) NOT NULL DEFAULT '0',
16 `email` tinytext,
17 `macs` tinytext,
18 `tempban` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
19 `greason` tinyint(4) unsigned DEFAULT NULL,
20 `ACash` int(11) NOT NULL DEFAULT '0',
21 `mPoints` int(11) NOT NULL DEFAULT '0',
22 `gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
23 `SessionIP` varchar(64) DEFAULT NULL,
24 `points` int(11) NOT NULL DEFAULT '0',
25 `vpoints` int(11) NOT NULL DEFAULT '0',
26 `dpoints` int(11) NOT NULL DEFAULT '0',
27 `epoints` int(11) NOT NULL DEFAULT '0',
28 `lastWorld` tinyint(3) DEFAULT NULL,
29 `monthvotes` int(11) NOT NULL DEFAULT '0',
30 `totalvotes` int(11) NOT NULL DEFAULT '0',
31 `lastvote` int(11) NOT NULL DEFAULT '0',
32 `lastvote2` int(11) NOT NULL DEFAULT '0',
33 `lastlogon` timestamp NULL DEFAULT NULL,
34 `lastvoteip` varchar(64) DEFAULT NULL,
35 `webadmin` int(1) DEFAULT '0',
36 `rebirths` int(11) NOT NULL DEFAULT '0',
37 `ip` text,
38 `mainchar` int(6) NOT NULL DEFAULT '0',
39 `nxCredit` varchar(45) NOT NULL DEFAULT '0',
40 `sitelogged` text,
41 `nick` varchar(20) DEFAULT NULL,
42 `mute` int(1) DEFAULT '0',
43 PRIMARY KEY (`id`),
44 UNIQUE KEY `name` (`name`),
45 KEY `ranking1` (`id`,`banned`,`gm`),
46 KEY `id` (`id`)
47) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
48
49--
50-- Dumping data for table `accounts`
51--
52
53/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
54INSERT INTO `accounts` (`id`,`name`,`password`,`salt`,`2ndpassword`,`salt2`,`loggedin`,`lastlogin`,`createdat`,`birthday`,`banned`,`banreason`,`gm`,`email`,`macs`,`tempban`,`greason`,`ACash`,`mPoints`,`gender`,`SessionIP`,`points`,`vpoints`,`dpoints`,`epoints`,`lastWorld`,`monthvotes`,`totalvotes`,`lastvote`,`lastvote2`,`lastlogon`,`lastvoteip`,`webadmin`,`rebirths`,`ip`,`mainchar`,`nxCredit`,`sitelogged`,`nick`,`mute`) VALUES
55 (229,'Admin','admin',NULL,'8A21FS48b2b18d3cfe150a85cecbec68776f50b8ed7aa73021f9d08fa6c14ea3dfc1116c4bf54933d365d635bfdc201e8adb68034cdfe5c41eb58f9236eb3f1c537a6a','22f3394d826d9f3910bc2c005c8d75b7',0,'2015-12-23 12:15:23','2015-03-16 18:34:34','0000-00-00',0,NULL,6,NULL,'1C-6F-65-C7-4C-F8','0000-00-00 00:00:00',NULL,3000,100000,0,'/192.168.2.90',0,1,0,0,NULL,0,0,0,0,'2015-12-23 12:04:54',NULL,1,0,'::1',0,'1455088','1440023302',NULL,0),
56 (230,'Admin2','blublub',NULL,'B3YH917a270a425e2811cef7448bb3dd1e0ad598bc9665f02a685d16b7de18107f4b6049cbc4cc6bc1202a8e6b84f2dd452d4831c0a6271484d1cfefe368a9343ba320','b68df6232dc679cb09d8be8f2f3ad6fc',0,'2015-05-01 02:13:07','2015-03-19 21:28:36','0000-00-00',0,NULL,0,NULL,'00-1D-60-9D-49-02','0000-00-00 00:00:00',NULL,0,111900,0,'/192.168.2.27',0,0,0,0,NULL,0,0,0,0,'2015-05-01 01:40:26',NULL,0,0,NULL,0,'8831',NULL,NULL,0),
57 (231,'shattered','itadakimasu',NULL,'411V81ebf20d38cf19b1b54021eb0f23cad5ae12ed082d15964cd4b2b21715e5583378a9cf21b8d891aa2fa5fd38422c7546da853257f56b455ffe95abbb26e2a0b7c3','71c2ea9d349fe1399e17d6912aba00ad',0,'2015-04-30 00:38:24','2015-04-16 14:10:43','0000-00-00',0,NULL,0,NULL,'C0-18-85-15-4F-E6','0000-00-00 00:00:00',NULL,0,0,0,'/69.118.5.174',0,0,0,0,NULL,0,0,0,0,'2015-04-30 00:10:47',NULL,0,0,NULL,0,'83',NULL,NULL,0),
58 (232,'Admin3','admin',NULL,'35X2Y57d60f9b80dca1c2ab81e8a281de39c6e354a2ab4ed21769453d773f01c617254c94bdc8956c22534f83caf923634c3b8e9184c08606c8fa0a21c9302a6f1617a','74ad7426736c287337ede242c9ef004c',0,'2015-07-21 06:24:36','2015-07-16 16:22:55','0000-00-00',0,NULL,0,NULL,'1C-6F-65-C7-4C-F8','0000-00-00 00:00:00',NULL,0,0,0,'/8.31.99.141',0,0,0,0,NULL,0,0,0,0,'2015-07-21 06:24:22',NULL,0,0,NULL,0,'0',NULL,NULL,0),
59 (234,'Admin5','3ff86dc229f36999f02726fa2b308438ff2341f3','126ea9d94b81a84f72bcb2d720a03553',NULL,NULL,0,NULL,'2015-12-10 01:47:36','1990-01-01',0,NULL,0,'mexyness@live.ca',NULL,'0000-00-00 00:00:00',NULL,0,0,0,NULL,0,0,0,0,NULL,0,0,0,0,NULL,NULL,0,0,'192.168.2.90',0,'0','1449792612',NULL,0),
60 (235,'Blake','eaf848cca4985c839a92eabb719635c2823a43a4',NULL,'V3O1M71388f5a13975d9ba1b835e05c2785150ede1c6ad6e436a4310d7ea7b3086c8e9dc03a51c7362bc386d90d8d600dbbd1166ab53c6b0b3e99ee4645dfaac737edf','8b3cb106958ab8a751b65e539a51bb57',0,'2015-12-12 10:36:39','2015-12-10 19:10:27','1990-01-01',0,NULL,0,'IheartMally@hotmail.com','00-1F-3B-56-CC-B7','0000-00-00 00:00:00',NULL,0,0,0,'/70.119.155.233',0,0,0,0,NULL,0,0,0,0,'2015-12-12 10:35:02',NULL,0,0,'129.110.241.142',0,'0',NULL,NULL,0),
61 (236,'Kumo','6c94d3b42518febd4ad747801d50a8972022f956',NULL,'23I9644867e9779f92a83eac46dc967a891d5913371a7df1248a3491fd956d51c5962a5fd62d02b9eee4ec01eb23fe2ccce011e5561d2620a2d1a47ac60db6aab80487','52cf261876bb43f566bf910d623d2baa',0,'2015-12-12 12:32:14','2015-12-10 19:14:50','1990-01-01',0,NULL,0,'kumokuu1@gmail.com','E0-91-F5-43-C0-A9','0000-00-00 00:00:00',NULL,0,18500,0,'/24.107.169.215',0,0,0,0,NULL,0,0,0,0,'2015-12-12 12:20:03',NULL,0,0,'24.107.169.215',0,'119','1449816992',NULL,0),
62 (237,'aalzenx','93da0660460587e3b6edb0d544e2e0cb07860ef4',NULL,'XX52T1eaad9e05a60997cb4cfabecf4129b72c72d79b70f0e18d98724dbebfd73a8758bf30d6b7b489b8233a474d85b873ec54caeae7e57d0f4d3c3fc1d1ec68468eea','2a78879eefe2cd974d55e0a8b61736e3',3,'2015-12-23 12:30:35','2015-12-10 20:10:12','1990-01-01',0,NULL,0,'afeng1461@bths.edu','FC-AA-14-9C-21-9A','0000-00-00 00:00:00',NULL,0,69500,0,'/68.174.67.239',0,0,0,0,NULL,0,0,0,0,'2015-12-23 11:45:31',NULL,0,0,'68.174.67.239',0,'112','1450584104',NULL,0),
63 (238,'Mally','2b8d4fcca1b3cf09b04e54bf61463b5fe7d2d310',NULL,NULL,NULL,0,NULL,'2015-12-13 14:55:42','1990-01-01',0,NULL,1,'mallissahh@gmail.com',NULL,'0000-00-00 00:00:00',NULL,0,0,0,NULL,0,0,0,0,NULL,0,0,0,0,NULL,NULL,1,0,'192.168.2.90',0,'0','1450876821',NULL,0);
64/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;