SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';


#mycomment --> why that ? Collation has not changed !

ALTER TABLE `mydb`.`table1` COLLATE = utf8_general_ci ;





DELIMITER $$



USE `mydb`$$

#mycomment Triggers have to be dropped before You create a new Trigger on the same Event
#mycomment so You are not able to rename triggers in the model

# Automatic Update of Timestamp on Update

CREATE TRIGGER table1_beforeupdate_changename BEFORE UPDATE on table1

FOR EACH ROW

BEGIN

SET NEW.timestamp=NOW();

END$$



USE `mydb`$$

#mycomment - that should happen before You create new Triggers

DROP TRIGGER IF EXISTS `mydb`.`table1_beforeupdate` $$





DELIMITER ;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

