Migrate away from using Drupal DBs where applicable
As noted here, we need to stop referencing the Drupal DBs that will be removed once accounts is migrated to Drupal 10.
One of these is the api_eclipse_api_gerrit_review_count
table. I propose we keep the same schema but with the username
instead of the current uid
field. And update the name to simply gerrit_review_count
. Pointing the Gerrit process to this new DB should be pretty simple. We shouldn't need to migrate any data since the code will update the DB for us. When a user navigates to their accounts page, this data will be pulled, updated, and persisted. It would look like this:
Name | Type |
---|---|
username(PK) | varchar(63) |
review_count | int(11) |
report_date | int(11) |
Profile-API also references these tables: api_eclipse_api_user_delete_request
, friends
(used to anonymize data in the user_delete process), and account_requests
. Is it safe to assume we will continue to use these after the D10 migration?