SET data type not translating
Submitted by muunkky on 24 April 2009 - 10:54pm
I reverse engineered from my mysql db and then added relationships and then forward engineered a sql script from SchemaBank. Somewhere along the way the items in my SET data types got lost.
The exported sql file showed:
CREATE TABLE `mydb`.`Band_Membership` (
`Band_Membership_ID` BIGINT(20) NOT NULL,
`Role` SET() CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, ...
when it should have showed:
CREATE TABLE `mydb`.`Band_Membership` (
`Band_Membership_ID` BIGINT(20) NOT NULL,
`Role` SET(`Musician`,`Administrator`) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,...
Login or register to post comments


Comments
Thanks for the bug report. We
Thanks for the bug report.
We will fix it asap.
The bug is fixed. Please run
The bug is fixed.
Please run the reverse engineer again or edit the attributes that have the data type "SET".