#!/bin/bash
# Script para atualizar schema na VPS (adicionar created_at e updated_at à tabela establishments)
# Execute na VPS: bash atualizar-schema-vps.sh

cd /var/www/maktubia-backend

echo "🔧 Atualizando schema da tabela establishments..."
echo ""

sudo -u postgres psql -d maktubia_points << EOF
-- Adicionar colunas created_at e updated_at se não existirem
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;
    
    -- Atualizar created_at para registros existentes sem data
    UPDATE establishments 
    SET created_at = CURRENT_TIMESTAMP 
    WHERE created_at IS NULL;
    
    -- Atualizar updated_at para registros existentes sem data
    UPDATE establishments 
    SET updated_at = CURRENT_TIMESTAMP 
    WHERE updated_at IS NULL;
END \$\$;

-- Verificar estrutura da tabela
SELECT column_name, data_type, is_nullable, column_default
FROM information_schema.columns 
WHERE table_name = 'establishments'
ORDER BY ordinal_position;
EOF

echo ""
echo "✅ Schema atualizado!"