Clear cache manually in update.sh to avoid post-update issues - close… #393

	name: Test App (MySQL)

	on:
	push:
	branches:
	- master
	workflow_dispatch:

	jobs:
	test:
	name: Test App (MySQL)
	runs-on: ubuntu-latest
	strategy:
	matrix:
	php: ['7.3', '7.4', '8.0', '8.1', '8.2']
	steps:
	- uses: actions/checkout@v3

	- name: Setup PHP
	uses: shivammathur/setup-php@v2
	with:
	php-version: ${{ matrix.php }}
	extensions: mysql, mbstring, xml, imap, zip, gd, curl, intl, json

	- name: Start MySQL
	run: \|
	sudo systemctl start mysql

	- name: Setup database
	run: \|
	mysql -uroot -proot -e 'CREATE DATABASE IF NOT EXISTS `freescout-test`;'
	mysql -uroot -proot -e "CREATE USER 'freescout-test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'freescout-test';"
	mysql -uroot -proot -e "GRANT ALL ON \`freescout-test\`.* TO 'freescout-test'@'localhost';"
	mysql -uroot -proot -e 'FLUSH PRIVILEGES;'

	- name: Install composer dependencies
	run: composer install --ignore-platform-reqs --no-interaction

	- name: Migrate and seed the database
	run: \|
	php${{ matrix.php }} artisan migrate --force -n --database=testing
	php${{ matrix.php }} artisan db:seed --force -n --database=testing

	- name: Run PHP tests
	run: php${{ matrix.php }} ./vendor/bin/phpunit

Provide feedback