textstable.js

exports.up = function (knex, Promise) {
    console.log('creating texts table')
    return knex.schema.createTableIfNotExists('texts', function (table) {
        table.increments('id')
        table.string('To')
        table.string('From')
        table.string('Text')
        table.datetime('Date')
    })
}

exports.down = function (knex, Promise) {
    console.log('dropping texts')
    return knex.schema.dropTableIfExists('texts').then(function () {
        console.log('texts table was dropped')
    })
}