Saying 'bigint' will get you an integer. See: https://www.sqlite.org/datatype3.html and look at sections 2 and 3.1.