Job Gouvernement

INSERT INTO `addon_account` (name, label, shared) VALUES
	('society_government', 'Gouvernement', 1)
;

INSERT INTO `datastore` (name, label, shared) VALUES
	('society_government', 'Gouvernement', 1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
	('society_government', 'Gouvernement', 1)
;

INSERT INTO `jobs` (name, label) VALUES
	('government', 'Gouvernement')
;

INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
(NULL, 'government', 0, 'agentsec', 'Agent de Sécurité', 1500, '{}', '{}'),
(NULL, 'government', 1, 'chefsec', 'Chef de la Sécurité', 2500, '{}', '{}'),
(NULL, 'government', 2, 'employe', 'Employé', 2000, '{}', '{}'),
(NULL, 'government', 3, 'assperso', 'Assistant Personnel', 3000, '{}', '{}'),
(NULL, 'government', 4, 'viceboss', 'Vice-Gouverneur', 4500, '{}', '{}'),
(NULL, 'government', 5, 'boss', 'Gouverneur', 6000, '{}', '{}');

CREATE TABLE `cj` (
  `id` int(11) NOT NULL,
  `author` text NOT NULL,
  `date` text NOT NULL,
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `reason` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `stockgovernment` (
  `id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `model` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

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

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

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

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