Changes between Version 8 and Version 9 of AdvancedDatabaseDevelopment

Timestamp:

08/05/26 11:13:39 (22 hours ago)

Author:

231136

Comment:

--

AdvancedDatabaseDevelopment

@@ -380 +380 @@
 {{{
 CREATE materialized VIEW top_songs_by_listens AS
-SELECT s.id, me.title, me.genre, u.full_name, u.username, me.cover, s.album_id
+SELECT s.id, me.title, me.genre, u.full_name, u.username, s.album_id
 FROM songs s
 JOIN listens l ON l.song_id = s.id
@@ -386 +386 @@
 JOIN users u ON u.user_id = me.released_by
 GROUP BY
-    s.id, me.title, me.genre, u.full_name, u.username, me.cover, s.album_id
+    s.id, me.title, me.genre, u.full_name, u.username, s.album_id
 ORDER BY count(*) DESC
 LIMIT 10;
@@ -398 +398 @@
     me.title AS song_title,
     me.genre AS song_genre,
-    me.cover AS song_cover,
     s.link AS song_link,
     alb_me.id AS album_id,
@@ -420 +419 @@
     p.playlist_id AS playlist_id,
     p.name AS playlist_name,
-    p.cover AS playlist_cover,
     p.created_by AS creator_id,
     COUNT(ps.song_id) AS song_count
 FROM project.playlists p
 LEFT JOIN project.playlist_songs ps ON p.playlist_id = ps.playlist_id
-GROUP BY p.playlist_id, p.name, p.cover, p.created_by;
+GROUP BY p.playlist_id, p.name, p.created_by;
 }}}
 
@@ -500 +498 @@
 );
 
-CREATE TABLE PLAYLISTS (
-    playlist_id BIGINT PRIMARY KEY,
-    cover media_url, -- <--- custom domain
-    name TEXT NOT NULL,
-    created_by BIGINT REFERENCES LISTENERS(user_id) ON DELETE CASCADE NOT NULL
-);
-
 }}}