X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=77e89f76c3d48cd0a67962677b2c3491a84821ad;hb=50f63fb11060a1f9f0a013bd79ec05d94e4ee151;hp=02aad2fd8b6feafc2731b52b7bf8f1f1e9f29a99;hpb=d3e9597081d64d93c3dbe828837e9d11c2116913;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 02aad2f..77e89f7 100644 --- a/Changes +++ b/Changes @@ -1,8 +1,100 @@ + +* Added mysql_character_set for 4.1+ -mda +* Two experimental filters. -mda +* Added build support for installing templates. -mda + # ----------------------------------------------------------- -# 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 -* Initial release. +* 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 +# ----------------------------------------------------------- + +* 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,17 +123,24 @@ * Expanded test suite # ----------------------------------------------------------- -# 0.03 2003-??-?? +# 0.01 2003-02-27 # ----------------------------------------------------------- -* Added parsers: XML::SQLFairy and Sybase +* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL, + DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML + +* Added producers: XML::SQLFairy, TTSchema, Storable, YAML -* Added producers: XML::SQLFairy, TTSchema +* HTML producer now uses stylesheets to allow easy customization of colors * Many bug fixes to most every module -* Added "sqlt-dumper.pl" script to help create a script for dumping +* 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