· 6 years ago · Mar 08, 2019, 06:32 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET NAMES utf8 */;
3/*!50503 SET NAMES utf8mb4 */;
4/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6-- Start
7SELECT @ESX_PROPERTY_OFFICES := FALSE;
8
9CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
10USE `essentialmode`;
11
12-- ES -> Es Plugin Mysql -> sql.sql
13CREATE TABLE IF NOT EXISTS `users` (
14 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
15 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
16 `money` int(11) DEFAULT NULL,
17 `bank` int(11) DEFAULT NULL,
18 `permission_level` int(11) DEFAULT NULL,
19 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
20 `name` VARCHAR(50) NULL DEFAULT '', -- ES -> Es Plugin Mysql -> sql.sql
21 `skin` LONGTEXT NULL,
22 `job` varchar(50) NULL DEFAULT 'unemployed',
23 `job_grade` INT NULL DEFAULT 0,
24 `loadout` LONGTEXT NULL,
25 `position` VARCHAR(36) NULL,
26 `firstname` VARCHAR(50) NULL DEFAULT '', -- ESX -> Character -> Identity -> esx_identity.sql (devonduty/esx/esx_identity)
27 `lastname` VARCHAR(50) NULL DEFAULT '',
28 `dateofbirth` VARCHAR(25) NULL DEFAULT '',
29 `sex` VARCHAR(10) NULL DEFAULT '',
30 `height` VARCHAR(5) NULL DEFAULT '',
31 `backstory` varchar(9999) NULL DEFAULT '',
32 `is_dead` TINYINT(1) NULL DEFAULT '0', -- ESX -> Jobs -> Whitelisted -> Ambulance Job -> esx_ambulancejob.sql
33 `status` LONGTEXT NULL, -- ESX -> Needs -> Status -> esx_status.sql
34 `phone_number` VARCHAR(10) NULL, -- ESX -> Phone -> gcphone -> base.sql
35 `last_property` VARCHAR(255) NULL -- ESX -> Property -> esx_property.sql
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
37
38-- ESX -> Banking -> Billing -> esx_billing.sql
39CREATE TABLE IF NOT EXISTS `billing` (
40 `id` int(11) NOT NULL AUTO_INCREMENT,
41 `identifier` varchar(255) NOT NULL,
42 `sender` varchar(255) NOT NULL,
43 `target_type` varchar(50) NOT NULL,
44 `target` varchar(255) NOT NULL,
45 `label` varchar(255) NOT NULL,
46 `amount` int(11) NOT NULL,
47
48 PRIMARY KEY (`id`)
49);
50
51-- ESX -> Functionalities -> Jail -> esx_jail.sql
52CREATE TABLE IF NOT EXISTS jail (
53 identifier VARCHAR(100) NOT NULL,
54 jail_time int(10) NOT NULL,
55 PRIMARY KEY (identifier)
56);
57
58-- ESX -> Structure -> Addon Account -> esx_addonaccount.sql
59CREATE TABLE IF NOT EXISTS `addon_account` (
60 `name` varchar(60) NOT NULL,
61 `label` varchar(255) NOT NULL,
62 `shared` int(11) NOT NULL,
63
64 PRIMARY KEY (`name`)
65);
66
67CREATE TABLE IF NOT EXISTS `addon_account_data` (
68 `id` int(11) NOT NULL AUTO_INCREMENT,
69 `account_name` varchar(255) DEFAULT NULL,
70 `money` double NOT NULL,
71 `owner` varchar(255) DEFAULT NULL,
72
73 PRIMARY KEY (`id`)
74);
75
76-- ESX -> Structure -> Addon Inventory -> esx_addoninventory.sql
77CREATE TABLE IF NOT EXISTS `addon_inventory` (
78 `name` varchar(60) NOT NULL,
79 `label` varchar(255) NOT NULL,
80 `shared` int(11) NOT NULL,
81
82 PRIMARY KEY (`name`)
83);
84
85CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `inventory_name` varchar(255) NOT NULL,
88 `name` varchar(255) NOT NULL,
89 `count` int(11) NOT NULL,
90 `owner` varchar(60) DEFAULT NULL,
91
92 PRIMARY KEY (`id`)
93);
94
95-- ESX -> Structure -> Data Store -> esx_datastore.sql
96CREATE TABLE IF NOT EXISTS `datastore` (
97 `name` varchar(60) NOT NULL,
98 `label` varchar(255) NOT NULL,
99 `shared` int(11) NOT NULL,
100
101 PRIMARY KEY (`name`)
102);
103
104CREATE TABLE IF NOT EXISTS `datastore_data` (
105 `id` int(11) NOT NULL AUTO_INCREMENT,
106 `name` varchar(60) NOT NULL,
107 `owner` varchar(60),
108 `data` longtext,
109
110 INDEX index_datastore_name (`name`),
111 CONSTRAINT unique_datastore_owner_name UNIQUE (`owner`, `name`),
112
113 PRIMARY KEY (`id`)
114);
115-- ESX -> Vehicle -> License -> esx_license.sql
116CREATE TABLE IF NOT EXISTS `licenses` (
117 `type` varchar(60) NOT NULL,
118 `label` varchar(60) NOT NULL,
119
120 PRIMARY KEY (`type`)
121);
122
123CREATE TABLE IF NOT EXISTS `user_licenses` (
124 `id` int(11) NOT NULL AUTO_INCREMENT,
125 `type` varchar(60) NOT NULL,
126 `owner` varchar(60) NOT NULL,
127
128 PRIMARY KEY (`id`)
129);
130
131-- ESX -> Vehicle -> DMV School -> esx_dmvschool.sql (TRANSLATED)
132INSERT IGNORE INTO `licenses` (`type`, `label`) VALUES
133 ('dmv', 'Theoretische Fahrprüfung'),
134 ('drive', 'Auto Führerschein'),
135 ('drive_bike', 'Motorradführerschein'),
136 ('drive_truck', 'LKW-Lizenz')
137;
138
139-- ESX -> Vehicle -> Garage -> esx_garage.sql
140CREATE TABLE IF NOT EXISTS `user_parkings` (
141 `id` int(11) NOT NULL AUTO_INCREMENT,
142 `identifier` varchar(60) DEFAULT NULL,
143 `garage` varchar(60) DEFAULT NULL,
144 `zone` int(11) NOT NULL,
145 `vehicle` longtext,
146 PRIMARY KEY (`id`)
147);
148
149-- ESX -> Structure -> Society -> esx_society.sql
150CREATE TABLE IF NOT EXISTS `society_moneywash` (
151 `id` int(11) NOT NULL AUTO_INCREMENT,
152 `identifier` varchar(60) NOT NULL,
153 `society` varchar(60) NOT NULL,
154 `amount` int(11) NOT NULL,
155
156 PRIMARY KEY (`id`)
157);
158
159-- ES -> Extended -> es_extended.sql
160CREATE TABLE IF NOT EXISTS `items` (
161 `name` varchar(50) NOT NULL,
162 `label` varchar(50) NOT NULL,
163 `limit` int(11) NOT NULL DEFAULT '-1',
164 `rare` int(11) NOT NULL DEFAULT '0',
165 `can_remove` int(11) NOT NULL DEFAULT '1',
166
167 PRIMARY KEY (`name`)
168);
169
170CREATE TABLE IF NOT EXISTS `job_grades` (
171 `id` int(11) NOT NULL AUTO_INCREMENT,
172 `job_name` varchar(50) DEFAULT NULL,
173 `grade` int(11) NOT NULL,
174 `name` varchar(50) NOT NULL,
175 `label` varchar(50) NOT NULL,
176 `salary` int(11) NOT NULL,
177 `skin_male` longtext NOT NULL,
178 `skin_female` longtext NOT NULL,
179
180 PRIMARY KEY (`id`)
181);
182
183INSERT IGNORE INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');
184
185CREATE TABLE IF NOT EXISTS `jobs` (
186 `name` varchar(50) NOT NULL,
187 `label` varchar(50) DEFAULT NULL,
188 `whitelisted` BOOLEAN NOT NULL DEFAULT FALSE, -- ESX -> Jobs -> Job Listing -> esx_joblisting.sql
189 PRIMARY KEY (`name`)
190);
191
192INSERT IGNORE INTO `jobs` (`name`, `label`) VALUES ('unemployed','Unemployed');
193
194CREATE TABLE IF NOT EXISTS `user_accounts` (
195 `id` int(11) NOT NULL AUTO_INCREMENT,
196 `identifier` varchar(22) NOT NULL,
197 `name` varchar(50) NOT NULL,
198 `money` double NOT NULL DEFAULT '0',
199
200 PRIMARY KEY (`id`)
201);
202
203CREATE TABLE IF NOT EXISTS `user_inventory` (
204 `id` int(11) NOT NULL AUTO_INCREMENT,
205 `identifier` varchar(22) NOT NULL,
206 `item` varchar(50) NOT NULL,
207 `count` int(11) NOT NULL,
208
209 PRIMARY KEY (`id`)
210);
211
212-- ESX -> Character -> Accessories -> esx_accessories.sql
213INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
214 ('user_ears', 'Ohr Zubehör', 0),
215 ('user_glasses', 'Brillen', 0),
216 ('user_helmet', 'Helme', 0),
217 ('user_mask', 'Masken', 0)
218;
219
220-- ESX -> Shops -> Shops -> esx_shops.sql
221CREATE TABLE IF NOT EXISTS `shops` (
222 `id` int(11) NOT NULL AUTO_INCREMENT,
223 `store` varchar(100) NOT NULL,
224 `item` varchar(100) NOT NULL,
225 `price` int(11) NOT NULL,
226
227 PRIMARY KEY (`id`)
228);
229
230INSERT IGNORE INTO `shops` (store, item, price) VALUES
231 ('TwentyFourSeven','bread',30),
232 ('TwentyFourSeven','water',15),
233 ('RobsLiquor','bread',30),
234 ('RobsLiquor','water',15),
235 ('LTDgasoline','bread',30),
236 ('LTDgasoline','water',15)
237;
238
239-- ESX -> Character -> Drug Effects -> esx_drugeffects.sql
240INSERT IGNORE INTO `items` (name, label) VALUES
241 ('xanax', 'Xanax')
242;
243
244-- ESX -> Character -> Identity -> esx_identity.sql (devonduty/esx/esx_identity)
245CREATE TABLE IF NOT EXISTS `characters` (
246 `identifier` varchar(255) NOT NULL,
247 `firstname` varchar(255) NOT NULL,
248 `lastname` varchar(255) NOT NULL,
249 `dateofbirth` varchar(255) NOT NULL,
250 `sex` varchar(1) NOT NULL DEFAULT 'f',
251 `height` varchar(128) NOT NULL,
252 `backstory` varchar(9999) NULL DEFAULT ''
253);
254
255-- ESX -> Jobs -> Jobs -> esx_jobs.sql
256INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
257 ('caution', 'Caution', 0)
258;
259
260INSERT IGNORE INTO `jobs` (name, label) VALUES
261 ('slaughterer', 'Schlachterei'),
262 ('fisherman', 'Fischerei'),
263 ('miner', 'Bergbau'),
264 ('lumberjack', 'Holzbetrieb'),
265 ('fueler', 'Raffinerie'),
266 ('reporter', 'Kanal 7'),
267 ('tailor', 'Schneiderei')
268;
269
270INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
271 ('lumberjack', 0, 'employee', 'Mitarbeiter', 0, '{}', '{}'),
272 ('fisherman', 0, 'employee', 'Mitarbeiter', 0, '{}', '{}'),
273 ('fueler', 0, 'employee', 'Mitarbeiter', 0, '{}', '{}'),
274 ('reporter', 0, 'employee', 'Mitarbeiter', 0, '{}', '{}'),
275 ('tailor', 0, 'employee', 'Mitarbeiter', 0,'{\"mask_1\":0,\"arms\":1,\"glasses_1\":0,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":0,\"torso_1\":24,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":0,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":0,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":36,\"tshirt_2\":0,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":48,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}','{\"mask_1\":0,\"arms\":5,\"glasses_1\":5,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":1,\"torso_1\":52,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":1,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":23,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":42,\"tshirt_2\":4,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":36,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}'),
276 ('miner', 0, 'employee', 'Mitarbeiter', 0, '{"tshirt_2":1,"ears_1":8,"glasses_1":15,"torso_2":0,"ears_2":2,"glasses_2":3,"shoes_2":1,"pants_1":75,"shoes_1":51,"bags_1":0,"helmet_2":0,"pants_2":7,"torso_1":71,"tshirt_1":59,"arms":2,"bags_2":0,"helmet_1":0}', '{}'),
277 ('slaughterer',0,'employee','Mitarbeiter', 0,'{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":67,\"pants_1\":36,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":0,\"torso_1\":56,\"beard_2\":6,\"shoes_1\":12,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":15,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":0,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}','{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":72,\"pants_1\":45,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":1,\"torso_1\":49,\"beard_2\":6,\"shoes_1\":24,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":9,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":5,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}')
278;
279
280INSERT IGNORE INTO `items` (`name`, `label`, `limit`) VALUES
281 ('alive_chicken', 'lebendes Huhn', 20),
282 ('slaughtered_chicken', 'geschlachtetes Huhn', 20),
283 ('packaged_chicken', 'Hähnchenfilet', 100),
284 ('fish', 'Fisch', 100),
285 ('stone', 'Felsbrocken', 7),
286 ('washed_stone', 'gewaschener Felsbrocken', 7),
287 ('copper', 'Kupfer', 56),
288 ('iron', 'Eisen', 42),
289 ('gold', 'Gold', 21),
290 ('diamond', 'Diamant', 50),
291 ('wood', 'Holz', 20),
292 ('cutted_wood', 'Holzstämme', 20),
293 ('packaged_plank', 'Bretterpaket', 100),
294 ('petrol', 'Öl', 24),
295 ('petrol_raffin', 'bearbeitetes Öl', 24),
296 ('essence', 'Benzin', 24),
297 ('whool', 'Wolle', 40),
298 ('fabric', 'Tuch', 80),
299 ('clothe', 'Kleidung', 40)
300;
301
302-- ESX -> Jobs -> Whitelisted -> Ambulance Job -> esx_ambulancejob.sql
303INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
304 ('society_ambulance', 'Notdienst', 1)
305;
306
307INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
308 ('society_ambulance', 'Ambulance', 1)
309;
310
311INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
312 ('society_ambulance', 'Ambulance', 1)
313;
314
315INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
316 ('ambulance', 0, 'paramedic1', 'Paramedic I', 2000, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
317 ('ambulance', 1, 'paramedic2', 'Paramedic II', 3000, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
318 ('ambulance', 2, 'medic', 'Medic', 3250, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
319 ('ambulance', 3, 'firefighter1', 'Firefighter I', 3500, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
320 ('ambulance', 4, 'firefighter2', 'Firefighter II', 3750, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
321 ('ambulance', 5, 'lieutenant', 'Lieutenant', 4000, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
322 ('ambulance', 6, 'captianlsfd', 'Captian', 4500, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
323 ('ambulance', 7, 'batchief', 'Battalion Chief', 4750, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
324 ('ambulance', 8, 'chief', 'Chief', 5000, '{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}', '{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}')
325 ;
326
327INSERT IGNORE INTO `jobs` (name, label, whitelisted) VALUES
328 ('ambulance','Notdienst',TRUE)
329;
330
331INSERT IGNORE INTO `items` (name, label, `limit`) VALUES
332 ('bandage','Bandage', 20),
333 ('medikit','Medikit', 5)
334;
335
336-- ESX -> Jobs -> Whitelisted -> Banker Job -> esx_bankerjob.sql
337INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
338 ('society_banker','Bank',1),
339 ('bank_savings','Bank',0)
340;
341
342INSERT IGNORE INTO `jobs` (name, label,whitelisted) VALUES
343 ('banker','Banker',TRUE)
344;
345
346INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
347 ('banker',0,'advisor','Berater',10,'{}','{}'),
348 ('banker',1,'banker','Banker',20,'{}','{}'),
349 ('banker',2,'business_banker','Business Banker',30,'{}','{}'),
350 ('banker',3,'trader','Trader',40,'{}','{}'),
351 ('banker',4,'boss','Boss',0,'{}','{}')
352;
353
354-- ESX -> Jobs -> Whitelisted -> Mafia Job -> esx_mafiajob.sql
355INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
356 ('society_mafia','Mafia',1)
357;
358
359INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
360 ('society_mafia','Mafia',1)
361;
362
363INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
364 ('society_mafia', 'Mafia', 1)
365;
366
367INSERT IGNORE INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
368('mafia', 'Mafia', 1);
369
370
371INSERT IGNORE INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
372 ('mafia', 0, 'soldato', 'Anfänger', '0', '{}', '{}'),
373 ('mafia', 1, 'mafioso', 'mafioso', '0', '{}', '{}'),
374 ('mafia', 2, 'capo', 'Captain', '0', '{}', '{}'),
375 ('mafia', 3, 'assassin', 'Attentäter', '0', '{}', '{}'),
376 ('mafia', 4, 'consigliere', 'Berater', '0', '{}', '{}'),
377 ('mafia', 5, 'boss', 'The Godfather', '0', '{}', '{}')
378;
379
380-- ESX -> Jobs -> Whitelisted -> Mechanic Job -> esx_mechanicjob.sql
381INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
382 ('society_mechanic', 'Mechaniker', 1)
383;
384
385INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
386 ('society_mechanic', 'Mechaniker', 1)
387;
388
389INSERT IGNORE INTO `jobs` (name, label,whitelisted) VALUES
390 ('mechanic', 'Mechaniker',TRUE)
391;
392
393INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
394 ('mechanic', '0', 'azubi', 'Azubi', '700', '{}', '{}'),
395 ('mechanic', '1', 'geselle1', 'Geselle I', '1000', '{}', '{}'),
396 ('mechanic', '2', 'geselle2', 'Geselle II', '2000', '{}', '{}'),
397 ('mechanic', '3', 'geselle3', 'Geselle III', '2500', '{}', '{}'),
398 ('mechanic', '4', 'meister1', 'Meister I', '2800', '{}', '{}'),
399 ('mechanic', '5', 'meister2', 'Meister II', '3000', '{}', '{}'),
400 ('mechanic', '6', 'meister3', 'Meister III', '3300', '{}', '{}'),
401 ('mechanic', '7', 'manager', 'Manager', '3500', '{}', '{}'),
402 ('mechanic', '8', 'boss1', 'Stv. Geschäftsführer', '4000', '{}', '{}'),
403 ('mechanic', '9', 'boss', 'Geschäftsfüher', '5000', '{}', '{}')
404;
405
406INSERT IGNORE INTO `items` (name, label, `limit`) VALUES
407 ('gazbottle', 'Gasflasche', 11),
408 ('fixtool', 'Reparaturwerkzeuge', 6),
409 ('carotool', 'Werkzeuge', 4),
410 ('blowpipe', 'Lötlampe', 10),
411 ('fixkit', 'Reperaturset', 5),
412 ('carokit', 'Bodykit', 3)
413;
414
415INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
416 ('society_police','Polizei',1)
417;
418
419INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
420 ('society_police','Polizei',1)
421;
422
423INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
424 ('society_police', 'Polizei', 1)
425;
426
427INSERT IGNORE INTO `jobs` (name, label,whitelisted) VALUES
428 ('police', 'Polizei',TRUE)
429;
430
431INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
432 ('police', '0', 'officer1', 'Officer I', '1500', '{}', '{}'),
433 ('police', '1', 'officer2', 'Officer II', '1750', '{}', '{}'),
434 ('police', '2', 'officer3', 'Officer III', '2000', '{}', '{}'),
435 ('police', '3', 'sergeant1', 'Sergeant I', '3250', '{}', '{}'),
436 ('police', '4', 'sergeant2', 'Sergeant II', '3250', '{}', '{}'),
437 ('police', '5', 'sergeant3', 'Sergeant III', '3500', '{}', '{}'),
438 ('police', '6', 'detective1', 'Detective I', '3000', '{}', '{}'),
439 ('police', '7', 'detective2', 'Detective II', '3250', '{}', '{}'),
440 ('police', '8', 'detective3', 'Detective III', '3500', '{}', '{}'),
441 ('police', '9', 'lieutenant1', 'Lieutenant I', '3750', '{}', '{}'),
442 ('police', '10', 'lieutenant2', 'Lieutenant II', '4000', '{}', '{}'),
443 ('police', '11', 'captian', 'Captian', '4250', '{}', '{}'),
444 ('police', '12', 'commander', 'Commander', '4500', '{}', '{}'),
445 ('police', '13', 'boss1', 'Deputy Chief of Police', '4750', '{}', '{}'),
446 ('police', '15', 'boss', 'Chief of Police', '5000', '{}', '{}'),
447 ('police', '14', 'swat', 'SWAT/FIB', '4000', '{}', '{}')
448;
449
450CREATE TABLE IF NOT EXISTS `fine_types` (
451
452 `id` int(11) NOT NULL AUTO_INCREMENT,
453 `label` varchar(255) DEFAULT NULL,
454 `amount` int(11) DEFAULT NULL,
455 `category` int(11) DEFAULT NULL,
456
457 PRIMARY KEY (`id`)
458);
459
460INSERT IGNORE INTO `fine_types` VALUES ('1', 'Missbrauchen der Hupe', '30', '0');
461INSERT IGNORE INTO `fine_types` VALUES ('2', 'Vorfahrtstraße missachtet', '40', '0');
462INSERT IGNORE INTO `fine_types` VALUES ('3', 'Gegenverkehr', '250', '0');
463INSERT IGNORE INTO `fine_types` VALUES ('4', 'Unbefugtes Wenden', '250', '0');
464INSERT IGNORE INTO `fine_types` VALUES ('5', 'Off-Road fahren', '170', '0');
465INSERT IGNORE INTO `fine_types` VALUES ('6', 'Sicherheitsrichtlinien missachtet', '30', '0');
466INSERT IGNORE INTO `fine_types` VALUES ('7', 'Gefährliches halten', '150', '0');
467INSERT IGNORE INTO `fine_types` VALUES ('8', 'Nicht erlaubtes parken', '70', '0');
468INSERT IGNORE INTO `fine_types` VALUES ('9', 'Nicht respektieren des Rechtsfahrgebotes', '70', '0');
469INSERT IGNORE INTO `fine_types` VALUES ('10', 'Nicht einhaltender Priorität eines Rettungsfahrzeuges', '90', '0');
470INSERT IGNORE INTO `fine_types` VALUES ('11', 'Nicht angehalten nach Aufforderung', '105', '0');
471INSERT IGNORE INTO `fine_types` VALUES ('12', 'Bei Rot über die Ampel', '130', '0');
472INSERT IGNORE INTO `fine_types` VALUES ('13', 'gefährliches Überholmanöver', '100', '0');
473INSERT IGNORE INTO `fine_types` VALUES ('14', 'Fahrzeug nicht Verkehrstauglich', '100', '0');
474INSERT IGNORE INTO `fine_types` VALUES ('15', 'Fahren ohne Lizenz', '1500', '0');
475INSERT IGNORE INTO `fine_types` VALUES ('16', 'Hit and Run', '800', '0');
476INSERT IGNORE INTO `fine_types` VALUES ('17', 'zu schnell < 5 kmh', '90', '0');
477INSERT IGNORE INTO `fine_types` VALUES ('18', 'zu schnell 5-15 kmh', '120', '0');
478INSERT IGNORE INTO `fine_types` VALUES ('19', 'zu schnell 15-30 kmh', '180', '0');
479INSERT IGNORE INTO `fine_types` VALUES ('20', 'zu schnell > 30 kmh', '300', '0');
480INSERT IGNORE INTO `fine_types` VALUES ('21', 'Verkehrsbehinderung', '110', '1');
481INSERT IGNORE INTO `fine_types` VALUES ('22', 'Nicht Benutzung öffentlicher Straßen', '90', '1');
482INSERT IGNORE INTO `fine_types` VALUES ('23', 'Störung der öffentlichen Ordnung', '90', '1');
483INSERT IGNORE INTO `fine_types` VALUES ('24', 'Polizeieinsatz behindern', '130', '1');
484INSERT IGNORE INTO `fine_types` VALUES ('25', 'Beildigung an Zivilist', '75', '1');
485INSERT IGNORE INTO `fine_types` VALUES ('26', 'Polizist geringschätzen', '110', '1');
486INSERT IGNORE INTO `fine_types` VALUES ('27', 'verbale Bedrohung an Zivilist', '90', '1');
487INSERT IGNORE INTO `fine_types` VALUES ('28', 'verbale Bedrohung an Polizist', '150', '1');
488INSERT IGNORE INTO `fine_types` VALUES ('29', 'Illegale Demonstration', '250', '1');
489INSERT IGNORE INTO `fine_types` VALUES ('30', 'versuchte Bestechung', '1500', '1');
490INSERT IGNORE INTO `fine_types` VALUES ('31', 'Mit Messer in der Stadt bewaffnet', '120', '2');
491INSERT IGNORE INTO `fine_types` VALUES ('32', 'Mit tötlicher Waffe bewaffnet', '300', '2');
492INSERT IGNORE INTO `fine_types` VALUES ('33', 'Unbefugter Besitz einer Waffe (Standard-Lizenz)', '600', '2');
493INSERT IGNORE INTO `fine_types` VALUES ('34', 'Illegale Waffe', '700', '2');
494INSERT IGNORE INTO `fine_types` VALUES ('35', 'Einbruch/Aufbruch', '300', '2');
495INSERT IGNORE INTO `fine_types` VALUES ('36', 'Autodiebstahl', '1800', '2');
496INSERT IGNORE INTO `fine_types` VALUES ('37', 'Drogenverkauf', '1500', '2');
497INSERT IGNORE INTO `fine_types` VALUES ('38', 'Drogen herstellen', '1500', '2');
498INSERT IGNORE INTO `fine_types` VALUES ('39', 'Drogenbesitz', '650', '2');
499INSERT IGNORE INTO `fine_types` VALUES ('40', 'Zivile Geisel genommen', '1500', '2');
500INSERT IGNORE INTO `fine_types` VALUES ('41', 'Geiselnahme', '2000', '2');
501INSERT IGNORE INTO `fine_types` VALUES ('42', 'Waghalsiges Lenken', '650', '2');
502INSERT IGNORE INTO `fine_types` VALUES ('43', 'Ladenraub', '650', '2');
503INSERT IGNORE INTO `fine_types` VALUES ('44', 'Bankraub', '1500', '2');
504INSERT IGNORE INTO `fine_types` VALUES ('45', 'Schießen auf Zivilisten', '2000', '3');
505INSERT IGNORE INTO `fine_types` VALUES ('46', 'Schießen auf Beamten', '2500', '3');
506INSERT IGNORE INTO `fine_types` VALUES ('47', 'versuchterMord an Zivilisten', '3000', '3');
507INSERT IGNORE INTO `fine_types` VALUES ('48', 'versuchter Mord an einem Beamten', '5000', '3');
508INSERT IGNORE INTO `fine_types` VALUES ('49', 'Mord an Zivilisten', '10000', '3');
509INSERT IGNORE INTO `fine_types` VALUES ('50', 'Mord an Beamten', '30000', '3');
510INSERT IGNORE INTO `fine_types` VALUES ('51', 'versehentlicher Mord', '1800', '3');
511INSERT IGNORE INTO `fine_types` VALUES ('52', 'Firmenbetrug', '2000', '2');
512;
513
514-- ESX -> Jobs -> Non-Whitelisted -> Taxi Job -> esx_taxijob.sql
515INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
516 ('society_taxi', 'Taxi', 1)
517;
518
519INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
520 ('society_taxi', 'Taxi', 1)
521;
522
523INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
524 ('society_taxi', 'Taxi', 1)
525;
526
527INSERT IGNORE INTO `jobs` (name, label) VALUES
528 ('taxi', 'Taxi')
529;
530
531INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
532 ('taxi',0,'recrue','Rekrut',12,'{"hair_2":0,"hair_color_2":0,"torso_1":32,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":31,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":0,"age_2":0,"glasses_2":0,"ears_2":0,"arms":27,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":0,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":0,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":10,"pants_1":24}', '{"hair_2":0,"hair_color_2":0,"torso_1":57,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":38,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":1,"age_2":0,"glasses_2":0,"ears_2":0,"arms":21,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":1,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":5,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":49,"pants_1":11}'),
533 ('taxi',1,'novice','Anfänger',24,'{"hair_2":0,"hair_color_2":0,"torso_1":32,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":31,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":0,"age_2":0,"glasses_2":0,"ears_2":0,"arms":27,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":0,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":0,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":10,"pants_1":24}', '{"hair_2":0,"hair_color_2":0,"torso_1":57,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":38,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":1,"age_2":0,"glasses_2":0,"ears_2":0,"arms":21,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":1,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":5,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":49,"pants_1":11}'),
534 ('taxi',2,'experimente','Experte',36,'{"hair_2":0,"hair_color_2":0,"torso_1":26,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":57,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":4,"age_2":0,"glasses_2":0,"ears_2":0,"arms":11,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":0,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":0,"bproof_1":0,"mask_1":0,"decals_1":0,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":10,"pants_1":24}', '{"hair_2":0,"hair_color_2":0,"torso_1":57,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":38,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":1,"age_2":0,"glasses_2":0,"ears_2":0,"arms":21,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":1,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":5,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":49,"pants_1":11}'),
535 ('taxi',3,'uber','Schichtführer',48,'{"hair_2":0,"hair_color_2":0,"torso_1":26,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":57,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":4,"age_2":0,"glasses_2":0,"ears_2":0,"arms":11,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":0,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":0,"bproof_1":0,"mask_1":0,"decals_1":0,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":10,"pants_1":24}', '{"hair_2":0,"hair_color_2":0,"torso_1":57,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":38,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":1,"age_2":0,"glasses_2":0,"ears_2":0,"arms":21,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":1,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":5,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":49,"pants_1":11}'),
536 ('taxi',4,'boss','Chef',0,'{"hair_2":0,"hair_color_2":0,"torso_1":29,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":31,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":4,"age_2":0,"glasses_2":0,"ears_2":0,"arms":1,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":0,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":0,"bproof_1":0,"mask_1":0,"decals_1":0,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":4,"eyebrows_1":0,"face":0,"shoes_1":10,"pants_1":24}', '{"hair_2":0,"hair_color_2":0,"torso_1":57,"bags_1":0,"helmet_2":0,"chain_2":0,"eyebrows_3":0,"makeup_3":0,"makeup_2":0,"tshirt_1":38,"makeup_1":0,"bags_2":0,"makeup_4":0,"eyebrows_4":0,"chain_1":0,"lipstick_4":0,"bproof_2":0,"hair_color_1":0,"decals_2":0,"pants_2":1,"age_2":0,"glasses_2":0,"ears_2":0,"arms":21,"lipstick_1":0,"ears_1":-1,"mask_2":0,"sex":1,"lipstick_3":0,"helmet_1":-1,"shoes_2":0,"beard_2":0,"beard_1":0,"lipstick_2":0,"beard_4":0,"glasses_1":5,"bproof_1":0,"mask_1":0,"decals_1":1,"hair_1":0,"eyebrows_2":0,"beard_3":0,"age_1":0,"tshirt_2":0,"skin":0,"torso_2":0,"eyebrows_1":0,"face":0,"shoes_1":49,"pants_1":11}')
537;
538
539-- ESX -> Needs -> Basic Needs -> esx_basicneeds.sql
540INSERT IGNORE INTO `items` (`name`, `label`, `limit`) VALUES
541 ('bread', 'Brot', 10),
542 ('water', 'Wasser', 5)
543;
544
545-- ESX -> Phone -> gcphone -> base.sql
546CREATE TABLE IF NOT EXISTS `phone_app_chat` (
547 `id` int(11) NOT NULL AUTO_INCREMENT,
548 `channel` varchar(20) NOT NULL,
549 `message` varchar(255) NOT NULL,
550 `time` timestamp NOT NULL DEFAULT current_timestamp(),
551 PRIMARY KEY (`id`)
552) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
553
554CREATE TABLE IF NOT EXISTS `phone_calls` (
555 `id` int(11) NOT NULL AUTO_INCREMENT,
556 `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
557 `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
558 `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
559 `time` timestamp NOT NULL DEFAULT current_timestamp(),
560 `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
561 PRIMARY KEY (`id`)
562) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
563
564CREATE TABLE IF NOT EXISTS `phone_messages` (
565 `id` int(11) NOT NULL AUTO_INCREMENT,
566 `transmitter` varchar(10) NOT NULL,
567 `receiver` varchar(10) NOT NULL,
568 `message` varchar(255) NOT NULL DEFAULT '0',
569 `time` timestamp NOT NULL DEFAULT current_timestamp(),
570 `isRead` int(11) NOT NULL DEFAULT 0,
571 `owner` int(11) NOT NULL DEFAULT 0,
572 PRIMARY KEY (`id`)
573) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;
574
575CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
576 `id` int(11) NOT NULL AUTO_INCREMENT,
577 `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
578 `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
579 `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
580 PRIMARY KEY (`id`)
581) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
582
583-- ESX -> Shops -> Drugs -> esx_drugs.sql
584INSERT IGNORE INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES
585 ('cannabis', 'Cannabis', 40, 0, 1),
586 ('marijuana', 'Marihuana', 14, 0, 1)
587;
588
589INSERT IGNORE INTO `licenses` (`type`, `label`) VALUES
590 ('weed_processing', 'Weedverarbeitungslizenz')
591;
592
593-- ESX -> Shops -> Extra Items -> esx_extraitems.sql
594INSERT IGNORE INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES
595 ('drill', 'Bohrer', 1, 0, 1),
596 ('oxygen_mask', 'Sauerstoffmaske', -1, 0, 1),
597 ('bulletproof', 'Kugelsichere Weste', -1, 0, 1),
598 ('clip', 'Waffen-Clip', -1, 0, 1),
599 ('grip', 'Griff', -1, 0, 1),
600 ('flashlight', 'Taschenlampe', -1, 0, 1),
601 ('silent', 'Schalldämpfer', -1, 0, 1),
602 ('scope', 'Visier', -1, 0, 1),
603 ('advanced_scope', 'Erweitertes Visier', -1, 0, 1),
604 ('extended_magazine', 'Erweitertes Magazin', -1, 0, 1),
605 ('very_extended_magazine', 'Sehr erweitertes Magazin', -1, 0, 1),
606 ('yusuf', 'Luxus Skin', -1, 0, 1),
607 ('lowrider', 'Lowrider Skin', -1, 0, 1),
608 ('darknet', 'Dark Net', 1, 0, 1)
609;
610
611INSERT IGNORE INTO `shops` (store, item, price) VALUES
612 ('ExtraItemsShop', 'drill', 1000),
613 ('ExtraItemsShop', 'oxygen_mask', 500),
614 ('ExtraItemsShop', 'bulletproof', 2500),
615 ('ExtraItemsShop', 'clip', 5000),
616 ('ExtraItemsShop', 'grip', 100),
617 ('ExtraItemsShop', 'flashlight', 50),
618 ('ExtraItemsShop', 'silent', 250),
619 ('ExtraItemsShop', 'scope', 100),
620 ('ExtraItemsShop', 'advanced_scope', 150),
621 ('ExtraItemsShop', 'extended_magazine', 250),
622 ('ExtraItemsShop', 'very_extended_magazine', 500),
623 ('ExtraItemsShop', 'yusuf', 3000),
624 ('ExtraItemsShop', 'lowrider', 1500),
625 ('ExtraItemsShop', 'darknet', 250)
626;
627
628-- ESX -> Shops -> Vehicle Shops -> esx_vehicleshop.sql
629INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
630 ('society_cardealer','Händler',1)
631;
632
633INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
634 ('society_cardealer','Händler',1)
635;
636
637INSERT IGNORE INTO `jobs` (name, label,whitelisted) VALUES
638 ('cardealer','Händler',TRUE)
639;
640
641INSERT IGNORE INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
642 ('cardealer', '0', 'kauf1', 'Verkäufer I', '500', '{}', '{}'),
643 ('cardealer', '1', 'kauf2', 'Verkäufer II', '600', '{}', '{}'),
644 ('cardealer', '2', 'kauf3', 'Verkäufer III', '700', '{}', '{}'),
645 ('cardealer', '3', 'manager', 'Manager', '750', '{}', '{}'),
646 ('cardealer', '4', 'boss1', 'Stv. Geschäftsführer', '1000', '{}', '{}'),
647 ('cardealer', '5', 'boss', 'Geschäftsführer', '1750', '{}', '{}')
648;
649
650CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
651 `id` int(11) NOT NULL AUTO_INCREMENT,
652 `vehicle` varchar(255) NOT NULL,
653 `price` int(11) NOT NULL,
654
655 PRIMARY KEY (`id`)
656);
657
658CREATE TABLE IF NOT EXISTS `vehicle_sold` (
659 `client` VARCHAR(50) NOT NULL,
660 `model` VARCHAR(50) NOT NULL,
661 `plate` VARCHAR(50) NOT NULL,
662 `soldby` VARCHAR(50) NOT NULL,
663 `date` VARCHAR(50) NOT NULL,
664
665 PRIMARY KEY (`plate`)
666);
667
668CREATE TABLE IF NOT EXISTS `owned_vehicles` (
669 `owner` varchar(22) NOT NULL,
670 `plate` varchar(12) NOT NULL,
671 `vehicle` longtext,
672 `type` VARCHAR(20) NOT NULL DEFAULT 'car',
673 `job` VARCHAR(20) NOT NULL,
674 `stored` TINYINT(1) NOT NULL DEFAULT '0',
675 `vehicleType` VARCHAR(20) NULL DEFAULT 'car', -- ESX -> Shops -> Boat -> esx_boat.sql
676 PRIMARY KEY (`plate`)
677);
678
679CREATE TABLE IF NOT EXISTS `rented_vehicles` (
680 `vehicle` varchar(60) NOT NULL,
681 `plate` varchar(12) NOT NULL,
682 `player_name` varchar(255) NOT NULL,
683 `base_price` int(11) NOT NULL,
684 `rent_price` int(11) NOT NULL,
685 `owner` varchar(22) NOT NULL,
686
687 PRIMARY KEY (`plate`)
688);
689
690CREATE TABLE IF NOT EXISTS `vehicle_categories` (
691 `name` varchar(60) NOT NULL,
692 `label` varchar(60) NOT NULL,
693
694 PRIMARY KEY (`name`)
695);
696
697INSERT IGNORE INTO `vehicle_categories` (name, label) VALUES
698 ('compacts','Compacts'),
699 ('coupes','Coupés'),
700 ('sedans','Sedans'),
701 ('sports','Sports'),
702 ('sportsclassics','Sports Classics'),
703 ('super','Super'),
704 ('muscle','Muscle'),
705 ('offroad','Off Road'),
706 ('suvs','SUVs'),
707 ('vans','Vans'),
708 ('motorcycles','Motos')
709;
710
711CREATE TABLE IF NOT EXISTS `vehicles` (
712 `name` varchar(60) NOT NULL,
713 `model` varchar(60) NOT NULL,
714 `price` int(11) NOT NULL,
715 `category` varchar(60) DEFAULT NULL,
716
717 PRIMARY KEY (`model`)
718);
719
720INSERT IGNORE INTO `vehicles` (name, model, price, category) VALUES
721 ('Blade','blade',15000,'muscle'),
722 ('Buccaneer','buccaneer',18000,'muscle'),
723 ('Buccaneer Rider','buccaneer2',24000,'muscle'),
724 ('Chino','chino',15000,'muscle'),
725 ('Chino Luxe','chino2',19000,'muscle'),
726 ('Coquette BlackFin','coquette3',55000,'muscle'),
727 ('Dominator','dominator',35000,'muscle'),
728 ('Dukes','dukes',28000,'muscle'),
729 ('Gauntlet','gauntlet',30000,'muscle'),
730 ('Hotknife','hotknife',125000,'muscle'),
731 ('Faction','faction',20000,'muscle'),
732 ('Faction Rider','faction2',30000,'muscle'),
733 ('Faction XL','faction3',40000,'muscle'),
734 ('Nightshade','nightshade',65000,'muscle'),
735 ('Phoenix','phoenix',12500,'muscle'),
736 ('Picador','picador',18000,'muscle'),
737 ('Sabre Turbo','sabregt',20000,'muscle'),
738 ('Sabre GT','sabregt2',25000,'muscle'),
739 ('Slam Van','slamvan3',11500,'muscle'),
740 ('Tampa','tampa',16000,'muscle'),
741 ('Virgo','virgo',14000,'muscle'),
742 ('Vigero','vigero',12500,'muscle'),
743 ('Voodoo','voodoo',7200,'muscle'),
744 ('Blista','blista',8000,'compacts'),
745 ('Brioso R/A','brioso',18000,'compacts'),
746 ('Issi','issi2',10000,'compacts'),
747 ('Panto','panto',10000,'compacts'),
748 ('Prairie','prairie',12000,'compacts'),
749 ('Bison','bison',45000,'vans'),
750 ('Bobcat XL','bobcatxl',32000,'vans'),
751 ('Burrito','burrito3',19000,'vans'),
752 ('Burrito','gburrito2',29000,'vans'),
753 ('Camper','camper',42000,'vans'),
754 ('Gang Burrito','gburrito',45000,'vans'),
755 ('Journey','journey',6500,'vans'),
756 ('Minivan','minivan',13000,'vans'),
757 ('Moonbeam','moonbeam',18000,'vans'),
758 ('Moonbeam Rider','moonbeam2',35000,'vans'),
759 ('Paradise','paradise',19000,'vans'),
760 ('Rumpo','rumpo',15000,'vans'),
761 ('Rumpo Trail','rumpo3',19500,'vans'),
762 ('Surfer','surfer',12000,'vans'),
763 ('Youga','youga',10800,'vans'),
764 ('Youga Luxuary','youga2',14500,'vans'),
765 ('Asea','asea',5500,'sedans'),
766 ('Cognoscenti','cognoscenti',55000,'sedans'),
767 ('Emperor','emperor',8500,'sedans'),
768 ('Fugitive','fugitive',12000,'sedans'),
769 ('Glendale','glendale',6500,'sedans'),
770 ('Intruder','intruder',7500,'sedans'),
771 ('Premier','premier',8000,'sedans'),
772 ('Primo Custom','primo2',14000,'sedans'),
773 ('Regina','regina',5000,'sedans'),
774 ('Schafter','schafter2',25000,'sedans'),
775 ('Stretch','stretch',90000,'sedans'),
776 ('Super Diamond','superd',130000,'sedans'),
777 ('Tailgater','tailgater',30000,'sedans'),
778 ('Warrener','warrener',4000,'sedans'),
779 ('Washington','washington',9000,'sedans'),
780 ('Baller','baller2',40000,'suvs'),
781 ('Baller Sport','baller3',60000,'suvs'),
782 ('Cavalcade','cavalcade2',55000,'suvs'),
783 ('Contender','contender',70000,'suvs'),
784 ('Dubsta','dubsta',45000,'suvs'),
785 ('Dubsta Luxuary','dubsta2',60000,'suvs'),
786 ('Fhantom','fq2',17000,'suvs'),
787 ('Grabger','granger',50000,'suvs'),
788 ('Gresley','gresley',47500,'suvs'),
789 ('Huntley S','huntley',40000,'suvs'),
790 ('Landstalker','landstalker',35000,'suvs'),
791 ('Mesa','mesa',16000,'suvs'),
792 ('Mesa Trail','mesa3',40000,'suvs'),
793 ('Patriot','patriot',55000,'suvs'),
794 ('Radius','radi',29000,'suvs'),
795 ('Rocoto','rocoto',45000,'suvs'),
796 ('Seminole','seminole',25000,'suvs'),
797 ('XLS','xls',32000,'suvs'),
798 ('Btype','btype',62000,'sportsclassics'),
799 ('Btype Luxe','btype3',85000,'sportsclassics'),
800 ('Btype Hotroad','btype2',155000,'sportsclassics'),
801 ('Casco','casco',30000,'sportsclassics'),
802 ('Coquette Classic','coquette2',40000,'sportsclassics'),
803 ('Manana','manana',12800,'sportsclassics'),
804 ('Monroe','monroe',55000,'sportsclassics'),
805 ('Pigalle','pigalle',20000,'sportsclassics'),
806 ('Stinger','stinger',80000,'sportsclassics'),
807 ('Stinger GT','stingergt',75000,'sportsclassics'),
808 ('Stirling GT','feltzer3',65000,'sportsclassics'),
809 ('Z-Type','ztype',220000,'sportsclassics'),
810 ('Bifta','bifta',12000,'offroad'),
811 ('Bf Injection','bfinjection',16000,'offroad'),
812 ('Blazer','blazer',6500,'offroad'),
813 ('Blazer Sport','blazer4',8500,'offroad'),
814 ('Brawler','brawler',45000,'offroad'),
815 ('Bubsta 6x6','dubsta3',120000,'offroad'),
816 ('Dune Buggy','dune',8000,'offroad'),
817 ('Guardian','guardian',45000,'offroad'),
818 ('Rebel','rebel2',35000,'offroad'),
819 ('Sandking','sandking',55000,'offroad'),
820 ('The Liberator','monster',210000,'offroad'),
821 ('Trophy Truck','trophytruck',60000,'offroad'),
822 ('Trophy Truck Limited','trophytruck2',80000,'offroad'),
823 ('Cognoscenti Cabrio','cogcabrio',55000,'coupes'),
824 ('Exemplar','exemplar',32000,'coupes'),
825 ('F620','f620',40000,'coupes'),
826 ('Felon','felon',42000,'coupes'),
827 ('Felon GT','felon2',55000,'coupes'),
828 ('Jackal','jackal',38000,'coupes'),
829 ('Oracle XS','oracle2',35000,'coupes'),
830 ('Sentinel','sentinel',32000,'coupes'),
831 ('Sentinel XS','sentinel2',40000,'coupes'),
832 ('Windsor','windsor',95000,'coupes'),
833 ('Windsor Drop','windsor2',125000,'coupes'),
834 ('Zion','zion',36000,'coupes'),
835 ('Zion Cabrio','zion2',45000,'coupes'),
836 ('9F','ninef',65000,'sports'),
837 ('9F Cabrio','ninef2',80000,'sports'),
838 ('Alpha','alpha',60000,'sports'),
839 ('Banshee','banshee',70000,'sports'),
840 ('Bestia GTS','bestiagts',55000,'sports'),
841 ('Buffalo','buffalo',12000,'sports'),
842 ('Buffalo S','buffalo2',20000,'sports'),
843 ('Carbonizzare','carbonizzare',75000,'sports'),
844 ('Comet','comet2',65000,'sports'),
845 ('Coquette','coquette',65000,'sports'),
846 ('Drift Tampa','tampa2',80000,'sports'),
847 ('Elegy','elegy2',38500,'sports'),
848 ('Feltzer','feltzer2',55000,'sports'),
849 ('Furore GT','furoregt',45000,'sports'),
850 ('Fusilade','fusilade',40000,'sports'),
851 ('Jester','jester',65000,'sports'),
852 ('Jester(Racecar)','jester2',135000,'sports'),
853 ('Khamelion','khamelion',38000,'sports'),
854 ('Kuruma','kuruma',30000,'sports'),
855 ('Lynx','lynx',40000,'sports'),
856 ('Mamba','mamba',70000,'sports'),
857 ('Massacro','massacro',65000,'sports'),
858 ('Massacro(Racecar)','massacro2',130000,'sports'),
859 ('Omnis','omnis',35000,'sports'),
860 ('Penumbra','penumbra',28000,'sports'),
861 ('Rapid GT','rapidgt',35000,'sports'),
862 ('Rapid GT Convertible','rapidgt2',45000,'sports'),
863 ('Schafter V12','schafter3',50000,'sports'),
864 ('Seven 70','seven70',39500,'sports'),
865 ('Sultan','sultan',15000,'sports'),
866 ('Surano','surano',50000,'sports'),
867 ('Tropos','tropos',40000,'sports'),
868 ('Verlierer','verlierer2',70000,'sports'),
869 ('Adder','adder',900000,'super'),
870 ('Banshee 900R','banshee2',255000,'super'),
871 ('Bullet','bullet',90000,'super'),
872 ('Cheetah','cheetah',375000,'super'),
873 ('Entity XF','entityxf',425000,'super'),
874 ('ETR1','sheava',220000,'super'),
875 ('FMJ','fmj',185000,'super'),
876 ('Infernus','infernus',180000,'super'),
877 ('Osiris','osiris',160000,'super'),
878 ('Pfister','pfister811',85000,'super'),
879 ('RE-7B','le7b',325000,'super'),
880 ('Reaper','reaper',150000,'super'),
881 ('Sultan RS','sultanrs',65000,'super'),
882 ('T20','t20',300000,'super'),
883 ('Turismo R','turismor',350000,'super'),
884 ('Tyrus','tyrus',600000,'super'),
885 ('Vacca','vacca',120000,'super'),
886 ('Voltic','voltic',90000,'super'),
887 ('X80 Proto','prototipo',2500000,'super'),
888 ('Zentorno','zentorno',1500000,'super'),
889 ('Akuma','AKUMA',7500,'motorcycles'),
890 ('Avarus','avarus',18000,'motorcycles'),
891 ('Bagger','bagger',13500,'motorcycles'),
892 ('Bati 801','bati',12000,'motorcycles'),
893 ('Bati 801RR','bati2',19000,'motorcycles'),
894 ('BF400','bf400',6500,'motorcycles'),
895 ('BMX (velo)','bmx',160,'motorcycles'),
896 ('Carbon RS','carbonrs',18000,'motorcycles'),
897 ('Chimera','chimera',38000,'motorcycles'),
898 ('Cliffhanger','cliffhanger',9500,'motorcycles'),
899 ('Cruiser (velo)','cruiser',510,'motorcycles'),
900 ('Daemon','daemon',11500,'motorcycles'),
901 ('Daemon High','daemon2',13500,'motorcycles'),
902 ('Defiler','defiler',9800,'motorcycles'),
903 ('Double T','double',28000,'motorcycles'),
904 ('Enduro','enduro',5500,'motorcycles'),
905 ('Esskey','esskey',4200,'motorcycles'),
906 ('Faggio','faggio',1900,'motorcycles'),
907 ('Vespa','faggio2',2800,'motorcycles'),
908 ('Fixter (velo)','fixter',225,'motorcycles'),
909 ('Gargoyle','gargoyle',16500,'motorcycles'),
910 ('Hakuchou','hakuchou',31000,'motorcycles'),
911 ('Hakuchou Sport','hakuchou2',55000,'motorcycles'),
912 ('Hexer','hexer',12000,'motorcycles'),
913 ('Innovation','innovation',23500,'motorcycles'),
914 ('Manchez','manchez',5300,'motorcycles'),
915 ('Nemesis','nemesis',5800,'motorcycles'),
916 ('Nightblade','nightblade',35000,'motorcycles'),
917 ('PCJ-600','pcj',6200,'motorcycles'),
918 ('Ruffian','ruffian',6800,'motorcycles'),
919 ('Sanchez','sanchez',5300,'motorcycles'),
920 ('Sanchez Sport','sanchez2',5300,'motorcycles'),
921 ('Sanctus','sanctus',25000,'motorcycles'),
922 ('Scorcher (velo)','scorcher',280,'motorcycles'),
923 ('Sovereign','sovereign',22000,'motorcycles'),
924 ('Shotaro Concept','shotaro',320000,'motorcycles'),
925 ('Thrust','thrust',24000,'motorcycles'),
926 ('Tri bike (velo)','tribike3',520,'motorcycles'),
927 ('Vader','vader',7200,'motorcycles'),
928 ('Vortex','vortex',9800,'motorcycles'),
929 ('Woflsbane','wolfsbane',9000,'motorcycles'),
930 ('Zombie','zombiea',9500,'motorcycles'),
931 ('Zombie Luxuary','zombieb',12000,'motorcycles'),
932 ('blazer5', 'blazer5', 1755600, 'offroad'),
933 ('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
934 ('Voltic 2', 'voltic2', 3830400, 'super'),
935 ('Ardent', 'ardent', 1150000, 'sportsclassics'),
936 ('Oppressor', 'oppressor', 3524500, 'super'),
937 ('Visione', 'visione', 2250000, 'super'),
938 ('Retinue', 'retinue', 615000, 'sportsclassics'),
939 ('Cyclone', 'cyclone', 1890000, 'super'),
940 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
941 ('raiden', 'raiden', 1375000, 'sports'),
942 ('Yosemite', 'yosemite', 485000, 'muscle'),
943 ('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
944 ('Pariah', 'pariah', 1420000, 'sports'),
945 ('Stromberg', 'stromberg', 3185350, 'sports'),
946 ('SC 1', 'sc1', 1603000, 'super'),
947 ('riata', 'riata', 380000, 'offroad'),
948 ('Hermes', 'hermes', 535000, 'muscle'),
949 ('Savestra', 'savestra', 990000, 'sportsclassics'),
950 ('Streiter', 'streiter', 500000, 'sports'),
951 ('Kamacho', 'kamacho', 345000, 'offroad'),
952 ('GT 500', 'gt500', 785000, 'sportsclassics'),
953 ('Z190', 'z190', 900000, 'sportsclassics'),
954 ('Viseris', 'viseris', 875000, 'sportsclassics'),
955 ('Autarch', 'autarch', 1955000, 'super'),
956 ('Comet 5', 'comet5', 1145000, 'sports'),
957 ('Neon', 'neon', 1500000, 'sports'),
958 ('Revolter', 'revolter', 1610000, 'sports'),
959 ('Sentinel3', 'sentinel3', 650000, 'sports'),
960 ('Hustler', 'hustler', 625000, 'muscle')
961;
962
963-- ESX -> Shops -> Boat -> esx_boat.sql
964INSERT IGNORE INTO `licenses` (`type`, `label`) VALUES
965 ('boat', 'Bootslizenz')
966;
967
968-- ESX -> Shops -> Weapon Shops -> esx_weaponshop.sql
969CREATE TABLE IF NOT EXISTS `weashops` (
970 `id` int(11) NOT NULL AUTO_INCREMENT,
971 `zone` varchar(255) NOT NULL,
972 `item` varchar(255) NOT NULL,
973 `price` int(11) NOT NULL,
974
975 PRIMARY KEY (`id`)
976);
977
978INSERT IGNORE INTO `licenses` (`type`, `label`) VALUES
979 ('weapon', "Waffenlizenz")
980;
981
982INSERT IGNORE INTO `weashops` (`zone`, `item`, `price`) VALUES
983 ('GunShop','WEAPON_PISTOL', 300),
984 ('BlackWeashop','WEAPON_PISTOL', 500),
985 ('GunShop', 'WEAPON_FLASHLIGHT', 60),
986 ('BlackWeashop', 'WEAPON_FLASHLIGHT', 70),
987 ('GunShop', 'WEAPON_MACHETE', 90),
988 ('BlackWeashop', 'WEAPON_MACHETE', 110),
989 ('GunShop', 'WEAPON_NIGHTSTICK', 150),
990 ('BlackWeashop', 'WEAPON_NIGHTSTICK', 150),
991 ('GunShop', 'WEAPON_BAT', 100),
992 ('BlackWeashop', 'WEAPON_BAT', 100),
993 ('GunShop', 'WEAPON_STUNGUN', 50),
994 ('BlackWeashop', 'WEAPON_STUNGUN', 50),
995 ('GunShop', 'WEAPON_MICROSMG', 1400),
996 ('BlackWeashop', 'WEAPON_MICROSMG', 1700),
997 ('GunShop', 'WEAPON_PUMPSHOTGUN', 3400),
998 ('BlackWeashop', 'WEAPON_PUMPSHOTGUN', 3500),
999 ('GunShop', 'WEAPON_ASSAULTRIFLE', 10000),
1000 ('BlackWeashop', 'WEAPON_ASSAULTRIFLE', 11000),
1001 ('GunShop', 'WEAPON_SPECIALCARBINE', 15000),
1002 ('BlackWeashop', 'WEAPON_SPECIALCARBINE', 16500),
1003 ('GunShop', 'WEAPON_SNIPERRIFLE', 22000),
1004 ('BlackWeashop', 'WEAPON_SNIPERRIFLE', 24000),
1005 ('GunShop', 'WEAPON_FIREWORK', 18000),
1006 ('BlackWeashop', 'WEAPON_FIREWORK', 20000),
1007 ('GunShop', 'WEAPON_GRENADE', 500),
1008 ('BlackWeashop', 'WEAPON_GRENADE', 650),
1009 ('GunShop', 'WEAPON_BZGAS', 200),
1010 ('BlackWeashop', 'WEAPON_BZGAS', 350),
1011 ('GunShop', 'WEAPON_FIREEXTINGUISHER', 100),
1012 ('BlackWeashop', 'WEAPON_FIREEXTINGUISHER', 100),
1013 ('GunShop', 'WEAPON_BALL', 50),
1014 ('BlackWeashop', 'WEAPON_BALL', 50),
1015 ('GunShop', 'WEAPON_SMOKEGRENADE', 100),
1016 ('BlackWeashop', 'WEAPON_SMOKEGRENADE', 100),
1017 ('BlackWeashop', 'WEAPON_APPISTOL', 1100),
1018 ('BlackWeashop', 'WEAPON_CARBINERIFLE', 12000),
1019 ('BlackWeashop', 'WEAPON_HEAVYSNIPER', 30000),
1020 ('BlackWeashop', 'WEAPON_MINIGUN', 45000),
1021 ('BlackWeashop', 'WEAPON_RAILGUN', 50000),
1022 ('BlackWeashop', 'WEAPON_STICKYBOMB', 500)
1023;
1024
1025-- ESX -> Property -> esx_property.sql
1026INSERT IGNORE INTO `addon_account` (name, label, shared) VALUES
1027 ('property_black_money','Schwarzgeld',0)
1028;
1029
1030INSERT IGNORE INTO `addon_inventory` (name, label, shared) VALUES
1031 ('property','Immobilien',0)
1032;
1033
1034INSERT IGNORE INTO `datastore` (name, label, shared) VALUES
1035 ('property','Immobilien',0)
1036;
1037
1038CREATE TABLE IF NOT EXISTS `owned_properties` (
1039
1040 `id` int(11) NOT NULL AUTO_INCREMENT,
1041 `name` varchar(255) NOT NULL,
1042 `price` double NOT NULL,
1043 `rented` int(11) NOT NULL,
1044 `owner` varchar(60) NOT NULL,
1045
1046 PRIMARY KEY (`id`)
1047);
1048
1049CREATE TABLE IF NOT EXISTS `properties` (
1050
1051 `id` int(11) NOT NULL AUTO_INCREMENT,
1052 `name` varchar(255) DEFAULT NULL,
1053 `label` varchar(255) DEFAULT NULL,
1054 `entering` varchar(255) DEFAULT NULL,
1055 `exit` varchar(255) DEFAULT NULL,
1056 `inside` varchar(255) DEFAULT NULL,
1057 `outside` varchar(255) DEFAULT NULL,
1058 `ipls` varchar(255) DEFAULT '[]',
1059 `gateway` varchar(255) DEFAULT NULL,
1060 `is_single` int(11) DEFAULT NULL,
1061 `is_room` int(11) DEFAULT NULL,
1062 `is_gateway` int(11) DEFAULT NULL,
1063 `room_menu` varchar(255) DEFAULT NULL,
1064 `price` int(11) NOT NULL,
1065
1066 PRIMARY KEY (`id`)
1067);
1068
1069INSERT IGNORE INTO `properties` VALUES
1070 (1,'WhispymoundDrive','2677 Whispymound Drive','{\"y\":564.89,\"z\":182.959,\"x\":119.384}','{\"x\":117.347,\"y\":559.506,\"z\":183.304}','{\"y\":557.032,\"z\":183.301,\"x\":118.037}','{\"y\":567.798,\"z\":182.131,\"x\":119.249}','[]',NULL,1,1,0,'{\"x\":118.748,\"y\":566.573,\"z\":175.697}',1500000),
1071 (2,'NorthConkerAvenue2045','2045 North Conker Avenue','{\"x\":372.796,\"y\":428.327,\"z\":144.685}','{\"x\":373.548,\"y\":422.982,\"z\":144.907},','{\"y\":420.075,\"z\":145.904,\"x\":372.161}','{\"x\":372.454,\"y\":432.886,\"z\":143.443}','[]',NULL,1,1,0,'{\"x\":377.349,\"y\":429.422,\"z\":137.3}',1500000),
1072 (3,'RichardMajesticApt2','Richard Majestic, Apt 2','{\"y\":-379.165,\"z\":37.961,\"x\":-936.363}','{\"y\":-365.476,\"z\":113.274,\"x\":-913.097}','{\"y\":-367.637,\"z\":113.274,\"x\":-918.022}','{\"y\":-382.023,\"z\":37.961,\"x\":-943.626}','[]',NULL,1,1,0,'{\"x\":-927.554,\"y\":-377.744,\"z\":112.674}',1700000),
1073 (4,'NorthConkerAvenue2044','2044 North Conker Avenue','{\"y\":440.8,\"z\":146.702,\"x\":346.964}','{\"y\":437.456,\"z\":148.394,\"x\":341.683}','{\"y\":435.626,\"z\":148.394,\"x\":339.595}','{\"x\":350.535,\"y\":443.329,\"z\":145.764}','[]',NULL,1,1,0,'{\"x\":337.726,\"y\":436.985,\"z\":140.77}',1500000),
1074 (5,'WildOatsDrive','3655 Wild Oats Drive','{\"y\":502.696,\"z\":136.421,\"x\":-176.003}','{\"y\":497.817,\"z\":136.653,\"x\":-174.349}','{\"y\":495.069,\"z\":136.666,\"x\":-173.331}','{\"y\":506.412,\"z\":135.0664,\"x\":-177.927}','[]',NULL,1,1,0,'{\"x\":-174.725,\"y\":493.095,\"z\":129.043}',1500000),
1075 (6,'HillcrestAvenue2862','2862 Hillcrest Avenue','{\"y\":596.58,\"z\":142.641,\"x\":-686.554}','{\"y\":591.988,\"z\":144.392,\"x\":-681.728}','{\"y\":590.608,\"z\":144.392,\"x\":-680.124}','{\"y\":599.019,\"z\":142.059,\"x\":-689.492}','[]',NULL,1,1,0,'{\"x\":-680.46,\"y\":588.6,\"z\":136.769}',1500000),
1076 (7,'LowEndApartment','Appartement de base','{\"y\":-1078.735,\"z\":28.4031,\"x\":292.528}','{\"y\":-1007.152,\"z\":-102.002,\"x\":265.845}','{\"y\":-1002.802,\"z\":-100.008,\"x\":265.307}','{\"y\":-1078.669,\"z\":28.401,\"x\":296.738}','[]',NULL,1,1,0,'{\"x\":265.916,\"y\":-999.38,\"z\":-100.008}',562500),
1077 (8,'MadWayneThunder','2113 Mad Wayne Thunder','{\"y\":454.955,\"z\":96.462,\"x\":-1294.433}','{"x":-1289.917,"y":449.541,"z":96.902}','{\"y\":446.322,\"z\":96.899,\"x\":-1289.642}','{\"y\":455.453,\"z\":96.517,\"x\":-1298.851}','[]',NULL,1,1,0,'{\"x\":-1287.306,\"y\":455.901,\"z\":89.294}',1500000),
1078 (9,'HillcrestAvenue2874','2874 Hillcrest Avenue','{\"x\":-853.346,\"y\":696.678,\"z\":147.782}','{\"y\":690.875,\"z\":151.86,\"x\":-859.961}','{\"y\":688.361,\"z\":151.857,\"x\":-859.395}','{\"y\":701.628,\"z\":147.773,\"x\":-855.007}','[]',NULL,1,1,0,'{\"x\":-858.543,\"y\":697.514,\"z\":144.253}',1500000),
1079 (10,'HillcrestAvenue2868','2868 Hillcrest Avenue','{\"y\":620.494,\"z\":141.588,\"x\":-752.82}','{\"y\":618.62,\"z\":143.153,\"x\":-759.317}','{\"y\":617.629,\"z\":143.153,\"x\":-760.789}','{\"y\":621.281,\"z\":141.254,\"x\":-750.919}','[]',NULL,1,1,0,'{\"x\":-762.504,\"y\":618.992,\"z\":135.53}',1500000),
1080 (11,'TinselTowersApt12','Tinsel Towers, Apt 42','{\"y\":37.025,\"z\":42.58,\"x\":-618.299}','{\"y\":58.898,\"z\":97.2,\"x\":-603.301}','{\"y\":58.941,\"z\":97.2,\"x\":-608.741}','{\"y\":30.603,\"z\":42.524,\"x\":-620.017}','[]',NULL,1,1,0,'{\"x\":-622.173,\"y\":54.585,\"z\":96.599}',1700000),
1081 (12,'MiltonDrive','Milton Drive','{\"x\":-775.17,\"y\":312.01,\"z\":84.658}',NULL,NULL,'{\"x\":-775.346,\"y\":306.776,\"z\":84.7}','[]',NULL,0,0,1,NULL,0),
1082 (13,'Modern1Apartment','Appartement Moderne 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_01_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.661,\"y\":327.672,\"z\":210.396}',1300000),
1083 (14,'Modern2Apartment','Appartement Moderne 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_01_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.735,\"y\":326.757,\"z\":186.313}',1300000),
1084 (15,'Modern3Apartment','Appartement Moderne 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_01_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.386,\"y\":330.782,\"z\":195.08}',1300000),
1085 (16,'Mody1Apartment','Appartement Mode 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_02_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.615,\"y\":327.878,\"z\":210.396}',1300000),
1086 (17,'Mody2Apartment','Appartement Mode 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_02_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.297,\"y\":327.092,\"z\":186.313}',1300000),
1087 (18,'Mody3Apartment','Appartement Mode 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_02_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.303,\"y\":330.932,\"z\":195.085}',1300000),
1088 (19,'Vibrant1Apartment','Appartement Vibrant 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_03_a\"]','MiltonDrive',0,1,0,'{\"x\":-765.885,\"y\":327.641,\"z\":210.396}',1300000),
1089 (20,'Vibrant2Apartment','Appartement Vibrant 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_03_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.607,\"y\":327.344,\"z\":186.313}',1300000),
1090 (21,'Vibrant3Apartment','Appartement Vibrant 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_03_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.525,\"y\":330.851,\"z\":195.085}',1300000),
1091 (22,'Sharp1Apartment','Appartement Persan 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_04_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.527,\"y\":327.89,\"z\":210.396}',1300000),
1092 (23,'Sharp2Apartment','Appartement Persan 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_04_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.642,\"y\":326.497,\"z\":186.313}',1300000),
1093 (24,'Sharp3Apartment','Appartement Persan 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_04_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.503,\"y\":331.318,\"z\":195.085}',1300000),
1094 (25,'Monochrome1Apartment','Appartement Monochrome 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_05_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.289,\"y\":328.086,\"z\":210.396}',1300000),
1095 (26,'Monochrome2Apartment','Appartement Monochrome 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_05_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.692,\"y\":326.762,\"z\":186.313}',1300000),
1096 (27,'Monochrome3Apartment','Appartement Monochrome 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_05_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.094,\"y\":330.976,\"z\":195.085}',1300000),
1097 (28,'Seductive1Apartment','Appartement Séduisant 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_06_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.263,\"y\":328.104,\"z\":210.396}',1300000),
1098 (29,'Seductive2Apartment','Appartement Séduisant 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_06_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.655,\"y\":326.611,\"z\":186.313}',1300000),
1099 (30,'Seductive3Apartment','Appartement Séduisant 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_06_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.3,\"y\":331.414,\"z\":195.085}',1300000),
1100 (31,'Regal1Apartment','Appartement Régal 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_07_a\"]','MiltonDrive',0,1,0,'{\"x\":-765.956,\"y\":328.257,\"z\":210.396}',1300000),
1101 (32,'Regal2Apartment','Appartement Régal 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_07_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.545,\"y\":326.659,\"z\":186.313}',1300000),
1102 (33,'Regal3Apartment','Appartement Régal 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_07_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.087,\"y\":331.429,\"z\":195.123}',1300000),
1103 (34,'Aqua1Apartment','Appartement Aqua 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_08_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.187,\"y\":328.47,\"z\":210.396}',1300000),
1104 (35,'Aqua2Apartment','Appartement Aqua 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_08_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.658,\"y\":326.563,\"z\":186.313}',1300000),
1105 (36,'Aqua3Apartment','Appartement Aqua 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_08_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.287,\"y\":331.084,\"z\":195.086}',1300000),
1106 (37,'IntegrityWay','4 Integrity Way','{\"x\":-47.804,\"y\":-585.867,\"z\":36.956}',NULL,NULL,'{\"x\":-54.178,\"y\":-583.762,\"z\":35.798}','[]',NULL,0,0,1,NULL,0),
1107 (38,'IntegrityWay28','4 Integrity Way - Apt 28',NULL,'{\"x\":-31.409,\"y\":-594.927,\"z\":79.03}','{\"x\":-26.098,\"y\":-596.909,\"z\":79.03}',NULL,'[]','IntegrityWay',0,1,0,'{\"x\":-11.923,\"y\":-597.083,\"z\":78.43}',1700000),
1108 (39,'IntegrityWay30','4 Integrity Way - Apt 30',NULL,'{\"x\":-17.702,\"y\":-588.524,\"z\":89.114}','{\"x\":-16.21,\"y\":-582.569,\"z\":89.114}',NULL,'[]','IntegrityWay',0,1,0,'{\"x\":-26.327,\"y\":-588.384,\"z\":89.123}',1700000),
1109 (40,'DellPerroHeights','Dell Perro Heights','{\"x\":-1447.06,\"y\":-538.28,\"z\":33.74}',NULL,NULL,'{\"x\":-1440.022,\"y\":-548.696,\"z\":33.74}','[]',NULL,0,0,1,NULL,0),
1110 (41,'DellPerroHeightst4','Dell Perro Heights - Apt 28',NULL,'{\"x\":-1452.125,\"y\":-540.591,\"z\":73.044}','{\"x\":-1455.435,\"y\":-535.79,\"z\":73.044}',NULL,'[]','DellPerroHeights',0,1,0,'{\"x\":-1467.058,\"y\":-527.571,\"z\":72.443}',1700000),
1111 (42,'DellPerroHeightst7','Dell Perro Heights - Apt 30',NULL,'{\"x\":-1451.562,\"y\":-523.535,\"z\":55.928}','{\"x\":-1456.02,\"y\":-519.209,\"z\":55.929}',NULL,'[]','DellPerroHeights',0,1,0,'{\"x\":-1457.026,\"y\":-530.219,\"z\":55.937}',1700000)
1112;
1113
1114-- ESX -> Property -> offices.sql
1115DELIMITER $$
1116CREATE PROCEDURE esx_properties_insert_office()
1117BEGIN
1118 IF @ESX_PROPERTY_OFFICES THEN
1119 INSERT IGNORE INTO `properties` VALUES
1120 (43, 'MazeBankBuilding', 'Maze Bank Building', '{\"x\":-79.18,\"y\":-795.92,\"z\":43.35}', NULL, NULL, '{\"x\":-72.50,\"y\":-786.92,\"z\":43.40}', '[]', NULL, 0, 0, 1, NULL, 0),
1121 (44, 'OldSpiceWarm', 'Old Spice Warm', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1122 (45, 'OldSpiceClassical', 'Old Spice Classical', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1123 (46, 'OldSpiceVintage', 'Old Spice Vintage', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1124 (47, 'ExecutiveRich', 'Executive Rich', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1125 (48, 'ExecutiveCool', 'Executive Cool', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1126 (49, 'ExecutiveContrast', 'Executive Contrast', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1127 (50, 'PowerBrokerIce', 'Power Broker Ice', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1128 (51, 'PowerBrokerConservative', 'Power Broker Conservative', NULL, '{"x":-75.69,"y":-827.08,"z":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1129 (52, 'PowerBrokerPolished', 'Power Broker Polished', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
1130 (53, 'LomBank', 'Lom Bank', '{\"x\":-1581.36,\"y\":-558.23,\"z\":34.07}', NULL, NULL, '{\"x\":-1583.60,\"y\":-555.12,\"z\":34.07}', '[]', NULL, 0, 0, 1, NULL, 0),
1131 (54, 'LBOldSpiceWarm', 'LB Old Spice Warm', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1132 (55, 'LBOldSpiceClassical', 'LB Old Spice Classical', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1133 (56, 'LBOldSpiceVintage', 'LB Old Spice Vintage', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1134 (57, 'LBExecutiveRich', 'LB Executive Rich', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1135 (58, 'LBExecutiveCool', 'LB Executive Cool', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1136 (59, 'LBExecutiveContrast', 'LB Executive Contrast', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1137 (60, 'LBPowerBrokerIce', 'LB Power Broker Ice', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1138 (61, 'LBPowerBrokerConservative', 'LB Power Broker Conservative', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1139 (62, 'LBPowerBrokerPolished', 'LB Power Broker Polished', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
1140 (63, 'MazeBankWest', 'Maze Bank West', '{\"x\":-1379.58,\"y\":-499.63,\"z\":32.22}', NULL, NULL, '{\"x\":-1378.95,\"y\":-502.82,\"z\":32.22}', '[]', NULL, 0, 0, 1, NULL, 0),
1141 (64, 'MBWOldSpiceWarm', 'MBW Old Spice Warm', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1142 (65, 'MBWOldSpiceClassical', 'MBW Old Spice Classical', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1143 (66, 'MBWOldSpiceVintage', 'MBW Old Spice Vintage', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1144 (67, 'MBWExecutiveRich', 'MBW Executive Rich', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1145 (68, 'MBWExecutiveCool', 'MBW Executive Cool', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1146 (69, 'MBWExecutive Contrast', 'MBW Executive Contrast', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1147 (70, 'MBWPowerBrokerIce', 'MBW Power Broker Ice', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1148 (71, 'MBWPowerBrokerConvservative', 'MBW Power Broker Convservative', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
1149 (72, 'MBWPowerBrokerPolished', 'MBW Power Broker Polished', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000);
1150 END IF;
1151END $$
1152DELIMITER ;
1153CALL esx_properties_insert_office();
1154DROP PROCEDURE esx_properties_insert_office;
1155
1156SELECT @ESX_PROPERTY_OFFICES := NULL;
1157
1158-- End
1159/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1160/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1161/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;