1 import { Knex } from "knex";
4 const monsterColumns = ['helmAp', 'chestAp', 'armsAp', 'legsAp'];
6 export async function up(knex: Knex): Promise<void> {
7 return knex.schema.alterTable('players', function(table) {
8 table.integer('vigor').defaultTo(0);
9 }).alterTable('monsters', function(table) {
10 monsterColumns.forEach(col => {
11 table.dropColumn(col);
13 table.integer('defence').notNullable().defaultTo(0);
14 }).alterTable('fight', function(table) {
15 monsterColumns.forEach(col => {
16 table.dropColumn(col);
18 table.integer('defence').notNullable().defaultTo(0);
23 export async function down(knex: Knex): Promise<void> {
24 return knex.schema.alterTable('players', function(table) {
25 table.dropColumn('vigor');
26 }).alterTable('monsters', function(table) {
27 monsterColumns.forEach(col => {
28 table.integer(col).defaultTo(0)
30 table.dropColumn('defence');
31 }).alterTable('fight', function(table) {
32 monsterColumns.forEach(col => {
33 table.integer(col).defaultTo(0)
35 table.dropColumn('defence');