1 files changed, 45 insertions, 0 deletions
diff --git a/test.sql b/test.sql
new file mode 100644
index 0000000..ae8d13b
--- /dev/null
+++ b/test.sql
@@ -0,0 +1,45 @@
+--album
+SELECT
+	al.id as "ID",
+	al.name as "Title",
+	ar.name as "Artist",
+	al.original_year as "Release Year",
+	SUM(s.time) as "Duration"
+FROM album al
+JOIN artist ar ON ar.id=al.album_artist
+JOIN song s ON s.album=al.id
+GROUP BY al.id
+INTO OUTFILE '/var/lib/mysql-files/albums.csv'
+FIELDS ENCLOSED BY '"'
+TERMINATED BY ';'
+ESCAPED BY '"'
+LINES TERMINATED BY '\r\n';
+
+--song
+SELECT
+	s.id as "ID",
+	s.title as "Title",
+	ar.name as "Artist",
+	s.time as "Duration",
+	s.file as "Content"
+FROM song s
+JOIN artist ar ON ar.id=s.artist
+INTO OUTFILE '/var/lib/mysql-files/songs.csv'
+FIELDS ENCLOSED BY '"'
+TERMINATED BY ';'
+ESCAPED BY '"'
+LINES TERMINATED BY '\r\n';
+
+--playlist
+SELECT
+	p.id as "ID",
+	p.name as "Name",
+	s.title as "Song"
+FROM playlist_data pd
+JOIN playlist p ON p.id=pd.playlist
+JOIN song s ON s.id=pd.object_id
+INTO OUTFILE '/var/lib/mysql-files/playlists.csv'
+FIELDS ENCLOSED BY '"'
+TERMINATED BY ';'
+ESCAPED BY '"'
+LINES TERMINATED BY '\r\n';