title: Change the primary key of a table in SQLite
body: <p>I have the following table:</p>
  
  <pre><code>[id,lang,data]
  </code></pre>
  
  <p>Where the primary key is <code>id</code></p>
  
  <p>I want to change the primary key to  <code>id,lang</code> without losing the content of the table. What is the query I must run to change it</p>
  
  <p>Thanks</p>