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

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

DROP TABLE IF EXISTS `mydb`.`myView`;
CREATE VIEW `mydb`.`myView` AS
select 0;