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';



CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;



-- -----------------------------------------------------

-- Table `mydb`.`table1`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `mydb`.`table1` (

  `idtable1` INT NOT NULL ,

  `timestamp` TIMESTAMP NULL ,

  PRIMARY KEY (`idtable1`) )

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;





DELIMITER $$

USE `mydb`$$



# Automatic Update of Timestamp on Update

CREATE TRIGGER table1_beforeupdate BEFORE UPDATE on table1

FOR EACH ROW

BEGIN

SET NEW.timestamp=NOW();

END$$





DELIMITER ;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;