# ONE-LINER TO FIX ASSIGNMENT_NUMBER FIELD
# Run this in your cPanel terminal/SSH

cd /home/acbptxvs/public_html/branchbusinessadvance.co.ke && python3 -c "
import os, django
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'branch_system.settings')
django.setup()
from django.db import connection
with connection.cursor() as cursor:
    cursor.execute('ALTER TABLE portfolio_assignments MODIFY COLUMN assignment_number VARCHAR(50) NULL')
    print('Fixed assignment_number column to allow NULL values')
" && echo "ASSIGNMENT_NUMBER FIXED!"
