Added different counter query support for Doctrine_Pager. Now it can use 2 different queries to paginate items. Added 4 new methods: setCountQuery, getCountQuery, setCountQueryParams and getCountQueryParams. If not defined a counter Doctrine_Query, the collector one is used. If no params were defined to be used in counter query, the ones passed by execute method are used

Fixed count bug in Doctrine_Pager that was wrong counting the total of results found. Added 3 new methods: Doctrine_Pager::getExecuted (checks if the Pager was already executed), Doctrine_Pager_Layout::execute (handy access to execute Pager query without having to access Doctrine_Pager instance) and Doctrine_Pager_Layout::processPage (processes the template of a given page and returns the parsed string)

--no commit message

--no commit message

--no commit message

--no commit message

--no commit message

--no commit message

--no commit message

Added support to leftJoin and innerJoin parameters. Included some tests that failed due to an existent Doctrine bug.

- unified getDefaultFieldDeclaration(), force DEFAULT NULL when no default is set and the field allows nulls

- ensure that nextId() always relies in autoincrement id generation to ensure that last insert id works reliably

- added support for temporary tables, tweaked createSequence and enum support in getDefaultFieldDeclaration()

generalized a connection example to use user:pass instead of jwage:pass...