-- migrate:up
-- Eliminar la tabla mp_payments (integración de MercadoPago removida)
drop table if exists mp_payments;

-- migrate:down
-- Recrear la tabla si se necesita rollback
create table if not exists mp_payments (
  tenant_id uuid not null references tenants(id) on delete cascade,
  woo_order_id bigint null,
  preference_id text null,
  payment_id text null,
  status text null,
  paid_at timestamptz null,
  raw jsonb not null default '{}'::jsonb,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now(),
  primary key (tenant_id, payment_id)
);

create index if not exists mp_payments_tenant_order_idx
  on mp_payments (tenant_id, woo_order_id);