-
Notifications
You must be signed in to change notification settings - Fork 0
/
esx_mechanicjob.sql
34 lines (28 loc) · 995 Bytes
/
esx_mechanicjob.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
USE `es_extended`;
INSERT INTO `addon_account` (name, label, shared) VALUES
('society_mechanic', 'Mécano', 1)
;
INSERT INTO `addon_inventory` (name, label, shared) VALUES
('society_mechanic', 'Mécano', 1)
;
INSERT INTO `datastore` (name, label, shared) VALUES
('society_mechanic', 'Mécano', 1)
;
INSERT INTO `jobs` (name, label) VALUES
('mechanic', 'Mécano')
;
INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
('mechanic',0,'recrue','Recrue',12,'{}','{}'),
('mechanic',1,'novice','Novice',24,'{}','{}'),
('mechanic',2,'experimente','Experimente',36,'{}','{}'),
('mechanic',3,'chief',"Chef d\'équipe",48,'{}','{}'),
('mechanic',4,'boss','Patron',0,'{}','{}')
;
INSERT INTO `items` (name, label, weight) VALUES
('gazbottle', 'bouteille de gaz', 2),
('fixtool', 'outils réparation', 2),
('carotool', 'outils carosserie', 2),
('blowpipe', 'Chalumeaux', 2),
('fixkit', 'Kit réparation', 3),
('carokit', 'Kit carosserie', 3)
;