Issue Type: Bug Bug
Affects Versions: 3.2.4.GA
Assignee: Unassigned
Components: reverse-engineer
Created: 24/Oct/12 1:13 PM
Description:

1. Create a table in MySQL using the SQL below.
2. Try to import the database using the reverse-eng tool

— SQL to generate DB ----
CREATE DATABASE test_wm;

USE test_wm;

CREATE TABLE `country` (
`id` varchar(4) NOT NULL,
`name` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `k_name` (`name`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;

CREATE TABLE `city` (
`id` varchar(4) NOT NULL,
`country_id` varchar(4) NOT NULL,
`name` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
UNIQUE INDEX `k_name` (`name`) USING BTREE ,
INDEX `fk_city_country_id` (`country_id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;

CREATE TABLE `resort` (
`city_id` varchar(4) NOT NULL,
PRIMARY KEY (`city_id`),
FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
INDEX `fk_from_city_city_id` (`city_id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;

Environment: MySQL, hibernate tool 3.2.4.GA
Project: Hibernate Tools
Priority: Major Major
Reporter: Seung Lee
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira