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 `mydb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb1`;

-- -----------------------------------------------------
-- Table `mydb2`.`foobar2`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb2`.`foobar2` ;

CREATE  TABLE IF NOT EXISTS `mydb2`.`foobar2` (
  `foobar2_id` INT NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(45) NULL ,
  PRIMARY KEY (`foobar2_id`) )
ENGINE = InnoDB;


DELIMITER //

DROP TRIGGER IF EXISTS `mydb2`.`trg_foobar2_inserted` //
CREATE 
TRIGGER mydb2.trg_foobar2_inserted
AFTER INSERT on mydb2.foobar2
FOR EACH ROW
BEGIN
    INSERT INTO mydb2.foobar3 SET foobar2_id = NEW.foobar2_id;
END//


DELIMITER ;

-- -----------------------------------------------------
-- Data for table `mydb2`.`foobar2`
-- -----------------------------------------------------
SET AUTOCOMMIT=0;
INSERT INTO `foobar2` (`foobar2_id`, `name`) VALUES (1, 'one');
INSERT INTO `foobar2` (`foobar2_id`, `name`) VALUES (2, 'two');
INSERT INTO `foobar2` (`foobar2_id`, `name`) VALUES (3, 'three');

COMMIT;

-- -----------------------------------------------------
-- Table `mydb1`.`foobar1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb1`.`foobar1` ;

CREATE  TABLE IF NOT EXISTS `mydb1`.`foobar1` (
  `foobar1_id` INT NOT NULL AUTO_INCREMENT ,
  `foobar2_id` INT NOT NULL ,
  `name` VARCHAR(45) NOT NULL ,
  PRIMARY KEY (`foobar1_id`) ,
  INDEX fk_foobar1_foobar2 (`foobar2_id` ASC) ,
  CONSTRAINT `fk_foobar1_foobar2`
    FOREIGN KEY (`foobar2_id` )
    REFERENCES `mydb2`.`foobar2` (`foobar2_id` )
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;

CREATE SCHEMA IF NOT EXISTS `mydb2` ;
USE `mydb2`;

-- -----------------------------------------------------
-- Table `mydb2`.`foobar3`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb2`.`foobar3` ;

CREATE  TABLE IF NOT EXISTS `mydb2`.`foobar3` (
  `foobar3_id` INT NOT NULL AUTO_INCREMENT ,
  `foobar2_id` INT NOT NULL ,
  `count` INT NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`foobar3_id`) ,
  INDEX fk_foobar3_foobar2 (`foobar2_id` ASC) ,
  CONSTRAINT `fk_foobar3_foobar2`
    FOREIGN KEY (`foobar2_id` )
    REFERENCES `mydb2`.`foobar2` (`foobar2_id` )
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;



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