When creating an SQLite model in Appcelerator Studio you can add columns. However, the column types are incorrect. SQLite only has a handful.
When running the application and using the model you're getting warnings
(See attachment for the types Studio suggests)
However, the actual types are, in uppercase:
Studio should be updated to reflect that.