Revision fbb89b3b
Von Moritz Bunkus vor mehr als 16 Jahren hinzugefügt
| sql/Pg-upgrade2/transaction_description_not_null.sql | ||
|---|---|---|
|
-- @tag: transaction_description_not_null
|
||
|
-- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten.
|
||
|
-- @depends: transaction_description
|
||
|
-- @depends: transaction_description delivery_orders
|
||
|
UPDATE ap SET transaction_description = '' WHERE transaction_description IS NULL;
|
||
|
UPDATE ar SET transaction_description = '' WHERE transaction_description IS NULL;
|
||
|
UPDATE oe SET transaction_description = '' WHERE transaction_description IS NULL;
|
||
|
UPDATE delivery_orders SET transaction_description = '' WHERE transaction_description IS NULL;
|
||
Auch abrufbar als: Unified diff
Das Feld "transaction_description" gibt es auch in der Tabelle "delivery_orders".