-
Improvement
-
Resolution: Fixed
-
Normal
-
None
-
None
-
None
We currently use a username in the listens table to reference the user for who a listen refers to.
In order to allow users to rename their accounts, we should use a user_id field here instead. Note that as this table is in a separate database instance we won't be able to set a foreign key. This is the same situation that we have in the playlists tables, which are in the same db instance.
To perform the migration, we should do multiple steps
- add column to the table
- update listen writer to write both user id and username for new listens
- set background worker to update this field on old listens
- update listenstore to only use user id instead of username
- delete username column
- is a dependency of
-
LB-383 Allow updating usernames when they're changed in MusicBrainz
- Closed