-
Notifications
You must be signed in to change notification settings - Fork 17
/
esx_foodtruck_en.sql
32 lines (25 loc) · 835 Bytes
/
esx_foodtruck_en.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
SET @job_name = 'foodtruck';
SET @society_name = 'society_foodtruck';
SET @job_Name_Caps = 'Foodtruck';
INSERT INTO `addon_account` (name, label, shared) VALUES
(@society_name, @job_Name_Caps, 1)
;
INSERT INTO `jobs` (name, label, whitelisted) VALUES
(@job_name, @job_Name_Caps, 1)
;
INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
(@job_name, 0, 'cook', 'Cook', 200, '{}', '{}'),
(@job_name, 1, 'boss', 'Owner', 300, '{}', '{}')
;
INSERT INTO `items` (`name`, `label`, `limit`) VALUES
('cola', 'Coke', 20),
('vegetables', 'Vegetables', 20),
('meat', 'Meat', 20),
('tacos', 'Tacos', 20),
('burger', 'Burger', 20)
;
INSERT INTO `shops` (`store`, `item`, `price`) VALUES
('Market', 'cola', 100),
('Market', 'vegetables', 100),
('Market', 'meat', 100)
;