fixed migrations and report #20

	name: Build and deploy a container to an Azure Container Registry

	on:
	push:
	branches: [ "main" ]
	workflow_dispatch:

	permissions:
	contents: read

	env:
	SQLFLUFF_DIALECT: postgres
	DOCKER_IMAGE: redgate/flyway
	SCHEMAS: public

	jobs:
	build:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout
	uses: actions/checkout@v2

	- name: Apply migrations
	run: >-
	docker run --rm
	--volume ${{ github.workspace }}/src/migrations:/flyway/sql:ro
	--volume ${{ github.workspace }}/reports:/flyway/reports
	"${{ env.DOCKER_IMAGE }}"
	-url="${{ secrets.DB_PROD_URL }}"
	-user="${{ secrets.DB_PROD_USERNAME }}"
	-password="${{ secrets.DB_PROD_PASSWORD }}"
	migrate -schemas="${{ env.SCHEMAS }}"

	- name: Upload Flyway report
	uses: actions/upload-artifact@v3
	with:
	name: Database Report
	path: reports/

	- name: 'Docker Login'
	uses: azure/docker-login@v1
	with:
	login-server: ${{ secrets.REGISTRY_LOGIN_SERVER }}
	username: ${{ secrets.REGISTRY_USERNAME }}
	password: ${{ secrets.REGISTRY_PASSWORD }}

	- name: Build the frontend image and push it to ACR
	uses: docker/build-push-action@v2
	with:
	push: true
	tags: dotnetruacr.azurecr.io/vahter-bot-ban:${{ github.sha }}, dotnetruacr.azurecr.io/vahter-bot-ban:latest
	file: ./Dockerfile

Provide feedback