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

DROP SCHEMA IF EXISTS `mydb` ;
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
SHOW WARNINGS;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `test1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test1` ;

SHOW WARNINGS;
CREATE  TABLE IF NOT EXISTS `test1` (
  `ID` INT UNSIGNED NOT NULL ,
  `UserID` MEDIUMINT UNSIGNED NOT NULL ,
  `Name` VARCHAR(45) NOT NULL COMMENT 'Nick or real' ,
  `Age` TINYINT UNSIGNED NOT NULL COMMENT 'Steadily growing older...' ,
  PRIMARY KEY (`ID`) )
ENGINE = InnoDB;

SHOW WARNINGS;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;


/*
+--------------------------------------------+
| Catalog Diff Report                        |
+--------------------------------------------+
Table `mydb`.`test1` was modified
  columns:
  - modified column Name
  - modified column Age
  __
----------------------------------------------
End of MySQL Workbench Report
*/

/* The sync script
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';

ALTER TABLE `mydb`.`test1` CHANGE COLUMN `Name` `Name` VARCHAR(45) NOT NULL COMMENT 'Nick or real'  , CHANGE COLUMN `Age` `Age` TINYINT(3) UNSIGNED NOT NULL COMMENT 'Steadily growing older...'  ;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
*/