#3 Translation of database table content

[Peter Hopfgartner]

In a multilingual context there might be interest in
having a chance to switch language on a case by case base.

A valuable featere addition could be, that the content
of the tables INT_tariffe and INT_pratiche_tipo is
multilingual? Just as an example, there could be a new
table

INT_tariffe_strings (
id INT,
lang_id CHAR(2),
tat_id CHAR(5),
tat_desc VARCHAR(250)
)

The column tat_desc could then be dropped from
INT_tariffe.

Queries would then be done like

SELECT tat_desc FROM INT_tariffe ta INNER JOIN
INT_tariffe_stirngs ta_str ON ta.tat_id = ta_str.tat_id
AND lang_id = $current_lang_id

Best regards,

Peter Hopfgartner