· 9 years ago · May 08, 2017, 02:26 AM
1CREATE TABLE IF NOT EXISTS `ajaxim_users` (
2 `username` varchar(32) DEFAULT NULL,
3 `password` varchar(32) DEFAULT NULL,
4 `email` text,
5 `is_online` int(11) DEFAULT '0',
6 `last_ping` text,
7 `last_ip` varchar(15) DEFAULT NULL,
8 `banned` tinyint(1) DEFAULT '0',
9 `admin` tinyint(1) DEFAULT '0',
10 `buddyicon` varchar(4) NOT NULL DEFAULT 'none',
11 `profile` text,
12 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
13 UNIQUE KEY `id` (`id`),
14 UNIQUE KEY `username` (`username`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
16
17--
18-- Dumping data for table `ajaxim_users`
19--
20
21INSERT INTO `ajaxim_users` (`username`, `password`, `email`, `is_online`, `last_ping`, `last_ip`, `banned`, `admin`, `buddyicon`, `profile`, `id`) VALUES
22('bbyte', 'c096629f2f8eaa7c3b428918893b39f8', 'enjoi.444@gmail.com', 0, '1266281425', '127.0.0.1', 0, 1, 'jpg', NULL, 1),
23('testinput@gmail.com', 'c096629f2f8eaa7c3b428918893b39f8', 'testinput@gmail.com', 0, NULL, NULL, 0, 0, 'none', NULL, 3),
24('John.Wood', 'c096629f2f8eaa7c3b428918893b39f8', 'johnwood@gmail.com', 0, '1266282906', '127.0.0.1', 0, 0, 'none', NULL, 4),
25('Kelly.Gillaer', '4442eaef72feac05644a2a01363c45e2', 'kelly.gillaer@random.com', 0, '1266840567', '127.0.0.1', 0, 0, 'none', NULL, 5),
26('bottie', 'c096629f2f8eaa7c3b428918893b39f8', 'bottie@bot.be', 1, NULL, NULL, 0, 1, 'none', 'bottie', 6),
27('John.Walker', 'c096629f2f8eaa7c3b428918893b39f8', 'John.Walker@gmail.com', 0, '1266282628', '127.0.0.1', 0, 0, 'none', NULL, 7),
28('Test.Or', 'c096629f2f8eaa7c3b428918893b39f8', 'testor@gmail.com', 0, '1266282740', '127.0.0.1', 0, 0, 'none', NULL, 8),
29('ijpojop.jiopjop', 'd954b2df523ee31648ea5851c6fa3873', 'jopjpoj@gmail.com', 0, NULL, NULL, 0, 0, 'none', NULL, 9),
30('jos.los', 'c096629f2f8eaa7c3b428918893b39f8', 'joslos@gmail.com', 0, '1266841767', '127.0.0.1', 0, 0, 'none', NULL, 10);