sql/Pg-upgrade2/dunning_invoices_per_dunning_level.sql

   1 -- @tag: dunning_invoices_per_dunning_level
   2 -- @description: Umstellung der Konfiguration f&uuml;r das automatische Erzeugen von Rechnungen &uuml;ber Mahngeb&uuml;hren von &quot;global&quot; auf &quot;pro Mahnlevel&quot;
   3 -- @depends: dunning_invoices_for_fees
   4 ALTER TABLE dunning_config ADD COLUMN create_invoices_for_fees boolean;
   5 ALTER TABLE dunning_config ALTER COLUMN create_invoices_for_fees SET DEFAULT TRUE;
   6 UPDATE dunning_config SET create_invoices_for_fees =
   7   (SELECT dunning_create_invoices_for_fees FROM defaults LIMIT 1);
   8 ALTER TABLE defaults DROP COLUMN dunning_create_invoices_for_fees;