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.

Sign up for GitHub

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

Jump to bottom

DB: Migrate bands and characters to autoincrement IDs #43

Open
1 of 2 tasks
JanGross opened this issue Jan 19, 2023 · 1 comment
Open
1 of 2 tasks

DB: Migrate bands and characters to autoincrement IDs #43

JanGross opened this issue Jan 19, 2023 · 1 comment

Comments

@JanGross
Copy link
Owner

JanGross commented Jan 19, 2023 •
edited
Loading

Using Discogs IDs was a stupid idea.
All the existing references and records need to be migrated

  • Enable auto_increment
  • Migrate existing character and group IDs
JanGross added a commit that referenced this issue Feb 25, 2023
@JanGross
DB: Add auto_increment to Characters and Groups
1dde3a0 
starting at a very high ID because I was too lazy to migrate existing data
as it is referenced in json blobs.
Part of Issue #43
@JanGross
Copy link
Owner Author

JanGross commented Aug 7, 2023

Tables to migrate:

  • Groups
  • Characters
  • DropHistories -> dropData (This field is a JSON blob and therefore not cascadable)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@JanGross