kivitendo/sql/Pg-upgrade2/generic_translations.sql @ 7b1da9c3
| e09347c8 | Geoffrey Richardson | -- @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);
|