title: How to structure a database for simple multilanguage website (PHP MySQL)?
body: <p>I've developed a website more than a year ago. The content were/is in two languages and now I need to build a database driven update/data insertion system for them to inserte some news, events etc.
  Is the best approach to create tables like this:</p>
  
  <pre><code>news_id         int(10) unsigned PK
  lang_id         int(2)
  status          tinyint(1)
  title           varchar(255)
  title_en        varchar(255)
  title_es        varchar(255)
  content         text
  content_en      text
  content_es      text
  date_inserted   datetime
  date_modified   datetime
  type            varchar(45)
  atach           text
  </code></pre>
  
  <p>then create a table for the languages</p>