-- MySQL Workbench Forward Engineering

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';

-- -----------------------------------------------------
-- Schema atm_db
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `atm_db` ;

-- -----------------------------------------------------
-- Schema atm_db
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `atm_db` DEFAULT CHARACTER SET utf8 ;
USE `atm_db` ;

-- -----------------------------------------------------
-- Table `atm_db`.`weekdays`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `atm_db`.`weekdays` ;

CREATE TABLE IF NOT EXISTS `atm_db`.`weekdays` (
  `weekday_id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `weekday_name` CHAR(2) NOT NULL,
  PRIMARY KEY (`weekday_id`),
  UNIQUE INDEX `weekday_name_UNIQUE` (`weekday_name` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `atm_db`.`weekperiods`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `atm_db`.`weekperiods` ;

CREATE TABLE IF NOT EXISTS `atm_db`.`weekperiods` (
  `weekperiod_id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `weekday_from` TINYINT(3) NOT NULL,
  `weekday_to` TINYINT(3) NOT NULL,
  PRIMARY KEY (`weekperiod_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `atm_db`.`weekperiods_days`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `atm_db`.`weekperiods_days` ;

CREATE TABLE IF NOT EXISTS `atm_db`.`weekperiods_days` (
  `weekperiod_day_id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `weekday_id` TINYINT(3) NOT NULL,
  `weekperiod_id` TINYINT(3) NOT NULL,
  PRIMARY KEY (`weekperiod_day_id`),
  INDEX `fk_weekperiods_days_weekdays_idx` (`weekday_id` ASC),
  INDEX `fk_weekperiods_days_weekperiods1_idx` (`weekperiod_id` ASC),
  CONSTRAINT `fk_weekperiods_days_weekdays`
    FOREIGN KEY (`weekday_id`)
    REFERENCES `atm_db`.`weekdays` (`weekday_id`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT,
  CONSTRAINT `fk_weekperiods_days_weekperiods1`
    FOREIGN KEY (`weekperiod_id`)
    REFERENCES `atm_db`.`weekperiods` (`weekperiod_id`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT)
ENGINE = InnoDB;


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