Multi Languange in Yii from database content

Good Morning Master,

I want to use multilanguange in Indonesian and English

I have already handled the content of database in multi languange,

Example , there are atributes desc_indonesian dan desc_english in post table

what is the best practice to solve that?

Please help master :)


you can split a table into two table.exmp :

Ex Table:

id | type_id | name | disc | date


id | type_id | date


id | name | desc | lang_id | first_table_id

first table for constant data(exmp date , type_id ,…) , second table for translate data (exmp name , discribtion ,…)

Thanks for your help…