From 53cb7cc1a416d38a26a5287478e00920f3d67b7c Mon Sep 17 00:00:00 2001
From: Adam Chlipala <adamc@hcoop.net>
Date: Tue, 17 Apr 2007 03:17:08 +0000
Subject: [PATCH 1/1] Change dbtool to create user only (and assign tablespace
 ownership for Postgres)

---
 src/plugins/domtool-mysql    | 7 +++++--
 src/plugins/domtool-postgres | 5 ++++-
 2 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/src/plugins/domtool-mysql b/src/plugins/domtool-mysql
index 4fad400..657ed00 100755
--- a/src/plugins/domtool-mysql
+++ b/src/plugins/domtool-mysql
@@ -2,8 +2,11 @@
 
 case $1 in
 	adduser)
-		echo MySQL user was already created during create-user.
-	;;
+		USERNAME=$2
+		PASSWORD=$3
+
+		sudo -H mysql -e "CREATE USER '$USERNAME'@'localhost' IDENTIFIED BY '$PASSWORD';"
+
 	passwd)
 		USERNAME=$2
 		PASSWORD=$3
diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index cbc10e9..1d945d4 100755
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -2,7 +2,10 @@
 
 case $1 in
 	adduser)
-		echo Postgres user was already created during create-user.
+		USERNAME=$2
+
+		sudo -u postgres psql -c "CREATE USER $USERNAME" template1
+		sudo -u postgres psql -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
 	;;
 	createdb)
 		USERNAME=$2
-- 
2.20.1