Column 'tbl1.id' is not the same data type as referencing column 'tbl2.field_id' in foreign key 'tb1_field_id_tbl2_id'
I have a problem with migrations. I'm using database which was created with old Django version 1.4 in new application with Django version >5. The problem is that old Django is using different data type for primary key field (AutoField - int in database). So in database datatype of old django's primary key is "int" and in the new Django datatype is "bigint". I've created new model with Foreign Key to old model and now I'm facing an error:
Column 'tbl1.id' is not the same data type as referencing column 'tbl2.field_id' in foreign key 'tb1_field_id_tbl2_id'
How can I solve this problem?
Only thing that help is to assign db_constraint=True in the models.ForeignKey field. But I don't want have this risk.
Things that I've already tried:
- Change DEFAULT_AUTO_FIELD to django.db.models.AutoField
- Explicitly set id of foreign key table to AutoField. To much dependencies on this table, so it crashes on other relations.
- Explicitly map to certain field
to_field="id" - Set
db_constraint=False- it helps but not the best solution. - Made new migration for new model with AutoField. It seems like Django still refer to
bigintfor foreign key table