1 import { Knex } from "knex";
4 export async function up(knex: Knex): Promise<void> {
5 return knex.schema.createTable('shop_items', function(table) {
6 table.integer('item_id');
7 table.integer('location_id');
8 table.integer('amount');
9 table.integer('price_per_unit');
10 table.primary(['item_id', 'location_id']);
15 export async function down(knex: Knex): Promise<void> {
16 return knex.schema.dropTable('shop_items');