database.js file

database.js

const sqlite3 = require('sqlite3').verbose();

const db = new sqlite3.Database('./database.db', [sqlite3.OPEN_CREATE, sqlite3.OPEN_READWRITE], (err) => {
  if (err) console.error(err.message)
});

db.run(`create table if not exists users (id text, name text)`)

db.run(`
  create table if not exists logs(
    id integer primary key,
    author_id text,
    recipient_id text,
    words_count integer default 0,
    chars_count integer default 0,
    created_at text not null default (datetime('now','localtime'))
  );
`)

module.exports = db