#!/bin/bash
# Script para corrigir tabela establishments na VPS
# Execute na VPS: bash fix-establishments-vps.sh

cd /var/www/maktubia-backend

echo "🔧 Adicionando colunas created_at e updated_at à tabela establishments..."
echo ""

sudo -u postgres psql -d maktubia_points << EOF
DO $$ 
BEGIN
    -- created_at
    IF NOT EXISTS (
        SELECT 1 FROM information_schema.columns 
        WHERE table_name='establishments' AND column_name='created_at'
    ) THEN
        ALTER TABLE establishments ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
        RAISE NOTICE '✅ Coluna created_at adicionada';
    ELSE
        RAISE NOTICE 'ℹ️  Coluna created_at já existe';
    END IF;
    
    -- updated_at
    IF NOT EXISTS (
        SELECT 1 FROM information_schema.columns 
        WHERE table_name='establishments' AND column_name='updated_at'
    ) THEN
        ALTER TABLE establishments ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
        RAISE NOTICE '✅ Coluna updated_at adicionada';
    ELSE
        RAISE NOTICE 'ℹ️  Coluna updated_at já existe';
    END IF;
END $$;

-- Verificar resultado
SELECT 
    column_name, 
    data_type, 
    column_default,
    is_nullable
FROM information_schema.columns 
WHERE table_name = 'establishments' 
AND column_name IN ('created_at', 'updated_at')
ORDER BY column_name;
EOF

echo ""
echo "✅ Tabela establishments corrigida!"
echo ""
echo "🔄 Reiniciando aplicação..."
pm2 restart maktubia-backend

echo ""
echo "✅ Concluído!"