Feature proposal #7619open
Implement additional unique indexes
A unique index should be on the likes and follows tables for user id and asset. A user can't like or follow the same asset twice. This would further improve SQL performance, but migration code needs to be implemented to clean up the duplicates first before the index is made unique.