Job EMS

INSERT INTO `addon_account` (name, label, shared) VALUES
	('society_ambulance', 'E.M.S.', 1)
;

INSERT INTO `datastore` (name, label, shared) VALUES
	('society_ambulance', 'E.M.S.', 1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
	('society_ambulance', 'E.M.S.', 1)
;

INSERT INTO `jobs` (name, label) VALUES
	('ambulance', 'E.M.S.')
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
  ('casierambulance','Casier E.M.S',0)
;

INSERT INTO `datastore` (name, label, shared) VALUES
  ('casierambulance','Casier E.M.S',0)
;

INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
(NULL, 'ambulance', 0, 'stagiaire', 'Médecin Stagiaire', 1500, '{}', '{}'),
(NULL, 'ambulance', 1, 'medecin', 'Médecin', 2500, '{}', '{}'),
(NULL, 'ambulance', 2, 'medecinchf', 'Médecin-Chef', 2000, '{}', '{}'),
(NULL, 'ambulance', 3, 'manager', 'Manager', 3000, '{}', '{}'),
(NULL, 'ambulance', 4, 'boss', 'Patron', 6000, '{}', '{}');

CREATE TABLE `casierambulance` (
  `id` int(11) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `guest` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `casierambulance`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `casierambulance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

CREATE TABLE `casierambulancecontent` (
  `id` int(11) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `type` varchar(25) NOT NULL,
  `name` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `casierambulancecontent`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `casierambulancecontent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;