1 import { Knex } from "knex";
4 export async function up(knex: Knex): Promise<void> {
5 return knex.schema.createTable('items', function(table) {
6 table.increments('id').primary();
8 table.string('description');
9 table.string('effect_name');
10 table.string('icon_name');
11 }).createTable('player_items', function(table) {
12 table.integer('item_id');
13 table.string('player_id');
14 table.integer('amount').defaultTo(1);
16 table.primary(['item_id', 'player_id']);
21 export async function down(knex: Knex): Promise<void> {
22 return knex.schema.dropTable('items').dropTable('player_items');