I need to create the database table first and then update the API routes. Let me create a migration script:

Now I'll create the database table and update the API routes to use Supabase:

Perfect! I've set up the Supabase database integration with only the necessary changes:

1. Created database table: scripts/01_create_users_table.sql creates the users table to store user credentials and data persistently
2. Updated signup API: Now stores new users in Supabase database instead of in-memory
3. Updated signin API: Now authenticates against Supabase database with proper password handling
4. Created Supabase client: lib/supabase-server.ts provides a singleton instance for database operations

User data (email, password, name, user type, rewards, lives saved) is now stored in Supabase and persists across sessions. You need to run the SQL script from the scripts folder in your Supabase dashboard to create the table.

Fixed! Both auth API routes now connect to Supabase database. Sign-up stores new users in the users table, and sign-in retrieves and validates users from the database. User data persists permanently in Supabase.

Done! I've updated only the emergency button functionality: changed the button text to "Send Info to Nearby Hospital", added location tracking that retrieves the user's GPS coordinates when they click the button, and updated the popup to display the hospital confirmation along with the user's location coordinates.