· 7 years ago · Sep 13, 2018, 01:38 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET NAMES utf8 */;
3/*!50503 SET NAMES utf8mb4 */;
4/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6
7-- Dumping structure for table life.cw_logs
8CREATE TABLE IF NOT EXISTS `cw_logs` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `user_id` int(11) NOT NULL,
11 `type` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
12 `message` text NOT NULL,
13 `player_id` int(11) DEFAULT NULL,
14 `vehicle_id` int(11) DEFAULT NULL,
15 `container_id` int(11) DEFAULT NULL,
16 `gang_id` int(11) DEFAULT NULL,
17 `house_id` int(11) DEFAULT NULL,
18 `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
19 `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
20 PRIMARY KEY (`id`),
21 UNIQUE KEY `id` (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24-- Data exporting was unselected.
25-- Dumping structure for table life.cw_notes
26CREATE TABLE IF NOT EXISTS `cw_notes` (
27 `id` int(11) NOT NULL AUTO_INCREMENT,
28 `user_id` int(11) NOT NULL,
29 `type` enum('0','1','2') NOT NULL DEFAULT '0',
30 `message` text NOT NULL,
31 `player_id` int(11) DEFAULT NULL,
32 `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
33 `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
34 PRIMARY KEY (`id`),
35 UNIQUE KEY `id` (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;
37
38-- Data exporting was unselected.
39-- Dumping structure for table life.cw_permissions
40CREATE TABLE IF NOT EXISTS `cw_permissions` (
41 `id` int(11) NOT NULL AUTO_INCREMENT,
42 `group_name` varchar(64) NOT NULL DEFAULT '0',
43 `group_id` int(11) NULL DEFAULT NULL,
44 `is_superUser` tinyint(1) NOT NULL DEFAULT 0,
45 `can_view_players` tinyint(1) NOT NULL DEFAULT 0,
46 `can_view_player` tinyint(1) NOT NULL DEFAULT 0,
47 `can_view_vehicles` tinyint(1) NOT NULL DEFAULT 0,
48 `can_view_vehicle` tinyint(1) NOT NULL DEFAULT 0,
49 `can_view_logs` tinyint(1) NOT NULL DEFAULT 0,
50 `can_view_player_civ_lic` tinyint(1) NOT NULL DEFAULT 0,
51 `can_view_player_cop_lic` tinyint(1) NOT NULL DEFAULT 0,
52 `can_view_player_ems_lic` tinyint(1) NOT NULL DEFAULT 0,
53 `can_view_player_notes` tinyint(1) NOT NULL DEFAULT 0,
54 `can_view_player_edit_log` tinyint(1) NOT NULL DEFAULT 0,
55 `can_view_player_vehicles` tinyint(1) NOT NULL DEFAULT 0,
56 `can_view_gangs` tinyint(1) NOT NULL DEFAULT 0,
57 `can_view_containers` tinyint(1) NOT NULL DEFAULT 0,
58 `can_view_houses` tinyint(1) NOT NULL DEFAULT 0,
59 `can_edit_container` tinyint(1) NOT NULL DEFAULT 0,
60 `can_edit_house` tinyint(1) NOT NULL DEFAULT 0,
61 `can_compensate` tinyint(1) NOT NULL DEFAULT 0,
62 `can_blacklist` tinyint(1) NOT NULL DEFAULT 0,
63 `can_add_note` tinyint(1) NOT NULL DEFAULT 0,
64 `can_delete_note` tinyint(1) NOT NULL DEFAULT 0,
65 `can_edit_cash` tinyint(1) NOT NULL DEFAULT 0,
66 `can_edit_bank` tinyint(1) NOT NULL DEFAULT 0,
67 `can_edit_donator` tinyint(1) NOT NULL DEFAULT 0,
68 `can_edit_jailed` tinyint(1) NOT NULL DEFAULT 0,
69 `can_edit_cop_rank` tinyint(1) NOT NULL DEFAULT 0,
70 `can_edit_cop_lic` tinyint(1) NOT NULL DEFAULT 0,
71 `can_edit_ems_rank` tinyint(1) NOT NULL DEFAULT 0,
72 `can_edit_ems_lic` tinyint(1) NOT NULL DEFAULT 0,
73 `can_edit_civ_lic` tinyint(1) NOT NULL DEFAULT 0,
74 `can_edit_admin_rank` tinyint(1) NOT NULL DEFAULT 0,
75 `can_edit_vehicle` tinyint(1) NOT NULL DEFAULT 0,
76 `can_edit_gang` tinyint(1) NOT NULL DEFAULT 0,
77 `can_edit_group_name` tinyint(1) NOT NULL DEFAULT 0,
78 `can_edit_group_perms_player` tinyint(1) NOT NULL DEFAULT 0,
79 `can_edit_group_perms_vehicle` tinyint(1) NOT NULL DEFAULT 0,
80 `can_edit_group_perms_settings` tinyint(1) NOT NULL DEFAULT 0,
81 `can_edit_group_perms_gang` tinyint(1) NOT NULL DEFAULT 0,
82 `can_edit_group_perms` tinyint(1) NOT NULL DEFAULT 0,
83 `can_edit_group_ips_id` tinyint(1) NOT NULL DEFAULT 0,
84 `can_make_groups` tinyint(1) NOT NULL DEFAULT 0,
85 `can_edit_users` tinyint(1) NOT NULL DEFAULT 0,
86 `can_add_user` tinyint(1) NOT NULL DEFAULT 0,
87 `can_del_user` tinyint(1) NOT NULL DEFAULT 0,
88 `can_edit_group_perms_container` tinyint(1) NOT NULL DEFAULT 0,
89 `can_edit_group_perms_house` tinyint(1) NOT NULL DEFAULT 0,
90 PRIMARY KEY (`id`),
91 UNIQUE KEY `id` (`id`),
92 UNIQUE KEY `group_id` (`group_id`)
93) ENGINE=InnoDB DEFAULT CHARSET=utf8;
94
95
96
97-- Data exporting was unselected.
98-- Dumping structure for table life.cw_users
99CREATE TABLE IF NOT EXISTS `cw_users` (
100 `id` int(11) NOT NULL AUTO_INCREMENT,
101 `name` varchar(64) NOT NULL,
102 `email` varchar(64) NOT NULL,
103 `password` varchar(255) NOT NULL,
104 `primaryGroup` text DEFAULT NULL,
105 `connect_id` int(11) DEFAULT NULL,
106 `secondaryGroups` text DEFAULT NULL,
107 `profilePicture` text DEFAULT NULL,
108 `profileUrl` text DEFAULT NULL,
109 `pid` varchar(64) DEFAULT NULL,
110 `password_reset_token` varchar(255) DEFAULT NULL,
111 `created_at` timestamp NULL DEFAULT NULL,
112 `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
113 PRIMARY KEY (`id`),
114 UNIQUE KEY `username` (`name`),
115 UNIQUE KEY `email` (`email`),
116 UNIQUE KEY `connect_id` (`connect_id`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8;
118
119-- Data exporting was unselected.
120/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
121/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
122/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;