Erwin,
Please refer to: http://www.sqlite.org/faq.html#q13
If you are using SQLite 2.8.x then a similar solution is used by the modify table wizard in SQLite Database Browser if you prefer a GUI way to do this alteration. Make a backup of your db data first, of course.
Regards, Mauricio
