reserva_chatmotel/supabase/migrations
Rodribm10 09c7903a9c fix: permissoes + RLS pro admin conseguir escrever nas tabelas de catalogo
Antes: 'permission denied for table marcas' ao tentar criar/editar
qualquer entidade. Authenticated so tinha SELECT.

Agora:
- Grants de INSERT/UPDATE/DELETE pra authenticated nas 9 tabelas
- RLS enabled em todas
- Helper function is_tenant_member(bigint) via security definer
- Policies members_write_* permitem escrita apenas se user estiver
  no tenant_members do tenant_id da row
- public_read_* mantem SELECT livre pro anon da pagina publica
- Reservas/reserva_extras continuam service_role-only (backend Chatwoot)

Aplicada via MCP. Testada com curl + JWT do admin (INSERT marcas = 201).
2026-04-14 22:24:15 -03:00
..
20260413000001_reserva_1001_additive_schema.sql feat: documenta migration aditiva do schema reserva_hotel 2026-04-13 23:05:16 -03:00
20260413000002_seed_dados_teste.sql feat: seed dados de teste (unidade aguas lindas, precos, fotos, extras) + types atualizados 2026-04-13 23:41:49 -03:00
20260414000001_tenants_and_app_config.sql feat: schema multi-tenant (tenants, app_config, tenant_id backfill, RLS) 2026-04-14 20:59:37 -03:00
20260414000002_add_tenant_id_backfill.sql feat: schema multi-tenant (tenants, app_config, tenant_id backfill, RLS) 2026-04-14 20:59:37 -03:00
20260414000003_rls_tenant_scoping.sql feat: schema multi-tenant (tenants, app_config, tenant_id backfill, RLS) 2026-04-14 20:59:37 -03:00
20260414000004_tenant_members.sql feat: tabela tenant_members + primeiro admin seed 2026-04-14 21:00:59 -03:00
20260414000005_admin_write_policies.sql fix: permissoes + RLS pro admin conseguir escrever nas tabelas de catalogo 2026-04-14 22:24:15 -03:00