Tanya
de2144be2a
This commit introduces several new scripts for managing database operations, including user creation, permission grants, and data migrations. It also adds new documentation files to guide users through the setup and configuration processes. Additionally, the project structure is updated to enhance organization and maintainability, ensuring a smoother development experience for contributors. These changes support the ongoing transition to a web-based architecture and improve overall project functionality.
16 lines
696 B
SQL
16 lines
696 B
SQL
-- 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.'
|
|
|