#!/bin/bash
# Run migration 008 to relax tickets resource constraints

set -e

echo "Running migration 008: Relax tickets resource constraints..."

# Check if we're in Docker or local
if [ -f /.dockerenv ]; then
    # Running inside Docker
    psql "$DATABASE_URL" -f /app/migrations/008_relax_tickets_resource_constraints.sql
else
    # Running locally
    if [ -z "$DATABASE_URL" ]; then
        echo "Error: DATABASE_URL environment variable not set"
        exit 1
    fi
    psql "$DATABASE_URL" -f ./migrations/008_relax_tickets_resource_constraints.sql
fi

echo "Migration 008 completed successfully!"