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
6 UPDATE ar SET amount = 0 WHERE amount IS NULL;
7 ALTER TABLE ar ALTER COLUMN amount SET NOT NULL;
8 ALTER TABLE ar ALTER COLUMN amount SET DEFAULT 0;
9 UPDATE ar SET netamount = 0 WHERE netamount IS NULL;
10 ALTER TABLE ar ALTER COLUMN netamount SET NOT NULL;
11 ALTER TABLE ar ALTER COLUMN netamount SET DEFAULT 0;
12 UPDATE ar SET paid = 0 WHERE paid IS NULL;
13 ALTER TABLE ar ALTER COLUMN paid SET NOT NULL;
14 ALTER TABLE ar ALTER COLUMN paid SET DEFAULT 0;
16 UPDATE ap SET amount = 0 WHERE amount IS NULL;
17 ALTER TABLE ap ALTER COLUMN amount SET NOT NULL;
18 ALTER TABLE ap ALTER COLUMN amount SET DEFAULT 0;
19 UPDATE ap SET netamount = 0 WHERE netamount IS NULL;
20 ALTER TABLE ap ALTER COLUMN netamount SET NOT NULL;
21 ALTER TABLE ap ALTER COLUMN netamount SET DEFAULT 0;
22 UPDATE ap SET paid = 0 WHERE paid IS NULL;
23 ALTER TABLE ap ALTER COLUMN paid SET NOT NULL;
24 ALTER TABLE ap ALTER COLUMN paid SET DEFAULT 0;