ALTER TABLE `bank_accounts` ADD `is_primary` integer NOT NULL DEFAULT 0;
--> statement-breakpoint
UPDATE `bank_accounts` SET `is_primary` = 1 WHERE `id` IN (SELECT MIN(`id`) FROM `bank_accounts` GROUP BY `company_id`);
--> statement-breakpoint
CREATE UNIQUE INDEX `bank_accounts_company_primary_unique` ON `bank_accounts` (`company_id`) WHERE `is_primary` = 1;
--> statement-breakpoint
PRAGMA optimize;