<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> <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>