title: Dynamic Database table attributes (best practice)
body: <p>I want to create a DVD Database (MySQL) with custom fields, that means, that the user should be able to add his own information fields to catalogue his DVDs. I just provide the required attributes, for example:</p>
  
  <pre><code> - ID
   - Title
  </code></pre>
  
  <p>The user can add fields for his own use like</p>
  
  <pre><code>- Actors
  - Year
  - Genre
  - Plot
  - etc
  </code></pre>
  
  <p>Now, what's the best practice for this challenge? I've got some ideas:</p>
  
  <ol>
  <li>Alter the table and add attributes (possible data loss)</li>
  <li>Use temporary tables (less performance)</li>
  </ol>
  
  <p>Is there a better idea?</p>