title: How to add default value in SQLite?
body: <p>I had a table modified to add status column to it in this fashion</p>
  
  <pre><code>ALTER TABLE ITEM ADD COLUMN STATUS VARCHAR DEFAULT 'N';
  </code></pre>
  
  <p>However SQLite doesnt seem to add N to the column for any new ITEM created. Is the syntax wrong or is there any issue with SQLite and its support for defaults.</p>
  
  <p>I am using SQLite 3.6.22</p>