#!/bin/bash

# Script para adicionar coluna establishment_id numérica à tabela establishments
# Execute: bash deploy/add-establishment-id-numeric.sh

echo "🔄 Adicionando coluna establishment_id numérica à tabela establishments..."

# Verificar se o arquivo SQL existe
if [ ! -f "deploy/add-establishment-id-numeric.sql" ]; then
    echo "❌ Arquivo SQL não encontrado: deploy/add-establishment-id-numeric.sql"
    exit 1
fi

# Executar SQL no PostgreSQL
sudo -u postgres psql -d maktubia_points -f deploy/add-establishment-id-numeric.sql

if [ $? -eq 0 ]; then
    echo "✅ Coluna establishment_id adicionada/verificada com sucesso!"
    echo ""
    echo "📋 Verificando estrutura da tabela:"
    sudo -u postgres psql -d maktubia_points -c "SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'establishments' AND column_name IN ('establishment_id', 'est_id') ORDER BY column_name;"
else
    echo "❌ Erro ao executar SQL"
    exit 1
fi