test: add contract event emission tests for all state-changing functions #2

	name: Supabase schema

	on:
	push:
	branches: [main, develop]
	paths:
	- 'supabase/**'
	pull_request:
	branches: [main, develop]
	paths:
	- 'supabase/**'

	jobs:
	validate:
	name: Validate migrations
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- uses: supabase/setup-cli@v1
	with:
	version: latest

	- name: Start Supabase local stack
	run: supabase start

	- name: Apply all migrations (forward)
	run: supabase db reset

	- name: Verify rollback scripts exist for every migration
	run: \|
	missing=0
	for f in supabase/migrations/*.sql; do
	base=$(basename "$f" .sql)
	down="supabase/migrations/rollbacks/${base}.down.sql"
	if [ ! -f "$down" ]; then
	echo "Missing rollback: $down"
	missing=1
	fi
	done
	exit $missing

	- name: Stop Supabase local stack
	if: always()
	run: supabase stop

Provide feedback