Support for Partial Indexes was available in Doctrine 1 following
http://www.doctrine-project.org/jira/browse/DC-82. This commit
reintroduce support for Doctrine 2. We use the same syntax with an
optionnal "where" attribute for Index and UniqueConstraint.

- added test for getListTableColumnsSQL
- added test for getListTableForeignKeysSQL
- added test for getListTableIndexesSQL

DBAL-54 was fixed in commit 3d55dc8e by
changing SQL queries order. However it was later reintroduced.

This patch uses a different, more future-proof way, approach by using
DROP SEQUENCE ... CASCADE syntax, and thus does not depend on queries order.

[DBAL-374] Fix issue with column quoting in primary keys, fixing this in indexes in general is much more complex as the code is messy.

DBAL-84 - Fix VARCHARs being silently set to 255 chars when larger than Maxlength. Now they are converted to Text/CLOB fields automatically. Refactored the VARCHAR code considerably.

[DBAL-42] Add support to reverse engineer Comments from MySQL, PostgreSQL and ORacle into Doctrine\DBAL\Schema\Column instances and added comment comparison into Comparator.

DBAL-91 - Fix auto-generation of asset names (foreign keys and indexes) which could lead to exceptions due to auto-quoting of PostgreSQL for example. Now hashing the names with crc32+dechex

DBAL-37 - Fix PostgreSQL Platform not supporting changes in Autoicnrement during ALTER TABLE generation

Revertd partially the support to DBAL\Transaction, it was wrong. Fixed implementation of ORM\EntityTransaction and fixed tests.