lanyrd/mysql-postgresql-converter — pull request #13 by kstinchcombe (2013-12-10 23:00:50+00:00)
Title: improve handling of non-primary indices, foo_id primary keys, 0000-00-00 dates

* preserve 'KEY' lines in CREATE TABLE as CREATE INDEX statements
* if the first row of the table is [...]_id, consider that a
primary key
* replace '0000-00-00 00:00:00' in table default values and use
a date in 1970 instead of 'null' on table inserts
* add drop-if-exists before creating tables and sequences