Knex -- add new column migration file.

20200319151108_add_is_deleted_column_to_random_table.js

function up(knex) {
    return knex.schema.table('random', (table) => {
        table.boolean('is_deleted')
            .defaultsTo(0)
            .notNullable();
    });
}

function down(knex) {
    const tableName = 'random';
    const columnName = 'is_deleted';
    return knex.schema.hasColumn(tableName, columnName).then((hasColumn) => {
        if (hasColumn) {
            return knex.schema.table(tableName, (table) => {
                table.dropColumn(columnName);
            });
        }
    });
}

module.exports = {
    up,
    down,
};