· 8 years ago · Mar 01, 2018, 05:58 PM
1DROP TABLE IF EXISTS `permissions_ranks`;
2CREATE TABLE `permissions_ranks` (
3 `rank` int(1) unsigned NOT NULL,
4 `cmd_update_permissions` enum('1','0') NOT NULL,
5 `cmd_update_settings` enum('1','0') NOT NULL,
6 `cmd_update_bots` enum('1','0') NOT NULL,
7 `cmd_update_catalogue` enum('1','0') NOT NULL,
8 `cmd_update_navigator` enum('1','0') NOT NULL,
9 `cmd_update_items` enum('1','0') NOT NULL,
10 `cmd_award` enum('1','0') NOT NULL,
11 `cmd_coords` enum('1','0') NOT NULL,
12 `cmd_override` enum('1','0') NOT NULL,
13 `cmd_coins` enum('1','0') NOT NULL,
14 `cmd_pixels` enum('1','0') NOT NULL,
15 `cmd_ha` enum('1','0') NOT NULL,
16 `cmd_hal` enum('1','0') NOT NULL,
17 `cmd_freeze` enum('1','0') NOT NULL,
18 `cmd_enable` enum('1','0') NOT NULL,
19 `cmd_roommute` enum('1','0') NOT NULL,
20 `cmd_setspeed` enum('1','0') NOT NULL,
21 `cmd_masscredits` enum('1','0') NOT NULL,
22 `cmd_globalcredits` enum('1','0') NOT NULL,
23 `cmd_roombadge` enum('1','0') NOT NULL,
24 `cmd_massbadge` enum('1','0') NOT NULL,
25 `cmd_userinfo` enum('1','0') NOT NULL,
26 `cmd_shutdown` enum('1','0') NOT NULL,
27 `cmd_givebadge` enum('1','0') NOT NULL,
28 `cmd_invisible` enum('1','0') NOT NULL,
29 `cmd_ban` enum('1','0') NOT NULL,
30 `cmd_superban` enum('1','0') NOT NULL,
31 `cmd_roomkick` enum('1','0') NOT NULL,
32 `cmd_roomalert` enum('1','0') NOT NULL,
33 `cmd_mute` enum('1','0') NOT NULL,
34 `cmd_unmute` enum('1','0') NOT NULL,
35 `cmd_alert` enum('1','0') NOT NULL,
36 `cmd_motd` enum('1','0') NOT NULL,
37 `cmd_kick` enum('1','0') NOT NULL,
38 `cmd_update_filter` enum('1','0') NOT NULL,
39 `acc_anyroomrights` enum('1','0') NOT NULL,
40 `acc_anyroomowner` enum('1','0') NOT NULL,
41 `acc_supporttool` enum('1','0') NOT NULL,
42 `acc_chatlogs` enum('1','0') NOT NULL,
43 `acc_enter_fullrooms` enum('1','0') NOT NULL,
44 `acc_enter_anyroom` enum('1','0') NOT NULL,
45 `acc_restrictedrooms` enum('1','0') NOT NULL,
46 `acc_unkickable` enum('1','0') NOT NULL,
47 `acc_unbannable` enum('1','0') NOT NULL,
48 `cmd_removebadge` enum('1','0') NOT NULL DEFAULT '0',
49 `cmd_summon` enum('1','0') NOT NULL DEFAULT '0',
50 `cmd_update_bans` enum('1','0') NOT NULL DEFAULT '0',
51 `hk_login` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
52 `hk_basics` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
53 `hk_news` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
54 `hk_users` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
55 `hk_rooms` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
56 `hk_edit` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
57 `hk_mod` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
58 `hk_voucher` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
59 `hk_badge` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
60 `hk_ban` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
61 `hk_iplookup` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
62 `hk_delete` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
63 `hk_ha` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
64 `hk_ext_login` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
65 `hk_permissions` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
66 `hk_plugins` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
67 `hk_bots` enum('1','0') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
68 PRIMARY KEY (`rank`),
69 UNIQUE KEY `rank` (`rank`) USING BTREE
70) ENGINE=InnoDB DEFAULT CHARSET=utf8;
71
72-- ----------------------------
73-- Records of permissions_ranks
74-- ----------------------------
75INSERT INTO `permissions_ranks` VALUES ('1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
76INSERT INTO `permissions_ranks` VALUES ('2', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
77INSERT INTO `permissions_ranks` VALUES ('3', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
78INSERT INTO `permissions_ranks` VALUES ('4', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '0', '1', '1', '0', '0', '0', '1', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0');
79INSERT INTO `permissions_ranks` VALUES ('5', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '1', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0');
80INSERT INTO `permissions_ranks` VALUES ('6', '1', '0', '0', '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '0', '1', '1', '1', '1', '0', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '0', '0', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0');
81INSERT INTO `permissions_ranks` VALUES ('7', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
82INSERT INTO `permissions_ranks` VALUES ('8', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '1');
83INSERT INTO `permissions_ranks` VALUES ('9', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');