Feat/113 team invitation system #21

	name: Database Migration Check

	on:
	pull_request:
	paths:
	- 'prisma/schema.prisma'
	- 'prisma/migrations/**'

	permissions:
	contents: read
	checks: write

	jobs:
	validate:
	name: Validate Migrations
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16-alpine
	env:
	POSTGRES_USER: test_user
	POSTGRES_PASSWORD: test_password
	POSTGRES_DB: test_db
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Setup Node.js
	uses: actions/setup-node@v4
	with:
	node-version: 22.x
	cache: npm

	- name: Install dependencies
	run: npm ci

	- name: Deploy migrations
	run: npx prisma migrate deploy
	env:
	DATABASE_URL: postgresql://test_user:test_password@localhost:5432/test_db

	- name: Check migration status
	run: npx prisma migrate status
	env:
	DATABASE_URL: postgresql://test_user:test_password@localhost:5432/test_db

	- name: Generate Prisma client
	run: npx prisma generate
	env:
	DATABASE_URL: postgresql://test_user:test_password@localhost:5432/test_db

Provide feedback