title: what way can i fix django DB migration error without deleting migration files
body: <p>what is the best way to fix this kind of DataBase Errors without having to delete my db and migration files and starting to enter data from scratch?</p>
  <pre><code>django.db.utils.IntegrityError: The row in table 'store_product_category' with primary key '1' has an invalid foreign key: store_product_category.category_id contains a value '1' that does not have a corresponding value in store_category.id.
  </code></pre>
  <p>while inspection the sqlit DB i observe that there is a mismatch in the IDs of the store_product_category and store_category.id.</p>
  <p>is there anyway i can modify the id directly on the DB, i dont want to start deleting database files and migrations</p>