Bug #47969 Forward Eng SQL CREATE Script ignores Skip Creation of FOREIGN KEYS
Submitted: 10 Oct 2009 15:32 Modified: 9 Feb 2010 16:59
Reporter: Carl Downing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.4 OS:Any
Assigned to: Alexander Musienko CPU Architecture:Any

[10 Oct 2009 15:32] Carl Downing 
Description:
Selecting "Skip Creation of FOREIGN KEYS" while exporting create script seems to have no impact on the output.  Here is SQL generated with "Skip Creation" selected:

-- -----------------------------------------------------
-- Table `testdb`.`tdb_keyword_tb`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `testdb`.`tdb_keyword_tb` ;

CREATE  TABLE IF NOT EXISTS `testdb`.`tdb_keyword_tb` (
  `id` INT NOT NULL ,
  `test_id` INT NULL ,
  `keyword` VARCHAR(45) NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `bdb_test_id_fk` (`test_id` ASC) ,
  CONSTRAINT `bdb_test_id_fk`
    FOREIGN KEY (`test_id` )
    REFERENCES `testdb`.`bdb_test_tb` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

How to repeat:
Create two tables with appropriate FK, export Forward Engineer SQL CREATE Script, select "Skip Creation of FOREIGN KEYS"
[8 Feb 2010 18:03] Johannes Taxacher 
fixed in repository
[9 Feb 2010 16:59] Tony Bedford 
An entry has been added to the 5.2.16 changelog:

In the Forward Engineer SQL Script wizard, selection of the Skip Creation of FOREIGN KEYS checkbox was not reflected in the generated script.