X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Foe_delivery_orders_foreign_keys.sql;h=9ad72dfce4e489df8812f2787b8bbac1a687bcb1;hb=ff159a4d47b9a2d10744dcfc23da2c63605c8a32;hp=ac92ca4e6be23d715be62a3a79393ead79a504a8;hpb=d482851e1d8edce7fc2e80bdaf47a4defa70da36;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql b/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql index ac92ca4e6..9ad72dfce 100644 --- a/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql +++ b/sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql @@ -1,7 +1,6 @@ -- @tag: oe_delivery_orders_foreign_keys -- @description: Fremdschlüsseldefinitionen für oe und delivery_orders -- @depends: release_3_0_0 --- @charset: utf-8 ALTER TABLE oe ALTER COLUMN department_id DROP DEFAULT; UPDATE oe SET cp_id = NULL WHERE (cp_id IS NOT NULL) AND (cp_id NOT IN (SELECT cp_id FROM contacts));