Bug #56389 the option "Skip Creation of FOREIGN KEYS" to export is not creating index

• Submitted: 30 Aug 2010 21:56
• Modified: 7 Mar 2011 13:00
• Reporter: Bernardo Silva
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S1 (Critical)
• Version: 5.2.26
• OS: Windows (7)
• Assigned to: Alexander Musienko
• CPU Architecture: Any
• Tags: export, INDEX, Skip FOREIGN KEYS

[30 Aug 2010 21:56] Bernardo Silva

Description:
By selecting "Skip Creation of FOREIGN KEYS" the index of the table are not created, this worked correctly in version 5.1.

sql generated on "Skip Creation of FOREIGN KEYS" not checked

CREATE  TABLE IF NOT EXISTS `est_volumesSaidaItens` (
  `volumesSaida_id` INT NOT NULL ,
  `nroEtiqueta` SMALLINT NOT NULL ,
  `quantidade` VARCHAR(45) NOT NULL ,
  `produtosServicos_id` INT(10)  NOT NULL ,
  INDEX `fk_est_volumesSaidaItens_est_volumesSaida` (`volumesSaida_id` ASC) ,
  INDEX `fk_est_volumesSaidaItens_finan_produtosServicos` (`produtosServicos_id` ASC) ,
  CONSTRAINT `fk_est_volumesSaidaItens_est_volumesSaida`
    FOREIGN KEY (`volumesSaida_id` )
    REFERENCES `est_volumesSaida` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_est_volumesSaidaItens_finan_produtosServicos`
    FOREIGN KEY (`produtosServicos_id` )
    REFERENCES `finan_produtosServicos` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

with "Skip Creation of FOREIGN KEYS" checked

CREATE  TABLE IF NOT EXISTS `est_volumesSaidaItens` (
  `volumesSaida_id` INT NOT NULL ,
  `nroEtiqueta` SMALLINT NOT NULL ,
  `quantidade` VARCHAR(45) NOT NULL ,
  `produtosServicos_id` INT(10)  NOT NULL
)
ENGINE = InnoDB;

How to repeat:
just select "Skip Creation of FOREIGN KEYS and export

[3 Mar 2011 13:55] Johannes Taxacher

fix confirmed in repository

[7 Mar 2011 13:00] Tony Bedford

An entry has been added to the 5.2.32 changelog: 

When exporting a model, if the option <guilabel>Skip Creation of FOREIGN 
KEYS</guilabel> was selected, then indexes were not created.