0
Accepted

MySQL script generation bug (typo) on unique indexes

alan 4 years ago updated by anonymous 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`

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