From a8c9873e09dca96c125bfb0c126d84b6742d2351 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 13 Jul 2016 13:58:45 +0200 Subject: [PATCH] =?utf8?q?Revert=20"generic=5Ftranslations:=20Eintr=C3=A4g?= =?utf8?q?e=20automatisch=20l=C3=B6schen,=20wenn=20Sprache=20gel=C3=B6scht?= =?utf8?q?=20wird"?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit This reverts commit 86299a413d457abfa10f657b243d00b194702824. --- ..._generic_translations_on_language_deletion.sql | 15 --------------- 1 file changed, 15 deletions(-) delete mode 100644 sql/Pg-upgrade2/delete_from_generic_translations_on_language_deletion.sql diff --git a/sql/Pg-upgrade2/delete_from_generic_translations_on_language_deletion.sql b/sql/Pg-upgrade2/delete_from_generic_translations_on_language_deletion.sql deleted file mode 100644 index e01b51c66..000000000 --- a/sql/Pg-upgrade2/delete_from_generic_translations_on_language_deletion.sql +++ /dev/null @@ -1,15 +0,0 @@ --- @tag: delete_from_generic_translations_on_language_deletion --- @description: Übersetzungen automatisch löschen, wenn die dazugehörige Sprache gelöscht wird --- @depends: release_3_3_0 -ALTER TABLE generic_translations - DROP CONSTRAINT generic_translations_language_id_fkey, - ADD CONSTRAINT generic_translations_language_id_fkey - FOREIGN KEY (language_id) - REFERENCES language (id) - ON DELETE CASCADE; - -DELETE FROM generic_translations -WHERE language_id NOT IN ( - SELECT id - FROM language -); -- 2.20.1