Check whether you have sqlite3 installed:
sqlite3 -version
To create a new db:
sqlite3 <filename.db>
CREATE TABLE bike ( id BIGINT NOT NULL,contact BOOLEAN NOT NULL,email VARCHAR,name VARCHAR,phone VARCHAR,purchase_date DATETIME,purchase_price NUMERIC,serial_number VARCHAR PRIMARY KEY (id) )
Quit the editing mode:
.quit
