[Adonis 4.1] Database schema with zerofill auto_increments?

[aprakasa]

'use strict'

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

class CardSchema extends Schema {
  up () {
    this.create('cards', (table) => {
      table.increments() // How to add zerofill in here or
      table.int('cardID', 4).increments() // here
      table.timestamps()
    })
  }

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

module.exports = CardSchema

I want the output into something like this:

ID	cardID
1	0001
2	0002
3	0003
4	0004
5	0005

[thetutlage]

I don't know about zerofill. Maybe point me to the SQL documentation for it?

[aprakasa]

Originally was google it from here https://stackoverflow.com/a/5256505 and https://mariadb.com/kb/en/int/

[thetutlage]

You have to run a raw query to alter the column and add ZEROFILL.

// not tested
this.raw('ALTER TABLE cards CHANGE reference id INT(2) UNSIGNED ZEROFILL NOT NULL')

As a side note, I am not sure this is something you should be using coz of the following reasons

• The leading zeros in Javascript are removed from the number data type. For JS 00001 === 1.
• I think MYSQL understands this is an issue and that's why there docs mention depreciating zerofill with int data type

[aprakasa]

Ahh didn't read that part. Thank you for the enlightenment