From 357b3d4acb4cb9b8729578ab6fbc8c6f2fa9f7f8 Mon Sep 17 00:00:00 2001
From: zapata <zapata>
Date: Sat, 19 Apr 2003 01:26:59 +0000
Subject: [PATCH] update to create db script + new script to change the owner
 of a mir database

---
 dbscripts/createmirdb.sh         |  1 +
 dbscripts/extra/changedbowner.sh | 70 ++++++++++++++++++++++++++++++++++++++++
 2 files changed, 71 insertions(+)
 create mode 100755 dbscripts/extra/changedbowner.sh

diff --git a/dbscripts/createmirdb.sh b/dbscripts/createmirdb.sh
index 237a6fbf..dd26e9eb 100755
--- a/dbscripts/createmirdb.sh
+++ b/dbscripts/createmirdb.sh
@@ -51,6 +51,7 @@ echo "grant all on topic           to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on uploaded_media  to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on images          to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on content_x_media to $3;"   >> ${SCRIPT_FILE}
+echo "grant all on comment_x_media to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on audio           to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on video           to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on content         to $3;"   >> ${SCRIPT_FILE}
diff --git a/dbscripts/extra/changedbowner.sh b/dbscripts/extra/changedbowner.sh
new file mode 100755
index 00000000..4bc139d9
--- /dev/null
+++ b/dbscripts/extra/changedbowner.sh
@@ -0,0 +1,70 @@
+#!/bin/bash
+
+# bash script to change the owner of a database
+#
+# 
+
+usage () {
+  echo "usage: $0 dbname newowner"
+}
+
+if [ $# -ne 2 ]; then
+  usage 
+  exit;
+fi;
+  
+SCRIPT_FILE="/tmp/createmir.$$.sql"
+
+echo "UPDATE pg_database SET datdba=(select usesysid from pg_user where usename='$2') where datname='$1';" > ${SCRIPT_FILE}
+
+echo "\connect $1" >> ${SCRIPT_FILE}
+
+# grant rights
+echo "grant all on media_type      to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on img_format      to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on img_layout      to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on img_type        to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on img_color       to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on language        to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on rights          to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on feature         to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on article_type    to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on media           to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on breaking        to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on messages        to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on comment_status  to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on links_imcs      to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on other_media     to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on webdb_users     to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on content_x_topic to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on topic           to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on uploaded_media  to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on images          to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on content_x_media to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on comment_x_media to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on audio           to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on video           to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on content         to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on comment         to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on media_folder    to $2;"   >> ${SCRIPT_FILE}
+			  
+
+echo "grant all on media_id_seq    to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on media_folder_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on feature_id_seq  to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on topic_id_seq    to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on webdb_users_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on comment_id_seq  to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on breaking_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on messages_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on media_type_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on links_imcs_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on comment_status_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on article_type_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on language_id_seq to $2;"   >> ${SCRIPT_FILE}
+
+
+# execute the script
+psql -f ${SCRIPT_FILE} -d template1
+
+rm ${SCRIPT_FILE}
-- 
2.11.0