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
179
February 21, 2022 06:23AM


Sorry, only registered users may post in this forum.

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.