sqldiff produces invalid code for MySQL UNIQUE

[Mikhail Simin]

I ran sqldiff on one of my models and it produced the following:

ALTER TABLE `data_accuweatherlocation`
ADD COLUMN UNIQUE (`locationid`);

the COLUMN word should not be present to create this constraint.

[trbs]

Thanks for the report !

Could you create a ticket for this on Github ?

Regards,
Trbs

[trbs]

Seems this was wrong for PostGreSQL and SQLite as well.

Fix has been committed, thanks for the report !