Cleaned up input helper scripts

git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk@126 e10066b5-e1e2-0310-b819-94efdf66514b

4 files changed, 7 insertions, 45 deletions

diff --git a/muggle-plugin/scripts/createdb.mysql b/muggle-plugin/scripts/createdb.mysql
index 8b9ea42..b68d90c 100755
--- a/muggle-plugin/scripts/createdb.mysql
+++ b/muggle-plugin/scripts/createdb.mysql
@@ -4,7 +4,6 @@
 DROP DATABASE IF EXISTS GiantDisc;
 CREATE DATABASE GiantDisc;
 use GiantDisc;
-grant all privileges on GiantDisc.* to music@'%';
-grant all privileges on GiantDisc.* to music@localhost;
-grant all privileges on GiantDisc.* to apache@localhost with grant option; 
+grant all privileges on GiantDisc.* to vdr@'%';
+grant all privileges on GiantDisc.* to vdr@localhost;
 
diff --git a/muggle-plugin/scripts/make-db b/muggle-plugin/scripts/make-db
deleted file mode 100755
index ec25531..0000000
--- a/muggle-plugin/scripts/make-db
+++ /dev/null
@@ -1,8 +0,0 @@
-#!/bin/sh
-
-export SCRIPTDIR=/home/andi/muggle/import
-cd $SCRIPTDIR
-echo "creating db"
-mysql < createdb.mysql
-
-#
diff --git a/muggle-plugin/scripts/make-empty-db b/muggle-plugin/scripts/make-empty-db
index 59d2c21..3acb512 100755
--- a/muggle-plugin/scripts/make-empty-db
+++ b/muggle-plugin/scripts/make-empty-db
@@ -1,22 +1,19 @@
 #!/bin/sh
 
-export SCRIPTDIR=/home/lvw/Development/muggle-plugin/scripts
-cd $SCRIPTDIR
-
 echo "creating db"
 mysql -u root < createdb.mysql
  
 echo "creating tables"
-mysql -u root < $SCRIPTDIR/createtables.mysql
+mysql -u root < createtables.mysql
 
 echo "reading genres"
-echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql -u root --local-infile=1 
+echo " use GiantDisc; load data local infile 'genres.txt' into table genre;"| mysql -u root --local-infile=1 
 
 echo "reading languages"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql -u root --local-infile=1
+echo "use GiantDisc; load data local infile 'languages.txt' into table language;" | mysql -u root --local-infile=1
 
 echo "reading musictypes"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql -u root --local-infile=1
+echo "use GiantDisc; load data local infile 'musictypes.txt' into table language;" | mysql -u root --local-infile=1
 
 echo "reading sources"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql -u root --local-infile=1
+echo "use GiantDisc; load data local infile 'sources.txt' into table language;" | mysql -u root --local-infile=1
diff --git a/muggle-plugin/scripts/make-tables b/muggle-plugin/scripts/make-tables
deleted file mode 100755
index 1dc9c01..0000000
--- a/muggle-plugin/scripts/make-tables
+++ /dev/null
@@ -1,26 +0,0 @@
-#!/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