DDL

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

CREATE SCHEMA IF NOT EXISTS `Driving_School` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `Driving_School` ;

-- -----------------------------------------------------
-- Table `Driving_School`.`Staff`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Driving_School`.`Staff` (
  `Staff_ID` INT NOT NULL AUTO_INCREMENT ,
  `Name` VARCHAR(45) NOT NULL ,
  `Office` INT NOT NULL ,
  PRIMARY KEY (`Staff_ID`) ,
  INDEX `fk_Staff_Office` (`Office` ASC) ,
  CONSTRAINT `fk_Staff_Office`
    FOREIGN KEY (`Office` )
    REFERENCES `Driving_School`.`Office` (`Office_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Driving_School`.`Office`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Driving_School`.`Office` (
  `Office_ID` INT NOT NULL AUTO_INCREMENT ,
  `City` VARCHAR(45) NOT NULL ,
  `Telephone` VARCHAR(45) NOT NULL ,
  `Manager` INT NOT NULL ,
  PRIMARY KEY (`Office_ID`) ,
  INDEX `fk_Office_Staff` (`Manager` ASC) ,
  CONSTRAINT `fk_Office_Staff`
    FOREIGN KEY (`Manager` )
    REFERENCES `Driving_School`.`Staff` (`Staff_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;