ALTER TABLE `bank_transactions` ADD `cancelled_at` text;
--> statement-breakpoint
ALTER TABLE `bank_transactions` ADD `cancellation_reason` text;
--> statement-breakpoint
DROP INDEX `bank_transactions_cash_flow_unique`;
--> statement-breakpoint
CREATE UNIQUE INDEX `bank_transactions_cash_flow_unique` ON `bank_transactions` (`cash_flow_id`) WHERE `cash_flow_id` IS NOT NULL AND `cancelled_at` IS NULL;
--> statement-breakpoint
CREATE INDEX `idx_bank_transactions_settlements` ON `bank_transactions` (`company_id`,`kind`,`transaction_date`);
--> statement-breakpoint
PRAGMA optimize;