summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xscripts/createdb.mysql5
-rwxr-xr-xscripts/make-db8
-rwxr-xr-xscripts/make-empty-db13
-rwxr-xr-xscripts/make-tables26
4 files changed, 7 insertions, 45 deletions
diff --git a/scripts/createdb.mysql b/scripts/createdb.mysql
index 8b9ea42..b68d90c 100755
--- a/scripts/createdb.mysql
+++ b/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/scripts/make-db b/scripts/make-db
deleted file mode 100755
index ec25531..0000000
--- a/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/scripts/make-empty-db b/scripts/make-empty-db
index 59d2c21..3acb512 100755
--- a/scripts/make-empty-db
+++ b/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/scripts/make-tables b/scripts/make-tables
deleted file mode 100755
index 1dc9c01..0000000
--- a/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