1 import { Knex } from "knex";
4 export async function up(knex: Knex): Promise<void> {
5 return knex.schema.createTable('travel', function(table) {
6 table.string('player_id').primary();
7 table.integer('source_id').notNullable();
8 table.integer('destination_id').notNullable();
9 table.integer('total_distance').notNullable();
10 table.integer('current_position').notNullable().defaultTo(0);
15 export async function down(knex: Knex): Promise<void> {
16 return knex.schema.dropTable('travel');