-- Adicionar colunas created_at e updated_at à tabela establishments na VPS
-- Execute: sudo -u postgres psql -d maktubia_points -f add-created-updated-to-establishments.sql

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;