-- Verificar tablas
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY table_name;
-- Verificar funciones
SELECT routine_name FROM information_schema.routines
WHERE routine_schema = 'public'
ORDER BY routine_name;
-- Verificar políticas RLS
SELECT tablename, policyname FROM pg_policies
WHERE schemaname = 'public'
ORDER BY tablename;
-- Verificar nuevas tablas v1.1.0
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
AND table_name IN ('client_companies', 'client_contacts', 'company_templates');
-- Contar registros en cada tabla
SELECT
'subscription_plans' as table_name, COUNT(*) as count FROM subscription_plans
UNION ALL
SELECT 'companies', COUNT(*) FROM companies
UNION ALL
SELECT 'profiles', COUNT(*) FROM profiles
UNION ALL
SELECT 'user_roles', COUNT(*) FROM user_roles
UNION ALL
SELECT 'products', COUNT(*) FROM products
UNION ALL
SELECT 'budgets', COUNT(*) FROM budgets
UNION ALL
SELECT 'knowledge_base', COUNT(*) FROM knowledge_base;
-- Ejemplo: Actualizar URLs de logos
UPDATE companies
SET logo_url = REPLACE(logo_url, 'OLD_PROJECT_ID', 'NEW_PROJECT_ID')
WHERE logo_url LIKE '%supabase%';
npm install -g supabase
# Login en Supabase
supabase login
# Vincular al proyecto (reemplaza TU_PROJECT_REF)
supabase link --project-ref TU_PROJECT_REF
# Desplegar todas las funciones
supabase functions deploy
# O desplegar una función específica
supabase functions deploy chat-gemini
supabase functions deploy accept-invitation
# ... etc
-- Verificar integridad referencial
SELECT
'budgets sin company' as issue,
COUNT(*) as count
FROM budgets b
LEFT JOIN companies c ON b.company_id = c.id
WHERE c.id IS NULL
UNION ALL
SELECT
'profiles sin company' as issue,
COUNT(*)
FROM profiles p
LEFT JOIN companies c ON p.company_id = c.id
WHERE p.company_id IS NOT NULL AND c.id IS NULL;
