1 -- @tag: parts_add_chart_foreign_keys
2 -- @description: Warenkonten mit chart-Tabelle per Fremdschlüssel verknüpft.
3 -- @depends: release_3_4_1
6 ALTER TABLE parts ADD FOREIGN KEY (income_accno_id) REFERENCES chart(id);
7 ALTER TABLE parts ADD FOREIGN KEY (inventory_accno_id) REFERENCES chart(id);
8 ALTER TABLE parts ADD FOREIGN KEY (expense_accno_id) REFERENCES chart(id);