B7D7APcG

1DROP TABLE IF EXISTS `ranks`;
2CREATE TABLE `ranks` (
3  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4  `name` varchar(50) NOT NULL,
5  `prefix` text NOT NULL,
6  `suffix` text NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
9
10-- ----------------------------
11-- Records of ranks
12-- ----------------------------
13INSERT INTO `ranks` VALUES ('1', 'User', '', '');
14INSERT INTO `ranks` VALUES ('2', 'VIP', '<b>', '</b>');
15INSERT INTO `ranks` VALUES ('3', 'Trial Moderator', '<span style=\"color: #04B404;\">', '</span>');
16INSERT INTO `ranks` VALUES ('4', 'Moderator', '<b style=\"color: #04B404;\">', '</b>');
17INSERT INTO `ranks` VALUES ('5', 'Senior Moderator', '<b style=\"color: #04B404;\">', '</b>');
18INSERT INTO `ranks` VALUES ('6', 'Administrator', '<b style=\"color: darkred;\">', '</b>');
19INSERT INTO `ranks` VALUES ('7', 'Senior Administrator', '<b style=\"color: darkred;\">', '</b>');