Affiliate URL IDs

[Craft]

Hello,

Is there an option to make the affiliate IDs starts from a custom number for example (5000, 5001, 5002, etc..) instead of (1, 2, 3, etc...)?

[LosBooom]

It is possible to change the index via SQL:

ALTER TABLE tblaffiliates AUTO_INCREMENT=5000;

But remember that there is a limit:

Quote

You cannot reset the counter to a value less than or equal to the value that is currently in use. For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one.

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

And I highly recommend testing before making changes in production.