-- israeli-tax-reports (wave-14)
-- Extends tenant_settings with VAT filing period and advance tax rate columns.
-- Base table owned by foundation-auth-rbac; modules add columns via IF NOT EXISTS.

ALTER TABLE tenant_settings
  ADD COLUMN IF NOT EXISTS vat_period TEXT NOT NULL DEFAULT 'bimonthly'
    CHECK (vat_period IN ('monthly', 'bimonthly')),
  ADD COLUMN IF NOT EXISTS advance_tax_rate_pct NUMERIC(5,2);
