Synchronize adding spurious commands

[David Driscoll]

Whenever I do a synchronize it comes up with some statements that it shouldn't and this happens on every subsquent synchronize.


The first issue is trying to set the character set and the second is re-creating the contraint/index...


ALTER TABLE `table1`
DROP FOREIGN KEY `fk_table1`;

ALTER TABLE `table1`
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;

ALTER TABLE `table1`
ADD CONSTRAINT `fk_table1`
FOREIGN KEY (`table2_id`)
REFERENCES `table2` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;


It does this for every table so it creates a lot of chaff making it hard to find and check a genuine schema change.