1 files changed, 44 insertions, 0 deletions
diff --git a/README.md b/README.md
new file mode 100644
index 0000000..8b68bd1
--- /dev/null
+++ b/README.md
@@ -0,0 +1,44 @@
+OOP project in Java done in my first year, first semester at ESIEA.
+
+#Personal notes
+I decided to be ballsy and do it fully in english.
+
+For the finale I'll be using an extraction of my Ampache (ampache.adjutor.xyz) MySQL DB for my CSV files.
+Resulting in many musics.
+The genres have been added randomly to the songs.
+
+##Commands used on my DB
+Albums :
+```
+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;
+```
+
+Songs:
+```
+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;
+```
+
+Playlists :
+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;