X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=85cb72a2c3d0d86825932db7baceba686594c02d;hb=b08b5416f45bfbe381637ee3091202524c78ecab;hp=3368fc5ec68f133c9eabcf730aa11b37691fa60a;hpb=7c67b30251f6df0e2abf2630efcf0cf29ff0cf66;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 3368fc5..85cb72a 100644 --- a/Changes +++ b/Changes @@ -1,8 +1,85 @@ # ----------------------------------------------------------- +# 0.08_03 +# ----------------------------------------------------------- + +* Added patch to use default values for Pg timestamp fields + +# ----------------------------------------------------------- +# 0.08_02 2006-11-03 +# ----------------------------------------------------------- + +* Added patch from Ash to separate DROP statements in mysql producer in list-context +* Fixed up SQLites usage of no-comments + +# ----------------------------------------------------------- +# 0.08_01 2006-07-23 +# ----------------------------------------------------------- + +* Made Trigger check that a give table exists in on_table - castaway +* Split some producers (DB2, MySQL, SQLite, PostgreSQL) into sub methods (others to follow) - castaway +* Add alter_* methods to some Producers and docs to Producer.pm (for use by Diff later) - castaway +* Made changes to allow producers to return a list of statements - castaway +* Split sqlt-diff into script and module - castaway +* Added quote_table_names and quote_field_names patch (omega, zamolxes) - castaway +* Added DB2 Producer - castaway +* 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.07 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 # ----------------------------------------------------------- -* Various bug fixes and enhancements to Parsers (esp. PostgreSQL) - and Producers (esp. Oracle) +* 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 @@ -72,7 +149,6 @@ # 0.01 2003-02-27 # ----------------------------------------------------------- -<<<<<<< Changes * Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL, DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML @@ -91,27 +167,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 - -# ----------------------------------------------------------- -# 0.05 2003-12-17 -# ----------------------------------------------------------- - -* 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 -======= -* Initial release. ->>>>>>> 1.10