Skip to content

Bump auto-increment fields in database to a high and recognizable starting offset. #771

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
dmsnell opened this issue Nov 22, 2023 · 0 comments

Comments

@dmsnell
Copy link
Member

dmsnell commented Nov 22, 2023

Preliminary work for #727

Let's rewrite every table create to shift the starting auto_increment value to something large and recognizable so that it's easier later to rewrite id values stored in the database.

For example, starting ids at 1,325,476,980 leaves 700 million ids (in a 32-bit Playground) and would make it easier to make a subjective call if some integer in the database is likely an id. This can be used to dynamically rewrite ids while importing contents from one site into another, or when synchronizing two WordPresses.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants