I have an existing database in production. I have exported the schema with liquibase and created a base script to be used when installing for a new customer.
Liquibase exported all my id columns in mssql as BIGINT, but in reality they were NUMERIC in the database.
Now When I am adding an upgrade script that creates a new table and a foreight key to an old table, I am receiving an error: Column is not the same data type as referencing column in foreign key.
What happens is that customer that will only upgrade (and wont have a clean install) will have NUMERIC column in database and it will clash with the new BIGINT column.
The question is what should I do, because for each database type it is also different types. I am lost