From 7cb88587850fc30c3af3c102b351deb81fc56ff5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Fri, 24 Apr 2009 06:39:02 +0000 Subject: [PATCH] =?utf8?q?Fremdschl=C3=BCssel-Constraint=20f=C3=BCr=20oe?= =?utf8?q?=20und=20employee=20(=C3=BCber=20ID)=20hinzugef=C3=BCgt.=20Beim?= =?utf8?q?=20harten=20L=C3=B6schen=20eines=20Benutzers=20in=20der=20DB,=20?= =?utf8?q?verwaist=20ansonsten=20der=20Eintrag=20in=20oe?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/Pg-upgrade2/oe_employee_id_foreignkey.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/Pg-upgrade2/oe_employee_id_foreignkey.sql diff --git a/sql/Pg-upgrade2/oe_employee_id_foreignkey.sql b/sql/Pg-upgrade2/oe_employee_id_foreignkey.sql new file mode 100644 index 000000000..5ff87030b --- /dev/null +++ b/sql/Pg-upgrade2/oe_employee_id_foreignkey.sql @@ -0,0 +1,4 @@ +-- @tag: oe_employee_id_foreignkey +-- @description: Falls ein Benutzer hart in der Datenbank gelöscht werden soll, müssen auch die Verknüpfung zu seinen bearbeitenden Aufträge bedacht werden +-- @depends: release_2_4_3 +ALTER TABLE oe ADD FOREIGN KEY (employee_id) REFERENCES employee (id); -- 2.20.1