ENUM in migrations

[KarelWintersky]

ENUM in migrations

[hrach]

See docs at https://nextras.org.

[mabar]

Migrations are just regular .sql files so yes, any sql compatible with your database is supported.

[KarelWintersky]

can I create this files with nextras/dbal ? On the fly, I mean

[hrach]

No, we do not have any autogeneration of the migration.

[KarelWintersky]

Sorry, what does auto generation have to do with it? I asked if your package supports SQL Enum?

[domainfun]

@KarelWintersky asked today:

Sorry, what does auto generation have to do with it? I asked if your package supports SQL Enum?

As far as I can see, your question was answered in July 2021:

Migrations are just regular .sql files so yes, any sql compatible with your database is supported.

This means if your database server supports ENUM you can put ENUM changes in an SQL file & use it, right?

You later asked:

can I create this files with nextras/dbal ? On the fly, I mean

To me, "on the fly" sounds like you're expecting some sort of auto-generation of schema changes, hence today the reply was:

No, we do not have any autogeneration of the migration.

What are we missing?

[KarelWintersky]

Good example of using. Without dbal, doctrine and other excessive staff.

How to use your tool?

[KarelWintersky]

Can not understand anything. Can I have an example of use?