Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

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

diff --git a/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql b/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql
index 9add1418ad65db8e3dc798d6608369f5d2551f9d..b5e5567c3a1653d9d10c00ff9f482ff312a23a81 100644 (file)
--- a/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql
+++ b/sql/Pg-upgrade2/invoices_amount_paid_not_null.sql
@@ -1,7 +1,6 @@
 -- @tag: invoices_amount_paid_not_null
 -- @description: Bei Rechnungen die drei Spalten "amount", "netamount" und "paid" auf NOT NULL setzen
 -- @depends: release_3_2_0
 -- @tag: invoices_amount_paid_not_null
 -- @description: Bei Rechnungen die drei Spalten "amount", "netamount" und "paid" auf NOT NULL setzen
 -- @depends: release_3_2_0

--- @encoding: utf-8

 
 UPDATE ar SET amount    = 0 WHERE amount    IS NULL;
 ALTER TABLE ar ALTER COLUMN amount    SET NOT NULL;
 
 UPDATE ar SET amount    = 0 WHERE amount    IS NULL;
 ALTER TABLE ar ALTER COLUMN amount    SET NOT NULL;