Fix fuer Bug 980 Ertraege auch fuer Erzeugnisse in Rechnungen ausweisen

[mfinanz.git] / sql / Pg-upgrade2 / dunning_invoices_per_dunning_level.sql

-- @tag: dunning_invoices_per_dunning_level
-- @description: Umstellung der Konfiguration für das automatische Erzeugen von Rechnungen über Mahngebühren von "global" auf "pro Mahnlevel"
-- @depends: dunning_invoices_for_fees
ALTER TABLE dunning_config ADD COLUMN create_invoices_for_fees boolean;
ALTER TABLE dunning_config ALTER COLUMN create_invoices_for_fees SET DEFAULT TRUE;
UPDATE dunning_config SET create_invoices_for_fees =
  (SELECT dunning_create_invoices_for_fees FROM defaults LIMIT 1);
ALTER TABLE defaults DROP COLUMN dunning_create_invoices_for_fees;