
Allow specify Generation format for MySQL constraints
I need to forward engineer for MySQL in a different way (to use the script within mysql or h2 in compatible mode)
For that reason I need any of the following ideas.
1) When generating the script don't generate using the keyword 'CONSTRAINT'
Example:
CREATE TABLE `sample`
(
`id` char(36) NOT NULL ,
`parent_id` char(36) DEFAULT NULL ,
`name` varchar(255) DEFAULT NULL ,
PRIMARY KEY (`id`),
KEY `FK_sample_parent_id` (`parent_id`), FOREIGN KEY `FK_sample_parent_id` (`parent_id`) REFERENCES `sample` (`id`)
CONSTRAINT `FK_sample_parent_id`
);
The CONSTRAINT [name] before the FOREIGN KEY its not need for MYSQL.
2) Allow to create the FK index/constraint using an alter table instead inside the create.
ALTER TABLE sample
ADD CONSTRAINT FK_sample_parent_id FOREIGN KEY (parent_id) REFERENCES sample (id);


Customer support service by UserEcho