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: | |
| Category: | MySQL Workbench: Modeling | Severity: | S3 (Non-critical) |
| Version: | 5.2.4 | OS: | Any |
| Assigned to: | Alexander Musienko | CPU Architecture: | Any |
[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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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"