[Django]-Set AUTOINCREMENT value in django table

5👍

You can use a RunSQL operation in your migrations to execute the necessary SQL:

migrations.RunSQL("ALTER TABLE portal_asset AUTO_INCREMENT=1000000;")

If you haven’t run any migrations, you can add this to your first migration to ensure no rows are inserted before the new value is set. Otherwise you’ll have to add this operation in a new migration. You can create a new, empty migration using python manage.py makemigrations --empty <yourappname>.

👤knbk

Leave a comment