PASTE THIS INTO YOUR SSH TERMINAL (root@2867656c525168:/app#):

================================================================================
STEP 1: Create the fix script - Copy and paste this entire block:
================================================================================

cat > /tmp/fix.py << 'EOF'
import os
import sys
os.system("pip install psycopg2-binary")
import psycopg2




print("Connecting to database...")
conn = psycopg2.connect(DATABASE_URL)
cur = conn.cursor()
print("Connected!")

# Add all missing columns
columns = [
    ("username", "VARCHAR(80)"),
    ("phone_number", "VARCHAR(20)"),
    ("location", "VARCHAR(255)"),
    ("business_name", "VARCHAR(255)"),
    ("business_type", "VARCHAR(50)"),
    ("abn", "VARCHAR(20)"),
    ("bio", "TEXT"),
    ("skills", "TEXT"),
    ("experience_years", "INTEGER"),
    ("rating", "FLOAT"),
    ("total_reviews", "INTEGER DEFAULT 0"),
    ("completed_jobs", "INTEGER DEFAULT 0"),
    ("verified", "BOOLEAN DEFAULT FALSE"),
    ("stripe_customer_id", "VARCHAR(255)"),
    ("stripe_account_id", "VARCHAR(255)"),
    ("profile_image", "VARCHAR(255)"),
    ("date_of_birth", "DATE"),
    ("address", "VARCHAR(255)"),
    ("suburb", "VARCHAR(100)"),
    ("state", "VARCHAR(50)"),
    ("postcode", "VARCHAR(10)"),
    ("latitude", "FLOAT"),
    ("longitude", "FLOAT"),
    ("availability", "TEXT"),
    ("hourly_rate", "NUMERIC(10,2)"),
    ("specializations", "TEXT"),
    ("certifications", "TEXT"),
    ("role", "VARCHAR(20) DEFAULT 'worker'")
]

print("Adding missing columns...")
for col_name, col_type in columns:
    try:
        cur.execute(f"ALTER TABLE users ADD COLUMN IF NOT EXISTS {col_name} {col_type}")
        print(f"✓ Added {col_name}")
    except Exception as e:
        if "already exists" in str(e).lower():
            print(f"  {col_name} already exists")
        else:
            print(f"✗ Error with {col_name}: {e}")

# Create user_sessions table if needed
cur.execute("""
    CREATE TABLE IF NOT EXISTS user_sessions (
        id SERIAL PRIMARY KEY,
        user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
        session_token VARCHAR(255) UNIQUE NOT NULL,
        ip_address VARCHAR(45),
        user_agent TEXT,
        last_activity TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        expires_at TIMESTAMP,
        is_active BOOLEAN DEFAULT TRUE
    )
""")
print("✓ User sessions table ready")

conn.commit()
cur.close()
conn.close()

print("\n🎉 DATABASE FIXED! 500 errors resolved!")
print("Test at: https://rateright.fly.dev/register")
EOF

================================================================================
STEP 2: Run the fix - Type this command:
================================================================================

python3 /tmp/fix.py

================================================================================
STEP 3: Exit SSH - Type this command:
================================================================================

exit

================================================================================
STEP 4: Test your app:
================================================================================

Open these URLs in your browser:
- https://rateright.fly.dev/register
- https://rateright.fly.dev/login

================================================================================
EXPECTED OUTPUT:
================================================================================

You should see something like:
Installing required packages...
Connecting to database...
Connected!
Adding missing columns...
✓ Added username
✓ Added phone_number
✓ Added location
... (more columns)
✓ User sessions table ready

🎉 DATABASE FIXED! 500 errors resolved!
Test at: https://rateright.fly.dev/register