-- Adicionar colunas faltantes em establishments na VPS
-- Execute: sudo -u postgres psql -d maktubia_points -f add-establishment-columns-vps.sql

ALTER TABLE establishments ADD COLUMN IF NOT EXISTS address TEXT;
ALTER TABLE establishments ADD COLUMN IF NOT EXISTS phone VARCHAR(50);
ALTER TABLE establishments ADD COLUMN IF NOT EXISTS email VARCHAR(120);
ALTER TABLE establishments ADD COLUMN IF NOT EXISTS image_secondary TEXT;
ALTER TABLE establishments ADD COLUMN IF NOT EXISTS color VARCHAR(50);
ALTER TABLE establishments ADD COLUMN IF NOT EXISTS created_by INTEGER REFERENCES users(user_id);

-- Verificar resultado
SELECT column_name, data_type 
FROM information_schema.columns 
WHERE table_name = 'establishments' 
AND column_name IN ('address', 'phone', 'email', 'image_secondary', 'color', 'created_by')
ORDER BY column_name;