Added a machinesongs table, and a small snippet to insert all songs as EM2 machine...

[ccbs] / sql / em2-machinesongs.sql

diff --git a/sql/em2-machinesongs.sql b/sql/em2-machinesongs.sql
new file mode 100644 (file)
index 0000000..bc47d84
--- /dev/null
+++ b/sql/em2-machinesongs.sql
@@ -0,0 +1 @@
+INSERT INTO machinesongs SELECT song,(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2') FROM songs;