 -- MySQL Script generated by MySQL Workbench
--- 11/29/16 16:48:27
+-- 12/19/16 11:58:51
 -- Model: New Model    Version: 1.0
 -- MySQL Workbench Forward Engineering
 

-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`fsm_floor` (`location_id`, `floor_code`, `min_x`, `min_y`, `max_x`, `max_y`) VALUES (1, 'L2', 0, 0, 100, 100);
INSERT INTO `mydb`.`fsm_floor` (`location_id`, `floor_code`, `min_x`, `min_y`, `max_x`, `max_y`) VALUES (1, 'L3', -1, -1, -1, -1);

COMMIT;


  PRIMARY KEY (`id`),
  INDEX `fk_fsm_user_role_fsm_user1_idx` (`user_id` ASC),
  INDEX `fk_fsm_user_role_fsm_role1_idx` (`role_id` ASC),
  CONSTRAINT `fk_fsm_user_role_fsm_user1`
    FOREIGN KEY (`user_id`)
    REFERENCES `mydb`.`fsm_user` (`id`)
