title: SQL Not Auto-incrementing
body: <p>I have the following SQL I trigger in a C# app.</p>
  
  <p>All works well but the ID table doesn't auto increment. It creates the value of 1 for the first entry then will not allow other inserts due to not being able to create a unquie ID.</p>
  
  <p>Here is the SQL:</p>
  
  <pre><code>CREATE TABLE of_mapplist_raw (
      id          integer PRIMARY KEY NOT NULL,
      form_name   varchar(200) NOT NULL,
      form_revi   varchar(200) NOT NULL,
      source_map  varchar(200),
      page_num    varchar(200) NOT NULL,
      fid         varchar(200) NOT NULL,
      fdesc       varchar(200) NOT NULL
  )";
  </code></pre>
  
  <p>I'm sure its a schoolboy error at play here.</p>