From fbf75327ef719dd937cd1b66d3055b0f43f98356 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Mon, 2 Nov 2015 13:43:46 +0100 Subject: [PATCH] =?utf8?q?Fehlende=20Fremdschl=C3=BCssel=20f=C3=BCr=20buch?= =?utf8?q?ungsgruppen.inventory=5Faccno=5Fid=20erg=C3=A4nzt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/buchungsgruppen_forein_keys.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/Pg-upgrade2/buchungsgruppen_forein_keys.sql diff --git a/sql/Pg-upgrade2/buchungsgruppen_forein_keys.sql b/sql/Pg-upgrade2/buchungsgruppen_forein_keys.sql new file mode 100644 index 000000000..7f144a280 --- /dev/null +++ b/sql/Pg-upgrade2/buchungsgruppen_forein_keys.sql @@ -0,0 +1,5 @@ +-- @tag: buchungsgruppen_forein_keys +-- @description: Fremdschlüssel für Tabelle buchungsgruppen +-- @depends: release_3_3_0 +ALTER TABLE buchungsgruppen ADD FOREIGN KEY (inventory_accno_id) REFERENCES chart (id); +ALTER TABLE buchungsgruppen ALTER COLUMN inventory_accno_id SET NOT NULL; -- 2.20.1