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