X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Funit_foreign_key_for_line_items.sql;h=ba547c824b55141ee1f29ef110f1c33f23a29b36;hb=bcdc9f7040d4bc0c0b4d7ce77f1afc29543b04a4;hp=d99e1a7fa5b82fa210e26c83cf2fd67c66e7bdf8;hpb=fb03d191f53516cbf1022e755665556e7f1acb82;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql b/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql index d99e1a7fa..ba547c824 100644 --- a/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql +++ b/sql/Pg-upgrade2/unit_foreign_key_for_line_items.sql @@ -1,6 +1,6 @@ -- @tag: unit_foreign_key_for_line_items -- @description: Fremdschlüssel auf »unit« für Beleg-Positionstabellen --- @depends: release_3_0_0 +-- @depends: release_3_0_0 oe_do_delete_via_trigger ALTER TABLE orderitems ADD FOREIGN KEY (unit) REFERENCES units (name); ALTER TABLE delivery_order_items ADD FOREIGN KEY (unit) REFERENCES units (name); ALTER TABLE invoice ADD FOREIGN KEY (unit) REFERENCES units (name);