 -- Table `mdm`.`leave_request`
 -- -----------------------------------------------------
 CREATE TABLE IF NOT EXISTS `mdm`.`leave_request` (
-  `id` INT NOT NULL COMMENT '',
+  `id` INT NOT NULL AUTO_INCREMENT COMMENT '',
   `date_applied` DATE NULL COMMENT '',
   `comments` VARCHAR(256) NULL COMMENT '',
   `employee_id` INT NOT NULL COMMENT '',
-  `leave_type_id` INT(10) NOT NULL COMMENT '',
-  PRIMARY KEY (`id`)  COMMENT '',
-  INDEX `fk_leave_request_employee_idx` (`employee_id` ASC)  COMMENT '',
+  `leave_type_id` INT(10) UNSIGNED NOT NULL COMMENT '',
+  PRIMARY KEY (`id`)  COMMENT '',
+  INDEX `fk_leave_request_employee1_idx` (`employee_id` ASC)  COMMENT '',
   INDEX `fk_leave_request_leave_type1_idx` (`leave_type_id` ASC)  COMMENT '',
-  CONSTRAINT `fk_leave_request_employee`
+  CONSTRAINT `fk_leave_request_employee1`
     FOREIGN KEY (`employee_id`)
     REFERENCES `mdm`.`employee` (`id`)
     ON DELETE NO ACTION

-- -----------------------------------------------------
-- Table `mdm`.`employee`
-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `mdm`.`employee` (
  `id` INT NOT NULL COMMENT '',
  `employee_number` VARCHAR(255) NOT NULL COMMENT '',

-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mdm`.`leave_request_comment` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '',
  `employee_id` INT NULL COMMENT '',
  `leave_request_id` INT NOT NULL COMMENT '',
  `user_id` INT(11) NULL COMMENT '',
  `created` DATETIME NULL COMMENT '',
