SQLite3 Autoincrement, schema, table_info

 Autoincrement

Тип данных не INT, а INTEGER

CREATE TABLE proxies (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, proxy VARCHAR(16), status VARCHAR(10) DEFAULT 'good', last_used_time DATETIME DEFAULT NULL);

sqlite> pragma table_info(proxies)

0|id|INTEGER|1||1
1|proxy|VARCHAR(16)|0||0
2|status|VARCHAR(10)|0|'good'|0
3|last_used_time|DATETIME|0|NULL|0



sqlite> .schema proxies
CREATE TABLE proxies (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, proxy VARCHAR(16), status VARCHAR(10) DEFAULT 'good', last_used_time DATETIME DEFAULT NULL);