SQLite Forum

Can't migrate auto-increment bigint columns
Login
Chronological Hierarchical 
sqlite> create table x (i averybigint, j alittleint, k doyouseetheint, l interesting);
sqlite> create table y as select * from x;
sqlite> .schema
CREATE TABLE x (i averybigint, j alittleint, k doyouseetheint, l interesting);
CREATE TABLE y(i INT,j INT,k INT,l INT);
sqlite> 

There is nothing special about 'bigint'.  It simply contains 'int'.