X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Funit_foreign_key_for_line_items.sql;h=ba547c824b55141ee1f29ef110f1c33f23a29b36;hb=e5f53eb5c67c19d6a356fcde22ca46169cdca5dc;hp=d99e1a7fa5b82fa210e26c83cf2fd67c66e7bdf8;hpb=e42233910a57d39f3ccef150db1212f7ecb7fb30;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);