-- Quick fix: Grant DELETE permission on inappropriate_photo_reports table
-- Run this as PostgreSQL superuser: sudo -u postgres psql -d punimtag_auth -f grant-delete-permission.sql
-- 
-- BEFORE RUNNING: Edit this file and replace 'your_user' with your actual database username
-- (Check your DATABASE_URL_AUTH environment variable to see which user you're using)

\c punimtag_auth

-- Grant DELETE permission on inappropriate_photo_reports table
GRANT DELETE ON TABLE inappropriate_photo_reports TO your_user;

\echo '✅ DELETE permission granted on inappropriate_photo_reports table!'
\echo ''
\echo 'Note: Replace "your_user" with your actual database username before running this script.'