sql/Pg-upgrade2/bank_account_informations_for_swiss_qrbill.sql

   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;
   6
   7 UPDATE bank_accounts SET use_for_qrbill = (
   8     SELECT COUNT(*)
   9     FROM bank_accounts
  10   ) = 1;
  11
  12 ALTER TABLE bank_accounts
  13   ALTER COLUMN use_for_qrbill SET DEFAULT FALSE,
  14   ALTER COLUMN use_for_qrbill SET NOT NULL;