title: SQLite: ON DELETE CASCADE is not working right
body: <p>I tried very often and looked also on the other forum posts, but they didn't help me.
  This is my problem: I create Tables like this:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS Parent
      (Id INTEGER PRIMARY KEY,
       Name STRING);
  CREATE TABLE IF NOT EXISTS Child
      (Id INTEGER,
       Name STRING,
       ParentId INTEGER,
       PRIMARY KEY (Id, ParentId)
       FOREIGN KEY (ParentId) REFERENCES Parent (ParentId) ON DELETE CASCADE);
  </code></pre>
  
  <p>After that I insert this:</p>
  
  <pre><code>INSERT INTO Parent (Id, Name) VALUES (1, 'Michael');
  INSERT INTO Child (Id, Name, ParentId) VALUES (1, 'Paul', 1);
  </code></pre>
  
  <p>Alright! We have now in each table a row with a parent and a child. Now I want to delete the parent:</p>
  
  <pre><code>DELETE FROM Parent WHERE Id = 1;
  </code></pre>
  
  <p>What is happening? The row in the table 'Parent' is not there anymore, but the row in the table 'Child' is still there, even if I said: 'ON DELETE CASCADE'.</p>