title: SQLite Modify Column
body: <p>I need to modify a column in a SQLite database but I have to do it programatically due to the database already being in production.  From my research I have found that in order to do this I must do the following.</p>
  
  <ul>
  <li>Create a new table with new schema</li>
  <li>Copy data from old table to new table</li>
  <li>Drop old table</li>
  <li>Rename new table to old tables name</li>
  </ul>
  
  <p>That seems like a ridiculous amount of work for something that should be relatively easy.  Is there not an easier way? All I need to do is change a constraint on a existing column and give it a default value.</p>