SQLITE tips
# start working on command line
sqlite3
# open database
.open DB-NAME
# create table
CREATE TABLE system_status (
id INTEGER PRIMARY KEY,
status VARCHAR(20),
date_start VARCHAR(20),
date_end VARCHAR(20),
pir_sensor_process_id VARCHAR(20)
);
# list tables of database
.tables
