sqlite does recognize the SMALLINT keyword and treats it as an INTEGER (sqlite only has two number types, integer and real). See here under "Type Affinity": https://www.sqlite.org/datatype3.html