title: SQLite Delete Cascade not working
body: <p>In Android 4.2, using SQLite 3.7.11, when I delete a row from the Quizzes table, who's schema is below, the corresponding rows in the QuizQuestions table are not deleted.</p>
  
  <p>I can't figure out what's wrong. I have tried putting </p>
  
  <pre><code>db.execSQL("PRAGMA foreign_keys = ON;"); 
  </code></pre>
  
  <p>before and after the create table statements.</p>
  
  <p>Create table statements:</p>
  
  <pre><code>CREATE TABLE quizzes(quiz_name TEXT PRIMARY KEY COLLATE NOCASE);
  
  CREATE TABLE quizQuestions(quiz_name TEXT, question_id INTEGER,
       PRIMARY KEY(quiz_name, question_id),
       FOREIGN KEY(quiz_name) REFERENCES quizzes(quiz_name) ON DELETE CASCADE,
       FOREIGN KEY(question_id) REFERENCES questions(question_id) ON DELETE CASCADE);
  </code></pre>