I have another syntax error when migrating a diagram. I'm not certain this diagram is necessary, but it would be nice to have a smooth migration, and this is all that's standing in the way.
The error is: You have an error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1) NULL, PRIMARY KEY ('diagram_id'), UNIQUE INDEX 'UK_principal_name' ('pri' at line 6
And the syntax has a VARBINARY(-1)
which I've never seen before. Is that the problem?
DROP TABLE IF EXISTS `Fonebook_dbo`.`sysdiagrams`; CREATE TABLE `Fonebook_dbo`.`sysdiagrams` ( `name` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `principal_id` INT(10) NOT NULL, `diagram_id` INT(10) NOT NULL AUTO_INCREMENT, `version` INT(10) NULL, `definition` VARBINARY(-1) NULL, PRIMARY KEY (`diagram_id`), UNIQUE INDEX `UK_principal_name` (`principal_id`, `name`) ) ENGINE = INNODB;