Is it possible to set the DB default value in migration?

[manabu0926]

If this is already a feature, I would be very happy to know!

Rails

    create_table :users do |t|
      t.string :email, null: false, unique: true
      t.integer :status, default: 0 # like this!
      t.timestamps
    end

    add_column :users, :step, :integer, default: 1 # like this!

Loco, How to set?

    async fn up(&self, manager: &SchemaManager) -> Result<(), DbErr> {
        manager
            .create_table(
                table_auto_tz(Languages::Table)
                    .col(pk_auto(Languages::Id))
                    .col(string(Languages::Name))
                    .col(integer(Languages::LanguageType))
                    .to_owned(),
            )
            .await
    }

    async fn up(&self, m: &SchemaManager) -> Result<(), DbErr> {
        add_column(m, "engineers", "is_approved", ColType::Boolean).await?;
        Ok(())
    }

[kaplanelad]

Hey @manabu0926,
Currently, is not supported, but it would be great to have it!
Please feel free to open an issue, and we can talk about the possibility of implementing it.

[kaplanelad]

We open an issue: #1262

[manabu0926]

I am very happy to see that you have responded!
I look forward to being able to use it!👍