How can I get boolean not null defaul '0' in sqlite?

[ghost]

boolean not null defaul '0'
.col(
    ColumnDef::new(Collection::IgnoreAutoTag)
        .boolean()
        .not_null()
        .default(Value::Boolean(false)),
)

[billy1624]

Hey @JediMaster25, seems to me this, '0', is a string. Try this:

.col(
    ColumnDef::new(Collection::IgnoreAutoTag)
        .boolean()
        .not_null()
        .default("0"),
)

[ghost]

That would work only for sqlite. How would it be from a false boolean to a number 0?

Would it be like this?

.col(
    ColumnDef::new(Media::Organized)
        .boolean()
        .not_null()
        .default(false),
)

I get

"organized" boolean NOT NULL DEFAULT FALSE

but I should be getting

"organized" integer NOT NULL DEFAULT 0

[billy1624]

Providing a typed integer should work.

.col(
    ColumnDef::new(Media::Organized)
        .boolean()
        .not_null()
        .default(0_i32),
)