title: Is there UID datatype in SQLITE if Yes then how to generate value for that
body: <p>I am creating table like this:</p>
  
  <pre><code>CREATE TABLE foobar (id uniqueidentifier, foo text, bar text, PRIMARY  KEY (id))
  </code></pre>
  
  <p>How to insert  or generate value for id field in table foobar?</p>