title: MySQL DB is ignoring foreign key constraints
body: <p>I've got a really strange (and scary) issue: My mySQL DB is generally ignoring foreign key constraints!</p>
  
  <p>All my tables are <code>InnoDB</code> and I'm creating them with liquibase like this:</p>
  
  <pre><code>&lt;addForeignKeyConstraint baseColumnNames="user_account_id"
      baseTableName="account_transaction"
      constraintName="fk_account_transaction_user_account_id"
      referencedColumnNames="id"
      referencedTableName="user_account"/&gt;
  </code></pre>
  
  <p>The foreign keys are created fine. In HeidiSQL I see them like this:
  <a href="https://i.stack.imgur.com/xG0Ga.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xG0Ga.png" alt="heidiSQL DB Management"></a></p>
  
  <p>I also checked for <code>FOREIGN_KEY_CHECKS</code> and I've set it to 1 (<code>SET FOREIGN_KEY_CHECKS=1;</code>)</p>
  
  <p>All my ID columns have the data type <code>BIGINT</code> (dunno if that matters).</p>
  
  <p>What is also worth to mention: The following statement</p>
  
  <pre><code>  SELECT * FROM information_schema.TABLE_CONSTRAINTS
  WHERE CONSTRAINT_SCHEMA = DATABASE();
  </code></pre>
  
  <p>returns a bunch of constraints, but no foreign key constraints... When I execute the same statement on my local mySQL DB, it returns all the constraints INCLUDING foreign key constraints. I can't figure out what's the difference between them though... </p>
  
  <p>Any help is very much appreciated :)</p>
  
  <p>@Update:
  So the hint with MyISAM and InnoDB did the trick. I did investigate that before. However, for some reason my tables are InnoDB, but my DB is MyISAM. I'm gonna make further investigations on that :)
  <a href="https://i.stack.imgur.com/9Vf9y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9Vf9y.png" alt="enter image description here"></a></p>