-- @tag: bank_accounts
-- @description: Tabelle für Bankkonten (u.a. für SEPA-Export)
-- @depends: release_2_4_3
CREATE TABLE bank_accounts (
  id integer NOT NULL DEFAULT nextval('id'),
  account_number varchar(100),
  bank_code varchar(100),
  iban varchar(100),
  bic varchar(100),
  bank text,
  chart_id integer NOT NULL,

  PRIMARY KEY (id),
  FOREIGN KEY (chart_id) REFERENCES chart (id)
);

ALTER TABLE customer ADD COLUMN iban varchar(100);
ALTER TABLE customer ADD COLUMN bic varchar(100);
UPDATE customer SET iban = '', bic = '';

ALTER TABLE vendor ADD COLUMN iban varchar(100);
ALTER TABLE vendor ADD COLUMN bic varchar(100);
UPDATE vendor SET iban = '', bic = '';