ZzNVQ0ND

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(10) NOT NULL AUTO_INCREMENT,
3  `username` varchar(50) NOT NULL,
4  `password` varchar(80) NOT NULL,
5  `email` varchar(80) NOT NULL,
6  `character_name` varchar(50) NOT NULL,
7  `verify` int(5) NOT NULL,
8  `rank` varchar(50) NOT NULL,
9  `position` int(10) NOT NULL,
10  PRIMARY KEY (`id`),
11  UNIQUE INDEX (`email`)
12) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;
13	
14CREATE TABLE IF NOT EXISTS `rank` (
15  `id` int(10) NOT NULL AUTO_INCREMENT,
16  `rank` varchar(50) NOT NULL,
17  `position` int(10) NOT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;