Job Mécano

INSERT INTO `addon_account` (name, label, shared) VALUES
	('society_mecano', 'Mécano', 1)
;

INSERT INTO `datastore` (name, label, shared) VALUES
	('society_mecano', 'Mécano', 1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
	('society_mecano', 'Mécano', 1)
;

INSERT INTO `jobs` (name, label) VALUES
	('mecano', 'Mécano')
;

INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
	(NULL, 'mecano', 0, 'mecanojunior', 'Mécanicien Débutant', 1000, '{}', '{}'),
	(NULL, 'mecano', 1, 'mecano', 'Mécanicien', 1500, '{}', '{}'),
	(NULL, 'mecano', 2, 'chef', 'Chef d\'Atelier', 1700, '{}', '{}'),
	(NULL, 'mecano', 3, 'boss', 'Patron', 1700, '{}', '{}');

CREATE TABLE `casiermecano` (
  `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 `casiermecano`
  ADD PRIMARY KEY (`id`);

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

CREATE TABLE `casiermecanocontent` (
  `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 `casiermecanocontent`
  ADD PRIMARY KEY (`id`);

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

CREATE TABLE `mecano_stock` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `label` VARCHAR(255) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `quantity` INT NOT NULL
);