import { BaseSchema } from '@adonisjs/lucid/schema'

export default class extends BaseSchema {
  protected tableName = 'customers'

  async up() {
    this.schema.alterTable(this.tableName, (table) => {
      // 既存のstatusカラムを削除して再作成
      table.dropColumn('status')
    })

    this.schema.alterTable(this.tableName, (table) => {
      table.enum('status', ['active', 'waiting', 'checked_out', 'cancelled']).notNullable().defaultTo('active')
    })
  }

  async down() {
    this.schema.alterTable(this.tableName, (table) => {
      table.dropColumn('status')
    })

    this.schema.alterTable(this.tableName, (table) => {
      table.enum('status', ['active', 'checked_out', 'cancelled']).notNullable().defaultTo('active')
    })
  }
}