<p>As stated in the SQLite docs, the behaviour of autoincrement changes when the column is a primary key.</p>

<p><a href="http://www.sqlite.org/autoinc.html">http://www.sqlite.org/autoinc.html</a></p>

<p>Heres a summary of the changes included:</p>

<ul>
<li>I have patched SQL::Translator::Generator::DDL::SQLite to add the word AUTOINCREMENT to the primary keys column is detected as primary key.</li>
<li>I've also patched 30sqlt-new-diff-sqlite.t and 48xml-to-sqlite.t as the new Generator broke some of the tests</li>
<li>I've added a couple of tests in 56-sqlite-producer.t to prove the new feature.</li>
<li>I've added my name and mail in the AUTHORS file as suggested by a Peter Rabbitson message in sqlfairy-developers mailing list</li>
</ul><p>Please do take into account that I'm very new to SQL::Translator and I don't know if the changes and the implementation of them are in sync with the common practices of SQL::Translation.</p>

<p>Regards,</p>

<p>Rafa</p>

<p>PS. BTW, thanks for SQL::Translator. It's been <strong>VERY</strong> helpful ;-)</p>

<hr>

<h4>You can merge this Pull Request by running</h4>
<pre>  git pull https://github.com/rporres/sql-translator people/rporres/sqlite-autoincrement</pre>
<p>Or view, comment on, or merge it at:</p>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/sql-translator/pull/26'>https://github.com/dbsrgits/sql-translator/pull/26</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>Fixed autoincrement in primary keys for SQLite</li>
  <li>removed EOL spaces</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/26/files#diff-0">AUTHORS</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/26/files#diff-1">lib/SQL/Translator/Generator/DDL/SQLite.pm</a>
    (5)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/26/files#diff-2">t/30sqlt-new-diff-sqlite.t</a>
    (4)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/26/files#diff-3">t/48xml-to-sqlite.t</a>
    (10)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/26/files#diff-4">t/56-sqlite-producer.t</a>
    (36)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/26.patch'>https://github.com/dbsrgits/sql-translator/pull/26.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/26.diff'>https://github.com/dbsrgits/sql-translator/pull/26.diff</a></li>
</ul>