1 -- @tag: invoices_amount_paid_not_null
2 -- @description: Bei Rechnungen die drei Spalten "amount", "netamount" und "paid" auf NOT NULL setzen
3 -- @depends: release_3_2_0
5 UPDATE ar SET amount = 0 WHERE amount IS NULL;
6 ALTER TABLE ar ALTER COLUMN amount SET NOT NULL;
7 ALTER TABLE ar ALTER COLUMN amount SET DEFAULT 0;
8 UPDATE ar SET netamount = 0 WHERE netamount IS NULL;
9 ALTER TABLE ar ALTER COLUMN netamount SET NOT NULL;
10 ALTER TABLE ar ALTER COLUMN netamount SET DEFAULT 0;
11 UPDATE ar SET paid = 0 WHERE paid IS NULL;
12 ALTER TABLE ar ALTER COLUMN paid SET NOT NULL;
13 ALTER TABLE ar ALTER COLUMN paid SET DEFAULT 0;
15 UPDATE ap SET amount = 0 WHERE amount IS NULL;
16 ALTER TABLE ap ALTER COLUMN amount SET NOT NULL;
17 ALTER TABLE ap ALTER COLUMN amount SET DEFAULT 0;
18 UPDATE ap SET netamount = 0 WHERE netamount IS NULL;
19 ALTER TABLE ap ALTER COLUMN netamount SET NOT NULL;
20 ALTER TABLE ap ALTER COLUMN netamount SET DEFAULT 0;
21 UPDATE ap SET paid = 0 WHERE paid IS NULL;
22 ALTER TABLE ap ALTER COLUMN paid SET NOT NULL;
23 ALTER TABLE ap ALTER COLUMN paid SET DEFAULT 0;