migration.js

const sqlite3 = require('sqlite3');

const db = new sqlite3.Database('./database.sqlite');

db.run('CREATE TABLE IF NOT EXISTS `Artist` ( ' +
    '`id` INTEGER PRIMARY KEY NOT NULL, ' +
    '`name` TEXT NOT NULL, ' +
    '`date_of_birth` TEXT NOT NULL, ' +
    '`biography` TEXT NOT NULL, ' +
    '`is_currently_employed` INTEGER NOT NULL DEFAULT 1)', () => {
        console.log('Migrated Artist Successfully!')
    });

db.run('CREATE TABLE IF NOT EXISTS `Series` ( ' +
    '`id` INTEGER PRIMARY KEY NOT NULL, ' +
    '`name` TEXT NOT NULL, ' +
    '`description` TEXT NOT NULL)', () => {
        console.log('Migrated Series Successfully!')
    });

db.run('CREATE TABLE IF NOT EXISTS `Issue` ( ' +
    '`id` INTEGER NOT NULL, ' +
    '`name` TEXT NOT NULL, ' +
    '`issue_number` INTEGER NOT NULL,' +
    '`publication_date` TEXT NOT NULL,' +
    '`artist_id` INTEGER NOT NULL,' +
    '`series_id` INTEGER NOT NULL,' +
    'PRIMARY KEY (`id`),' +
    'FOREIGN KEY (`artist_id`) REFERENCES Artist(`id`),' +
    'FOREIGN KEY (`series_id`) REFERENCES Series(`id`))', () => {
        console.log('Migrated Issue Successfully!')
    });