Revision fbb89b3b
Von Moritz Bunkus vor etwa 16 Jahren hinzugefügt
| sql/Pg-upgrade2/transaction_description_not_null.sql | ||
|---|---|---|
| 1 | 1 |
-- @tag: transaction_description_not_null |
| 2 | 2 |
-- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten. |
| 3 |
-- @depends: transaction_description |
|
| 3 |
-- @depends: transaction_description delivery_orders
|
|
| 4 | 4 |
UPDATE ap SET transaction_description = '' WHERE transaction_description IS NULL; |
| 5 | 5 |
UPDATE ar SET transaction_description = '' WHERE transaction_description IS NULL; |
| 6 | 6 |
UPDATE oe SET transaction_description = '' WHERE transaction_description IS NULL; |
| 7 |
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".