migrations.js

exports.up = function (knex, Promise) {
  return knex.schema.createTableIfNotExists('authors', function (table) {
    table.increments('uid').primary();
    table.string('name');
    table.string('password');
    table.string('email');
  })
    .then(res => {
      return knex.schema.createTableIfNotExists('thunks', function (table) {
        table.increments('id').primary();
        table.string('title');
        table.string('body');
        table.integer('author_id')
          .references('uid')
          .inTable('authors');
        table.dateTime('postDate');
      })
    })
    .then(res => {
      return knex.schema.createTableIfNotExists('comments', function(table) {
        table.increments('id').primary();
        table.string('body');
        table.integer('author_id')
          .references('uid')
          .inTable('authors');
        table.integer('post_id')
          .references('id')
          .inTable('thunks');
        table.dateTime('postDate');
      })
    })
};

exports.down = function (knex, Promise) {
  knex.schema.dropTableIfExists('authors');
  knex.schema.dropTableIfExists('thunks');
  knex.schema.dropTableIfExists('comments');
};