migrations.js

exports.up = function(knex, Promise) {
  return knex.schema.hasTable('short_urls').then(function(exists) {
    if (!exists) {
      return knex.schema.createTable('short_urls', function(t) {
        t.increments('id').primary();
        t.text('long_url');
        t.string('token', 11);
        t.index(['token'], 'short_urls_token_idx')
        t.timestamps();
      });
    }
  });
};

exports.down = function(knex, Promise) {
  return knex.schema.hasTable('short_urls').then(function(exists) {
    if (exists) { knex.schema.dropTable('short_urls') }
  });
};