· 5 years ago · Mar 31, 2020, 10:10 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 8.0.19 - MySQL Community Server - GPL
4-- Server OS: Win64
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 essentialmode
16CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET latin1 */ /*!80016 DEFAULT ENCRYPTION='N' */;
17USE `essentialmode`;
18
19-- Dumping structure for table essentialmode.jobs
20CREATE TABLE IF NOT EXISTS `jobs` (
21 `id` int NOT NULL AUTO_INCREMENT,
22 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
23 `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
24 `whitelisted` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'FALSE',
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
27
28-- Dumping data for table essentialmode.jobs: ~21 rows (approximately)
29DELETE FROM `jobs`;
30/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
31INSERT INTO `jobs` (`id`, `name`, `label`, `whitelisted`) VALUES
32 (1, 'unemployed', 'Unemployed', 'FALSE'),
33 (11, 'ambulance', 'Ambulance', '1'),
34 (14, 'police', 'Police', '1'),
35 (22, 'mecano', 'Mechanic', '1'),
36 (29, 'tower', 'Tow truck driver', '1');
37/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
38
39-- Dumping structure for table essentialmode.job_grades
40CREATE TABLE IF NOT EXISTS `job_grades` (
41 `id` int NOT NULL AUTO_INCREMENT,
42 `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
43 `grade` int NOT NULL,
44 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
45 `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
46 `salary` int NOT NULL,
47 `skin_male` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
48 `skin_female` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB AUTO_INCREMENT=126017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
51
52-- Dumping data for table essentialmode.job_grades: ~27 rows (approximately)
53DELETE FROM `job_grades`;
54/*!40000 ALTER TABLE `job_grades` DISABLE KEYS */;
55INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
56 (125987, 'unemployed', 0, 'rsa', 'Welfare', 375, '{}', '{}'),
57 (125988, 'ambulance', 0, 'trainee', 'Trainee/Probationary Firefighter', 4500, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":0,"shoes":9,"torso_2":0,"hair_color_2":0,"pants_1":24,"glasses_1":0,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":20,"helmet_1":122,"helmet_2":0,"arms":85,"face":19,"decals_1":58,"torso_1":250,"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}'),
58 (125989, 'ambulance', 1, 'doctor', 'ER/Firefighter', 5200, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":0,"shoes":9,"torso_2":0,"hair_color_2":0,"pants_1":24,"glasses_1":0,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":20,"helmet_1":122,"helmet_2":0,"arms":85,"face":19,"decals_1":58,"torso_1":250,"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}'),
59 (125990, 'ambulance', 2, 'doctor', 'EMT/Firefighter', 5550, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":0,"shoes":9,"torso_2":0,"hair_color_2":0,"pants_1":24,"glasses_1":0,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":20,"helmet_1":122,"helmet_2":0,"arms":85,"face":19,"decals_1":58,"torso_1":250,"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}'),
60 (125991, 'ambulance', 3, 'doctor', 'Paramedic/Driver engineer', 5500, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":0,"shoes":9,"torso_2":0,"hair_color_2":0,"pants_1":24,"glasses_1":0,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":20,"helmet_1":122,"helmet_2":0,"arms":85,"face":19,"decals_1":58,"torso_1":250,"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}'),
61 (125992, 'offambulance', 0, 'trainee', 'Trainee/Probationary Firefighter', 0, '{}', '{}'),
62 (125993, 'offambulance', 1, 'senior', 'ER/Firefighter', 0, '{}', '{}'),
63 (125994, 'offambulance', 2, 'doctor', 'EMT/Firefighter', 0, '{}', '{}'),
64 (125995, 'offambulance', 3, 'doctor', 'Paramedic/Driver engineer', 0, '{}', '{}'),
65 (125996, 'police', 1, 'trooper', 'Trooper', 3200, '{}', '{}'),
66 (125997, 'police', 3, 'sergeant', 'Sergeant', 4500, '{}', '{}'),
67 (125998, 'police', 5, 'captain', 'Captain', 4500, '{}', '{}'),
68 (125999, 'police', 7, 'commissioner', 'Commissioner', 4500, '{}', '{}'),
69 (126000, 'ambulance', 4, 'senior', 'Doctor', 6200, '{"tshirt_2":0,"hair_color_1":5,"glasses_2":0,"shoes":9,"torso_2":0,"hair_color_2":0,"pants_1":24,"glasses_1":0,"hair_1":2,"sex":0,"decals_2":0,"tshirt_1":20,"helmet_1":122,"helmet_2":0,"arms":85,"face":19,"decals_1":58,"torso_1":250,"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}'),
70 (126001, 'police', 0, 'cadet', 'Cadet', 0, '{}', '{}'),
71 (126002, 'police', 2, 'seniortrooper', 'Senior Trooper', 0, '{}', '{}'),
72 (126003, 'police', 4, 'lieutenant', 'Lieutenant', 0, '{}', '{}'),
73 (126004, 'police', 6, 'chieftrooper', 'Chief Trooper', 0, '{}', '{}'),
74 (126005, 'offambulance', 4, 'senior', 'Doctor', 0, '{}', '{}'),
75 (126006, 'offpolice', 1, 'trooper', 'Trooper', 3200, '{}', '{}'),
76 (126007, 'offpolice', 3, 'sergeant', 'Sergeant', 4500, '{}', '{}'),
77 (126008, 'offpolice', 5, 'captain', 'Captain', 4500, '{}', '{}'),
78 (126009, 'offpolice', 7, 'commissioner', 'Commissioner', 4500, '{}', '{}'),
79 (126010, 'offpolice', 0, 'cadet', 'Cadet', 0, '{}', '{}'),
80 (126011, 'offpolice', 2, 'seniortrooper', 'Senior Trooper', 0, '{}', '{}'),
81 (126012, 'offpolice', 4, 'lieutenant', 'Lieutenant', 0, '{}', '{}'),
82 (126013, 'offpolice', 6, 'chieftrooper', 'Chief Trooper', 0, '{}', '{}'),
83 (126015, 'tower', 0, 'tower', 'Tow truck driver', 0, '{}', '{}'),
84 (126016, 'mecano', 0, 'mecano', 'Mechanic', 0, '{}', '{}');
85/*!40000 ALTER TABLE `job_grades` ENABLE KEYS */;
86
87/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
88/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
89/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;