diff options
-rwxr-xr-x | scripts/createdb.mysql | 5 | ||||
-rwxr-xr-x | scripts/make-db | 8 | ||||
-rwxr-xr-x | scripts/make-empty-db | 13 | ||||
-rwxr-xr-x | scripts/make-tables | 26 |
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 |