/**
 * Migration: Create shoe table.
 */

exports.up = function (knex) {
  return knex.schema.createTable("shoe", function (table) {
    table.increments("shoe_id").primary().unsigned();
    table.string("shoelace", 16).nullable();
    table.string("shoebox", 16).nullable();
    table.string("type", 16).nullable();
    table.jsonb("metadata").defaultTo({});
    table.timestamp("created_at").defaultTo(knex.fn.now());
  });
};

exports.down = function (knex) {
  return knex.schema.dropTable("shoe");
};