jobs.sql

-- Table pour les grades dans le job "pizzathis"
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`, `type`) VALUES
('pizzathis', 1, 'novice', 'Serveur / Cuisinier Débutant', 20, '{}', '{}', null),
('pizzathis', 2, 'expert', 'Serveur / Cuisinier Expérimenté', 20, '{}', '{}', null),
('pizzathis', 3, 'manager', 'Manager', 20, '{}', '{}', null),
('pizzathis', 4, 'boss', 'Patronne', 20, '{}', '{}', null);

-- Table pour le job "pizzathis"
INSERT INTO `jobs` (`name`, `label`) VALUES
('pizzathis', 'pizzathis');


CREATE TABLE jobs_builder (
    id INT AUTO_INCREMENT PRIMARY KEY,
    job VARCHAR(255),
    label VARCHAR(255),
    blips VARCHAR(255),
    coord_duty VARCHAR(255),
    coord_chest VARCHAR(255),
    coord_boss VARCHAR(255)
);

INSERT INTO jobs_builder (job, label, blips, coord_duty, coord_chest, coord_boss) 
VALUES ('tabac', 'tabac', '{id = 1, color = 1, coord = vect3(0,0,0)}', 'vect3(0,0,0)', 'vect3(0,0,0)', '');