1 -- @tag: bank_account_information_for_swiss_qrbill
2 -- @description: Bankkonto Informationen für Swiss QR-Bill hinzufügen
3 -- @depends: release_3_5_6_1
4 ALTER TABLE bank_accounts ADD COLUMN use_for_qrbill BOOLEAN;
5 ALTER TABLE bank_accounts ADD COLUMN bank_account_id VARCHAR;
7 UPDATE bank_accounts SET use_for_qrbill = (
12 ALTER TABLE bank_accounts
13 ALTER COLUMN use_for_qrbill SET DEFAULT FALSE,
14 ALTER COLUMN use_for_qrbill SET NOT NULL;