-- MySQL Workbench Synchronization
-- Generated: 2014-12-23 10:55
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: ro

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 `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

CREATE TABLE IF NOT EXISTS `mydb`.`university` (
  `iduniversity` INT(11) NOT NULL,
  `universityname` VARCHAR(45) NOT NULL,
  `universityaddress` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`iduniversity`),
  UNIQUE INDEX `iduniversity_id_UNIQUE` (`iduniversity` ASC),
  UNIQUE INDEX `universityname_UNIQUE` (`universityname` ASC))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;

CREATE TABLE IF NOT EXISTS `mydb`.`student` (
  `idstudent` INT(11) NOT NULL,
  `universityname` VARCHAR(45) NOT NULL,
  `departmentname` VARCHAR(45) NOT NULL,
  `facultyname` VARCHAR(45) NOT NULL,
  `studentfirstname` VARCHAR(45) NOT NULL,
  `studentsecondname` VARCHAR(45) NOT NULL,
  `studentaddress` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`idstudent`),
  UNIQUE INDEX `idstudent_UNIQUE` (`idstudent` ASC),
  INDEX `idfaculty_idx` (`facultyname` ASC),
  INDEX `universityname_idx` (`universityname` ASC),
  INDEX `deparmentname_idx` (`departmentname` ASC),
  CONSTRAINT `universityname`
    FOREIGN KEY (`universityname`)
    REFERENCES `mydb`.`university` (`universityname`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `facultyname`
    FOREIGN KEY (`facultyname`)
    REFERENCES `mydb`.`faculty` (`facultyname`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `deparmentname`
    FOREIGN KEY (`departmentname`)
    REFERENCES `mydb`.`department` (`departmentname`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;

CREATE TABLE IF NOT EXISTS `mydb`.`faculty` (
  `idfaculty` INT(11) NOT NULL,
  `facultyname` VARCHAR(45) NOT NULL,
  `universityname` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`idfaculty`),
  INDEX `universatyname_idx` (`universityname` ASC),
  UNIQUE INDEX `idfaculty_UNIQUE` (`idfaculty` ASC),
  UNIQUE INDEX `facultyname_UNIQUE` (`facultyname` ASC),
  CONSTRAINT `universatyname`
    FOREIGN KEY (`universityname`)
    REFERENCES `mydb`.`university` (`universityname`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;

CREATE TABLE IF NOT EXISTS `mydb`.`department` (
  `iddepartment` INT(11) NOT NULL,
  `universityname` VARCHAR(45) NOT NULL,
  `departmentname` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`iddepartment`),
  UNIQUE INDEX `iddepartment_UNIQUE` (`iddepartment` ASC),
  INDEX `universityname_idx` (`universityname` ASC),
  UNIQUE INDEX `departmentname_UNIQUE` (`departmentname` ASC),
  CONSTRAINT `universityname`
    FOREIGN KEY (`universityname`)
    REFERENCES `mydb`.`university` (`universityname`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


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

Executing SQL script in server
ERROR: Error 1005: Can't create table 'mydb.department' (errno: 121)
SQL Code:
        CREATE TABLE IF NOT EXISTS `mydb`.`department` (
          `iddepartment` INT(11) NOT NULL,
          `universityname` VARCHAR(45) NOT NULL,
          `departmentname` VARCHAR(45) NOT NULL,
          PRIMARY KEY (`iddepartment`),
          UNIQUE INDEX `iddepartment_UNIQUE` (`iddepartment` ASC),
          INDEX `universityname_idx` (`universityname` ASC),
          UNIQUE INDEX `departmentname_UNIQUE` (`departmentname` ASC),
          CONSTRAINT `universityname`
            FOREIGN KEY (`universityname`)
            REFERENCES `mydb`.`university` (`universityname`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB
        DEFAULT CHARACTER SET = utf8
        COLLATE = utf8_general_ci

SQL script execution finished: statements: 7 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch