
0
Accepted
MySQL script generation bug (typo) on unique indexes
-- ************************************** `users`
CREATE TABLE `users`
(
`id` int unsigned NOT NULL ,
`username` varchar(45) NOT NULL ,
`email_address` varchar(96) NOT NULL ,
`first_name` varchar(24) NOT NULL ,
`last_name` varchar(24) NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE KEY `username`)
) ENGINE=INNODB;
Notice the missing ( between UNIQUE KEY and `username`
Customer support service by UserEcho
Dear user,
We are looking into this issue. We will notify you as soon as we know more details.
Team - SqlDBM
Dear user,
Sorry for the late response. Yes, there is missing open parenthesis when you create index without members.
I'll report this issue to developing team.
Thank you