I suggest you try manipulating your database directly in sqlite3, without using CodeRunner; I think you'll find that you have the same problems. In which case, this isn't really a CodeRunner-related question.
This link might help? Otherwise, I suggest you either build yourself a new database from scratch rather than importing one. Or post your question on an sqlite forum.