From 4f4c4eceb3e4d6b01a87c4c5dbb65df24fcc0638 Mon Sep 17 00:00:00 2001
From: Robin Sheat <robin@catalyst.net.nz>
Date: Wed, 20 Oct 2010 14:28:29 +1300
Subject: [PATCH] Bug 5313 - allow creation of libraries with hyphens

Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
---
 debian/scripts/koha-create | 8 +++-----
 debian/scripts/koha-remove | 4 ++--
 2 files changed, 5 insertions(+), 7 deletions(-)

diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create
index 672c841de6..e3c73fca51 100755
--- a/debian/scripts/koha-create
+++ b/debian/scripts/koha-create
@@ -125,19 +125,17 @@ then
 
     # Generate Zebra database password.
     zebrapwd="$(pwgen -1)"
-
     # Set up MySQL database for this instance.
     if [ "$op" = create ]
     then
         mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof
-CREATE DATABASE $mysqldb;
-CREATE USER '$mysqluser'@'%' IDENTIFIED BY '$mysqlpwd';
-GRANT ALL PRIVILEGES ON $mysqldb.* TO '$mysqluser';
+CREATE DATABASE \`$mysqldb\`;
+CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd';
+GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`;
 FLUSH PRIVILEGES;
 eof
     fi
 
-
     # Generate and install Apache site-available file and log dir.
     generate_config_file apache-site.conf.in \
         "/etc/apache2/sites-available/$name"
diff --git a/debian/scripts/koha-remove b/debian/scripts/koha-remove
index 97399cca35..10a8b781e5 100755
--- a/debian/scripts/koha-remove
+++ b/debian/scripts/koha-remove
@@ -25,8 +25,8 @@ do
     echo "Removing Koha instance $name"
 
     mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof
-DROP USER 'koha_$name';
-DROP DATABASE koha_$name;
+DROP USER \`koha_$name\`;
+DROP DATABASE \`koha_$name\`;
 FLUSH PRIVILEGES;
 eof
     
-- 
2.39.5