· 6 years ago · Mar 14, 2019, 11:06 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.38-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 10.1.0.5464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for rpframework
16CREATE DATABASE IF NOT EXISTS `rpframework` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `rpframework`;
18
19-- Dumping structure for table rpframework.company_employees
20CREATE TABLE IF NOT EXISTS `company_employees` (
21 `company_id` tinyint(255) NOT NULL,
22 `employee_id` smallint(255) NOT NULL AUTO_INCREMENT,
23 `employee_uid` varchar(17) NOT NULL,
24 `access_level` tinyint(255) NOT NULL,
25 `employee_paycheck` mediumint(255) NOT NULL DEFAULT '100',
26 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
27 PRIMARY KEY (`employee_id`) USING BTREE,
28 KEY `employee_uid` (`employee_uid`) USING BTREE,
29 KEY `company_id` (`company_id`) USING BTREE
30) ENGINE=InnoDB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
31
32-- Dumping data for table rpframework.company_employees: ~44 rows (approximately)
33/*!40000 ALTER TABLE `company_employees` DISABLE KEYS */;
34/*!40000 ALTER TABLE `company_employees` ENABLE KEYS */;
35
36-- Dumping structure for table rpframework.company_employees_inventory
37CREATE TABLE IF NOT EXISTS `company_employees_inventory` (
38 `ID` int(50) NOT NULL AUTO_INCREMENT,
39 `uid` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
40 `items` text NOT NULL,
41 `clothes` text NOT NULL,
42 `weapons` text NOT NULL,
43 `company` varchar(10) NOT NULL,
44 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
45 PRIMARY KEY (`ID`) USING BTREE,
46 KEY `company` (`company`) USING BTREE,
47 KEY `uid` (`uid`) USING BTREE,
48 CONSTRAINT `company_employees_inventory_ibfk_1` FOREIGN KEY (`company`) REFERENCES `company_list` (`variable_name`) ON DELETE CASCADE ON UPDATE CASCADE,
49 CONSTRAINT `company_employees_inventory_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
50) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
51
52-- Dumping data for table rpframework.company_employees_inventory: ~49 rows (approximately)
53/*!40000 ALTER TABLE `company_employees_inventory` DISABLE KEYS */;
54/*!40000 ALTER TABLE `company_employees_inventory` ENABLE KEYS */;
55
56-- Dumping structure for table rpframework.company_garage
57CREATE TABLE IF NOT EXISTS `company_garage` (
58 `id` int(255) NOT NULL AUTO_INCREMENT,
59 `classname` varchar(255) NOT NULL,
60 `license` varchar(7) NOT NULL,
61 `hit` varchar(1000) NOT NULL,
62 `color` varchar(255) NOT NULL,
63 `material` varchar(32) NOT NULL,
64 `rims` varchar(32) NOT NULL,
65 `windows` varchar(32) NOT NULL,
66 `lights` varchar(32) NOT NULL,
67 `fuel` varchar(32) NOT NULL,
68 `status` varchar(32) NOT NULL,
69 `type` enum('car','air','ship') NOT NULL DEFAULT 'car',
70 `company_id` tinyint(255) NOT NULL,
71 `access_level` int(255) NOT NULL,
72 `typeColor` enum('rgb','texture') NOT NULL DEFAULT 'rgb',
73 `deleted` enum('0','1') NOT NULL DEFAULT '0',
74 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
75 PRIMARY KEY (`id`) USING BTREE,
76 KEY `company_id` (`company_id`) USING BTREE
77) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
78
79-- Dumping data for table rpframework.company_garage: ~190 rows (approximately)
80/*!40000 ALTER TABLE `company_garage` DISABLE KEYS */;
81/*!40000 ALTER TABLE `company_garage` ENABLE KEYS */;
82
83-- Dumping structure for table rpframework.company_list
84CREATE TABLE IF NOT EXISTS `company_list` (
85 `company_id` tinyint(255) NOT NULL AUTO_INCREMENT,
86 `variable_name` varchar(10) NOT NULL,
87 `fullname` text NOT NULL,
88 `owner_uid` varchar(255) NOT NULL,
89 `vehicles_current` int(5) NOT NULL,
90 `vehicles_max` int(5) NOT NULL,
91 `employees_current` int(5) NOT NULL,
92 `employees_max` int(5) NOT NULL,
93 `bank` int(255) NOT NULL,
94 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
95 PRIMARY KEY (`company_id`) USING BTREE,
96 UNIQUE KEY `variable_name` (`variable_name`) USING BTREE
97) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
98
99-- Dumping data for table rpframework.company_list: ~17 rows (approximately)
100/*!40000 ALTER TABLE `company_list` DISABLE KEYS */;
101/*!40000 ALTER TABLE `company_list` ENABLE KEYS */;
102
103-- Dumping structure for table rpframework.company_logs
104CREATE TABLE IF NOT EXISTS `company_logs` (
105 `ID` int(255) NOT NULL AUTO_INCREMENT,
106 `company_id` int(11) NOT NULL,
107 `employee_uid` varchar(19) NOT NULL,
108 `text` varchar(255) NOT NULL,
109 `type` enum('finance','fleet','company','none') NOT NULL DEFAULT 'none',
110 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
111 PRIMARY KEY (`ID`) USING BTREE
112) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
113
114-- Dumping data for table rpframework.company_logs: ~0 rows (approximately)
115/*!40000 ALTER TABLE `company_logs` DISABLE KEYS */;
116/*!40000 ALTER TABLE `company_logs` ENABLE KEYS */;
117
118-- Dumping structure for table rpframework.company_privilages
119CREATE TABLE IF NOT EXISTS `company_privilages` (
120 `company_id` tinyint(255) NOT NULL,
121 `privilage_id` int(255) NOT NULL AUTO_INCREMENT,
122 `variable_name` varchar(255) NOT NULL,
123 `access_level` int(255) NOT NULL,
124 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
125 PRIMARY KEY (`privilage_id`) USING BTREE,
126 KEY `company_id` (`company_id`) USING BTREE,
127 CONSTRAINT `company_privilages_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `company_list` (`company_id`) ON DELETE CASCADE ON UPDATE CASCADE
128) ENGINE=InnoDB AUTO_INCREMENT=378 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
129
130-- Dumping data for table rpframework.company_privilages: ~296 rows (approximately)
131/*!40000 ALTER TABLE `company_privilages` DISABLE KEYS */;
132INSERT INTO `company_privilages` (`company_id`, `privilage_id`, `variable_name`, `access_level`, `date`) VALUES
133 (1, 1, 'startjob', 1, '2017-07-30 05:06:46'),
134 (1, 2, 'computer', 1, '2017-07-30 05:06:46'),
135 (1, 3, 'atm_withdraw', 7, '2017-07-30 05:06:46'),
136 (1, 4, 'atm_deposit', 1, '2017-07-30 05:06:46'),
137 (1, 5, 'atm_transfer_employee', 8, '2017-07-30 05:06:46'),
138 (1, 6, 'atm_transfer_bankaccount', 1, '2017-07-30 05:06:46'),
139 (1, 7, 'atm_transfer_company', 6, '2017-07-30 05:06:46'),
140 (1, 8, 'log_finance', 8, '2017-07-30 05:06:46'),
141 (1, 9, 'log_company', 8, '2017-07-30 05:06:46'),
142 (1, 10, 'log_fleet', 2, '2017-07-30 05:06:46'),
143 (1, 11, 'edit_employee', 8, '2017-07-30 05:06:46'),
144 (1, 12, 'edit_permissions', 8, '2017-07-30 05:06:46'),
145 (1, 13, 'edit_fleet', 8, '2017-07-30 05:06:46'),
146 (1, 14, 'company_panel', 3, '2017-07-30 05:06:46'),
147 (2, 15, 'startjob', 1, '2017-07-30 05:06:46'),
148 (2, 16, 'computer', 1, '2017-07-30 05:06:46'),
149 (2, 17, 'atm_withdraw', 7, '2017-07-30 05:06:46'),
150 (2, 18, 'atm_deposit', 1, '2017-07-30 05:06:46'),
151 (2, 19, 'atm_transfer_employee', 8, '2017-07-30 05:06:46'),
152 (2, 20, 'atm_transfer_bankaccount', 8, '2017-07-30 05:06:46'),
153 (2, 21, 'atm_transfer_company', 8, '2017-07-30 05:06:46'),
154 (2, 22, 'log_finance', 8, '2017-07-30 05:06:46'),
155 (2, 23, 'log_company', 8, '2017-07-30 05:06:46'),
156 (2, 24, 'log_fleet', 8, '2017-07-30 05:06:46'),
157 (2, 25, 'edit_employee', 8, '2017-07-30 05:06:46'),
158 (2, 26, 'edit_permissions', 8, '2017-07-30 05:06:46'),
159 (2, 27, 'edit_fleet', 8, '2017-07-30 05:06:46'),
160 (2, 28, 'company_panel', 3, '2017-07-30 05:06:46'),
161 (3, 29, 'startjob', 1, '2017-07-30 05:06:46'),
162 (3, 30, 'computer', 1, '2017-07-30 05:06:46'),
163 (3, 31, 'atm_withdraw', 8, '2017-07-30 05:06:46'),
164 (3, 32, 'atm_deposit', 1, '2017-07-30 05:06:46'),
165 (3, 33, 'atm_transfer_employee', 8, '2017-07-30 05:06:46'),
166 (3, 34, 'atm_transfer_bankaccount', 8, '2017-07-30 05:06:46'),
167 (3, 35, 'atm_transfer_company', 8, '2017-07-30 05:06:46'),
168 (3, 36, 'log_finance', 8, '2017-07-30 05:06:46'),
169 (3, 37, 'log_company', 8, '2017-07-30 05:06:46'),
170 (3, 38, 'log_fleet', 8, '2017-07-30 05:06:46'),
171 (3, 39, 'edit_employee', 8, '2017-07-30 05:06:46'),
172 (3, 40, 'edit_permissions', 8, '2017-07-30 05:06:46'),
173 (3, 41, 'edit_fleet', 8, '2017-07-30 05:06:46'),
174 (3, 42, 'company_panel', 3, '2017-07-30 05:06:46'),
175 (4, 43, 'startjob', 1, '2017-07-30 05:06:46'),
176 (4, 44, 'computer', 1, '2017-07-30 05:06:46'),
177 (4, 45, 'atm_withdraw', 8, '2017-07-30 05:06:46'),
178 (4, 46, 'atm_deposit', 8, '2017-07-30 05:06:46'),
179 (4, 47, 'atm_transfer_employee', 8, '2017-07-30 05:06:46'),
180 (4, 48, 'atm_transfer_bankaccount', 8, '2017-07-30 05:06:46'),
181 (4, 49, 'atm_transfer_company', 8, '2017-07-30 05:06:46'),
182 (4, 50, 'log_finance', 8, '2017-07-30 05:06:46'),
183 (4, 51, 'log_company', 8, '2017-07-30 05:06:46'),
184 (4, 52, 'log_fleet', 8, '2017-07-30 05:06:46'),
185 (4, 53, 'edit_employee', 8, '2017-07-30 05:06:46'),
186 (4, 54, 'edit_permissions', 8, '2017-07-30 05:06:46'),
187 (4, 55, 'edit_fleet', 8, '2017-07-30 05:06:46'),
188 (4, 56, 'company_panel', 3, '2017-07-30 05:06:46'),
189 (5, 57, 'startjob', 1, '2017-07-30 05:06:46'),
190 (5, 58, 'computer', 1, '2017-07-30 05:06:46'),
191 (5, 59, 'atm_withdraw', 8, '2017-07-30 05:06:46'),
192 (5, 60, 'atm_deposit', 8, '2017-07-30 05:06:46'),
193 (5, 61, 'atm_transfer_employee', 8, '2017-07-30 05:06:46'),
194 (5, 62, 'atm_transfer_bankaccount', 8, '2017-07-30 05:06:46'),
195 (5, 63, 'atm_transfer_company', 8, '2017-07-30 05:06:46'),
196 (5, 64, 'log_finance', 8, '2017-07-30 05:06:46'),
197 (5, 65, 'log_company', 8, '2017-07-30 05:06:46'),
198 (5, 66, 'log_fleet', 8, '2017-07-30 05:06:46'),
199 (5, 67, 'edit_employee', 8, '2017-07-30 05:06:46'),
200 (5, 68, 'edit_permissions', 8, '2017-07-30 05:06:46'),
201 (5, 69, 'edit_fleet', 8, '2017-07-30 05:06:46'),
202 (5, 70, 'company_panel', 3, '2017-07-30 05:06:46'),
203 (1, 84, 'atm_manage', 8, '2017-07-30 05:06:46'),
204 (1, 85, 'pdcomputer', 1, '2017-07-30 05:06:46'),
205 (1, 86, 'pdcomputer_writeraport', 1, '2017-07-30 16:03:49'),
206 (1, 87, 'pdcomputer_listraports', 1, '2017-07-30 16:32:45'),
207 (6, 88, 'startjob', 10, '2017-07-30 19:58:38'),
208 (6, 89, 'company_panel', 10, '2017-07-30 19:58:38'),
209 (6, 90, 'computer', 1, '2017-07-30 19:58:38'),
210 (6, 91, 'atm_manage', 9, '2017-07-30 19:58:38'),
211 (6, 92, 'atm_withdraw', 10, '2017-07-30 19:58:38'),
212 (6, 93, 'atm_deposit', 10, '2017-07-30 19:58:38'),
213 (6, 94, 'atm_transfer_employee', 10, '2017-07-30 19:58:38'),
214 (6, 95, 'atm_transfer_bankaccount', 10, '2017-07-30 19:58:38'),
215 (6, 96, 'atm_transfer_company', 10, '2017-07-30 19:58:38'),
216 (6, 97, 'log_finance', 10, '2017-07-30 19:58:39'),
217 (6, 98, 'log_company', 10, '2017-07-30 19:58:39'),
218 (6, 99, 'log_fleet', 10, '2017-07-30 19:58:39'),
219 (6, 100, 'edit_employee', 10, '2017-07-30 19:58:39'),
220 (6, 101, 'edit_permissions', 9, '2017-07-30 19:58:39'),
221 (6, 102, 'edit_fleet', 10, '2017-07-30 19:58:39'),
222 (1, 103, 'add_employee', 6, '2017-08-04 21:24:15'),
223 (6, 104, 'crafting', 3, '2017-11-21 23:04:24'),
224 (6, 105, 'selldrugs', 2, '2017-11-21 23:19:30'),
225 (6, 106, 'sellsuitcases', 4, '2017-11-21 23:32:35'),
226 (6, 107, 'opencontainer', 2, '2017-11-24 21:45:05'),
227 (2, 108, 'add_employee', 8, '2017-12-06 19:26:44'),
228 (3, 109, 'add_employee', 8, '2017-12-06 19:26:52'),
229 (4, 110, 'add_employee', 8, '2017-12-06 19:26:58'),
230 (5, 111, 'add_employee', 8, '2017-12-06 19:27:01'),
231 (6, 112, 'add_employee', 9, '2017-12-06 19:27:04'),
232 (1, 113, 'crafting', 1, '2017-12-07 18:40:41'),
233 (2, 114, 'crafting', 1, '2017-12-07 18:40:55'),
234 (3, 115, 'crafting', 1, '2017-12-07 18:40:58'),
235 (4, 116, 'crafting', 1, '2017-12-07 18:41:02'),
236 (5, 117, 'crafting', 1, '2017-12-07 18:41:09'),
237 (2, 118, 'atm_manage', 8, '2017-12-11 17:39:22'),
238 (3, 119, 'atm_manage', 8, '2017-12-11 17:39:27'),
239 (4, 120, 'atm_manage', 8, '2017-12-11 17:39:32'),
240 (5, 121, 'atm_manage', 8, '2017-12-11 17:39:58'),
241 (7, 127, 'startjob', 1, '2018-01-22 19:03:54'),
242 (7, 190, 'startjob', 1, '2018-01-22 19:07:01'),
243 (7, 191, 'computer', 1, '2018-01-22 19:07:01'),
244 (7, 192, 'atm_withdraw', 7, '2018-01-22 19:07:01'),
245 (7, 193, 'atm_deposit', 1, '2018-01-22 19:07:01'),
246 (7, 194, 'atm_transfer_employee', 7, '2018-01-22 19:07:01'),
247 (7, 195, 'atm_transfer_bankaccount', 1, '2018-01-22 19:07:01'),
248 (7, 196, 'atm_transfer_company', 6, '2018-01-22 19:07:01'),
249 (7, 197, 'log_finance', 7, '2018-01-22 19:07:01'),
250 (7, 198, 'log_company', 7, '2018-01-22 19:07:01'),
251 (7, 199, 'log_fleet', 2, '2018-01-22 19:07:01'),
252 (7, 200, 'edit_employee', 7, '2018-01-22 19:07:01'),
253 (7, 201, 'edit_permissions', 7, '2018-01-22 19:07:01'),
254 (7, 202, 'edit_fleet', 7, '2018-01-22 19:07:01'),
255 (7, 203, 'company_panel', 3, '2018-01-22 19:07:01'),
256 (7, 204, 'atm_manage', 7, '2018-01-22 19:07:01'),
257 (7, 205, 'add_employee', 6, '2018-01-22 19:07:01'),
258 (7, 206, 'crafting', 1, '2018-01-22 19:07:01'),
259 (8, 207, 'startjob', 1, '2018-01-22 19:07:01'),
260 (8, 208, 'computer', 1, '2018-01-22 19:07:01'),
261 (8, 209, 'atm_withdraw', 8, '2018-01-22 19:07:01'),
262 (8, 210, 'atm_deposit', 1, '2018-01-22 19:07:01'),
263 (8, 211, 'atm_transfer_employee', 8, '2018-01-22 19:07:01'),
264 (8, 212, 'atm_transfer_bankaccount', 8, '2018-01-22 19:07:01'),
265 (8, 213, 'atm_transfer_company', 8, '2018-01-22 19:07:02'),
266 (8, 214, 'log_finance', 7, '2018-01-22 19:07:02'),
267 (8, 215, 'log_company', 7, '2018-01-22 19:07:02'),
268 (8, 216, 'log_fleet', 7, '2018-01-22 19:07:02'),
269 (8, 217, 'edit_employee', 9, '2018-01-22 19:07:02'),
270 (8, 218, 'edit_permissions', 7, '2018-01-22 19:07:02'),
271 (8, 219, 'edit_fleet', 9, '2018-01-22 19:07:02'),
272 (8, 220, 'company_panel', 3, '2018-01-22 19:07:02'),
273 (8, 221, 'atm_manage', 7, '2018-01-22 19:07:02'),
274 (8, 222, 'add_employee', 6, '2018-01-22 19:07:02'),
275 (8, 223, 'crafting', 1, '2018-01-22 19:07:02'),
276 (9, 224, 'startjob', 1, '2018-01-22 19:07:02'),
277 (9, 225, 'computer', 1, '2018-01-22 19:07:02'),
278 (9, 226, 'atm_withdraw', 7, '2018-01-22 19:07:02'),
279 (9, 227, 'atm_deposit', 1, '2018-01-22 19:07:02'),
280 (9, 228, 'atm_transfer_employee', 7, '2018-01-22 19:07:02'),
281 (9, 229, 'atm_transfer_bankaccount', 1, '2018-01-22 19:07:02'),
282 (9, 230, 'atm_transfer_company', 6, '2018-01-22 19:07:02'),
283 (9, 231, 'log_finance', 7, '2018-01-22 19:07:02'),
284 (9, 232, 'log_company', 7, '2018-01-22 19:07:02'),
285 (9, 233, 'log_fleet', 2, '2018-01-22 19:07:02'),
286 (9, 234, 'edit_employee', 7, '2018-01-22 19:07:02'),
287 (9, 235, 'edit_permissions', 7, '2018-01-22 19:07:02'),
288 (9, 236, 'edit_fleet', 7, '2018-01-22 19:07:02'),
289 (9, 237, 'company_panel', 3, '2018-01-22 19:07:02'),
290 (9, 238, 'atm_manage', 7, '2018-01-22 19:07:02'),
291 (9, 239, 'add_employee', 6, '2018-01-22 19:07:03'),
292 (9, 240, 'crafting', 1, '2018-01-22 19:07:03'),
293 (10, 241, 'startjob', 1, '2018-01-22 19:07:03'),
294 (10, 242, 'computer', 1, '2018-01-22 19:07:03'),
295 (10, 243, 'atm_withdraw', 7, '2018-01-22 19:07:03'),
296 (10, 244, 'atm_deposit', 1, '2018-01-22 19:07:03'),
297 (10, 245, 'atm_transfer_employee', 7, '2018-01-22 19:07:03'),
298 (10, 246, 'atm_transfer_bankaccount', 1, '2018-01-22 19:07:03'),
299 (10, 247, 'atm_transfer_company', 6, '2018-01-22 19:07:03'),
300 (10, 248, 'log_finance', 7, '2018-01-22 19:07:03'),
301 (10, 249, 'log_company', 7, '2018-01-22 19:07:03'),
302 (10, 250, 'log_fleet', 2, '2018-01-22 19:07:03'),
303 (10, 251, 'edit_employee', 7, '2018-01-22 19:07:03'),
304 (10, 252, 'edit_permissions', 7, '2018-01-22 19:07:03'),
305 (10, 253, 'edit_fleet', 7, '2018-01-22 19:07:03'),
306 (10, 254, 'company_panel', 3, '2018-01-22 19:07:03'),
307 (10, 255, 'atm_manage', 7, '2018-01-22 19:07:03'),
308 (10, 256, 'add_employee', 6, '2018-01-22 19:07:03'),
309 (10, 257, 'crafting', 1, '2018-01-22 19:07:03'),
310 (11, 258, 'startjob', 1, '2018-01-22 19:07:03'),
311 (11, 259, 'computer', 1, '2018-01-22 19:07:03'),
312 (11, 260, 'atm_withdraw', 7, '2018-01-22 19:07:03'),
313 (11, 261, 'atm_deposit', 1, '2018-01-22 19:07:03'),
314 (11, 262, 'atm_transfer_employee', 7, '2018-01-22 19:07:03'),
315 (11, 263, 'atm_transfer_bankaccount', 1, '2018-01-22 19:07:03'),
316 (11, 264, 'atm_transfer_company', 6, '2018-01-22 19:07:03'),
317 (11, 265, 'log_finance', 7, '2018-01-22 19:07:03'),
318 (11, 266, 'log_company', 7, '2018-01-22 19:07:04'),
319 (11, 267, 'log_fleet', 2, '2018-01-22 19:07:04'),
320 (11, 268, 'edit_employee', 7, '2018-01-22 19:07:04'),
321 (11, 269, 'edit_permissions', 7, '2018-01-22 19:07:04'),
322 (11, 270, 'edit_fleet', 7, '2018-01-22 19:07:04'),
323 (11, 271, 'company_panel', 3, '2018-01-22 19:07:04'),
324 (11, 272, 'atm_manage', 7, '2018-01-22 19:07:04'),
325 (11, 273, 'add_employee', 6, '2018-01-22 19:07:04'),
326 (11, 274, 'crafting', 1, '2018-01-22 19:07:04'),
327 (12, 275, 'startjob', 1, '2018-02-05 21:31:32'),
328 (12, 276, 'computer', 1, '2018-02-05 21:31:32'),
329 (12, 277, 'atm_withdraw', 7, '2018-02-05 21:31:32'),
330 (12, 278, 'atm_deposit', 1, '2018-02-05 21:31:32'),
331 (12, 279, 'atm_transfer_employee', 7, '2018-02-05 21:31:32'),
332 (12, 280, 'atm_transfer_bankaccount', 1, '2018-02-05 21:31:32'),
333 (12, 281, 'atm_transfer_company', 6, '2018-02-05 21:31:32'),
334 (12, 282, 'log_finance', 7, '2018-02-05 21:31:32'),
335 (12, 283, 'log_company', 7, '2018-02-05 21:31:32'),
336 (12, 284, 'log_fleet', 2, '2018-02-05 21:31:32'),
337 (12, 285, 'edit_employee', 7, '2018-02-05 21:31:32'),
338 (12, 286, 'edit_permissions', 7, '2018-02-05 21:31:32'),
339 (12, 287, 'edit_fleet', 7, '2018-02-05 21:31:32'),
340 (12, 288, 'company_panel', 3, '2018-02-05 21:31:32'),
341 (12, 289, 'atm_manage', 7, '2018-02-05 21:31:32'),
342 (12, 290, 'add_employee', 6, '2018-02-05 21:31:32'),
343 (12, 291, 'crafting', 1, '2018-02-05 21:31:32'),
344 (13, 293, 'startjob', 1, '2018-03-05 20:08:30'),
345 (13, 294, 'computer', 1, '2018-03-05 20:08:30'),
346 (13, 295, 'atm_withdraw', 7, '2018-03-05 20:08:30'),
347 (13, 296, 'atm_deposit', 1, '2018-03-05 20:08:30'),
348 (13, 297, 'atm_transfer_employee', 7, '2018-03-05 20:08:30'),
349 (13, 298, 'atm_transfer_bankaccount', 1, '2018-03-05 20:08:30'),
350 (13, 299, 'atm_transfer_company', 6, '2018-03-05 20:08:30'),
351 (13, 300, 'log_finance', 7, '2018-03-05 20:08:30'),
352 (13, 301, 'log_company', 7, '2018-03-05 20:08:30'),
353 (13, 302, 'log_fleet', 2, '2018-03-05 20:08:30'),
354 (13, 303, 'edit_employee', 7, '2018-03-05 20:08:30'),
355 (13, 304, 'edit_permissions', 7, '2018-03-05 20:08:30'),
356 (13, 305, 'edit_fleet', 7, '2018-03-05 20:08:30'),
357 (13, 306, 'company_panel', 3, '2018-03-05 20:08:30'),
358 (13, 307, 'atm_manage', 7, '2018-03-05 20:08:30'),
359 (13, 308, 'add_employee', 6, '2018-03-05 20:08:30'),
360 (13, 309, 'crafting', 1, '2018-03-05 20:08:30'),
361 (14, 310, 'startjob', 1, '2018-04-09 18:36:38'),
362 (14, 311, 'computer', 1, '2018-04-09 18:36:38'),
363 (14, 312, 'atm_withdraw', 7, '2018-04-09 18:36:38'),
364 (14, 313, 'atm_deposit', 1, '2018-04-09 18:36:38'),
365 (14, 314, 'atm_transfer_employee', 7, '2018-04-09 18:36:38'),
366 (14, 315, 'atm_transfer_bankaccount', 1, '2018-04-09 18:36:38'),
367 (14, 316, 'atm_transfer_company', 6, '2018-04-09 18:36:38'),
368 (14, 317, 'log_finance', 7, '2018-04-09 18:36:38'),
369 (14, 318, 'log_company', 7, '2018-04-09 18:36:38'),
370 (14, 319, 'log_fleet', 2, '2018-04-09 18:36:38'),
371 (14, 320, 'edit_employee', 7, '2018-04-09 18:36:38'),
372 (14, 321, 'edit_permissions', 7, '2018-04-09 18:36:38'),
373 (14, 322, 'edit_fleet', 7, '2018-04-09 18:36:38'),
374 (14, 323, 'company_panel', 3, '2018-04-09 18:36:38'),
375 (14, 324, 'atm_manage', 7, '2018-04-09 18:36:38'),
376 (14, 325, 'add_employee', 6, '2018-04-09 18:36:38'),
377 (14, 326, 'crafting', 1, '2018-04-09 18:36:38'),
378 (15, 327, 'startjob', 1, '2018-04-14 00:58:20'),
379 (15, 328, 'computer', 1, '2018-04-14 00:58:20'),
380 (15, 329, 'atm_withdraw', 7, '2018-04-14 00:58:20'),
381 (15, 330, 'atm_deposit', 1, '2018-04-14 00:58:20'),
382 (15, 331, 'atm_transfer_employee', 7, '2018-04-14 00:58:20'),
383 (15, 332, 'atm_transfer_bankaccount', 1, '2018-04-14 00:58:20'),
384 (15, 333, 'atm_transfer_company', 6, '2018-04-14 00:58:20'),
385 (15, 334, 'log_finance', 7, '2018-04-14 00:58:20'),
386 (15, 335, 'log_company', 7, '2018-04-14 00:58:20'),
387 (15, 336, 'log_fleet', 2, '2018-04-14 00:58:20'),
388 (15, 337, 'edit_employee', 7, '2018-04-14 00:58:20'),
389 (15, 338, 'edit_permissions', 7, '2018-04-14 00:58:20'),
390 (15, 339, 'edit_fleet', 7, '2018-04-14 00:58:20'),
391 (15, 340, 'company_panel', 3, '2018-04-14 00:58:20'),
392 (15, 341, 'atm_manage', 7, '2018-04-14 00:58:20'),
393 (15, 342, 'add_employee', 6, '2018-04-14 00:58:20'),
394 (15, 343, 'crafting', 1, '2018-04-14 00:58:20'),
395 (17, 344, 'startjob', 1, '2018-04-17 18:19:46'),
396 (17, 345, 'computer', 1, '2018-04-17 18:19:46'),
397 (17, 346, 'atm_withdraw', 7, '2018-04-17 18:19:46'),
398 (17, 347, 'atm_deposit', 1, '2018-04-17 18:19:46'),
399 (17, 348, 'atm_transfer_employee', 7, '2018-04-17 18:19:46'),
400 (17, 349, 'atm_transfer_bankaccount', 1, '2018-04-17 18:19:46'),
401 (17, 350, 'atm_transfer_company', 6, '2018-04-17 18:19:46'),
402 (17, 351, 'log_finance', 7, '2018-04-17 18:19:46'),
403 (17, 352, 'log_company', 7, '2018-04-17 18:19:46'),
404 (17, 353, 'log_fleet', 2, '2018-04-17 18:19:46'),
405 (17, 354, 'edit_employee', 7, '2018-04-17 18:19:46'),
406 (17, 355, 'edit_permissions', 7, '2018-04-17 18:19:46'),
407 (17, 356, 'edit_fleet', 7, '2018-04-17 18:19:46'),
408 (17, 357, 'company_panel', 3, '2018-04-17 18:19:46'),
409 (17, 358, 'atm_manage', 7, '2018-04-17 18:19:46'),
410 (17, 359, 'add_employee', 6, '2018-04-17 18:19:46'),
411 (17, 360, 'crafting', 1, '2018-04-17 18:19:46'),
412 (16, 361, 'startjob', 1, '2018-04-17 18:20:01'),
413 (16, 362, 'computer', 1, '2018-04-17 18:20:01'),
414 (16, 363, 'atm_withdraw', 7, '2018-04-17 18:20:01'),
415 (16, 364, 'atm_deposit', 1, '2018-04-17 18:20:01'),
416 (16, 365, 'atm_transfer_employee', 7, '2018-04-17 18:20:01'),
417 (16, 366, 'atm_transfer_bankaccount', 1, '2018-04-17 18:20:01'),
418 (16, 367, 'atm_transfer_company', 6, '2018-04-17 18:20:01'),
419 (16, 368, 'log_finance', 7, '2018-04-17 18:20:01'),
420 (16, 369, 'log_company', 7, '2018-04-17 18:20:01'),
421 (16, 370, 'log_fleet', 2, '2018-04-17 18:20:01'),
422 (16, 371, 'edit_employee', 7, '2018-04-17 18:20:01'),
423 (16, 372, 'edit_permissions', 7, '2018-04-17 18:20:02'),
424 (16, 373, 'edit_fleet', 7, '2018-04-17 18:20:02'),
425 (16, 374, 'company_panel', 3, '2018-04-17 18:20:02'),
426 (16, 375, 'atm_manage', 7, '2018-04-17 18:20:02'),
427 (16, 376, 'add_employee', 6, '2018-04-17 18:20:02'),
428 (16, 377, 'crafting', 1, '2018-04-17 18:20:02');
429/*!40000 ALTER TABLE `company_privilages` ENABLE KEYS */;
430
431-- Dumping structure for table rpframework.company_shopsystem_prices
432CREATE TABLE IF NOT EXISTS `company_shopsystem_prices` (
433 `ID` int(50) NOT NULL AUTO_INCREMENT,
434 `classname` varchar(255) NOT NULL,
435 `price` int(50) NOT NULL DEFAULT '0',
436 `count` int(50) NOT NULL,
437 `type` enum('Weapon','Item','Clothing','Backpack') NOT NULL DEFAULT 'Item',
438 `clothing_type` enum('None','Uniform','Backpack','Vest','Goggles','Headgear') NOT NULL DEFAULT 'None',
439 `shop` enum('gunstore_pd','clothing_pd','backpack_pd','vest_pd','gunstore_so','clothing_so','backpack_so','vest_so','gunstore_ems','clothing_ems','backpack_ems','vest_ems','gunstore_fd','clothing_fd','backpack_fd','vest_fd','gunstore_dtu','backpack_dtu','clothing_dtu','vest_dtu','general_pd','general_so','general_dtu','general_ems','backpack_doj','clothing_doj','general_doj','general_aiad','gunstore_aiad','clothing_aiad','vest_aiad','backpack_aiad','clothing_motoroad','gunstore_security','clothing_security','general_fd','clothing_cg','gunstore_cg','general_cg','backpack_cg','vest_cg') NOT NULL,
440 `company` varchar(10) NOT NULL,
441 `access` int(3) NOT NULL DEFAULT '1',
442 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
443 PRIMARY KEY (`ID`) USING BTREE,
444 KEY `company` (`company`) USING BTREE,
445 CONSTRAINT `company_shopsystem_prices_ibfk_1` FOREIGN KEY (`company`) REFERENCES `company_list` (`variable_name`) ON DELETE CASCADE ON UPDATE CASCADE
446) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
447
448-- Dumping data for table rpframework.company_shopsystem_prices: ~173 rows (approximately)
449/*!40000 ALTER TABLE `company_shopsystem_prices` DISABLE KEYS */;
450INSERT INTO `company_shopsystem_prices` (`ID`, `classname`, `price`, `count`, `type`, `clothing_type`, `shop`, `company`, `access`, `date`) VALUES
451 (1, 'silver_lake_fbi', 50, 29993, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-12-08 18:43:48'),
452 (2, 'silver_lake_police', 50, 30001, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 1, '2018-11-18 20:03:26'),
453 (4, 'silver_lake_statepolice', 50, 30000, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 6, '2018-10-05 21:00:50'),
454 (5, 'female_police', 50, 29999, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 6, '2018-11-18 20:03:05'),
455 (6, 'female_police2', 50, 29999, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 1, '2018-11-24 17:15:09'),
456 (7, 'female_police3', 50, 29999, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-11-24 17:22:39'),
457 (8, 'EF_HMP_1', 50, 29996, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-12-08 01:04:30'),
458 (9, 'EF_HMP_2', 50, 29996, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-12-08 17:13:04'),
459 (10, 'S5xD_BLK_POL_WHT', 50, 29994, 'Clothing', 'Headgear', 'clothing_pd', 'pd', 1, '2018-12-08 17:15:36'),
460 (11, 'EF_FEM_4_2', 50, 29995, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-12-08 18:42:34'),
461 (12, 'EF_FEM_3_3', 50, 29995, 'Clothing', 'Uniform', 'clothing_pd', 'pd', 9, '2018-12-08 04:24:15'),
462 (13, 'Campaign_Hat_black', 50, 29995, 'Clothing', 'Headgear', 'clothing_pd', 'pd', 9, '2018-11-25 20:55:39'),
463 (14, 'AM_PoliceBelt', 50, 29996, 'Backpack', 'Backpack', 'backpack_pd', 'pd', 9, '2018-12-08 18:42:42'),
464 (15, 'TAC_V_tacv1_P2', 50, 29995, 'Clothing', 'Vest', 'clothing_pd', 'pd', 9, '2018-12-08 01:04:26'),
465 (16, 'silver_lake_fbi', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:20:20'),
466 (17, 'silver_lake_statepolice', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:20:20'),
467 (18, 'silver_lake_sheriff', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:20:20'),
468 (19, 'female_police3', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:20:20'),
469 (20, 'female_police', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:22:53'),
470 (21, 'female_police1', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:22:53'),
471 (22, 'EF_HMSRF_1', 50, 29995, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-12-08 00:59:36'),
472 (23, 'EF_HMSRF_2', 50, 29997, 'Clothing', 'Uniform', 'clothing_so', 'so', 1, '2018-11-23 21:22:53'),
473 (24, 'TAC_V_tacv1_SRF2', 50, 29995, 'Clothing', 'Vest', 'clothing_so', 'so', 1, '2018-12-08 00:59:40'),
474 (25, 'sl_client_c_sheriffhat_b_W', 50, 29997, 'Clothing', 'Headgear', 'clothing_so', 'so', 1, '2018-11-23 21:27:27'),
475 (26, 'AM_PoliceBelt', 50, 29995, 'Backpack', 'Backpack', 'backpack_so', 'so', 1, '2018-12-08 00:55:09'),
476 (27, 'sl_gps_receiver', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-23 21:30:21'),
477 (28, 'sl_item_handcuffs', 50, 29994, 'Item', 'None', 'general_pd', 'pd', 1, '2018-12-08 00:38:53'),
478 (30, 'sl_item_handcuffs_key', 50, 29996, 'Item', 'None', 'general_pd', 'pd', 1, '2018-12-08 00:38:55'),
479 (31, 'sl_item_panicbutton', 50, 29995, 'Item', 'None', 'general_pd', 'pd', 1, '2018-12-08 17:16:06'),
480 (32, 'sl_item_spike_strips', 50, 29994, 'Item', 'None', 'general_pd', 'pd', 1, '2018-12-08 00:38:58'),
481 (33, 'sl_item_policeline_1m', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
482 (34, 'sl_item_policeline_4m', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
483 (35, 'sl_item_policeline_8m', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
484 (36, 'sl_item_policebarrier_large', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
485 (37, 'sl_item_policebarrier_small', 50, 29996, 'Item', 'None', 'general_pd', 'pd', 1, '2018-12-08 17:14:50'),
486 (38, 'sl_item_trafficConeOrange', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
487 (39, 'sl_item_roadCone_L_F', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-24 12:35:10'),
488 (40, 'sl_gps_receiver', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:39:45'),
489 (41, 'sl_item_handcuffs', 50, 29991, 'Item', 'None', 'general_so', 'so', 1, '2018-12-08 01:01:55'),
490 (42, 'sl_item_handcuffs_key', 50, 29994, 'Item', 'None', 'general_so', 'so', 1, '2018-12-08 01:01:52'),
491 (43, 'sl_item_panicbutton', 50, 29994, 'Item', 'None', 'general_so', 'so', 1, '2018-12-08 01:01:50'),
492 (44, 'sl_item_spike_strips', 50, 29995, 'Item', 'None', 'general_so', 'so', 1, '2018-12-08 01:01:47'),
493 (45, 'sl_item_policeline_1m', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:08'),
494 (46, 'sl_item_policeline_4m', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:14'),
495 (47, 'sl_item_policeline_8m', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:10'),
496 (48, 'sl_item_policebarrier_large', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:17'),
497 (49, 'sl_item_policebarrier_small', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:21'),
498 (50, 'sl_item_trafficConeOrange', 50, 29996, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 13:34:17'),
499 (51, 'sl_item_roadCone_L_F', 50, 29997, 'Item', 'None', 'general_so', 'so', 1, '2018-11-24 12:40:29'),
500 (52, 'sl_gps_receiver', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:40:33'),
501 (53, 'sl_item_handcuffs', 50, 29996, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-12-08 17:35:16'),
502 (54, 'sl_item_handcuffs_key', 50, 29996, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-12-08 17:35:14'),
503 (55, 'sl_item_panicbutton', 50, 29996, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-12-08 17:35:12'),
504 (56, 'sl_item_spike_strips', 50, 29996, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-25 21:18:23'),
505 (57, 'sl_item_policeline_1m', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:40:33'),
506 (58, 'sl_item_policeline_4m', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:40:33'),
507 (59, 'sl_item_policeline_8m', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:40:33'),
508 (60, 'sl_item_policebarrier_large', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:41:57'),
509 (61, 'sl_item_policebarrier_small', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:41:57'),
510 (62, 'sl_item_trafficConeOrange', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:41:57'),
511 (63, 'sl_item_roadCone_L_F', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-24 12:41:57'),
512 (64, 'sl_gps_receiver', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
513 (65, 'sl_item_handcuffs', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
514 (66, 'sl_item_handcuffs_key', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
515 (67, 'sl_item_panicbutton', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
516 (68, 'sl_item_spike_strips', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
517 (69, 'sl_item_policeline_1m', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
518 (70, 'sl_item_policeline_4m', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
519 (71, 'sl_item_policeline_8m', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
520 (72, 'sl_item_policebarrier_large', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
521 (73, 'sl_item_policebarrier_small', 50, 29996, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-25 16:54:14'),
522 (74, 'sl_item_trafficConeOrange', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
523 (75, 'sl_item_roadCone_L_F', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
524 (76, 'RM_SWAT_Uniform_02', 50, 29997, 'Clothing', 'Uniform', 'clothing_aiad', 'aiad', 1, '2018-11-24 12:43:58'),
525 (77, 'AM_PoliceBelt', 50, 29997, 'Clothing', 'Backpack', 'backpack_aiad', 'aiad', 1, '2018-11-25 14:42:53'),
526 (78, 'RM_SWAT_Helmet_01', 50, 29997, 'Clothing', 'Headgear', 'clothing_aiad', 'aiad', 1, '2018-11-25 14:42:53'),
527 (79, 'G_RM_SWAT_Bandana', 50, 29997, 'Clothing', 'Goggles', 'clothing_aiad', 'aiad', 1, '2018-11-25 14:44:05'),
528 (80, 'PATHuK_swat_vest', 50, 29997, 'Clothing', 'Vest', 'clothing_aiad', 'aiad', 1, '2018-11-25 19:41:18'),
529 (81, 'tf_anprc152_1', 50, 29997, 'Item', 'None', 'general_pd', 'pd', 1, '2018-11-25 14:56:47'),
530 (82, 'tf_anprc152_1', 50, 29997, 'Item', 'None', 'general_dtu', 'dtu', 1, '2018-11-25 14:56:51'),
531 (83, 'tf_anprc152_1', 50, 29996, 'Item', 'None', 'general_so', 'so', 1, '2018-12-08 00:53:58'),
532 (84, 'tf_anprc152_1', 50, 29997, 'Item', 'None', 'general_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
533 (85, 'RH_g17', 50, 29996, 'Weapon', 'None', 'gunstore_pd', 'pd', 1, '2018-11-25 16:50:03'),
534 (86, 'RH_17Rnd_9x19_g17', 50, 29991, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-11-25 16:50:06'),
535 (87, 'RH_uspm', 50, 29995, 'Weapon', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 00:38:09'),
536 (88, 'RH_16Rnd_40cal_usp', 50, 29985, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 00:38:12'),
537 (89, 'RH_kimber', 50, 29997, 'Weapon', 'None', 'gunstore_pd', 'pd', 1, '2018-11-25 14:44:54'),
538 (90, 'RH_7Rnd_45cal_m1911', 50, 29997, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-11-25 14:44:54'),
539 (91, 'RH_fnp45', 50, 29996, 'Weapon', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 17:15:31'),
540 (92, 'RH_15Rnd_45cal_fnp', 50, 29992, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 17:15:52'),
541 (93, 'RH_fn57', 50, 29995, 'Weapon', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 17:17:17'),
542 (94, 'RH_20Rnd_57x28_FN', 50, 29973, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 17:17:21'),
543 (95, 'RH_x300', 50, 29982, 'Item', 'None', 'gunstore_pd', 'pd', 1, '2018-12-08 17:17:23'),
544 (96, 'RH_g17', 50, 29997, 'Weapon', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
545 (97, 'RH_17Rnd_9x19_g17', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
546 (98, 'RH_uspm', 50, 29997, 'Weapon', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
547 (99, 'RH_16Rnd_40cal_usp', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
548 (100, 'RH_kimber', 50, 29997, 'Weapon', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
549 (101, 'RH_7Rnd_45cal_m1911', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
550 (102, 'RH_fnp45', 50, 29997, 'Weapon', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
551 (103, 'RH_15Rnd_45cal_fnp', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 15:01:41'),
552 (104, 'RH_fn57', 50, 29997, 'Weapon', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
553 (105, 'RH_20Rnd_57x28_FN', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
554 (106, 'RH_x300', 50, 29997, 'Item', 'None', 'gunstore_dtu', 'dtu', 1, '2018-11-25 14:44:54'),
555 (107, 'RH_x300', 50, 29996, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-12-08 00:55:53'),
556 (108, 'RH_x300', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
557 (109, 'RH_20Rnd_57x28_FN', 50, 29991, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-12-08 00:55:56'),
558 (110, 'RH_20Rnd_57x28_FN', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
559 (111, 'RH_fn57', 50, 29996, 'Weapon', 'None', 'gunstore_so', 'so', 1, '2018-12-08 00:55:51'),
560 (112, 'RH_fn57', 50, 29997, 'Weapon', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
561 (113, 'RH_15Rnd_45cal_fnp', 50, 29997, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-11-25 15:01:41'),
562 (114, 'RH_15Rnd_45cal_fnp', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 15:01:41'),
563 (115, 'RH_fnp45', 50, 29997, 'Weapon', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
564 (116, 'RH_fnp45', 50, 29997, 'Weapon', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
565 (117, 'RH_7Rnd_45cal_m1911', 50, 29997, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
566 (118, 'RH_7Rnd_45cal_m1911', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
567 (119, 'RH_kimber', 50, 29997, 'Weapon', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
568 (120, 'RH_kimber', 50, 29997, 'Weapon', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
569 (121, 'RH_16Rnd_40cal_usp', 50, 29997, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
570 (122, 'RH_16Rnd_40cal_usp', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
571 (123, 'RH_uspm', 50, 29997, 'Weapon', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
572 (124, 'RH_uspm', 50, 29997, 'Weapon', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
573 (125, 'RH_17Rnd_9x19_g17', 50, 29997, 'Item', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
574 (126, 'RH_17Rnd_9x19_g17', 50, 29997, 'Item', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
575 (127, 'RH_g17', 50, 29997, 'Weapon', 'None', 'gunstore_so', 'so', 1, '2018-11-25 14:44:54'),
576 (128, 'RH_g17', 50, 29997, 'Weapon', 'None', 'gunstore_aiad', 'aiad', 1, '2018-11-25 14:44:54'),
577 (129, 'sl_client_c4_swat3_W', 50, 29997, 'Clothing', 'Uniform', 'clothing_dtu', 'dtu', 1, '2018-11-25 15:15:08'),
578 (130, 'AM_PoliceBelt', 50, 29997, 'Backpack', 'Backpack', 'backpack_dtu', 'dtu', 1, '2018-11-25 15:15:22'),
579 (131, 'EF_FEM_4_2', 50, 29997, 'Clothing', 'Uniform', 'clothing_dtu', 'dtu', 1, '2018-11-25 15:15:08'),
580 (132, 'EF_FEM_3_3', 50, 29997, 'Clothing', 'Uniform', 'clothing_dtu', 'dtu', 1, '2018-11-25 19:39:12'),
581 (133, 'EF_HMP_1', 50, 29995, 'Clothing', 'Uniform', 'clothing_dtu', 'dtu', 1, '2018-12-08 01:12:16'),
582 (134, 'EF_HMP_2', 50, 29997, 'Clothing', 'Uniform', 'clothing_dtu', 'dtu', 1, '2018-11-25 15:15:08'),
583 (135, 'Chief_uni1', 50, 29994, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 10, '2018-12-08 00:52:29'),
584 (142, 'female_ems3', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 4, '2018-12-03 21:17:47'),
585 (144, 'female_ems5', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 5, '2018-12-03 21:17:33'),
586 (147, 'female_ems8', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 3, '2018-12-03 21:17:59'),
587 (148, 'female_ems9', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 1, '2018-11-29 18:23:48'),
588 (159, 'EF_Fcap_EMSB', 50, 29995, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 1, '2018-12-08 00:53:13'),
589 (160, 'EF_Mcap_EMSB', 50, 29996, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 1, '2018-12-07 22:41:47'),
590 (161, 'sl_client_c3_masque_Chirurgical', 50, 29996, 'Clothing', 'Goggles', 'clothing_ems', 'ems', 1, '2018-12-08 00:25:01'),
591 (163, 'tf_anprc152_1', 50, 29995, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:41:01'),
592 (164, 'immersion_pops_pop0', 50, 29992, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:57:54'),
593 (166, 'sl_gps_receiver', 50, 29993, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:41:10'),
594 (167, 'sl_item_trafficConeOrange', 50, 29997, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-01 17:21:27'),
595 (168, 'sl_item_roadCone_L_F', 50, 29995, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-07 23:06:29'),
596 (169, 'Itemwatch', 50, 29997, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-01 17:21:27'),
597 (170, 'ToolKit', 50, 29993, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:42:37'),
598 (171, 'sl_item_first_aid_kit', 50, 29978, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:42:44'),
599 (172, 'sl_item_bandage', 50, 29955, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:42:52'),
600 (173, 'ItemMap', 50, 29996, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 00:41:13'),
601 (174, 'sl_client_c_medic', 50, 29988, 'Backpack', 'Backpack', 'backpack_ems', 'ems', 1, '2018-12-08 01:08:48'),
602 (175, ' B_Bolsa_camp_cruz', 50, 29997, 'Backpack', 'Backpack', 'backpack_ems', 'ems', 1, '2018-11-25 14:44:54'),
603 (176, 'murshun_cigs_cigpack', 100, 29992, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 02:04:00'),
604 (177, 'murshun_cigs_lighter', 50, 29992, 'Item', 'None', 'general_ems', 'ems', 1, '2018-12-08 02:04:05'),
605 (178, 'DeputyChief_uni1', 50, 29996, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 9, '2018-12-07 22:50:30'),
606 (179, 'Captain_uni1', 50, 29993, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 8, '2018-12-08 00:52:35'),
607 (180, 'Lieutenant_uni1', 50, 29996, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 7, '2018-12-08 00:53:58'),
608 (181, 'sparamedic_uni1', 50, 29996, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 6, '2018-12-07 22:48:01'),
609 (182, 'paramedic_uni1', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 5, '2018-12-03 20:55:12'),
610 (183, 'SEMT_uni1', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 4, '2018-12-03 20:55:12'),
611 (184, 'EMT_uni1', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 3, '2018-12-03 20:55:12'),
612 (185, 'CG_EMS2', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 2, '2018-12-03 20:55:12'),
613 (186, 'CG_EMS2', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 1, '2018-12-03 20:55:12'),
614 (187, 'CG_EMS1', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 1, '2018-12-03 20:55:12'),
615 (188, 'female_highway', 50, 29995, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 7, '2018-12-08 00:39:18'),
616 (189, 'female_liverpatrol', 50, 29995, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 2, '2018-12-07 23:06:51'),
617 (190, 'sl_client_c4_hazmat_yellow_W', 50, 29997, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 5, '2018-12-03 21:17:47'),
618 (191, 'H_Beret_Colonel', 50, 29993, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 10, '2018-12-08 00:24:19'),
619 (192, 'sl_client_c4_doctor_W', 50, 29995, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 7, '2018-12-08 00:40:36'),
620 (193, 'H_PilotHelmetHeli_B', 50, 29997, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 4, '2018-11-29 18:23:48'),
621 (194, 'H_CrewHelmetHeli_B', 50, 29997, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 4, '2018-11-29 18:23:48'),
622 (195, 'TRYK_H_headsetcap_blk', 50, 29997, 'Clothing', 'Headgear', 'clothing_ems', 'ems', 4, '2018-11-29 18:23:48'),
623 (196, 'Commissioner_uni1', 50, 29996, 'Clothing', 'Uniform', 'clothing_ems', 'ems', 10, '2018-12-07 22:50:30');
624/*!40000 ALTER TABLE `company_shopsystem_prices` ENABLE KEYS */;
625
626-- Dumping structure for table rpframework.crafting_company
627CREATE TABLE IF NOT EXISTS `crafting_company` (
628 `company` varchar(255) CHARACTER SET utf8 NOT NULL,
629 PRIMARY KEY (`company`) USING BTREE
630) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
631
632-- Dumping data for table rpframework.crafting_company: ~2 rows (approximately)
633/*!40000 ALTER TABLE `crafting_company` DISABLE KEYS */;
634INSERT INTO `crafting_company` (`company`) VALUES
635 ('mafia'),
636 ('None');
637/*!40000 ALTER TABLE `crafting_company` ENABLE KEYS */;
638
639-- Dumping structure for table rpframework.crafting_data
640CREATE TABLE IF NOT EXISTS `crafting_data` (
641 `ID` int(11) NOT NULL AUTO_INCREMENT,
642 `item` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
643 `type` enum('weapon','item','clothing') CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
644 `requirements` varchar(10000) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL DEFAULT '[["",0]]',
645 `access` tinyint(2) NOT NULL DEFAULT '0',
646 `company` varchar(255) NOT NULL DEFAULT 'None',
647 `count` int(255) NOT NULL,
648 `limited` enum('no','yes') NOT NULL DEFAULT 'no',
649 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
650 PRIMARY KEY (`ID`) USING BTREE,
651 KEY `crafting_data_fk` (`company`) USING BTREE,
652 CONSTRAINT `crafting_data_fk` FOREIGN KEY (`company`) REFERENCES `crafting_company` (`company`) ON DELETE CASCADE ON UPDATE CASCADE
653) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
654
655-- Dumping data for table rpframework.crafting_data: ~57 rows (approximately)
656/*!40000 ALTER TABLE `crafting_data` DISABLE KEYS */;
657INSERT INTO `crafting_data` (`ID`, `item`, `type`, `requirements`, `access`, `company`, `count`, `limited`, `date`) VALUES
658 (1, 'arifle_mas_ww2_ppsh', 'weapon', '[["sl_item_ironore",1]]', 6, 'mafia', 0, 'no', '2018-11-27 20:33:02'),
659 (2, 'arifle_mas_ww2_tommy', 'weapon', '[["sl_item_ironore",1]]', 6, 'mafia', 0, 'no', '2018-11-27 20:33:03'),
660 (3, 'arifle_mas_ww2_mp40', 'weapon', '[["sl_item_ironore",1]]', 6, 'mafia', 0, 'no', '2018-11-27 20:33:06'),
661 (4, 'arifle_mas_ww2_sten', 'weapon', '[["sl_item_ironore",1]]', 6, 'mafia', 0, 'no', '2018-11-27 20:33:08'),
662 (5, 'RH_g18', 'weapon', '[["sl_item_ironore",1]]', 6, 'mafia', 0, 'no', '2018-11-27 20:33:16'),
663 (6, 'NP_DrugTable', 'item', '[["sl_item_ironore",1]]', 0, 'None', 0, 'no', '2018-11-15 22:41:23'),
664 (7, 'NP_GrowingPlot', 'item', '[["sl_item_ironore",1]]', 0, 'None', 0, 'no', '2018-11-15 22:41:23'),
665 (8, 'sl_client_c4_hazmat_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:02:48'),
666 (10, 'sl_client_c_jackoy1_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:02'),
667 (11, 'sl_client_c_jackoy2_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:07'),
668 (12, 'sl_client_c_jackoy3_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:08'),
669 (13, 'sl_client_c_jackoy4_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:19'),
670 (14, 'sl_client_c_jackoy5_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:18'),
671 (15, 'sl_client_c_jackoy6_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:18'),
672 (16, 'sl_client_c_jackoy7_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:17'),
673 (17, 'sl_client_c_jackoy8_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:14'),
674 (18, 'sl_client_c_suit_W_0', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:15'),
675 (19, 'sl_client_c_suit_W_1', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:29'),
676 (20, 'sl_client_c_suit_W_2', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:30'),
677 (21, 'sl_client_c_suit_W_3', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:30'),
678 (22, 'sl_client_c_suit_W_4', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-29 15:12:01'),
679 (23, 'sl_client_c_suit_W_5', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-29 15:12:04'),
680 (24, 'sl_client_c_payday_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:32'),
681 (25, 'sl_client_c_priest_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:33'),
682 (26, 'sl_client_c4_rocker_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:34'),
683 (27, 'sl_client_c4_rocker2_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:34'),
684 (28, 'sl_client_c4_rocker3_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:35'),
685 (29, 'sl_client_c4_rocker4_W', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:36'),
686 (30, 'sl_client_c_suit_W_0_D1M', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:36'),
687 (31, 'sl_client_c_suit_W_0_D1M1', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:37'),
688 (32, 'sl_client_c_suit_W_0_D1M2', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:37'),
689 (33, 'sl_client_c_suit_W_0_D1M3', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:38'),
690 (34, 'KAEL_SUITS_BLK_F', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:39'),
691 (35, 'KAEL_SUITS_BR_F', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:39'),
692 (36, 'KAEL_SUITS_BR_F10', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:40'),
693 (37, 'KAEL_SUITS_BR_F11', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:41'),
694 (38, 'KAEL_SUITS_BR_F12', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:47'),
695 (39, 'KAEL_SUITS_BR_F13', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:49'),
696 (40, 'KAEL_SUITS_BR_F14', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:48'),
697 (41, 'KAEL_SUITS_BR_F15', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:49'),
698 (42, 'KAEL_SUITS_BR_F16', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:50'),
699 (43, 'KAEL_SUITS_BR_F17', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:50'),
700 (44, 'KAEL_SUITS_BR_F18', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:51'),
701 (45, 'KAEL_SUITS_BR_F19', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:51'),
702 (46, 'KAEL_SUITS_BR_F20', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:52'),
703 (47, 'KAEL_SUITS_BR_F21', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:52'),
704 (48, 'KAEL_SUITS_BR_F22', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:53'),
705 (49, 'KAEL_SUITS_BR_F23', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:54'),
706 (50, 'KAEL_SUITS_BR_F24', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:54'),
707 (51, 'KAEL_SUITS_BR_F25', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:56'),
708 (52, 'KAEL_SUITS_BR_F3', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:55'),
709 (53, 'KAEL_SUITS_BR_F4', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:57'),
710 (54, 'KAEL_SUITS_BR_F5', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:57'),
711 (55, 'KAEL_SUITS_BR_F6', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:58'),
712 (56, 'KAEL_SUITS_BR_F7', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:03:59'),
713 (57, 'KAEL_SUITS_BR_F8', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:04:00'),
714 (58, 'KAEL_SUITS_BR_F9', 'clothing', '[["sl_item_cotton",15]]', 0, 'None', 0, 'no', '2018-11-27 21:04:00');
715/*!40000 ALTER TABLE `crafting_data` ENABLE KEYS */;
716
717-- Dumping structure for table rpframework.garage
718CREATE TABLE IF NOT EXISTS `garage` (
719 `id` int(11) NOT NULL AUTO_INCREMENT,
720 `classname` varchar(100) NOT NULL,
721 `owner` varchar(17) CHARACTER SET utf8mb4 NOT NULL COMMENT 'UID Właściciela',
722 `license` varchar(7) NOT NULL,
723 `hit` varchar(1000) NOT NULL,
724 `color` text NOT NULL,
725 `material` varchar(32) NOT NULL,
726 `rims` varchar(32) NOT NULL,
727 `windows` int(1) NOT NULL,
728 `lights` int(1) NOT NULL,
729 `fuel` varchar(15) NOT NULL,
730 `status` int(1) NOT NULL,
731 `type` enum('car','air','ship') NOT NULL DEFAULT 'car',
732 `typeColor` enum('rgb','texture') NOT NULL DEFAULT 'texture',
733 `deleted` enum('0','1') NOT NULL DEFAULT '0',
734 `upgrade` enum('1','2','3') NOT NULL DEFAULT '1',
735 `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
736 PRIMARY KEY (`id`) USING BTREE,
737 UNIQUE KEY `id` (`id`) USING BTREE,
738 UNIQUE KEY `license` (`license`) USING BTREE,
739 KEY `owner` (`owner`) USING BTREE,
740 KEY `deleted` (`deleted`) USING BTREE,
741 CONSTRAINT `garage_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
742) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
743
744-- Dumping data for table rpframework.garage: ~59 rows (approximately)
745/*!40000 ALTER TABLE `garage` DISABLE KEYS */;
746/*!40000 ALTER TABLE `garage` ENABLE KEYS */;
747
748-- Dumping structure for table rpframework.log_action
749CREATE TABLE IF NOT EXISTS `log_action` (
750 `ID` int(11) NOT NULL AUTO_INCREMENT,
751 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
752 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
753 `playerName` varchar(64) NOT NULL,
754 `playerCash` int(13) NOT NULL,
755 `playerBank` int(13) NOT NULL,
756 `playerItems` text NOT NULL,
757 `playerClothes` text NOT NULL,
758 `playerWeapons` text NOT NULL,
759 `type` text NOT NULL,
760 `text` text NOT NULL,
761 `unitUID` varchar(50) NOT NULL,
762 `unitName` varchar(64) NOT NULL,
763 `unitCash` int(13) NOT NULL,
764 `unitBank` int(13) NOT NULL,
765 `unitItems` text NOT NULL,
766 `unitClothes` text NOT NULL,
767 `unitWeapons` text NOT NULL,
768 PRIMARY KEY (`ID`) USING BTREE,
769 KEY `playerUID` (`playerUID`) USING BTREE,
770 KEY `unitUID` (`unitUID`) USING BTREE,
771 CONSTRAINT `log_action_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
772) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
773
774-- Dumping data for table rpframework.log_action: ~121 rows (approximately)
775/*!40000 ALTER TABLE `log_action` DISABLE KEYS */;
776/*!40000 ALTER TABLE `log_action` ENABLE KEYS */;
777
778-- Dumping structure for table rpframework.log_admin
779CREATE TABLE IF NOT EXISTS `log_admin` (
780 `ID` int(11) NOT NULL AUTO_INCREMENT,
781 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
782 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
783 `playerName` varchar(64) NOT NULL,
784 `playerCash` int(13) NOT NULL,
785 `playerBank` int(13) NOT NULL,
786 `playerItems` text NOT NULL,
787 `playerClothes` text NOT NULL,
788 `playerWeapons` text NOT NULL,
789 `type` text NOT NULL,
790 `text` text NOT NULL,
791 `unitUID` varchar(50) NOT NULL,
792 `unitName` varchar(64) NOT NULL,
793 `unitCash` int(13) NOT NULL,
794 `unitBank` int(13) NOT NULL,
795 `unitItems` text NOT NULL,
796 `unitClothes` text NOT NULL,
797 `unitWeapons` text NOT NULL,
798 PRIMARY KEY (`ID`) USING BTREE,
799 KEY `playerUID` (`playerUID`) USING BTREE,
800 CONSTRAINT `log_admin_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
801) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
802
803-- Dumping data for table rpframework.log_admin: ~0 rows (approximately)
804/*!40000 ALTER TABLE `log_admin` DISABLE KEYS */;
805/*!40000 ALTER TABLE `log_admin` ENABLE KEYS */;
806
807-- Dumping structure for table rpframework.log_connection
808CREATE TABLE IF NOT EXISTS `log_connection` (
809 `ID` int(11) NOT NULL AUTO_INCREMENT,
810 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
811 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
812 `playerName` varchar(64) NOT NULL,
813 `playerCash` int(13) NOT NULL,
814 `playerBank` int(13) NOT NULL,
815 `playerItems` text NOT NULL,
816 `playerClothes` text NOT NULL,
817 `playerWeapons` text NOT NULL,
818 `type` varchar(20) NOT NULL,
819 `text` varchar(255) NOT NULL,
820 PRIMARY KEY (`ID`) USING BTREE
821) ENGINE=InnoDB AUTO_INCREMENT=748 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
822
823-- Dumping data for table rpframework.log_connection: ~747 rows (approximately)
824/*!40000 ALTER TABLE `log_connection` DISABLE KEYS */;
825/*!40000 ALTER TABLE `log_connection` ENABLE KEYS */;
826
827-- Dumping structure for table rpframework.log_cop
828CREATE TABLE IF NOT EXISTS `log_cop` (
829 `ID` int(11) NOT NULL AUTO_INCREMENT,
830 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
831 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
832 `playerName` varchar(64) NOT NULL,
833 `playerCash` int(13) NOT NULL,
834 `playerBank` int(13) NOT NULL,
835 `playerItems` varchar(1500) NOT NULL,
836 `playerClothes` varchar(1500) NOT NULL,
837 `playerWeapons` varchar(1500) NOT NULL,
838 `type` varchar(20) NOT NULL,
839 `text` varchar(255) NOT NULL,
840 `unitUID` varchar(50) NOT NULL,
841 `unitName` varchar(64) NOT NULL,
842 `unitCash` int(13) NOT NULL,
843 `unitBank` int(13) NOT NULL,
844 `unitItems` varchar(1500) NOT NULL,
845 `unitClothes` varchar(1500) NOT NULL,
846 `unitWeapons` varchar(1500) NOT NULL,
847 PRIMARY KEY (`ID`) USING BTREE,
848 KEY `playerUID` (`playerUID`) USING BTREE,
849 CONSTRAINT `log_cop_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
850) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
851
852-- Dumping data for table rpframework.log_cop: ~0 rows (approximately)
853/*!40000 ALTER TABLE `log_cop` DISABLE KEYS */;
854/*!40000 ALTER TABLE `log_cop` ENABLE KEYS */;
855
856-- Dumping structure for table rpframework.log_craft
857CREATE TABLE IF NOT EXISTS `log_craft` (
858 `ID` int(11) NOT NULL AUTO_INCREMENT,
859 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
860 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
861 `playerName` varchar(64) NOT NULL,
862 `playerCash` int(13) NOT NULL,
863 `playerBank` int(13) NOT NULL,
864 `playerItems` text NOT NULL,
865 `playerClothes` text NOT NULL,
866 `playerWeapons` text NOT NULL,
867 `type` text NOT NULL,
868 `text` text NOT NULL,
869 `classname` varchar(255) NOT NULL,
870 PRIMARY KEY (`ID`) USING BTREE,
871 KEY `playerUID` (`playerUID`) USING BTREE,
872 CONSTRAINT `log_craft_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
873) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
874
875-- Dumping data for table rpframework.log_craft: ~0 rows (approximately)
876/*!40000 ALTER TABLE `log_craft` DISABLE KEYS */;
877/*!40000 ALTER TABLE `log_craft` ENABLE KEYS */;
878
879-- Dumping structure for table rpframework.log_death
880CREATE TABLE IF NOT EXISTS `log_death` (
881 `ID` int(11) NOT NULL AUTO_INCREMENT,
882 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
883 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
884 `playerName` varchar(64) NOT NULL,
885 `playerCash` int(13) NOT NULL,
886 `playerBank` int(13) NOT NULL,
887 `playerItems` text NOT NULL,
888 `playerClothes` text NOT NULL,
889 `playerWeapons` text NOT NULL,
890 `type` text NOT NULL,
891 `text` text NOT NULL,
892 `unitUID` varchar(50) NOT NULL,
893 `unitName` varchar(64) NOT NULL,
894 `unitCash` int(13) NOT NULL,
895 `unitBank` int(13) NOT NULL,
896 `unitItems` text NOT NULL,
897 `unitClothes` text NOT NULL,
898 `unitWeapons` text NOT NULL,
899 `weapon` varchar(100) NOT NULL,
900 `distance` varchar(100) NOT NULL,
901 `unix_date` int(10) DEFAULT NULL,
902 PRIMARY KEY (`ID`) USING BTREE,
903 KEY `playerUID` (`playerUID`) USING BTREE,
904 CONSTRAINT `log_death_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
905) ENGINE=InnoDB AUTO_INCREMENT=1682 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
906
907-- Dumping data for table rpframework.log_death: ~1,027 rows (approximately)
908/*!40000 ALTER TABLE `log_death` DISABLE KEYS */;
909/*!40000 ALTER TABLE `log_death` ENABLE KEYS */;
910
911-- Dumping structure for table rpframework.log_economy
912CREATE TABLE IF NOT EXISTS `log_economy` (
913 `ID` int(11) NOT NULL AUTO_INCREMENT,
914 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
915 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
916 `playerName` varchar(64) NOT NULL,
917 `playerCash` int(13) NOT NULL,
918 `playerBank` int(13) NOT NULL,
919 `playerItems` text NOT NULL,
920 `playerClothes` text NOT NULL,
921 `playerWeapons` text NOT NULL,
922 `type` text NOT NULL,
923 `text` text NOT NULL,
924 `unitUID` varchar(50) NOT NULL,
925 `unitName` varchar(64) NOT NULL,
926 `unitCash` int(13) NOT NULL,
927 `unitBank` int(13) NOT NULL,
928 `unitItems` text NOT NULL,
929 `unitClothes` text NOT NULL,
930 `unitWeapons` text NOT NULL,
931 `price` varchar(100) NOT NULL,
932 `item` varchar(100) NOT NULL,
933 `quantity` varchar(100) NOT NULL,
934 PRIMARY KEY (`ID`) USING BTREE,
935 KEY `playerUID` (`playerUID`) USING BTREE
936) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
937
938-- Dumping data for table rpframework.log_economy: ~351 rows (approximately)
939/*!40000 ALTER TABLE `log_economy` DISABLE KEYS */;
940/*!40000 ALTER TABLE `log_economy` ENABLE KEYS */;
941
942-- Dumping structure for table rpframework.log_hax
943CREATE TABLE IF NOT EXISTS `log_hax` (
944 `ID` int(11) NOT NULL AUTO_INCREMENT,
945 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
946 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
947 `playerName` varchar(64) NOT NULL,
948 `playerCash` int(13) NOT NULL,
949 `playerBank` int(13) NOT NULL,
950 `playerItems` text NOT NULL,
951 `playerClothes` text NOT NULL,
952 `playerWeapons` text NOT NULL,
953 `type` text NOT NULL,
954 `text` text NOT NULL,
955 `unitUID` varchar(50) NOT NULL,
956 `unitName` varchar(64) NOT NULL,
957 `unitCash` int(13) NOT NULL,
958 `unitBank` int(13) NOT NULL,
959 `unitItems` text NOT NULL,
960 `unitClothes` text NOT NULL,
961 `unitWeapons` text NOT NULL,
962 PRIMARY KEY (`ID`) USING BTREE,
963 KEY `playerUID` (`playerUID`) USING BTREE,
964 CONSTRAINT `log_hax_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
965) ENGINE=InnoDB AUTO_INCREMENT=120503 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
966
967-- Dumping data for table rpframework.log_hax: ~119,226 rows (approximately)
968/*!40000 ALTER TABLE `log_hax` DISABLE KEYS */;
969/*!40000 ALTER TABLE `log_hax` ENABLE KEYS */;
970
971-- Dumping structure for table rpframework.log_job
972CREATE TABLE IF NOT EXISTS `log_job` (
973 `ID` int(11) NOT NULL AUTO_INCREMENT,
974 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
975 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
976 `playerName` varchar(64) NOT NULL,
977 `playerCash` int(13) NOT NULL,
978 `playerBank` int(13) NOT NULL,
979 `playerItems` text NOT NULL,
980 `playerClothes` text NOT NULL,
981 `playerWeapons` text NOT NULL,
982 `type` text NOT NULL,
983 `text` text NOT NULL,
984 `unitUID` varchar(50) NOT NULL,
985 `unitName` varchar(64) NOT NULL,
986 `unitCash` int(13) NOT NULL,
987 `unitBank` int(13) NOT NULL,
988 `unitItems` text NOT NULL,
989 `unitClothes` text NOT NULL,
990 `unitWeapons` text NOT NULL,
991 PRIMARY KEY (`ID`) USING BTREE,
992 KEY `playerUID` (`playerUID`) USING BTREE,
993 CONSTRAINT `log_job_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
994) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
995
996-- Dumping data for table rpframework.log_job: ~0 rows (approximately)
997/*!40000 ALTER TABLE `log_job` DISABLE KEYS */;
998/*!40000 ALTER TABLE `log_job` ENABLE KEYS */;
999
1000-- Dumping structure for table rpframework.log_money
1001CREATE TABLE IF NOT EXISTS `log_money` (
1002 `ID` int(11) NOT NULL AUTO_INCREMENT,
1003 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1004 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
1005 `playerName` varchar(64) NOT NULL,
1006 `playerCash` int(13) NOT NULL,
1007 `playerBank` int(13) NOT NULL,
1008 `playerItems` text NOT NULL,
1009 `playerClothes` text NOT NULL,
1010 `playerWeapons` text NOT NULL,
1011 `type` text NOT NULL,
1012 `text` text NOT NULL,
1013 `unitUID` varchar(50) NOT NULL,
1014 `unitName` varchar(64) NOT NULL,
1015 `unitCash` int(13) NOT NULL,
1016 `unitBank` int(13) NOT NULL,
1017 `unitItems` text NOT NULL,
1018 `unitClothes` text NOT NULL,
1019 `unitWeapons` text NOT NULL,
1020 `amount` varchar(100) NOT NULL,
1021 PRIMARY KEY (`ID`) USING BTREE,
1022 KEY `playerUID` (`playerUID`) USING BTREE
1023) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1024
1025-- Dumping data for table rpframework.log_money: ~53 rows (approximately)
1026/*!40000 ALTER TABLE `log_money` DISABLE KEYS */;
1027/*!40000 ALTER TABLE `log_money` ENABLE KEYS */;
1028
1029-- Dumping structure for table rpframework.log_vehicle
1030CREATE TABLE IF NOT EXISTS `log_vehicle` (
1031 `ID` int(11) NOT NULL AUTO_INCREMENT,
1032 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1033 `playerUID` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
1034 `playerName` varchar(64) NOT NULL,
1035 `playerCash` int(13) NOT NULL,
1036 `playerBank` int(13) NOT NULL,
1037 `playerItems` text NOT NULL,
1038 `playerClothes` text NOT NULL,
1039 `playerWeapons` text NOT NULL,
1040 `type` varchar(20) NOT NULL,
1041 `text` text NOT NULL,
1042 `vehClassname` varchar(255) NOT NULL,
1043 `vehName` varchar(255) NOT NULL,
1044 PRIMARY KEY (`ID`) USING BTREE,
1045 KEY `playerUID` (`playerUID`) USING BTREE,
1046 CONSTRAINT `log_vehicle_ibfk_1` FOREIGN KEY (`playerUID`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE CASCADE
1047) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1048
1049-- Dumping data for table rpframework.log_vehicle: ~264 rows (approximately)
1050/*!40000 ALTER TABLE `log_vehicle` DISABLE KEYS */;
1051/*!40000 ALTER TABLE `log_vehicle` ENABLE KEYS */;
1052
1053-- Dumping structure for table rpframework.mafia_storage
1054CREATE TABLE IF NOT EXISTS `mafia_storage` (
1055 `content` varchar(15000) NOT NULL DEFAULT '[[[],[]],[[],[]],[[],[]],[[],[]]]',
1056 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
1057) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1058
1059-- Dumping data for table rpframework.mafia_storage: ~1 rows (approximately)
1060/*!40000 ALTER TABLE `mafia_storage` DISABLE KEYS */;
1061INSERT INTO `mafia_storage` (`content`, `date`) VALUES
1062 ('[[[],[]],[[],[]],[[],[]],[[],[]]]', '2018-10-03 20:59:22');
1063/*!40000 ALTER TABLE `mafia_storage` ENABLE KEYS */;
1064
1065-- Dumping structure for table rpframework.medical_data
1066CREATE TABLE IF NOT EXISTS `medical_data` (
1067 `ID` int(11) NOT NULL AUTO_INCREMENT,
1068 `uid` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
1069 `damage` float NOT NULL DEFAULT '0',
1070 `bleeding` int(11) NOT NULL DEFAULT '0',
1071 `face_hub` int(11) NOT NULL DEFAULT '0',
1072 `neck` int(11) NOT NULL DEFAULT '0',
1073 `head` int(11) NOT NULL DEFAULT '0',
1074 `pelvis` int(11) NOT NULL DEFAULT '0',
1075 `spine1` int(11) NOT NULL DEFAULT '0',
1076 `spine2` int(11) NOT NULL DEFAULT '0',
1077 `spine3` int(11) NOT NULL DEFAULT '0',
1078 `body` int(11) NOT NULL DEFAULT '0',
1079 `arms` int(11) NOT NULL DEFAULT '0',
1080 `hands` int(11) NOT NULL DEFAULT '0',
1081 `legs` int(11) NOT NULL DEFAULT '0',
1082 `sickness` int(11) NOT NULL DEFAULT '0',
1083 `poop` int(11) NOT NULL DEFAULT '15',
1084 `pee` int(11) NOT NULL DEFAULT '15',
1085 `food` int(11) NOT NULL DEFAULT '100',
1086 `water` int(11) NOT NULL DEFAULT '100',
1087 `respawn` int(3) NOT NULL DEFAULT '3',
1088 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1089 PRIMARY KEY (`ID`) USING BTREE,
1090 UNIQUE KEY `uid` (`uid`) USING BTREE,
1091 CONSTRAINT `medical_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
1092) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1093
1094-- Dumping data for table rpframework.medical_data: ~23 rows (approximately)
1095/*!40000 ALTER TABLE `medical_data` DISABLE KEYS */;
1096/*!40000 ALTER TABLE `medical_data` ENABLE KEYS */;
1097
1098-- Dumping structure for table rpframework.pdcomputer_awards
1099CREATE TABLE IF NOT EXISTS `pdcomputer_awards` (
1100 `ID` int(11) NOT NULL AUTO_INCREMENT,
1101 `uid_award` varchar(20) NOT NULL,
1102 `type` enum('plus','minus','approbation','reprimand') NOT NULL,
1103 PRIMARY KEY (`ID`) USING BTREE
1104) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1105
1106-- Dumping data for table rpframework.pdcomputer_awards: ~0 rows (approximately)
1107/*!40000 ALTER TABLE `pdcomputer_awards` DISABLE KEYS */;
1108/*!40000 ALTER TABLE `pdcomputer_awards` ENABLE KEYS */;
1109
1110-- Dumping structure for table rpframework.pdcomputer_jail
1111CREATE TABLE IF NOT EXISTS `pdcomputer_jail` (
1112 `id` int(11) NOT NULL AUTO_INCREMENT,
1113 `suspect` varchar(20) NOT NULL,
1114 `active` int(1) NOT NULL DEFAULT '1',
1115 `time_prison` int(3) NOT NULL,
1116 `time_left` int(3) NOT NULL,
1117 `reason` text NOT NULL,
1118 `officer` varchar(20) NOT NULL,
1119 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1120 PRIMARY KEY (`id`) USING BTREE
1121) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1122
1123-- Dumping data for table rpframework.pdcomputer_jail: ~2 rows (approximately)
1124/*!40000 ALTER TABLE `pdcomputer_jail` DISABLE KEYS */;
1125/*!40000 ALTER TABLE `pdcomputer_jail` ENABLE KEYS */;
1126
1127-- Dumping structure for table rpframework.pdcomputer_raports
1128CREATE TABLE IF NOT EXISTS `pdcomputer_raports` (
1129 `ID` int(11) NOT NULL AUTO_INCREMENT,
1130 `author` varchar(20) NOT NULL,
1131 `title` text NOT NULL,
1132 `text` text NOT NULL,
1133 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1134 PRIMARY KEY (`ID`) USING BTREE
1135) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1136
1137-- Dumping data for table rpframework.pdcomputer_raports: ~0 rows (approximately)
1138/*!40000 ALTER TABLE `pdcomputer_raports` DISABLE KEYS */;
1139/*!40000 ALTER TABLE `pdcomputer_raports` ENABLE KEYS */;
1140
1141-- Dumping structure for table rpframework.pdcomputer_tickets
1142CREATE TABLE IF NOT EXISTS `pdcomputer_tickets` (
1143 `id` int(11) NOT NULL AUTO_INCREMENT,
1144 `suspect` varchar(255) NOT NULL,
1145 `reason` text NOT NULL,
1146 `amount` int(11) NOT NULL,
1147 `points` int(11) NOT NULL,
1148 `officer` varchar(255) NOT NULL,
1149 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1150 PRIMARY KEY (`id`) USING BTREE,
1151 KEY `suspect` (`suspect`) USING BTREE,
1152 KEY `officer` (`officer`) USING BTREE
1153) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1154
1155-- Dumping data for table rpframework.pdcomputer_tickets: ~0 rows (approximately)
1156/*!40000 ALTER TABLE `pdcomputer_tickets` DISABLE KEYS */;
1157/*!40000 ALTER TABLE `pdcomputer_tickets` ENABLE KEYS */;
1158
1159-- Dumping structure for table rpframework.pdcomputer_wanted
1160CREATE TABLE IF NOT EXISTS `pdcomputer_wanted` (
1161 `id` int(11) NOT NULL AUTO_INCREMENT,
1162 `suspect` varchar(255) NOT NULL,
1163 `description` varchar(255) NOT NULL,
1164 `reason` varchar(255) NOT NULL,
1165 `officer` varchar(255) NOT NULL,
1166 `active` int(1) NOT NULL DEFAULT '1',
1167 `wanted_level` int(1) NOT NULL DEFAULT '0',
1168 `uid_closed` varchar(20) DEFAULT NULL,
1169 `type` enum('person','vehicle') NOT NULL DEFAULT 'person',
1170 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1171 PRIMARY KEY (`id`) USING BTREE
1172) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1173
1174-- Dumping data for table rpframework.pdcomputer_wanted: ~0 rows (approximately)
1175/*!40000 ALTER TABLE `pdcomputer_wanted` DISABLE KEYS */;
1176/*!40000 ALTER TABLE `pdcomputer_wanted` ENABLE KEYS */;
1177
1178-- Dumping structure for table rpframework.phone_contacts
1179CREATE TABLE IF NOT EXISTS `phone_contacts` (
1180 `id` int(11) NOT NULL AUTO_INCREMENT,
1181 `player` varchar(50) CHARACTER SET latin1 NOT NULL,
1182 `name` varchar(50) CHARACTER SET latin1 NOT NULL,
1183 `number` varchar(10) CHARACTER SET latin1 NOT NULL,
1184 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1185 PRIMARY KEY (`id`) USING BTREE
1186) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1187
1188-- Dumping data for table rpframework.phone_contacts: ~9 rows (approximately)
1189/*!40000 ALTER TABLE `phone_contacts` DISABLE KEYS */;
1190/*!40000 ALTER TABLE `phone_contacts` ENABLE KEYS */;
1191
1192-- Dumping structure for table rpframework.phone_data
1193CREATE TABLE IF NOT EXISTS `phone_data` (
1194 `ID` int(11) NOT NULL AUTO_INCREMENT,
1195 `number` varchar(10) NOT NULL,
1196 `balance` int(13) NOT NULL DEFAULT '50',
1197 `ring` int(3) NOT NULL DEFAULT '1',
1198 `skin` int(3) NOT NULL DEFAULT '1',
1199 `background` int(10) NOT NULL DEFAULT '1',
1200 `darknet` int(3) NOT NULL DEFAULT '0',
1201 `uid` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
1202 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1203 PRIMARY KEY (`ID`) USING BTREE,
1204 KEY `uid` (`uid`) USING BTREE,
1205 CONSTRAINT `phone_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
1206) ENGINE=InnoDB AUTO_INCREMENT=3598 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1207
1208-- Dumping data for table rpframework.phone_data: ~28 rows (approximately)
1209/*!40000 ALTER TABLE `phone_data` DISABLE KEYS */;
1210/*!40000 ALTER TABLE `phone_data` ENABLE KEYS */;
1211
1212-- Dumping structure for table rpframework.phone_messages
1213CREATE TABLE IF NOT EXISTS `phone_messages` (
1214 `id` int(11) NOT NULL AUTO_INCREMENT,
1215 `message` text NOT NULL,
1216 `sender` varchar(64) CHARACTER SET latin1 NOT NULL,
1217 `number` varchar(64) CHARACTER SET latin1 NOT NULL,
1218 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1219 PRIMARY KEY (`id`) USING BTREE
1220) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
1221
1222-- Dumping data for table rpframework.phone_messages: ~0 rows (approximately)
1223/*!40000 ALTER TABLE `phone_messages` DISABLE KEYS */;
1224/*!40000 ALTER TABLE `phone_messages` ENABLE KEYS */;
1225
1226-- Dumping structure for table rpframework.playercards_data
1227CREATE TABLE IF NOT EXISTS `playercards_data` (
1228 `ID` int(10) NOT NULL AUTO_INCREMENT,
1229 `type` varchar(255) NOT NULL,
1230 `data` varchar(1000) NOT NULL,
1231 `uid` varchar(17) CHARACTER SET utf8mb4 NOT NULL,
1232 PRIMARY KEY (`ID`) USING BTREE,
1233 KEY `uid` (`uid`) USING BTREE,
1234 CONSTRAINT `playercards_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
1235) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1236
1237-- Dumping data for table rpframework.playercards_data: ~47 rows (approximately)
1238/*!40000 ALTER TABLE `playercards_data` DISABLE KEYS */;
1239/*!40000 ALTER TABLE `playercards_data` ENABLE KEYS */;
1240
1241-- Dumping structure for table rpframework.server_settings
1242CREATE TABLE IF NOT EXISTS `server_settings` (
1243 `donation_goal` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
1244 `sync_version` tinyint(1) NOT NULL,
1245 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1246 PRIMARY KEY (`donation_goal`) USING BTREE
1247) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1248
1249-- Dumping data for table rpframework.server_settings: ~1 rows (approximately)
1250/*!40000 ALTER TABLE `server_settings` DISABLE KEYS */;
1251INSERT INTO `server_settings` (`donation_goal`, `sync_version`, `date`) VALUES
1252 ('0', 28, '2018-05-27 00:28:40');
1253/*!40000 ALTER TABLE `server_settings` ENABLE KEYS */;
1254
1255-- Dumping structure for table rpframework.shopsystem_prices
1256CREATE TABLE IF NOT EXISTS `shopsystem_prices` (
1257 `ID` int(50) NOT NULL AUTO_INCREMENT,
1258 `classname` varchar(255) NOT NULL,
1259 `price` int(50) NOT NULL,
1260 `count` int(50) NOT NULL,
1261 `type` enum('Weapon','Item','Clothing','Backpack') NOT NULL DEFAULT 'Item',
1262 `clothing_type` enum('None','Uniform','Backpack','Vest','Goggles','Headgear') NOT NULL DEFAULT 'None',
1263 `shop` enum('general','gunstore','clothing','backpack','vest','mcdonalds','hotdogs','donuts','pizza','bar','head','donor_clothing','illegal','donor_gunstore','clothing_luxure','clothing_militar','glasses') DEFAULT NULL,
1264 PRIMARY KEY (`ID`) USING BTREE,
1265 KEY `classname` (`classname`) USING BTREE
1266) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1267
1268-- Dumping data for table rpframework.shopsystem_prices: ~360 rows (approximately)
1269/*!40000 ALTER TABLE `shopsystem_prices` DISABLE KEYS */;
1270INSERT INTO `shopsystem_prices` (`ID`, `classname`, `price`, `count`, `type`, `clothing_type`, `shop`) VALUES
1271 (1, 'sl_item_bandage', 50, 29925, 'Item', 'None', 'general'),
1272 (2, 'sl_item_first_aid_kit', 300, 29989, 'Item', 'None', 'general'),
1273 (3, 'ItemMap', 50, 29996, 'Item', 'None', 'general'),
1274 (4, 'ItemCompass', 35, 29998, 'Item', 'None', 'general'),
1275 (6, 'Itemwatch', 25, 29998, 'Item', 'None', 'general'),
1276 (7, 'sl_item_groceries_healthy_2', 1500, 29987, 'Item', 'None', 'general'),
1277 (8, 'sl_item_groceries_unhealthy_1', 500, 29997, 'Item', 'None', 'general'),
1278 (9, 'sl_item_food_dickdeli', 100, 29998, 'Item', 'None', 'general'),
1279 (10, 'sl_item_food_campbell', 100, 29998, 'Item', 'None', 'general'),
1280 (11, 'sl_item_food_bumblebee', 100, 29997, 'Item', 'None', 'general'),
1281 (12, 'sl_item_food_tacbac', 100, 29998, 'Item', 'None', 'general'),
1282 (13, 'sl_item_gopro', 2500, 29993, 'Item', 'None', 'general'),
1283 (14, 'sl_item_drink_monster', 250, 29990, 'Item', 'None', 'general'),
1284 (15, 'sl_item_drink_water', 100, 29998, 'Item', 'None', 'general'),
1285 (16, 'sl_item_food_pedigree', 100, 29997, 'Item', 'None', 'general'),
1286 (17, 'ToolKit', 200, 29992, 'Item', 'None', 'general'),
1287 (18, 'sl_item_pizza_cheese', 200, 29997, 'Item', 'None', 'pizza'),
1288 (19, 'sl_item_pizza_hawaiian', 200, 29998, 'Item', 'None', 'pizza'),
1289 (22, 'sl_item_pizza_meatlovers', 200, 29998, 'Item', 'None', 'pizza'),
1290 (23, 'sl_item_pizza_supreme', 200, 29998, 'Item', 'None', 'pizza'),
1291 (24, 'sl_item_pizza_vegetarian', 200, 29998, 'Item', 'None', 'pizza'),
1292 (25, 'sl_item_pizza_lumberjack', 200, 29998, 'Item', 'None', 'pizza'),
1293 (26, 'sl_item_pizza_silesian', 200, 29998, 'Item', 'None', 'pizza'),
1294 (27, 'sl_item_pizza_capriciosa', 200, 29998, 'Item', 'None', 'pizza'),
1295 (28, 'sl_item_pizza_peperoni', 200, 29998, 'Item', 'None', 'pizza'),
1296 (29, 'sl_item_pizza_farmer', 200, 29998, 'Item', 'None', 'pizza'),
1297 (30, 'sl_item_donuts', 300, 29997, 'Item', 'None', 'donuts'),
1298 (31, 'sl_item_cdonuts', 300, 29998, 'Item', 'None', 'donuts'),
1299 (32, 'sl_item_jdonuts', 300, 29998, 'Item', 'None', 'donuts'),
1300 (33, 'sl_item_chdonuts', 300, 29998, 'Item', 'None', 'donuts'),
1301 (34, 'sl_item_psdonuts', 300, 29998, 'Item', 'None', 'donuts'),
1302 (36, 'sl_item_fastfood_cheeseburger', 100, 29997, 'Item', 'None', 'mcdonalds'),
1303 (37, 'sl_item_fastfood_bigmac', 100, 29997, 'Item', 'None', 'mcdonalds'),
1304 (38, 'sl_item_fastfood_happymeal', 100, 29998, 'Item', 'None', 'mcdonalds'),
1305 (39, 'sl_item_fastfood_mchicken', 100, 29997, 'Item', 'None', 'mcdonalds'),
1306 (49, 'RH_g17', 1100, 29997, 'Weapon', 'None', 'gunstore'),
1307 (50, 'RH_17Rnd_9x19_g17', 250, 29998, 'Item', 'None', 'gunstore'),
1308 (51, 'RH_uspm', 2500, 29997, 'Weapon', 'None', 'gunstore'),
1309 (52, 'RH_16Rnd_40cal_usp', 250, 29997, 'Item', 'None', 'gunstore'),
1310 (53, 'RH_kimber', 2000, 29996, 'Weapon', 'None', 'gunstore'),
1311 (54, 'RH_7Rnd_45cal_m1911', 250, 29995, 'Item', 'None', 'gunstore'),
1312 (55, 'RH_fn57', 1300, 29993, 'Weapon', 'None', 'gunstore'),
1313 (56, 'RH_fnp45', 1500, 29991, 'Item', 'None', 'gunstore'),
1314 (57, 'RH_20Rnd_57x28_FN', 250, 29958, 'Item', 'None', 'gunstore'),
1315 (58, 'RH_15Rnd_45cal_fnp', 250, 29959, 'Item', 'None', 'gunstore'),
1316 (59, 'cg_hatchet', 500, 29996, 'Weapon', 'None', 'gunstore'),
1317 (60, 'sharp_swing', 50, 29986, 'Item', 'None', 'gunstore'),
1318 (61, 'cg_bat', 500, 29994, 'Weapon', 'None', 'gunstore'),
1319 (62, 'nonlethal_swing', 50, 29991, 'Item', 'None', 'gunstore'),
1320 (63, 'CG_PICKAXE', 500, 29987, 'Weapon', 'None', 'gunstore'),
1321 (64, 'sharp_swing', 50, 29986, 'Item', 'None', 'gunstore'),
1322 (65, 'sl_c_weap_fish_rod_wood', 700, 29992, 'Weapon', 'None', 'gunstore'),
1323 (66, 'sl_c_weap_fish_bait', 150, 29992, 'Item', 'None', 'gunstore'),
1324 (67, 'SFG_Tac_smallBeardB', 100, 29991, 'Clothing', 'Goggles', 'glasses'),
1325 (68, 'SFG_Tac_smallBeardD', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1326 (69, 'SFG_Tac_smallBeardG', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1327 (70, 'SFG_Tac_smallBeardO', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1328 (71, 'SFG_Tac_BeardB', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1329 (72, 'SFG_Tac_BeardD', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1330 (73, 'SFG_Tac_BeardG', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1331 (74, 'SFG_Tac_BeardO', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1332 (75, 'SFG_Tac_chinlessbB', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1333 (76, 'SFG_Tac_chinlessbD', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1334 (77, 'SFG_Tac_chinlessbG', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1335 (78, 'SFG_Tac_chinlessbO', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1336 (79, 'SFG_Tac_moustacheB', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1337 (80, 'SFG_Tac_moustacheD', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1338 (81, 'SFG_Tac_moustacheG', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1339 (82, 'SFG_Tac_moustacheO', 100, 29992, 'Clothing', 'Goggles', 'glasses'),
1340 (83, 'SFG_Tac_ChopsB', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1341 (84, 'SFG_Tac_ChopsD', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1342 (85, 'SFG_Tac_ChopsG', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1343 (86, 'SFG_Tac_ChopsO', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1344 (87, 'TRYK_Beard_BK', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1345 (88, 'TRYK_Beard', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1346 (89, 'TRYK_Beard_BW', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1347 (90, 'TRYK_Beard_Gr', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1348 (91, 'TRYK_Beard_BK2', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1349 (92, 'TRYK_Beard2', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1350 (93, 'TRYK_Beard_BW2', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1351 (94, 'TRYK_Beard_Gr2', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1352 (95, 'TRYK_Beard_BK3', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1353 (96, 'TRYK_Beard3', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1354 (97, 'TRYK_Beard_BW3', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1355 (98, 'TRYK_Beard_Gr3', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1356 (99, 'TRYK_Beard_BK4', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1357 (100, 'TRYK_Beard4', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1358 (101, 'TRYK_Beard_BW4', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1359 (102, 'TRYK_Beard_Gr4', 100, 29993, 'Clothing', 'Goggles', 'glasses'),
1360 (103, 'EF_AC3', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1361 (104, 'EF_AC2', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1362 (105, 'EF_AC1', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1363 (106, 'EF_ACC1', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1364 (107, 'EF_ACC3', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1365 (108, 'EF_ACC2', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1366 (109, 'G_Shades_Black', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1367 (110, 'G_Shades_Blue', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1368 (111, 'G_Sport_Checkered', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1369 (113, 'G_Sport_Blackyellow', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1370 (114, 'G_Sport_BlackWhite', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1371 (115, 'G_Squares', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1372 (116, 'G_Aviator', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1373 (117, 'G_Lady_Mirror', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1374 (118, 'G_Lady_Dark', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1375 (119, 'G_Lady_Blue', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1376 (120, 'G_Lowprofile', 120, 29992, 'Clothing', 'Goggles', 'glasses'),
1377 (121, 'G_Combat', 120, 29993, 'Clothing', 'Goggles', 'glasses'),
1378 (123, 'ALE_H_Calot', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1379 (124, 'ALE_H_Cowboy_White', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1380 (125, 'ALE_H_Cowboy_Black', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1381 (126, 'ALE_H_Cowboy_Brown', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1382 (127, 'ALE_H_NewEra_Monster', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1383 (128, 'ALE_H_NewEra_Rouge', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1384 (129, 'ALE_H_NewEra_Superman', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1385 (130, 'ALE_H_NewEra_Cyan', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1386 (131, 'ALE_H_NewEra_Black', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1387 (132, 'ALE_H_NewEra_Lakers', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1388 (133, 'ALE_H_NewEra_Redsox', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1389 (134, 'H_Booniehat_khk', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1390 (135, 'H_Beret_blk', 120, 29992, 'Clothing', 'Headgear', 'glasses'),
1391 (136, 'H_Booniehat_oli', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1392 (137, 'H_Booniehat_tan', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1393 (138, 'TRYK_H_woolhat_WH', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1394 (139, 'TRYK_H_woolhat_tan', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1395 (140, 'TRYK_H_woolhat_CW', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1396 (141, 'TRYK_H_woolhat_cu', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1397 (142, 'TRYK_H_woolhat_br', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1398 (143, 'TRYK_H_woolhat', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1399 (144, 'TRYK_r_cap_tan_Glasses', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1400 (145, 'TRYK_r_cap_od_Glasses', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1401 (146, 'TRYK_r_cap_blk_Glasses', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1402 (147, 'TRYK_R_CAP_OD_US', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1403 (148, 'TRYK_R_CAP_TAN', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1404 (149, 'TRYK_R_CAP_BLK', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1405 (150, 'TRYK_H_pakol2', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1406 (151, 'TRYK_H_headsetcap', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1407 (152, 'TRYK_H_headsetcap_od', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1408 (153, 'TRYK_H_headsetcap_blk', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1409 (154, 'TRYK_H_headsetcap_blk_Glasses', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1410 (155, 'TRYK_H_headsetcap_Glasses', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1411 (156, 'TRYK_H_LHS_HEL_G', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1412 (157, 'TRYK_H_Bandana_wig_g', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1413 (158, 'TRYK_H_Bandana_wig', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1414 (159, 'TRYK_H_Bandana_H', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1415 (160, 'TRYK_Kio_Balaclava', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1416 (161, 'H_Cap_tan', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1417 (162, 'H_Cap_blk', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1418 (163, 'H_Cap_blk_CMMG', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1419 (164, 'H_Cap_brn_SPECOPS', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1420 (165, 'H_Cap_tan_specops_US', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1421 (166, 'H_Cap_khaki_specops_UK', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1422 (167, 'H_Cap_grn', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1423 (169, 'H_Cap_grn_BI', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1424 (170, 'H_Cap_blk_Raven', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1425 (171, 'H_Cap_blk_ION', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1426 (172, 'EF_Long_wig_B', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1427 (173, 'EF_Long_wig_BL', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1428 (174, 'EF_Long_wig_BW', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1429 (175, 'EF_Long_wig_GL', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1430 (176, 'EF_Punk_wig_B', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1431 (177, 'EF_Punk_wig_BL', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1432 (178, 'EF_Punk_wig_BW', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1433 (179, 'EF_Punk_wig_GL', 120, 29993, 'Clothing', 'Headgear', 'glasses'),
1434 (180, 'sl_client_c_civil01_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1435 (181, 'sl_client_c_civil01_10_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1436 (182, 'sl_client_c_civil01_02_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1437 (183, 'sl_client_c_civil01_03_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1438 (184, 'sl_client_c_civil01_04_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1439 (185, 'sl_client_c_civil01_05_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1440 (186, 'sl_client_c_civil01_06_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1441 (187, 'sl_client_c_civil01_07_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1442 (188, 'sl_client_c_civil01_08_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1443 (189, 'sl_client_c_civil01_09_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1444 (190, 'sl_client_c_civil02_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1445 (191, 'sl_client_c_civil02_02_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1446 (192, 'sl_client_c_civil02_03_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1447 (193, 'sl_client_c_civil02_04_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1448 (194, 'sl_client_c_civil02_05_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1449 (195, 'sl_client_c_civil02_06_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1450 (196, 'sl_client_c_civil02_07_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1451 (197, 'sl_client_c_civil02_08_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1452 (198, 'sl_client_c_civil03_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1453 (199, 'sl_client_c_civil03_02_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1454 (200, 'sl_client_c_civil03_03_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1455 (201, 'sl_client_c_civil03_04_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1456 (202, 'sl_client_c_civil03_05_W', 450, 29992, 'Clothing', 'Uniform', 'clothing'),
1457 (203, 'sl_client_c_civil03_05_W', 450, 29992, 'Clothing', 'Uniform', 'clothing'),
1458 (204, 'sl_client_c_civil03_07_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1459 (205, 'sl_client_c_civil04_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1460 (206, 'sl_client_c_civil05_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1461 (207, 'sl_client_c_civil05_02_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1462 (208, 'sl_client_c_civil05_03_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1463 (209, 'sl_client_c_civil05_04_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1464 (210, 'sl_client_c_civil05_05_W', 450, 29992, 'Clothing', 'Uniform', 'clothing'),
1465 (211, 'sl_client_c_civil05_06_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1466 (212, 'sl_client_c_civil05_07_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1467 (213, 'sl_client_c_civil06_01_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1468 (214, 'sl_client_c_civil06_02_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1469 (215, 'sl_client_c_civil06_03_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1470 (216, 'sl_client_c_civil06_04_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1471 (217, 'sl_client_c_civil06_05_W', 450, 29993, 'Clothing', 'Uniform', 'clothing'),
1472 (218, 'sl_client_c_nigga2_black_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1473 (219, 'sl_client_c_nigga2_blue_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1474 (220, 'sl_client_c_nigga2_green_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1475 (221, 'sl_client_c_nigga2_multi_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1476 (222, 'sl_client_c_nigga2_red_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1477 (223, 'sl_client_c_nigga2_white_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1478 (224, 'sl_client_c_nigga1_black_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1479 (225, 'sl_client_c_nigga1_blue_W', 350, 29992, 'Clothing', 'Uniform', 'clothing'),
1480 (226, 'sl_client_c_nigga1_green_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1481 (227, 'sl_client_c_nigga1_multi_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1482 (228, 'sl_client_c_nigga1_red_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1483 (229, 'sl_client_c_nigga1_white_W', 350, 29993, 'Clothing', 'Uniform', 'clothing'),
1484 (230, 'KAEL_SUITS_BR_F26', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1485 (231, 'KAEL_SUITS_BR_F27', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1486 (232, 'KAEL_SUITS_BR_F28', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1487 (233, 'KAEL_SUITS_BR_F29', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1488 (234, 'KAEL_SUITS_BR_F30', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1489 (235, 'KAEL_SUITS_BR_F31', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1490 (236, 'KAEL_SUITS_BR_F32', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1491 (237, 'KAEL_SUITS_BR_F33', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1492 (238, 'KAEL_SUITS_BR_F34', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1493 (239, 'KAEL_SUITS_BR_F35', 600, 29993, 'Clothing', 'Uniform', 'clothing'),
1494 (242, 'EF_FEM_3_2', 400, 29992, 'Clothing', 'Uniform', 'clothing'),
1495 (243, 'EF_FEM_3_3B', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1496 (244, 'EF_FEM_3_3BL', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1497 (245, 'EF_FEM_3_3B2', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1498 (246, 'EF_FEM_3_3PP2', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1499 (247, 'EF_FEM_3_42', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1500 (248, 'EF_FEM_3_3LPBR', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1501 (249, 'EF_FEM_3_3LPBW', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1502 (250, 'EF_FEM_3_3LPBP2', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1503 (251, 'EF_FEM_3_3LPBW2', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1504 (252, 'EF_FEM_3_52RC', 400, 29993, 'Clothing', 'Uniform', 'clothing'),
1505 (253, 'sl_client_c_carryall_invisible', 4000, 29984, 'Backpack', 'Backpack', 'backpack'),
1506 (254, 'sl_client_c_carryall_1', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1507 (255, 'sl_client_c_carryall_2', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1508 (256, 'sl_client_c_carryall_3', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1509 (257, 'sl_client_c_carryall_4', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1510 (258, 'sl_client_c_carryall_5', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1511 (259, 'sl_client_c_carryall_6', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1512 (260, 'sl_client_c_carryall_7', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1513 (261, 'sl_client_c_carryall_8', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1514 (262, 'sl_client_c_carryall_9', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1515 (263, 'sl_client_c_carryall_10', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1516 (264, 'sl_client_c_carryall_11', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1517 (265, 'sl_client_c_carryall_12', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1518 (266, 'sl_client_c_carryall_13', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1519 (267, 'sl_client_c_carryall_14', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1520 (268, 'sl_client_c_carryall_15', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1521 (269, 'sl_client_c_carryall_16', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1522 (270, 'sl_client_c_carryall_17', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1523 (271, 'sl_client_c_carryall_18', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1524 (272, 'sl_client_c_carryall_19', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1525 (273, 'sl_client_c_carryall_20', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1526 (274, 'sl_client_c_carryall_21', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1527 (275, 'sl_client_c_carryall_22', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1528 (276, 'sl_client_c_carryall_23', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1529 (277, 'sl_client_c_carryall_24', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1530 (278, 'sl_client_c_carryall_25', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1531 (279, 'sl_client_c_carryall_26', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1532 (280, 'sl_client_c_carryall_27', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1533 (281, 'sl_client_c_carryall_28', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1534 (282, 'sl_client_c_carryall_29', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1535 (284, 'sl_client_c_carryall_30', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1536 (285, 'sl_client_c_carryall_31', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1537 (286, 'sl_client_c_carryall_32', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1538 (287, 'sl_client_c_carryall_33', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1539 (288, 'sl_client_c_carryall_34', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1540 (289, 'sl_client_c_carryall_35', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1541 (290, 'sl_client_c_carryall_36', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1542 (291, 'sl_client_c_carryall_37', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1543 (292, 'sl_client_c_carryall_38', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1544 (293, 'sl_client_c_carryall_39', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1545 (294, 'sl_client_c_carryall_40', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1546 (295, 'sl_client_c_carryall_41', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1547 (296, 'sl_client_c_carryall_42', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1548 (297, 'sl_client_c_carryall_43', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1549 (298, 'sl_client_c_carryall_44', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1550 (299, 'sl_client_c_carryall_45', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1551 (300, 'sl_client_c_carryall_46', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1552 (301, 'sl_client_c_carryall_47', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1553 (302, 'sl_client_c_carryall_48', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1554 (303, 'sl_client_c_carryall_49', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1555 (304, 'sl_client_c_carryall_50', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1556 (305, 'sl_client_c_carryall_50', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1557 (306, 'sl_client_c_carryall_50', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1558 (307, 'sl_client_c_carryall_50', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1559 (308, 'sl_client_c_carryall_51', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1560 (309, 'sl_client_c_carryall_52', 2500, 29993, 'Backpack', 'Backpack', 'backpack'),
1561 (310, 'sl_client_c_backpack_civil01', 3400, 29993, 'Backpack', 'Backpack', 'backpack'),
1562 (311, 'sl_client_c_backpack_civil02_01', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1563 (312, 'sl_client_c_backpack_civil02_02', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1564 (313, 'sl_client_c_backpack_civil02_03', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1565 (314, 'sl_client_c_backpack_civil03_01', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1566 (315, 'sl_client_c_backpack_civil03_02', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1567 (316, 'sl_client_c_backpack_civil03_03', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1568 (317, 'sl_client_c_backpack_civil03_04', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1569 (318, 'sl_client_c_backpack_civil04_01', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1570 (319, 'sl_client_c_backpack_civil04_02', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1571 (320, 'sl_client_c_backpack_civil04_03', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1572 (321, 'sl_client_c_backpack_civil04_04', 2300, 29993, 'Backpack', 'Backpack', 'backpack'),
1573 (322, 'sl_client_c_backpack_civil05', 3100, 29993, 'Backpack', 'Backpack', 'backpack'),
1574 (323, 'sl_client_c_baglike_b', 500, 29991, 'Backpack', 'Backpack', 'backpack'),
1575 (324, 'sl_client_c_baglike_bl', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1576 (325, 'sl_client_c_baglike_gr', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1577 (326, 'sl_client_c_baglike_pink', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1578 (327, 'sl_client_c_baglike_pur', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1579 (328, 'sl_client_c_baglike_r', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1580 (329, 'sl_client_c_baglike_yel', 500, 29993, 'Backpack', 'Backpack', 'backpack'),
1581 (330, 'sl_client_c_masks_gangster_W', 600, 29993, 'Clothing', 'Headgear', 'head'),
1582 (331, 'sl_client_c5_cap_nike_blk_W', 250, 29992, 'Clothing', 'Headgear', 'head'),
1583 (332, 'sl_client_c5_cap_nike_blu_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1584 (333, 'sl_client_c5_cap_nike_grn_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1585 (334, 'sl_client_c5_cap_nike_grey_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1586 (335, 'sl_client_c5_cap_nike_navy_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1587 (336, 'sl_client_c5_cap_nike_org_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1588 (337, 'sl_client_c5_cap_nike_red_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1589 (338, 'sl_client_c5_cap_nike_wh_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1590 (339, 'sl_client_c5_cap_nike_ylw_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1591 (340, 'sl_client_c5_cap_polo_blk_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1592 (341, 'sl_client_c5_cap_polo_lblu_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1593 (342, 'sl_client_c5_cap_polo_navy_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1594 (343, 'sl_client_c5_cap_polo_pink_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1595 (344, 'sl_client_c5_cap_polo_red_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1596 (345, 'sl_client_c5_cap_polo_tan_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1597 (346, 'sl_client_c5_cap_polo_wh_W', 250, 29993, 'Clothing', 'Headgear', 'head'),
1598 (347, 'sl_client_c_hats_russian_W', 450, 29993, 'Clothing', 'Headgear', 'head'),
1599 (348, 'sl_client_c_masks_trump_W', 450, 29992, 'Clothing', 'Headgear', 'head'),
1600 (349, 'ALE_H_NewEra_Redsox', 350, 29993, 'Clothing', 'Headgear', 'head'),
1601 (350, 'ALE_H_NewEra_Rouge', 350, 29993, 'Clothing', 'Headgear', 'head'),
1602 (351, 'ALE_H_NewEra_Lakers', 350, 29993, 'Clothing', 'Headgear', 'head'),
1603 (352, 'ALE_H_NewEra_Cyan', 350, 29993, 'Clothing', 'Headgear', 'head'),
1604 (353, 'ALE_H_NewEra_Black', 350, 29993, 'Clothing', 'Headgear', 'head'),
1605 (354, 'ALE_H_NewEra_Monster', 350, 29992, 'Clothing', 'Headgear', 'head'),
1606 (355, 'ALE_H_NewEra_Superman', 350, 29993, 'Clothing', 'Headgear', 'head'),
1607 (356, 'mgsr_eyepatch_goggles', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1608 (357, 'G_Bandanna_aviator', 500, 29991, 'Clothing', 'Goggles', 'glasses'),
1609 (358, 'G_Bandanna_beast', 750, 29993, 'Clothing', 'Goggles', 'glasses'),
1610 (359, 'G_Bandanna_blk', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1611 (360, 'G_Bandanna_khk', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1612 (361, 'G_Bandanna_oli', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1613 (362, 'G_Bandanna_sport', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1614 (363, 'G_Bandanna_tan', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1615 (364, 'G_Lady_Blue', 150, 29993, 'Clothing', 'Goggles', 'glasses'),
1616 (365, 'nigga_platok', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1617 (366, 'nigga_platok2', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1618 (367, 'nigga_platok3', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1619 (368, 'nigga_platok4', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1620 (369, 'nigga_platok5', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1621 (370, 'nigga_platok6', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1622 (371, 'nigga_platok7', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1623 (372, 'nigga_platok8', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1624 (373, 'nigga_platok9', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1625 (374, 'nigga_platok10', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1626 (375, 'nigga_platok11', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1627 (376, 'nigga_platok12', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1628 (377, 'nigga_gog', 200, 29993, 'Clothing', 'Goggles', 'glasses'),
1629 (378, 'murshun_cigs_lighter', 50, 29986, 'Item', 'None', 'general'),
1630 (379, 'murshun_cigs_cigpack', 100, 29987, 'Item', 'None', 'general');
1631/*!40000 ALTER TABLE `shopsystem_prices` ENABLE KEYS */;
1632
1633-- Dumping structure for table rpframework.showroom_prices
1634CREATE TABLE IF NOT EXISTS `showroom_prices` (
1635 `ID` int(11) NOT NULL AUTO_INCREMENT,
1636 `classname` text NOT NULL,
1637 `price` int(50) NOT NULL,
1638 `count` int(50) NOT NULL DEFAULT '100',
1639 `comapny_id` int(11) NOT NULL DEFAULT '0',
1640 `type` enum('car','ship','air') NOT NULL DEFAULT 'car',
1641 `date` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
1642 PRIMARY KEY (`ID`) USING BTREE
1643) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
1644
1645-- Dumping data for table rpframework.showroom_prices: ~53 rows (approximately)
1646/*!40000 ALTER TABLE `showroom_prices` DISABLE KEYS */;
1647INSERT INTO `showroom_prices` (`ID`, `classname`, `price`, `count`, `comapny_id`, `type`, `date`) VALUES
1648 (1, 'ivory_m3', 45000, 95, 0, 'car', '2018-11-16 00:12:08'),
1649 (2, 'red_beetle_66_black', 15000, 96, 0, 'car', '2018-11-04 17:00:02'),
1650 (3, 'red_camaro_12_black', 160000, 96, 0, 'car', '2018-11-04 17:00:03'),
1651 (4, 'red_challenger_15_black', 135000, 95, 0, 'car', '2018-12-04 23:10:40'),
1652 (5, 'red_charger_12_black', 50000, 94, 0, 'car', '2018-12-08 01:03:28'),
1653 (6, 'red_charger_15_black', 65000, 96, 0, 'car', '2018-11-04 17:00:58'),
1654 (7, 'red_corvette_14_black', 180000, 95, 0, 'car', '2018-11-04 17:52:00'),
1655 (8, 'red_cvpi_06_black', 28000, 96, 0, 'car', '2018-11-04 17:01:03'),
1656 (9, 'red_explorer_16_black', 70000, 96, 0, 'car', '2018-11-04 17:01:07'),
1657 (10, 'red_f12_13_red', 190000, 92, 0, 'car', '2018-12-08 00:22:55'),
1658 (11, 'red_f350_08_black', 40000, 96, 0, 'car', '2018-11-04 17:01:10'),
1659 (12, 'red_fusion_10_black', 28000, 96, 0, 'car', '2018-11-04 17:01:12'),
1660 (13, 'red_gs350_13_black', 37000, 96, 0, 'car', '2018-11-04 17:01:13'),
1661 (14, 'red_panamera_10_black', 100000, 96, 0, 'car', '2018-11-04 17:01:16'),
1662 (15, 'red_porsche_12_black', 140000, 96, 0, 'car', '2018-11-04 17:01:18'),
1663 (16, 'red_ram_06_black', 35000, 96, 0, 'car', '2018-11-04 17:01:19'),
1664 (17, 'red_s65_12_black', 40000, 96, 0, 'car', '2018-11-04 17:01:19'),
1665 (18, 'red_suburban_15_black', 60000, 96, 0, 'car', '2018-11-04 17:01:19'),
1666 (19, 'red_taurus_10_black', 54000, 96, 0, 'car', '2018-11-04 17:01:19'),
1667 (20, 'red_vanquish_13_black', 120000, 96, 0, 'car', '2018-11-04 17:01:19'),
1668 (21, 'red_venomgt_11_black', 700000, 93, 0, 'car', '2018-12-08 00:54:37'),
1669 (22, 'red_x6_10_black', 40000, 96, 0, 'car', '2018-11-04 17:03:11'),
1670 (23, 'red_xkrs_12_black', 85000, 96, 0, 'car', '2018-11-04 17:03:11'),
1671 (24, 'red_eldorado_57_black', 20000, 96, 0, 'car', '2018-11-04 17:03:11'),
1672 (25, 'red_impala_64_black', 27000, 96, 0, 'car', '2018-11-04 17:03:11'),
1673 (26, 'red_kawasaki_10_black', 30000, 95, 0, 'car', '2018-12-08 18:31:14'),
1674 (27, 'red_nova_69_black', 28000, 96, 0, 'car', '2018-11-04 17:03:11'),
1675 (28, 'red_savana_04_black', 38000, 96, 0, 'car', '2018-11-04 17:03:11'),
1676 (29, 'red_sel300_72_black', 55000, 96, 0, 'car', '2018-11-04 17:03:11'),
1677 (30, 'red_tahoe_13_black', 48000, 96, 0, 'car', '2018-11-04 17:03:11'),
1678 (31, 'jf_gtr', 375000, 92, 0, 'car', '2018-12-08 18:32:06'),
1679 (32, 'jf_tesla_x', 190000, 95, 0, 'car', '2018-11-30 18:33:04'),
1680 (33, 'jf_tesla_s', 215000, 96, 0, 'car', '2018-11-30 18:33:02'),
1681 (34, 'jf_levante', 130000, 96, 0, 'car', '2018-11-30 18:32:57'),
1682 (35, 'jf_mustang', 197000, 95, 0, 'car', '2018-11-30 18:45:51'),
1683 (36, 'jf_amg_gt', 310000, 96, 0, 'car', '2018-11-30 18:32:52'),
1684 (37, 'jf_e150', 55000, 95, 0, 'car', '2018-11-30 18:32:50'),
1685 (38, 'jf_silverado', 62000, 95, 0, 'car', '2018-12-08 02:48:30'),
1686 (39, 'jf_c10', 70000, 96, 0, 'car', '2018-11-30 18:32:42'),
1687 (40, 'jf_j40', 55000, 96, 0, 'car', '2018-11-30 18:32:39'),
1688 (41, 'jf_Camper_Mid', 60000, 96, 0, 'car', '2018-11-30 18:32:36'),
1689 (42, 'jf_sierra', 53000, 96, 0, 'car', '2018-11-30 18:32:31'),
1690 (43, 'jf_fairlane', 52000, 96, 0, 'car', '2018-11-30 18:32:28'),
1691 (44, 'jf_f350', 43000, 96, 0, 'car', '2018-11-30 18:32:25'),
1692 (45, 'jf_caprice_wagon', 80000, 96, 0, 'car', '2018-11-30 18:32:22'),
1693 (46, 'jf_buick_century', 60000, 96, 0, 'car', '2018-11-30 18:32:19'),
1694 (47, 'jf_caprice', 80000, 96, 0, 'car', '2018-11-30 18:32:17'),
1695 (48, 'jf_diplomat', 35000, 96, 0, 'car', '2018-11-30 18:32:15'),
1696 (49, 'jf_ltd_cv', 30000, 96, 0, 'car', '2018-11-30 18:32:12'),
1697 (50, 'jf_camper', 25000, 96, 0, 'car', '2018-11-30 18:32:09'),
1698 (51, 'jf_delta', 20000, 96, 0, 'car', '2018-11-30 18:32:07'),
1699 (52, 'jf_civ_biemdablju_m5_f90_t3', 20000, 0, 0, 'car', '2018-11-30 00:43:58'),
1700 (53, 'jf_diplomat', 100, 96, 2, 'car', '2018-12-08 01:08:48');
1701/*!40000 ALTER TABLE `showroom_prices` ENABLE KEYS */;
1702
1703-- Dumping structure for table rpframework.users
1704CREATE TABLE IF NOT EXISTS `users` (
1705 `ID` int(11) NOT NULL AUTO_INCREMENT,
1706 `uid` varchar(17) NOT NULL,
1707 `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
1708 `name` varchar(50) NOT NULL,
1709 `items` text NOT NULL,
1710 `clothes` text NOT NULL,
1711 `weapons` text NOT NULL,
1712 `cash` mediumint(9) NOT NULL,
1713 `bank` int(13) NOT NULL,
1714 `bankaccount` varchar(30) CHARACTER SET latin1 NOT NULL,
1715 `houselevel` enum('1','2','3','4','5','6','7','8','9','10') NOT NULL DEFAULT '1',
1716 `housecontent` varchar(15000) NOT NULL DEFAULT '[[[],[]],[[],[]],[[],[]],[[],[]]]',
1717 `exp_level` int(11) DEFAULT '0',
1718 `exp_total` int(11) NOT NULL DEFAULT '0',
1719 `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
1720 `exp_perks` text,
1721 `connection` int(1) NOT NULL DEFAULT '0',
1722 `admin` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
1723 `donor` enum('0','1') NOT NULL DEFAULT '0',
1724 `member_id` int(11) DEFAULT NULL,
1725 PRIMARY KEY (`ID`) USING BTREE,
1726 UNIQUE KEY `uid` (`uid`) USING BTREE,
1727 UNIQUE KEY `name` (`name`) USING BTREE
1728) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
1729
1730-- Dumping data for table rpframework.users: ~28 rows (approximately)
1731/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1732/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1733
1734-- Dumping structure for trigger rpframework.unix
1735SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
1736DELIMITER //
1737CREATE TRIGGER `unix` BEFORE INSERT ON `log_death` FOR EACH ROW SET new.unix_date = UNIX_TIMESTAMP(NOW())//
1738DELIMITER ;
1739SET SQL_MODE=@OLDTMP_SQL_MODE;
1740
1741/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1742/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1743/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;