DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_USER=root
DB_PASSWORD=password
DB_DATABASE=adonis

'use strict'

/** @type {import('@adonisjs/lucid/src/Schema')} */
const Schema = use('Schema')

class CustomerSchema extends Schema {
  up () {
    this.create('customers', (table) => {
      table.increments()
      table.string('name', 100).notNullable()
      table.string('email', 80).notNullable().unique()
      table.string('address', 100)
      table.bigInteger('phone', 100)
      table.timestamps()
    })
  }

  down () {
    this.drop('customers')
  }
}

module.exports = CustomerSchema

'use strict'

/** @type {typeof import('@adonisjs/lucid/src/Lucid/Model')} */
const Model = use('Model')

class Customer extends Model {

  static get table () {
    return 'customers'
  }

  // static get createdAtColumn () {
  //   return null
  // }
  //
  // static get updatedAtColumn () {
  //   return null
  // }

}

module.exports = Customer