How to define column with DEFAULT CURRENT_TIMESTAMP?

[rise0chen]

manager
.create_table(
    sea_query::Table::create()
        .table(scene::Entity)
        .if_not_exists()
        .col(
            ColumnDef::new(scene::Column::Id)
                .integer()
                .not_null()
                .auto_increment()
                .primary_key(),
        )
        .col(
            ColumnDef::new(scene::Column::CreatedAt)
                .date_time()
                .not_null()
                .default("CURRENT_TIMESTAMP"),
        )
        .col(
            ColumnDef::new(scene::Column::UpdatedAt)
                .date_time()
                .not_null()
                .default("CURRENT_TIMESTAMP"),
        )
        .to_owned(),
)

default("CURRENT_TIMESTAMP") can't work.

[billy1624]

Hey @rise0chen, this default method, https://docs.rs/sea-query/0.23.0/sea_query/table/struct.ColumnDef.html#method.default, is intended to be setting default value instead of default expression. You can use extra method for setting default expression for now. See SeaQL/sea-query#99 for details.