New room and queue model

rom_and_queue.sql

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

CREATE SCHEMA IF NOT EXISTS `imagine-cup` DEFAULT CHARACTER SET latin1 ;
USE `imagine-cup` ;

-- -----------------------------------------------------
-- Table `imagine-cup`.`Users`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `imagine-cup`.`Users` ;

CREATE TABLE IF NOT EXISTS `imagine-cup`.`Users` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `phone_number` VARCHAR(50) NULL DEFAULT NULL,
  `room_id` INT(50) NOT NULL,
  `symtom` VARCHAR(250) NULL DEFAULT NULL,
  `insurance` TINYINT(25) NOT NULL,
  `status` TINYINT(1) NOT NULL,
  `time` INT(25) NOT NULL,
  PRIMARY KEY (`id`, `room_id`),
  INDEX `foreign_room_user` (`room_id` ASC),
  CONSTRAINT `foreign_room_user`
    FOREIGN KEY (`room_id`)
    REFERENCES `imagine-cup`.`Rooms` (`id`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT)
ENGINE = InnoDB
AUTO_INCREMENT = 6
DEFAULT CHARACTER SET = latin1;


-- -----------------------------------------------------
-- Table `imagine-cup`.`Queue`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `imagine-cup`.`Queue` ;

CREATE TABLE IF NOT EXISTS `imagine-cup`.`Queue` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '	',
  `user_id` INT NOT NULL,
  `room_id` INT NULL,
  `num` INT NOT NULL DEFAULT 0,
  `status` TINYINT NOT NULL DEFAULT 1,
  `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`, `user_id`),
  INDEX `fk_Queue_1_idx` (`room_id` ASC),
  INDEX `fk_Queue_2_idx` (`user_id` ASC),
  CONSTRAINT `fk_Queue_1`
    FOREIGN KEY (`room_id`)
    REFERENCES `imagine-cup`.`Rooms` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Queue_2`
    FOREIGN KEY (`user_id`)
    REFERENCES `imagine-cup`.`Users` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;