You want to use a
TRANSLATIONS table, that looks something like:
CREATE TABLE TRANSLATIONS
PRIMARY KEY (translation_id, language_id)
Then edit your current schema and/or code to reference the
TRANSLATIONS table, rather than any hard-coded values (using
language_id to lookup). For example, rather than having a
VARCHAR column in a table, you'd instead have a
NUMBER column that would "link" to the
Probably also best to have a
LANGUAGES table that lists what each
CREATE TABLE LANGUAGES
language_id NUMBER PRIMARY KEY,
iso_code CHAR(4), -- eg "en"
language_name VARCHAR(32) -- eg "English"