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