db/migrations/20180224235946_add_close_at_to_threads.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

exports.up = async function (knex, Promise) {
  await knex.schema.table('threads', table => {
    table.dateTime('scheduled_close_at').index().nullable().defaultTo(null).after('channel_id');
    table.string('scheduled_close_id', 20).nullable().defaultTo(null).after('channel_id');
    table.string('scheduled_close_name', 128).nullable().defaultTo(null).after('channel_id');
  });
};

exports.down = async function(knex, Promise) {
  await knex.schema.table('threads', table => {
    table.dropColumn('scheduled_close_at');
    table.dropColumn('scheduled_close_id');
    table.dropColumn('scheduled_close_name');
  });
};