Skip to content
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

Migrate tables without uuid primary keys #774

Open
2 tasks
baktun14 opened this issue Feb 3, 2025 · 0 comments
Open
2 tasks

Migrate tables without uuid primary keys #774

baktun14 opened this issue Feb 3, 2025 · 0 comments
Labels
sev2 severity 2 bug

Comments

@baktun14
Copy link
Contributor

baktun14 commented Feb 3, 2025

Why

Some tables don't have a primary key defined in the sequelize schema and it generated automatic integer sequecial primary keys. These values are capped at around 2.14 billion. We're not exactly there yet, but eventually with more and more transactions it is just a matter of time before we hit those caps

Image

Solution

  • Add the primary keys with uuid to the tables missing primary key
  • Create a migration script to update the existing tables
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
sev2 severity 2 bug
Projects
Status: Backlog (not prioritized)
Development

No branches or pull requests

1 participant