chore: keep studyu-schema.sql updated by gh action #1

	name: Dumps database schema
	on:
	push:
	paths:
	- ".github/workflows/dump-database.yml"
	- "database/**"
	- "supabase/**"
	workflow_dispatch:

	jobs:
	pgtap:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: supabase/postgres
	env:
	POSTGRES_PASSWORD: postgres
	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: Prepare Supabase CI Seed
	run: \|
	cp supabase/seed-ci.sql supabase/seed.sql

	- name: Set up Supabase CLI
	uses: supabase/setup-cli@v1
	with:
	version: latest

	- name: Start Supabase database
	run: \|
	supabase db start

	- name: Export public database schema into database/studyu-schema.sql
	run: \|
	supabase db dump --local --keep-comments --schema public --file database/studyu-schema.sql

Provide feedback