alexzherdev/foosballtracker

View on GitHub
migrations/20160424195250_createPlayersTeams.js

Summary

Maintainability
A
0 mins
Test Coverage
exports.up = function(knex, Promise) {
  return knex.schema.createTableIfNotExists('players_teams', function(table) {
    table.increments();
    table.integer('player_id').unsigned().notNullable().references('players.id');
    table.integer('team_id').unsigned().notNullable().references('teams.id');
  });
};

exports.down = function(knex, Promise) {
  return knex.schema.dropTable('players_teams');
};