ALTER TABLE cash_flows ADD COLUMN beneficiary_name TEXT;
--> statement-breakpoint
ALTER TABLE payment_approvals ADD COLUMN beneficiary_name_before TEXT;
--> statement-breakpoint
ALTER TABLE payment_approvals ADD COLUMN beneficiary_name_after TEXT;
--> statement-breakpoint
ALTER TABLE payment_approvals ADD COLUMN beneficiary_changed INTEGER NOT NULL DEFAULT 0;
--> statement-breakpoint
UPDATE cash_flows SET beneficiary_name = party WHERE kind = 'fournisseur' AND (beneficiary_name IS NULL OR TRIM(beneficiary_name) = '');