X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Foe_delivery_orders_foreign_keys.sql;h=9ad72dfce4e489df8812f2787b8bbac1a687bcb1;hb=387386532c892b89f5c765a65ac2fe1482028d44;hp=2e2e8c971779202711bfac5daea6171ec3861412;hpb=4f15333b8cc0ae1b0b4089adc2e516ba002b298b;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 2e2e8c971..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));
@@ -19,7 +18,6 @@ ALTER TABLE oe              ADD FOREIGN KEY (cp_id)                REFERENCES co
 ALTER TABLE oe              ADD FOREIGN KEY (delivery_customer_id) REFERENCES customer      (id);
 ALTER TABLE oe              ADD FOREIGN KEY (delivery_vendor_id)   REFERENCES vendor        (id);
 ALTER TABLE oe              ADD FOREIGN KEY (department_id)        REFERENCES department    (id);
-ALTER TABLE oe              ADD FOREIGN KEY (employee_id)          REFERENCES employee      (id);
 ALTER TABLE oe              ADD FOREIGN KEY (language_id)          REFERENCES language      (id);
 ALTER TABLE oe              ADD FOREIGN KEY (payment_id)           REFERENCES payment_terms (id);
 ALTER TABLE oe              ADD FOREIGN KEY (shipto_id)            REFERENCES shipto        (shipto_id);