GauntletRunner2025 assistive-tickets .cursorrules file for TypeScript

We're using Vite and React and Supabase.
Database migration scripts should go in ./supabase/migrations.
Database scripts should only create tables. Do not create triggers. Do not create functions. Do not do anything fancy other than creating tables.
Whenever creating a table, also add RLS policies.
When you want to create a trigger, just create a [name].trigger file, and inside it put the plain english of what you want to do. I'll handle it myself.
Don't create a .down.sql script to "undo" the sql script.
Instead of creating a trigger, create an edge function. I will hook it up myself. 

When creating an edge function:
The issue is that Deno (which Supabase Edge Functions use) requires full URLs for imports rather than npm-style package names. The esm.sh URL provides an ES module version of the Supabase client that works with Deno

Remember that database migration .sql files go into ./supabase/migrations