How to update a table

I just started learning Adonis and have a database with real data already running but how do I add two more columns to a existing table?

Hi, welcome @Robmcmon

first, create a migration and use this.table(EXISTING_TABLE).

try this.

 up () {
    // remove column
    this.table('users', (table) => {
      table.dropColumn('phone')
    })

    // add column
    this.table('users', (table) => {
      table.text('email')
    })
  }