title: Adding NOT NULL column to SQLite table with references
body: <p>I need to add a column to my existing SQLite table that references a column in another table.  I use the command</p>
  
  <pre><code>ALTER TABLE users 
   ADD COLUMN dayChoice_id INTEGER 
               NOT NULL REFERENCES dayChoice(dayChoice_id) DEFAULT 0
  </code></pre>
  
  <p>And I get the error "Cannot add a REFERENCES column with non-NULL default value".  Is that true?  How would I add the column then?</p>