pvanek/sqliteman — pull request #4 by cilynx (2013-12-02 09:35:10+00:00)
Title: Perl Catalyst / DBIx Compatibility

I made a couple updates that make sqliteman much more efficient around REFERENCEs and CASCADEs.

1) Got rid of toUpper on field.type. This prevents "REFERENCES foo(id)" from being converted to "REFERENCES FOO(ID)" since schema creation from SQLite by several external tools is case sensitive.
2) Added a call to sqlite_master which parses the full CREATE statement, thus preserving REFERENCEs, CASCADEs, PRIMARY KEYs, and anything else interesting that shows up in the CREATE statement but not in the PRAGMA definition over table Alters.