· 8 years ago · Feb 28, 2018, 11:50 PM
1DROP TABLE IF EXISTS `ranks`;
2CREATE TABLE `ranks` (
3 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4 `name` varchar(50) NOT NULL,
5 `badgeid` varchar(5) DEFAULT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
8
9-- ----------------------------
10-- Records of ranks
11-- ----------------------------
12INSERT INTO `ranks` VALUES ('1', 'User', null);
13INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
14INSERT INTO `ranks` VALUES ('3', 'Super VIP', 'VIP');
15INSERT INTO `ranks` VALUES ('4', 'Player Support', 'ADM');
16INSERT INTO `ranks` VALUES ('5', 'Moderation Leaders', 'ADM');
17INSERT INTO `ranks` VALUES ('6', 'Managers', 'ADM');
18INSERT INTO `ranks` VALUES ('7', 'Owners', 'ADM');
19INSERT INTO `ranks` VALUES ('10', 'Technical Staff', 'ADM');