db.js

/* eslint-disable no-multi-str */
var crypto = require('crypto');
var sqlite3 = require('sqlite3');
var mkdirp = require('mkdirp');

mkdirp.sync('./var/db');

var db = new sqlite3.Database('./var/db/bonsai.db');

db.serialize(() => {
	// create the database schema for the todos app
	db.run(
		'CREATE TABLE IF NOT EXISTS users ( \
    id INTEGER PRIMARY KEY, \
    username TEXT UNIQUE, \
    hashed_password BLOB, \
    salt BLOB, \
    name TEXT, \
    mailchain_address TEXT UNIQUE, \
    mailchain_address_verified INTEGER, \
    email TEXT UNIQUE, \
    email_verified INTEGER \
)',
	);

	db.run(
		'CREATE TABLE IF NOT EXISTS federated_credentials ( \
    id INTEGER PRIMARY KEY, \
    user_id INTEGER NOT NULL, \
    provider TEXT NOT NULL, \
    subject TEXT NOT NULL, \
    UNIQUE (provider, subject) \
  )',
	);

	db.run(
		'CREATE TABLE IF NOT EXISTS bonsai ( \
    id INTEGER PRIMARY KEY, \
    owner_id INTEGER NOT NULL, \
    title TEXT NOT NULL, \
    completed INTEGER \
  )',
	);

  db.run(
		'CREATE TABLE IF NOT EXISTS scammers ( \
    id INTEGER PRIMARY KEY, \
    phone_number INTEGER, \
    name TEXT, \
    aliases TEXT, \
    numbers INTEGER, \
)',
	);

	// create an initial user (username: alice, password: letmein)
	var salt = crypto.randomBytes(16);
	db.run('INSERT OR IGNORE INTO users (username, hashed_password, salt) VALUES (?, ?, ?)', [
		'alice',
		crypto.pbkdf2Sync('letmein', salt, 310000, 32, 'sha256'),
		salt,
	]);
});

module.exports = db;