CREATE TABLE h20.house1 (
  apartmen int(11) NOT NULL AUTO_INCREMENT,
  entrance int(11) DEFAULT NULL,
  level int(11) DEFAULT NULL,
  PRIMARY KEY (apartmen)
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;

CREATE TABLE h20.roomer (
  id int(11) NOT NULL AUTO_INCREMENT,
  apartmen int(11) DEFAULT NULL,
  name varbinary(25) DEFAULT NULL,
  PRIMARY KEY (id),
  CONSTRAINT FK_roomer_apartmen2 FOREIGN KEY (apartmen)
  REFERENCES h20.house1 (apartmen) ON DELETE NO ACTION ON UPDATE RESTRICT
)
ENGINE = INNODB
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;