SQLite makes it easy to add a column, but not to modify or delete one. If you need to modify or delete a column, you need to rename the table, recreate the table with the new structure (you can use syncdb for this) and then copy the old data back into the new table.
