CREATE TABLE ingredients ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name VARCHAR(50), quantity SMALLINT )