import { Knex } from "knex";

export async function up(knex: Knex): Promise<any> {
  const hasChangeEmail = await knex.schema.hasColumn(
    "users",
    "change_email_token"
  );
  if (!hasChangeEmail) {
    await knex.schema.alterTable("users", table => {
      table.dateTime("change_email_expires");
      table.string("change_email_token");
      table.string("change_email_address");
    });
  }
}

export async function down(): Promise<any> {
  return null;
}