· 9 years ago · Nov 08, 2016, 06:08 PM
1CREATE TABLE IF NOT EXISTS `permissions_ranks` (
2 `rank` int(1) unsigned NOT NULL,
3 `cmd_update_permissions` enum('1','0') NOT NULL,
4 `cmd_update_settings` enum('1','0') NOT NULL,
5 `cmd_update_bots` enum('1','0') NOT NULL,
6 `cmd_update_catalogue` enum('1','0') NOT NULL,
7 `cmd_update_navigator` enum('1','0') NOT NULL,
8 `cmd_update_items` enum('1','0') NOT NULL,
9 `cmd_award` enum('1','0') NOT NULL,
10 `cmd_coords` enum('1','0') NOT NULL,
11 `cmd_override` enum('1','0') NOT NULL,
12 `cmd_coins` enum('1','0') NOT NULL,
13 `cmd_pixels` enum('1','0') NOT NULL,
14 `cmd_ha` enum('1','0') NOT NULL,
15 `cmd_hal` enum('1','0') NOT NULL,
16 `cmd_freeze` enum('1','0') NOT NULL,
17 `cmd_enable` enum('1','0') NOT NULL,
18 `cmd_roommute` enum('1','0') NOT NULL,
19 `cmd_setspeed` enum('1','0') NOT NULL,
20 `cmd_masscredits` enum('1','0') NOT NULL,
21 `cmd_globalcredits` enum('1','0') NOT NULL,
22 `cmd_roombadge` enum('1','0') NOT NULL,
23 `cmd_massbadge` enum('1','0') NOT NULL,
24 `cmd_userinfo` enum('1','0') NOT NULL,
25 `cmd_shutdown` enum('1','0') NOT NULL,
26 `cmd_givebadge` enum('1','0') NOT NULL,
27 `cmd_invisible` enum('1','0') NOT NULL,
28 `cmd_ban` enum('1','0') NOT NULL,
29 `cmd_superban` enum('1','0') NOT NULL,
30 `cmd_roomkick` enum('1','0') NOT NULL,
31 `cmd_roomalert` enum('1','0') NOT NULL,
32 `cmd_mute` enum('1','0') NOT NULL,
33 `cmd_unmute` enum('1','0') NOT NULL,
34 `cmd_alert` enum('1','0') NOT NULL,
35 `cmd_motd` enum('1','0') NOT NULL,
36 `cmd_kick` enum('1','0') NOT NULL,
37 `cmd_update_filter` enum('1','0') NOT NULL,
38 `acc_anyroomrights` enum('1','0') NOT NULL,
39 `acc_anyroomowner` enum('1','0') NOT NULL,
40 `acc_supporttool` enum('1','0') NOT NULL,
41 `acc_chatlogs` enum('1','0') NOT NULL,
42 `acc_enter_fullrooms` enum('1','0') NOT NULL,
43 `acc_enter_anyroom` enum('1','0') NOT NULL,
44 `acc_restrictedrooms` enum('1','0') NOT NULL,
45 `acc_unkickable` enum('1','0') NOT NULL,
46 `acc_unbannable` enum('1','0') NOT NULL,
47 `cmd_removebadge` enum('1','0') NOT NULL DEFAULT '0',
48 `cmd_summon` enum('1','0') NOT NULL DEFAULT '0',
49 `cmd_update_bans` enum('1','0') NOT NULL DEFAULT '0',
50 `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0',
51 `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0',
52 `cmd_sa` enum('1','0') NOT NULL DEFAULT '0',
53 `receive_sa` enum('1','0') NOT NULL DEFAULT '0',
54 `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0',
55 `floodtime` int(3) NOT NULL DEFAULT '30',
56 `cmd_spull` enum('1','0') NOT NULL DEFAULT '0',
57 `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0',
58 `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0',
59 `ignore_friendsettings` enum('1','0') NOT NULL DEFAULT '0',
60 `cmd_update_texts` enum('1','0') NOT NULL DEFAULT '0',
61 `cmd_points` enum('1','0') NOT NULL DEFAULT '0',
62 `cmd_teleport` enum('1','0') NOT NULL DEFAULT '0',
63 `cmd_masspoints` enum('1','0') NOT NULL DEFAULT '0',
64 `cmd_globalpoints` enum('1','0') NOT NULL DEFAULT '0',
65 `cmd_empty` enum('1','0') NOT NULL DEFAULT '0',
66 `wired_give_sql` enum('1','0') NOT NULL DEFAULT '0',
67 `wired_give_badge` enum('1','0') NOT NULL DEFAULT '0',
68 `wired_give_effect` enum('1','0') NOT NULL DEFAULT '0',
69 `wired_give_award` enum('1','0') NOT NULL DEFAULT '0',
70 `wired_give_send` enum('1','0') NOT NULL DEFAULT '0',
71 `wired_give_credits` enum('1','0') NOT NULL DEFAULT '0',
72 `wired_give_pixels` enum('1','0') NOT NULL DEFAULT '0',
73 `wired_give_points` enum('1','0') NOT NULL DEFAULT '0',
74 `wired_give_rank` enum('1','0') NOT NULL DEFAULT '0',
75 `wired_cnd_roomusers` enum('1','0') NOT NULL DEFAULT '0',
76 `wired_cnd_userhasachievement` enum('1','0') NOT NULL DEFAULT '0',
77 `wired_cnd_userhasbadge` enum('1','0') NOT NULL DEFAULT '0',
78 `wired_cnd_userhasvip` enum('1','0') NOT NULL DEFAULT '0',
79 `wired_cnd_userhaseffect` enum('1','0') NOT NULL DEFAULT '0',
80 `wired_cnd_userrank` enum('1','0') NOT NULL DEFAULT '0',
81 `wired_cnd_usercredits` enum('1','0') NOT NULL DEFAULT '0',
82 `wired_cnd_userpixels` enum('1','0') NOT NULL DEFAULT '0',
83 `wired_cnd_userpoints` enum('1','0') NOT NULL DEFAULT '0',
84 `wired_give_dance` enum('0','1') NOT NULL DEFAULT '0',
85 `wired_give_respect` enum('0','1') NOT NULL DEFAULT '0',
86 `wired_give_handitem` enum('0','1') NOT NULL DEFAULT '0',
87 `cmd_userinfo_viewip` enum('0','1') NOT NULL DEFAULT '0',
88 `wired_cnd_usergroups` enum('0','1') NOT NULL DEFAULT '0',
89 `wired_cnd_wearing` enum('0','1') NOT NULL DEFAULT '0',
90 `wired_cnd_carrying` enum('0','1') NOT NULL DEFAULT '0',
91 `wired_give_alert` enum('0','1') NOT NULL DEFAULT '0',
92 `ignore_roommute` enum('0','1') NOT NULL DEFAULT '0',
93 `cmd_dance` enum('0','1') NOT NULL DEFAULT '0',
94 `cmd_rave` enum('0','1') NOT NULL DEFAULT '0',
95 `cmd_roll` enum('0','1') NOT NULL DEFAULT '0',
96 `cmd_control` enum('0','1') NOT NULL DEFAULT '0',
97 `cmd_makesay` enum('0','1') NOT NULL DEFAULT '0',
98 `cmd_sitdown` enum('0','1') NOT NULL DEFAULT '0',
99 `cmd_lay` enum('0','1') NOT NULL DEFAULT '0',
100 `cmd_roomfreeze` enum('0','1') NOT NULL DEFAULT '0',
101 `cmd_redeempixel` enum('0','1') NOT NULL DEFAULT '0',
102 `cmd_redeemshell` enum('0','1') NOT NULL DEFAULT '0',
103 PRIMARY KEY (`rank`),
104 UNIQUE KEY `rank` (`rank`) USING BTREE
105) ENGINE=InnoDB DEFAULT CHARSET=utf8;