· 5 years ago · Mar 26, 2020, 12:46 PM
1CREATE TABLE IF NOT EXISTS `cw_permissions` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `group_name` varchar(64) NOT NULL DEFAULT '0',
4 `group_id` int(11) NULL DEFAULT NULL,
5 `is_superUser` tinyint(1) NOT NULL DEFAULT 0,
6 `can_view_players` tinyint(1) NOT NULL DEFAULT 0,
7 `can_view_player` tinyint(1) NOT NULL DEFAULT 0,
8 `can_view_vehicles` tinyint(1) NOT NULL DEFAULT 0,
9 `can_view_vehicle` tinyint(1) NOT NULL DEFAULT 0,
10 `can_view_logs` tinyint(1) NOT NULL DEFAULT 0,
11 `can_view_player_civ_lic` tinyint(1) NOT NULL DEFAULT 0,
12 `can_view_player_cop_lic` tinyint(1) NOT NULL DEFAULT 0,
13 `can_view_player_ems_lic` tinyint(1) NOT NULL DEFAULT 0,
14 `can_view_player_notes` tinyint(1) NOT NULL DEFAULT 0,
15 `can_view_player_edit_log` tinyint(1) NOT NULL DEFAULT 0,
16 `can_view_player_vehicles` tinyint(1) NOT NULL DEFAULT 0,
17 `can_view_gangs` tinyint(1) NOT NULL DEFAULT 0,
18 `can_view_containers` tinyint(1) NOT NULL DEFAULT 0,
19 `can_view_houses` tinyint(1) NOT NULL DEFAULT 0,
20 `can_edit_container` tinyint(1) NOT NULL DEFAULT 0,
21 `can_edit_house` tinyint(1) NOT NULL DEFAULT 0,
22 `can_compensate` tinyint(1) NOT NULL DEFAULT 0,
23 `can_blacklist` tinyint(1) NOT NULL DEFAULT 0,
24 `can_add_note` tinyint(1) NOT NULL DEFAULT 0,
25 `can_delete_note` tinyint(1) NOT NULL DEFAULT 0,
26 `can_edit_cash` tinyint(1) NOT NULL DEFAULT 0,
27 `can_edit_bank` tinyint(1) NOT NULL DEFAULT 0,
28 `can_edit_donator` tinyint(1) NOT NULL DEFAULT 0,
29 `can_edit_jailed` tinyint(1) NOT NULL DEFAULT 0,
30 `can_edit_cop_rank` tinyint(1) NOT NULL DEFAULT 0,
31 `can_edit_cop_lic` tinyint(1) NOT NULL DEFAULT 0,
32 `can_edit_ems_rank` tinyint(1) NOT NULL DEFAULT 0,
33 `can_edit_ems_lic` tinyint(1) NOT NULL DEFAULT 0,
34 `can_edit_civ_lic` tinyint(1) NOT NULL DEFAULT 0,
35 `can_edit_admin_rank` tinyint(1) NOT NULL DEFAULT 0,
36 `can_edit_vehicle` tinyint(1) NOT NULL DEFAULT 0,
37 `can_edit_gang` tinyint(1) NOT NULL DEFAULT 0,
38 `can_edit_group_name` tinyint(1) NOT NULL DEFAULT 0,
39 `can_edit_group_perms_player` tinyint(1) NOT NULL DEFAULT 0,
40 `can_edit_group_perms_vehicle` tinyint(1) NOT NULL DEFAULT 0,
41 `can_edit_group_perms_settings` tinyint(1) NOT NULL DEFAULT 0,
42 `can_edit_group_perms_gang` tinyint(1) NOT NULL DEFAULT 0,
43 `can_edit_group_perms` tinyint(1) NOT NULL DEFAULT 0,
44 `can_edit_group_ips_id` tinyint(1) NOT NULL DEFAULT 0,
45 `can_make_groups` tinyint(1) NOT NULL DEFAULT 0,
46 `can_edit_users` tinyint(1) NOT NULL DEFAULT 0,
47 `can_add_user` tinyint(1) NOT NULL DEFAULT 0,
48 `can_del_user` tinyint(1) NOT NULL DEFAULT 0,
49 `can_edit_group_perms_container` tinyint(1) NOT NULL DEFAULT 0,
50 `can_edit_group_perms_house` tinyint(1) NOT NULL DEFAULT 0,
51 PRIMARY KEY (`id`),
52 UNIQUE KEY `id` (`id`),
53 UNIQUE KEY `group_id` (`group_id`)
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;