title: MySQL ON DELETE CASCADE not work
body: <p>i have two table (type innoDb) why when i deleting main table row like </p>
  
  <p>+note(im using arch os so my database server type is maria db)</p>
  
  <pre><code>DELETE FROM buildings 
  WHERE
      building_no = 2;
  </code></pre>
  
  <p>relation table rows dont delete ???</p>
  
  <pre><code>CREATE TABLE buildings (
      building_no INT PRIMARY KEY AUTO_INCREMENT,
      building_name VARCHAR(255) NOT NULL,
      address VARCHAR(255) NOT NULL
  );
  
  CREATE TABLE rooms (
      room_no INT PRIMARY KEY AUTO_INCREMENT,
      room_name VARCHAR(255) NOT NULL,
      building_no INT NOT NULL,
      FOREIGN KEY (building_no)
          REFERENCES buildings (building_no)
          ON DELETE CASCADE
  );
  </code></pre>