Bearb. Buchungsgruppen: Spalte taxzone_id in oe/delivery_orders konvertieren
authorMoritz Bunkus <m.bunkus@linet-services.de>
Tue, 26 Aug 2014 08:53:15 +0000 (10:53 +0200)
committerMoritz Bunkus <m.bunkus@linet-services.de>
Tue, 26 Aug 2014 08:55:33 +0000 (10:55 +0200)
commitcc87243050bcec588ba8a5995ba3f9eca761ad2b
tree42837244ea5ba37cc99c125de02c75ecb4f6a61a
parent4d67a19b291239cdebc860664abcd96d681bbda4
Bearb. Buchungsgruppen: Spalte taxzone_id in oe/delivery_orders konvertieren

1. Werte 0 und NULL durch neue ID für »Inland« ersetzen (oe,
   delivery_orders, ar, ap)

2. Spalte taxzone_id NOT NULL setzen (oe, delivery_orders, ar, ap)

3. Fremdschlüssel auf Tabelle tax_zones setzen (oe, delivery_orders)
SL/DB/MetaSetup/DeliveryOrder.pm
SL/DB/MetaSetup/Invoice.pm
SL/DB/MetaSetup/Order.pm
SL/DB/MetaSetup/PurchaseInvoice.pm
sql/Pg-upgrade2/taxzone_id_in_oe_delivery_orders.sql [new file with mode: 0644]