Job Immobilier

INSERT INTO `addon_account` (name, label, shared) VALUES
	('society_realestateagent', 'Agence Immobilière', 1)
;

INSERT INTO `datastore` (name, label, shared) VALUES
	('society_realestateagent', 'Agence Immobilière', 1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
	('society_realestateagent', 'Agence Immobilière', 1)
;

INSERT INTO `jobs` (name, label) VALUES
	('realestateagent', 'Agence Immobilière')
;

INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
(NULL, 'realestateagent', 0, 'realestateagentjunior', 'Stagiaire', 1000, '{}', '{}'),
(NULL, 'realestateagent', 1, 'realestateagent', 'Agent Immobilier', 1500, '{}', '{}'),
(NULL, 'realestateagent', 2, 'chef', "Chef de Service", 1700, '{}', '{}'),
(NULL, 'realestateagent', 3, 'boss', 'Patron', 2800, '{}', '{}');

CREATE TABLE `properties2` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `posX` float NOT NULL,
  `posY` float NOT NULL,
  `posZ` float NOT NULL,
  `owned` tinyint(1) DEFAULT 0,
  `owner` varchar(255) DEFAULT NULL,
  `sellerName` varchar(255) DEFAULT NULL,
  `exitX` float DEFAULT NULL,
  `exitY` float DEFAULT NULL,
  `exitZ` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


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

ALTER TABLE `properties2`
ADD COLUMN date TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

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