title: Create table with primary key using jOOQ
body: <p>jOOQ has CREATE TABLE syntax as stated <a href="http://www.jooq.org/doc/3.5/manual/sql-building/ddl-statements/create-statement/">in the documentation</a>:</p>
  
  <pre><code>create.createTable(AUTHOR)
        .column(AUTHOR.ID, SQLDataType.INTEGER)
        .column(AUTHOR.FIRST_NAME, SQLDataType.VARCHAR.length(50))
        .column(AUTHOR_LAST_NAME, SQLDataType.VARCHAR.length(50))
        .execute();
  </code></pre>
  
  <p>I'm wondering how to define which column belongs to the primary key? So is there a way in jOOQ to create a CREATE TABLE statement with PRIMARY KEY information?</p>
  
  <p>I'm specifically interested in a solution for SQLite, which doesn't have syntax to add the primary key afterwards, so I think in worst case I have to go to a DB specific solution?</p>