import * as Knex from "knex";

export async function up(knex: Knex): Promise<any> {
  await knex.schema.createTable("votes", table => {
    table.increments("_Id").primary();
    table.integer("points");

    table.dateTime("created_on");
    table.dateTime("updated_on");
    table.integer("updated_by");
    table.integer("created_by");

    table
      .integer("user_id")
      .references("id")
      .inTable("users");

    table
      .integer("article_id")
      .references("id")
      .inTable("articles");
  });
}

export async function down(knex: Knex): Promise<any> {
  await knex.schema.dropTable("votes");
}