X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=ac76a7ff043af0a4774e650049fc0b2655d655c0;hb=8dc6a4a31380a1a53c9f50041620ef20337f849c;hp=e69de29bb2d1d6434b8b29ae775ad8c2e48c5391;hpb=c4a7d99451382eb542722468da507d41068ea65a;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index e69de29..ac76a7f 100644 --- a/Changes +++ b/Changes @@ -0,0 +1,146 @@ + +* Added mysql_character_set for 4.1+ -mda +* New filters, Names and Globals. -mda +* Added the initial work on a template based Dia UML producer. -mda + +# ----------------------------------------------------------- +# 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 +# ----------------------------------------------------------- + +* 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 +# ----------------------------------------------------------- + +* Added parsers for Excel and Oracle + +* Removed Sybase parser because it didn't actually work + +* Added ClassDBI, Diagram, GraphViz, HTML, POD, SQLite, Sybase producers + +* Added Schema classes to represent schema as objects + +* Removed "Raw" producer in favor of the Schema classes + +* Removed "Validator" class as the Schema classes validate themselves + +* Improved all existing parsers and producers, expanding them to + handle foreign keys much better, produce better output, etc. + +* Added sqlt-diagram.pl and sqlt-graphviz.pl as CLI frontends to the + graphical producers + +* Added sql_translator.cgi as a web-form frontend to graphical producers + +* Expanded test suite + +# ----------------------------------------------------------- +# 0.01 2003-02-27 +# ----------------------------------------------------------- + +* 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