I have a requirement of Create table with auto_increment using same changeset in Oracle, PostgreSQL and MySQL databases.
I have tried below approach…
- CreateTable with defaultValueSequenceNext but this is not supported on MySQL database
- Added changeset for “addAutoIncrement” but its not working with Oracle database.
What is common approach we can use, so it works for all Oracle, PostgreSQL and MySQL databases.