summaryrefslogtreecommitdiff
path: root/scripts/make-tables
diff options
context:
space:
mode:
authorlvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b>2004-05-28 15:30:48 +0000
committerlvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b>2004-05-28 15:30:48 +0000
commit2370a13b7f6512147550e5eec8a773e69d49119b (patch)
treedcf92a706d71b2c21cebef1969298c761f74de2c /scripts/make-tables
parent616adfc77dc1d08f3bfcd79991a78c6350e4e2f6 (diff)
downloadvdr-plugin-muggle-2370a13b7f6512147550e5eec8a773e69d49119b.tar.gz
vdr-plugin-muggle-2370a13b7f6512147550e5eec8a773e69d49119b.tar.bz2
Merged and added import scripts
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@99 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'scripts/make-tables')
-rwxr-xr-xscripts/make-tables26
1 files changed, 26 insertions, 0 deletions
diff --git a/scripts/make-tables b/scripts/make-tables
new file mode 100755
index 0000000..1dc9c01
--- /dev/null
+++ b/scripts/make-tables
@@ -0,0 +1,26 @@
+#!/bin/sh
+
+##################################################
+#
+# GiantDisc mp3 Jukebox
+#
+# © 2000-2002, Rolf Brugger
+#
+##################################################
+
+cd /home/andi/muggle/import
+
+echo "creating tables"
+mysql < createtables.mysql
+
+echo "reading genres"
+mysql --local-infile=1 < readgenres.mysql
+
+echo "reading languages"
+mysql --local-infile=1 < readlanguages.mysql
+
+echo "reading musictypes"
+mysql --local-infile=1 < readmusictypes.mysql
+
+echo "reading sources"
+mysql --local-infile=1 < readsources.mysql