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

CREATE  TABLE IF NOT EXISTS `mydb2`.`table1` (
  `idtable1` INT NOT NULL ,
  `testcol2` VARCHAR(45) NULL ,
  `testcol3` VARCHAR(45) NULL ,
  `testcol4` DECIMAL(10,2) NULL ,
  PRIMARY KEY (`idtable1`) )
ENGINE = InnoDB;

CREATE VIEW `mydb2`.`myView` AS
select 0;