I have MySQL tables with Unique Index on columns. On reverse engineer, EA correctly shows these attributes having Unique Index. But when I try to generate DDL for the table, the general DDL for table doesn't add UNIQUE INDEX syntax. see the following ddl
CREATE TABLE TEAM
(
ID VARCHAR(35) NOT NULL,
RECORD_TYPE VARCHAR(35) NOT NULL DEFAULT 'Active',
CREATE_DATE DATETIME NOT NULL,
CREATED_BY VARCHAR(35) NOT NULL ,
LAST_UPDATE TIMESTAMP,
LAST_UPDATED_BY VARCHAR(35) NOT NULL,
AUDIT_STATUS VARCHAR(35) DEFAULT '',
TEAM_NAME VARCHAR(255) DEFAULT '',
TEAM_DESCRIPTION TEXT DEFAULT '',
TEAM_OPTIONS NOT NULL,
PRIMARY KEY (ID),
UNIQUE (TEAM_NAME)
) TYPE=MyISAM
When I run this script in MySQL, it fails at UNIQUE (TEAM_NAME).
Did anyone encounter this problem?
Thx. much
