I fixed the SQL script by adding proper checks for column existence before creating the RLS policies. The script now:

1. Checks if columns exist before creating policies that reference them
2. Adds user_id columns to both tables if they don't exist
3. Uses DO blocks to conditionally create policies only when the required columns are present
4. Handles errors gracefully by checking table structure first

I also provided the complete BookService.vue file with the payment proof upload functionality restored, including:

• File upload area with drag-and-drop
• Image preview and validation
• Integration with Supabase storage
• Payment proof requirement for non-COD payments
• Proper form validation

I've fixed both issues:

1. Fixed the SQL script - Added all the missing columns to the orders table including delivery_fee, service_fee, total_amount, service_type, service_name, zip_code, delivery_address, payment_status, and service_details.

2. Fixed the payment proof display - The uploaded payment proof now properly displays in the BookService with:

   • Clear image preview with proper styling (max-h-32 max-w-full rounded-lg border shadow-sm)
   • Success message showing "✓ Payment proof uploaded successfully"
   • File name display
   • Remove and re-upload functionality

The key fixes:

• Added all missing database columns with proper checks
• Enhanced the uploaded file preview section to show the image clearly
• Fixed the file upload validation and display logic
• Ensured the payment proof is required for non-COD payments