1 files changed, 0 insertions, 45 deletions
diff --git a/test.sql b/test.sql
deleted file mode 100644
index ae8d13b..0000000
--- a/test.sql
+++ /dev/null
@@ -1,45 +0,0 @@
---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';