CREATE TABLE IF NOT EXISTS supplier_payment_policies (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  company_id TEXT NOT NULL REFERENCES companies(id),
  supplier_name TEXT NOT NULL,
  supplier_key TEXT NOT NULL,
  priority_rank INTEGER NOT NULL,
  splittable INTEGER NOT NULL DEFAULT 1,
  max_installment_months INTEGER NOT NULL DEFAULT 3,
  payment_deadline TEXT,
  active INTEGER NOT NULL DEFAULT 1,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX IF NOT EXISTS supplier_payment_policies_company_key_unique ON supplier_payment_policies(company_id, supplier_key);
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS idx_supplier_payment_policies_priority ON supplier_payment_policies(company_id, active, priority_rank);