Cannot parse NOT NULL COLLATE in DDL

MySQL connector fails on DDL changes when COLLATE comes after NOT NULL constraint.

CREATE TABLE c1 (
  pk INT PRIMARY KEY, 
  v1 CHAR(36) NOT NULL COLLATE utf8_unicode_ci
);

I am going to send a merge request with a fix and a unit test that demonstrates the error.