ALTER TABLE `transfer_orders` ADD `internal_number` text;
--> statement-breakpoint
ALTER TABLE `transfer_orders` ADD `comment` text;
--> statement-breakpoint
UPDATE `transfer_orders`
SET `internal_number` = 'OV-' || UPPER(`company_id`) || '-' || SUBSTR(`order_date`, 1, 4) || '-' || PRINTF('%06d', `id`)
WHERE `internal_number` IS NULL;
--> statement-breakpoint
CREATE INDEX `idx_transfer_orders_internal_number` ON `transfer_orders` (`internal_number`);
--> statement-breakpoint
PRAGMA optimize;