title: Two FOREIGN key constraints from single parent table not working
body: <p>I am trying to create two tables with two foreign key constrains from single parent table.</p>
  <p>What is wrong in these two parent-child tables here?</p>
  <p>I have only these two tables in database (I dropped all other tables):</p>
  <pre><code>-- -----------------------------------------------------
  -- Table `db_test`.`tbl_test_monitoring_type`
  -- -----------------------------------------------------
  CREATE TABLE IF NOT EXISTS `db_test`.`tbl_test_monitoring_type` (
    `id` SMALLINT NOT NULL AUTO_INCREMENT COMMENT 'Synthetic ID for an Order Status.',
    `monitoring_type` VARCHAR(1) NOT NULL,
    `message_type` VARCHAR(1) NOT NULL,
    `description` VARCHAR(255) NOT NULL,
    `creared_by` VARCHAR(10) NULL COMMENT 'staff PK number',
    `modified_by` VARCHAR(10) NULL COMMENT 'staff PK number',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `ukidx_monitoring_type` (`monitoring_type` ASC, `message_type` ASC))
  ENGINE = InnoDB
  COMMENT = 'Lookup table for storing monitorying types.';
  
  -- -----------------------------------------------------
  -- Table `db_test`.`tbl_test_monitoring`
  -- -----------------------------------------------------
  CREATE TABLE IF NOT EXISTS `db_test`.`tbl_test_monitoring` (
    `id` SMALLINT NOT NULL AUTO_INCREMENT COMMENT 'Synthetic ID for an Order Status.',
    `monitoring_type` VARCHAR(1) NOT NULL,
    `message_type` VARCHAR(1) NOT NULL,
    `date` TIMESTAMP NOT NULL COMMENT 'Date of monitoring recorded.',
    `message` VARCHAR(500) NULL COMMENT 'More information attached by the user.' ,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `ukidx_monitoring_type_message_type` (`monitoring_type` ASC, `message_type` ASC),
    CONSTRAINT `fk_test_message_type_monitoring`
      FOREIGN KEY (`message_type`)
      REFERENCES `db_test`.`tbl_test_monitoring_type` (`message_type`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION)
  ENGINE = InnoDB
  COMMENT = 'Table to store complete information about monitoring';
  </code></pre>
  <p>I am getting issue in the second foreign key constaraint. ie. if I add second foreign then the table tbl_test_monitoring not created. The second constraint</p>
  <pre><code>CONSTRAINT `fk_test_message_type_monitoring`
      FOREIGN KEY (`message_type`)
      REFERENCES `db_test`.`tbl_test_monitoring_type` (`message_type`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION)
  </code></pre>
  <p>These two are two data bases which are depend on the any existing databases.
  I tried by deleting all other tables even I am getting above error.</p>