MySQL Forums
Forum List  »  MySQL Workbench

Synchronize adding spurious commands
Posted by: David Driscoll
Date: February 21, 2022 06:23AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Synchronize adding spurious commands
488
February 21, 2022 06:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.