· 8 years ago · Jul 17, 2018, 06:54 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(10) NOT NULL auto_increment,
3 `username` varchar(14) NOT NULL,
4 `password` varchar(100) NOT NULL,
5 `reg_date` date NOT NULL,
6 `reg_ip` varchar(15) NOT NULL,
7 `login_ip` varchar(15) NOT NULL,
8 `user_level` int(1) NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
11
12--
13-- Data i tabell `users`
14--
15
16INSERT INTO `users` (`id`, `username`, `password`, `reg_date`, `reg_ip`, `login_ip`, `user_level`) VALUES
17(1, 'penis', '', '2009-11-15', '77.105.227.217', '', 1),
18(2, '', '', '0000-00-00', '77.105.227.217', '', 1),
19(3, '', '', '0000-00-00', '77.105.227.217', '', 1),
20(4, '', '', '0000-00-00', '77.105.227.217', '', 1),
21(5, '', '', '0000-00-00', '77.105.227.217', '', 1),
22(6, 'nigger', 'b379c613c2c1e4ad5c5e0bb36d519447f597ddd6', '0000-00-00', '77.105.227.217', '', 1),
23(7, 'Username', 'b379c613c2c1e4ad5c5e0bb36d519447f597ddd6', '0000-00-00', '77.105.227.217', '77.105.227.217', 1),
24(8, 'nejgor', 'b379c613c2c1e4ad5c5e0bb36d519447f597ddd6', '2009-11-15', '77.105.227.217', '', 1),
25(9, 'Admin', 'f45a7e61afba652a918b751cea612c2a2138b651', '2009-11-15', '77.105.227.217', '77.105.227.217', 1);