-- item table CREATE TABLE items ( id INTEGER PRIMARY KEY, name TEXT, stock INTEGER );