knex.js

exports.down = knex =>
  Promise.all([
    knex.schema.dropTableIfExists('boards'),
    knex.schema.dropTableIfExists('threads'),
    knex.schema.dropTableIfExists('posts'),
  ])

exports.up = knex =>
  Promise.all([
    knex.schema
      .createTable('boards', table => {
        table.increments('boardID').primary()
        table.string('name')
        table.string('description')
      }),
    knex.schema
      .createTable('threads', table => {
        table.increments('threadID').primary()
        table.string('name')
        table.foreign('boardID').references('boardID').inTable('boards')
      }),
    knex.schema
      .createTable('posts', table => {
        table.increments('post-id').primary()
        table.string('message')
        table.string('author')
        table.foreign('thread-id').references('threads')
      }),
  ])