bvandeusen
780beaa248
Three tables keyed on (user_id, entity_id) with liked_at. Per-table indexes on (user_id, liked_at DESC) for the recently-liked feed. sqlc queries cover like/unlike/list-rows/count/list-ids per entity.
4 lines
123 B
SQL
4 lines
123 B
SQL
DROP TABLE IF EXISTS general_likes_artists;
|
|
DROP TABLE IF EXISTS general_likes_albums;
|
|
DROP TABLE IF EXISTS general_likes;
|