X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreatemirdb.sh;h=28efe1618e16f6cf2e1e0ce65cf7a0510c5e36cf;hb=refs%2Fheads%2Fmaster;hp=dd26e9ebb9d7b9e348fc3900c43fa219bac6331c;hpb=357b3d4acb4cb9b8729578ab6fbc8c6f2fa9f7f8;p=mir.git diff --git a/dbscripts/createmirdb.sh b/dbscripts/createmirdb.sh index dd26e9eb..28efe161 100755 --- a/dbscripts/createmirdb.sh +++ b/dbscripts/createmirdb.sh @@ -37,13 +37,10 @@ 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} @@ -57,22 +54,21 @@ 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