--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/prod/install-workflows-db.sh	Fri Sep 10 07:47:54 2021 -0400
@@ -0,0 +1,26 @@
+#!/bin/bash
+#
+# read required env variables
+BASEDIR="$PWD"
+source $BASEDIR/.env/ssdt-workflows-shared.properties
+source $BASEDIR/.env/ssdt-workflows-db.properties
+#
+# docker login
+echo "Attempting to login to $artifactUrl"
+docker login $artifactUrl -u $artifactUser -p $artifactPassword
+# docker pull db image
+echo "Attempting to pull $artifactUrl/ssdt-workflows-$dbVersion"
+docker pull $artifactUrl/ssdt-workflows-db:$dbVersion
+#
+# Create workflows specific docker network for $entityId
+echo "Attempting to create $entityId-workflows-net docker network"
+docker network create $entityId-workflows-net
+#docker run workflows-db (data mounted as volume) connected to $entityId-workflows-net docker network
+echo "Attempting to execute docker run command"
+docker run --name $entityId-workflows-db \
+           --restart=unless-stopped \
+           --mount source=$entityId-workflows-db,target=/var/lib/postgresql/data \
+           --network $entityId-workflows-net \
+           -e POSTGRES_DB=workflowsdb \
+           -e POSTGRES_PASSWORD=$dbPassword \
+           -d $artifactUrl/ssdt-workflows-db:$dbVersion