X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreatemirdb.sh;h=28efe1618e16f6cf2e1e0ce65cf7a0510c5e36cf;hb=7ae692e7d7b8b001df03ebc088c717913b0f7aa0;hp=6d7975dee7f8ad598521b9c11465dd39f71dfe77;hpb=fde177e73d52ff087e16e2854c4a9996a7d0729a;p=mir.git

diff --git a/dbscripts/createmirdb.sh b/dbscripts/createmirdb.sh
index 6d7975de..28efe161 100755
--- a/dbscripts/createmirdb.sh
+++ b/dbscripts/createmirdb.sh
@@ -17,8 +17,8 @@ fi;
 SCRIPT_FILE="/tmp/createmir.$$.sql"
 
 # database/user creation
-echo "CREATE DATABASE $1 WITH ENCODING='UNICODE';" > ${SCRIPT_FILE}
-echo "CREATE USER "$3" WITH PASSWORD '$4';" >> ${SCRIPT_FILE}
+echo "CREATE DATABASE \"$1\" WITH ENCODING='UNICODE';" > ${SCRIPT_FILE}
+echo "CREATE USER \"$3\" WITH PASSWORD '$4';" >> ${SCRIPT_FILE}
 echo "UPDATE pg_database SET datdba=(select usesysid from pg_user where usename='$3') where datname='$1';" >> ${SCRIPT_FILE}
 
 echo "\connect $1" >> ${SCRIPT_FILE}
@@ -30,19 +30,17 @@ for i in populate*.sql ; do echo "\i ${i}" >> ${SCRIPT_FILE} ; done
 echo "\i update_all_sequences.sql" >> ${SCRIPT_FILE}
 
 # grant rights
+echo "grant all on media_type      to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on img_format      to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on img_layout      to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on img_type        to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on img_color       to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on language        to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on rights          to $3;"   >> ${SCRIPT_FILE}
-echo "grant all on feature         to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on article_type    to $3;"   >> ${SCRIPT_FILE}
-echo "grant all on media           to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on breaking        to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on messages        to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on comment_status  to $3;"   >> ${SCRIPT_FILE}
-echo "grant all on links_imcs      to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on other_media     to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on webdb_users     to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on content_x_topic to $3;"   >> ${SCRIPT_FILE}
@@ -50,27 +48,27 @@ 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}
 echo "grant all on comment         to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on media_folder    to $3;"   >> ${SCRIPT_FILE}
-
+echo "grant all on db_patches      to $3;"   >> ${SCRIPT_FILE}
+echo "grant all on model_version   to $3;"   >> ${SCRIPT_FILE}
 
 echo "grant all on media_id_seq    to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on media_folder_id_seq to $3;"   >> ${SCRIPT_FILE}
-echo "grant all on feature_id_seq  to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on topic_id_seq    to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on webdb_users_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on comment_id_seq  to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on breaking_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on messages_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on media_type_id_seq to $3;"   >> ${SCRIPT_FILE}
-echo "grant all on links_imcs_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on comment_status_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on article_type_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on language_id_seq to $3;"   >> ${SCRIPT_FILE}
-
+echo "grant all on db_patches_id_seq to $3;"   >> ${SCRIPT_FILE}
 
 # execute the script
 psql -U $2 -f ${SCRIPT_FILE} -d template1