1 # @tag: delete_from_generic_translations_on_language_deletion
2 # @description: Übersetzungen automatisch löschen, wenn die dazugehörige Sprache gelöscht wird
3 # @depends: release_3_4_0
4 package SL::DBUpgrade2::delete_from_generic_translations_on_language_deletion;
9 use parent qw(SL::DBUpgrade2::Base);
14 $self->drop_constraints(table => 'generic_translations');
16 $self->db_query(<<SQL);
17 ALTER TABLE generic_translations
18 ADD CONSTRAINT generic_translations_language_id_fkey
19 FOREIGN KEY (language_id)
20 REFERENCES language (id)
24 $self->db_query(<<SQL);
25 DELETE FROM generic_translations
26 WHERE language_id NOT IN (