X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Facc_trans_booleans_not_null.sql;h=8ce078ca5090337a363fc46fed4e82839666b0b3;hb=577042c61c5e1fffb8747079b4f9826e51532ee8;hp=983e53d754897637d40fa50a51bb17b8cd1fcef8;hpb=a23454bb1b039a31b7f77710ff663fa9152d530c;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/acc_trans_booleans_not_null.sql b/sql/Pg-upgrade2/acc_trans_booleans_not_null.sql index 983e53d75..8ce078ca5 100644 --- a/sql/Pg-upgrade2/acc_trans_booleans_not_null.sql +++ b/sql/Pg-upgrade2/acc_trans_booleans_not_null.sql @@ -1,7 +1,6 @@ -- @tag: acc_trans_booleans_not_null -- @description: Alte acc_trans boolean-Einträge mit NULL-Werten auf false setzen -- @depends: release_3_0_0 --- @charset: utf-8 UPDATE acc_trans SET cleared = 'f' where cleared IS NULL; UPDATE acc_trans SET ob_transaction = 'f' where ob_transaction IS NULL;