Accepted

MySQL script generation bug (typo) on unique indexes

4 years ago • updated by 4 years ago • 2

-- ************************************** `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`

Vote

Under review

Dear user,

We are looking into this issue. We will notify you as soon as we know more details.

Team - SqlDBM

Accepted

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