-- translatable strings which are not in tables
CREATE TABLE translation (translation_id SERIAL PRIMARY KEY, translation_en TEXT, translation_de TEXT, 
translation_fr TEXT, translation_sp TEXT, translation_pt TEXT, translation_ja TEXT, translation_it TEXT, 
translation_pl TEXT, translation_ru TEXT, translation_nl TEXT, translation_fi TEXT, translation_sv TEXT,
translation_cmn TEXT, translation_yue TEXT, translation_tr TEXT, translation_th TEXT, translation_hi TEXT,
translation_bn TEXT, translation_ar TEXT);

COMMENT ON COLUMN translation.translation_cmn IS 'mandarin chinese, i.e. simplified';
COMMENT ON COLUMN translation.translation_yue IS 'cantonese chinese, i.e. traditional';
COMMENT ON COLUMN translation.translation_tr IS 'turkish';
COMMENT ON COLUMN translation.translation_sv IS 'swedish';
COMMENT ON COLUMN translation.translation_th IS 'thai';
COMMENT ON COLUMN translation.translation_hi IS 'hindi';
COMMENT ON COLUMN translation.translation_bn IS 'bengali';
COMMENT ON COLUMN translation.translation_ar IS 'arabic';
