X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=73a731a589ffab7c2de55a9ea578c8c56a6579ff;hb=ef45b16bef113d0ad742b44e3a14991b8b002838;hp=9b2deded808554acd4243109bee3b5a296b6df6c;hpb=f6aed4790c9f8fecb85bcf3b0549baece186fa8a;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 9b2dede..73a731a 100644 --- a/Changes +++ b/Changes @@ -1,8 +1,95 @@ # ----------------------------------------------------------- -# 0.01 2003-02-27 +# 0.7 2005-06-10 +# ----------------------------------------------------------- +* YAML parser supports extra attributes on tables. + +* All schema objects now support the extra attribute, so can + have arbitary name/value data attached to them. + +* Refactoring: Added SQL::Translator::Schema::Object - base + class for all Schema objects. + +* Changes to MySQL Parser (Dave Howorth) + - ignore INSERT statements + - permit ALTER TABLE ADD FOREIGN KEY + - allow trailing comma on last field in CREATE statements + - collect the database name + +* TTSchema Producer + - Can pass extra variables using tt_vars producer arg. + - Can pass extra config using tt_conf producer arg. + - Variables and config can be passed on the command line + with --tt-var and --tt-conf options to sqlt. + +* Added schema filters. + +* MySQL Producer + - Added 'mysql_table_type' extra attribute on tables. + - Works out InnoDB tables from constraints. + - mysql_charset and mysql_collate extra attributes for tables and fiels. + + +# ----------------------------------------------------------- +# 0.06 2004-05-13 +# ----------------------------------------------------------- +* Added SQL::Translator::Manual + +* Installation process now uses Module::Build + +* Added new "Dumper" producer + +* Changed the native SQL Fairy XML format to a fixed mapping. + *NB:* You should convert your existing XML schema. See the + SQL::Translator::Parser::XML::SQLFairy docs. + +* Added producers: TT::Base and TT::Table. + +# ----------------------------------------------------------- +# 0.05 2004-02-27 +# ----------------------------------------------------------- +* Added "COMMENT ON *" syntax to PostgreSQL parser + +* Some fixes to Oracle parser as reported by Gail Binkley + +* Added support in PostgreSQL parser for all "ALTER TABLE" statements + +* Now distributing sqlt-diff script as it's pretty usable + +* Added new options to sqlt-graph and GraphViz producer (Dave Cash) + +# ----------------------------------------------------------- +# 0.04 2003-11-07 +# ----------------------------------------------------------- + +* Increased version of Constants module to 1.41 to avoid a problem + where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused + CPAN + +* Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than + setting them dynamically) so that automated tests would pass + +# ----------------------------------------------------------- +# 0.03 2003-11-06 # ----------------------------------------------------------- -* Initial release. +* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL, + DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML + +* Added producers: XML::SQLFairy, TTSchema, Storable, YAML + +* HTML producer now uses stylesheets to allow easy customization of colors + +* Many bug fixes to most every module + +* Added "sqlt-dumper" script to help create a script for dumping + a database a la "mysqldump" + +* Reversed the arrowheads on the graphical producers to show the + relationships in a more standard way + +* Changes all included script names to start with "sqlt" + +* Added capturing and printing most embedded table and field comments # ----------------------------------------------------------- # 0.02 2003-06-17 @@ -31,7 +118,7 @@ * Expanded test suite # ----------------------------------------------------------- -# 0.03 2003-11-06 +# 0.01 2003-02-27 # ----------------------------------------------------------- * Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL, @@ -52,14 +139,3 @@ * Changes all included script names to start with "sqlt" * Added capturing and printing most embedded table and field comments - -# ----------------------------------------------------------- -# 0.04 2003-11-07 -# ----------------------------------------------------------- - -* Increased version of Constants module to 1.41 to avoid a problem - where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused - CPAN - -* Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than - setting them dynamically) so that automated tests would pass