ALTER TABLE `cash_flows` ADD `settled_at` text;
--> statement-breakpoint
ALTER TABLE `cash_flows` ADD `settlement_bank_id` integer REFERENCES `bank_accounts`(`id`);
--> statement-breakpoint
CREATE TABLE `bank_transactions` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `bank_account_id` integer NOT NULL REFERENCES `bank_accounts`(`id`),
  `cash_flow_id` integer REFERENCES `cash_flows`(`id`),
  `company_id` text NOT NULL REFERENCES `companies`(`id`),
  `kind` text NOT NULL,
  `direction` text NOT NULL,
  `party` text NOT NULL,
  `reference` text NOT NULL,
  `amount` real NOT NULL,
  `balance_before` real NOT NULL,
  `balance_after` real NOT NULL,
  `transaction_date` text NOT NULL,
  `created_at` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `bank_transactions_cash_flow_unique` ON `bank_transactions` (`cash_flow_id`);
--> statement-breakpoint
CREATE INDEX `idx_bank_transactions_bank_date` ON `bank_transactions` (`bank_account_id`,`transaction_date`);
--> statement-breakpoint
PRAGMA optimize;