ALTER TABLE `cash_flows` ADD `blocked_supplier` integer NOT NULL DEFAULT 0;
--> statement-breakpoint
CREATE TABLE `blocked_suppliers` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `company_id` text NOT NULL REFERENCES `companies`(`id`),
  `supplier_name` text NOT NULL,
  `supplier_key` text NOT NULL,
  `created_at` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `blocked_suppliers_company_key_unique` ON `blocked_suppliers` (`company_id`,`supplier_key`);
--> statement-breakpoint
CREATE INDEX `idx_blocked_suppliers_company` ON `blocked_suppliers` (`company_id`);
--> statement-breakpoint
PRAGMA optimize;