Remove unused Gem Adoption tables

[colby-swandale]

What's this about?

We removed Gem Adoptions in #5356, but it seems we haven't yet cleaned up the relevant tables.

Tasks

• Remove unused Gem Adoption tables