-- @tag: generic_translations
-- @description: Allgemeine Tabelle fuer Uebersetzungen
-- @depends: release_2_6_0
CREATE TABLE generic_translations (
  id SERIAL,
  language_id integer,
  translation_type varchar(100) NOT NULL,
  translation_id integer,
  translation text,

  PRIMARY KEY (id),
  FOREIGN KEY (language_id) REFERENCES language (id)
);
CREATE INDEX generic_translations_type_id_idx ON generic_translations (language_id, translation_type, translation_id);