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 `nbtest` DEFAULT CHARACTER SET latin1 ; SHOW WARNINGS; USE `nbtest`; -- ----------------------------------------------------- -- Table `nbtest`.`JobType` -- ----------------------------------------------------- DROP TABLE IF EXISTS `nbtest`.`JobType` ; SHOW WARNINGS; CREATE TABLE IF NOT EXISTS `nbtest`.`JobType` ( `ID` SMALLINT UNSIGNED NOT NULL , `Name` VARCHAR(30) NOT NULL , PRIMARY KEY (`ID`) ) ENGINE = InnoDB; SHOW WARNINGS; -- ----------------------------------------------------- -- Table `nbtest`.`Job` -- ----------------------------------------------------- DROP TABLE IF EXISTS `nbtest`.`Job` ; SHOW WARNINGS; CREATE TABLE IF NOT EXISTS `nbtest`.`Job` ( `ID` INT UNSIGNED NOT NULL , `TypeID` SMALLINT UNSIGNED NOT NULL , PRIMARY KEY (`ID`) , CONSTRAINT `fkJobTypeID` FOREIGN KEY (`TypeID` ) REFERENCES `nbtest`.`JobType` (`ID` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; SHOW WARNINGS; CREATE INDEX fkJobTypeID ON `nbtest`.`Job` (`TypeID` ASC) ; SHOW WARNINGS; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;