1 # -----------------------------------------------------------
3 # -----------------------------------------------------------
4 * YAML parser supports extra attributes on tables.
6 * All schema objects now support the extra attribute, so can
7 have arbitary name/value data attached to them.
9 * Refactoring: Added SQL::Translator::Schema::Object - base
10 class for all Schema objects.
12 * Changes to MySQL Parser (Dave Howorth)
13 - ignore INSERT statements
14 - permit ALTER TABLE ADD FOREIGN KEY
15 - allow trailing comma on last field in CREATE statements
16 - collect the database name
19 - Can pass extra variables using tt_vars producer arg.
20 - Can pass extra config using tt_conf producer arg.
21 - Variables and config can be passed on the command line
22 with --tt-var and --tt-conf options to sqlt.
24 * Added schema filters.
27 - Added 'mysql_table_type' extra attribute on tables.
28 - Works out InnoDB tables from constraints.
29 - mysql_charset and mysql_collate extra attributes for tables and fiels.
32 # -----------------------------------------------------------
34 # -----------------------------------------------------------
35 * Added SQL::Translator::Manual
37 * Installation process now uses Module::Build
39 * Added new "Dumper" producer
41 * Changed the native SQL Fairy XML format to a fixed mapping.
42 *NB:* You should convert your existing XML schema. See the
43 SQL::Translator::Parser::XML::SQLFairy docs.
45 * Added producers: TT::Base and TT::Table.
47 # -----------------------------------------------------------
49 # -----------------------------------------------------------
50 * Added "COMMENT ON *" syntax to PostgreSQL parser
52 * Some fixes to Oracle parser as reported by Gail Binkley
54 * Added support in PostgreSQL parser for all "ALTER TABLE" statements
56 * Now distributing sqlt-diff script as it's pretty usable
58 * Added new options to sqlt-graph and GraphViz producer (Dave Cash)
60 # -----------------------------------------------------------
62 # -----------------------------------------------------------
64 * Increased version of Constants module to 1.41 to avoid a problem
65 where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused
68 * Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than
69 setting them dynamically) so that automated tests would pass
71 # -----------------------------------------------------------
73 # -----------------------------------------------------------
75 * Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
76 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
78 * Added producers: XML::SQLFairy, TTSchema, Storable, YAML
80 * HTML producer now uses stylesheets to allow easy customization of colors
82 * Many bug fixes to most every module
84 * Added "sqlt-dumper" script to help create a script for dumping
85 a database a la "mysqldump"
87 * Reversed the arrowheads on the graphical producers to show the
88 relationships in a more standard way
90 * Changes all included script names to start with "sqlt"
92 * Added capturing and printing most embedded table and field comments
94 # -----------------------------------------------------------
96 # -----------------------------------------------------------
98 * Added parsers for Excel and Oracle
100 * Removed Sybase parser because it didn't actually work
102 * Added ClassDBI, Diagram, GraphViz, HTML, POD, SQLite, Sybase producers
104 * Added Schema classes to represent schema as objects
106 * Removed "Raw" producer in favor of the Schema classes
108 * Removed "Validator" class as the Schema classes validate themselves
110 * Improved all existing parsers and producers, expanding them to
111 handle foreign keys much better, produce better output, etc.
113 * Added sqlt-diagram.pl and sqlt-graphviz.pl as CLI frontends to the
116 * Added sql_translator.cgi as a web-form frontend to graphical producers
118 * Expanded test suite
120 # -----------------------------------------------------------
122 # -----------------------------------------------------------
124 * Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
125 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
127 * Added producers: XML::SQLFairy, TTSchema, Storable, YAML
129 * HTML producer now uses stylesheets to allow easy customization of colors
131 * Many bug fixes to most every module
133 * Added "sqlt-dumper" script to help create a script for dumping
134 a database a la "mysqldump"
136 * Reversed the arrowheads on the graphical producers to show the
137 relationships in a more standard way
139 * Changes all included script names to start with "sqlt"
141 * Added capturing and printing most embedded table and field comments