search

dbsrgits / sql-translator

SQL::Translator (SQLFairy)
http://sqlfairy.sourceforge.net/
82 stars 91 forks source link

Added support for alter table with unique constraint syntax in MySQL. #132

Open uehara-delta opened 3 years ago

uehara-delta commented 3 years ago

This adds support for alter table with unique constraint syntax in MySQL.

For example, 

create table `example` (
  id integer not null,
  `subid` varchar(255),
  `subid2` varchar(255),
  primary key (`id`)
);

alter table `example`
  add constraint subid_uniq unique key (`subid`, `subid2`);