mysql_table_type extra data and InnoDB derivation fix.
[dbsrgits/SQL-Translator.git] / Changes
CommitLineData
7fc38348 1* All schema objects now support the extra attribute, so can
2 have arbitary name/value data attached to them.
3
4* Refactoring: Added SQL::Translator::Schema::Object - base
5 class for all Schema objects.
6
13aec984 7* Changes to MySQL Parser (Dave Howorth)
8 - ignore INSERT statements
9 - permit ALTER TABLE ADD FOREIGN KEY
10 - allow trailing comma on last field in CREATE statements
11 - collect the database name
12
f9725390 13* TTSchema Producer
14 - Can pass extra variables using tt_vars producer arg.
15 - Can pass extra config using tt_conf producer arg.
16 - Variables and config can be passed on the command line
17 with --tt-var and --tt-conf options to sqlt.
18
185c34d5 19* Added schema filters.
f9725390 20
5a0c7b43 21* MySQL Producer
22 - Added 'mysql_table_type' extra attribute on tables.
23 - Works out InnoDB tables from constraints.
24
25
c4bf7f53 26# -----------------------------------------------------------
27# 0.06 2004-05-13
28# -----------------------------------------------------------
29* Added SQL::Translator::Manual
30
31* Installation process now uses Module::Build
32
33* Added new "Dumper" producer
34
3e069fa1 35* Changed the native SQL Fairy XML format to a fixed mapping.
36 *NB:* You should convert your existing XML schema. See the
37 SQL::Translator::Parser::XML::SQLFairy docs.
38
39* Added producers: TT::Base and TT::Table.
40
eabd66e6 41# -----------------------------------------------------------
7c67b302 42# 0.05 2004-02-27
43# -----------------------------------------------------------
bc40219c 44* Added "COMMENT ON *" syntax to PostgreSQL parser
45
46* Some fixes to Oracle parser as reported by Gail Binkley
47
48* Added support in PostgreSQL parser for all "ALTER TABLE" statements
7c67b302 49
50* Now distributing sqlt-diff script as it's pretty usable
51
52* Added new options to sqlt-graph and GraphViz producer (Dave Cash)
53
54# -----------------------------------------------------------
d6b47dd5 55# 0.04 2003-11-07
eabd66e6 56# -----------------------------------------------------------
b9952639 57
d6b47dd5 58* Increased version of Constants module to 1.41 to avoid a problem
59 where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused
60 CPAN
61
62* Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than
63 setting them dynamically) so that automated tests would pass
64
65# -----------------------------------------------------------
66# 0.03 2003-11-06
67# -----------------------------------------------------------
68
69* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
70 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
71
72* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
73
74* HTML producer now uses stylesheets to allow easy customization of colors
75
76* Many bug fixes to most every module
77
78* Added "sqlt-dumper" script to help create a script for dumping
79 a database a la "mysqldump"
80
81* Reversed the arrowheads on the graphical producers to show the
82 relationships in a more standard way
83
84* Changes all included script names to start with "sqlt"
85
86* Added capturing and printing most embedded table and field comments
b9952639 87
eabd66e6 88# -----------------------------------------------------------
89# 0.02 2003-06-17
90# -----------------------------------------------------------
b9952639 91
eabd66e6 92* Added parsers for Excel and Oracle
b9952639 93
eabd66e6 94* Removed Sybase parser because it didn't actually work
b9952639 95
eabd66e6 96* Added ClassDBI, Diagram, GraphViz, HTML, POD, SQLite, Sybase producers
b9952639 97
eabd66e6 98* Added Schema classes to represent schema as objects
b9952639 99
eabd66e6 100* Removed "Raw" producer in favor of the Schema classes
b9952639 101
eabd66e6 102* Removed "Validator" class as the Schema classes validate themselves
b9952639 103
eabd66e6 104* Improved all existing parsers and producers, expanding them to
105 handle foreign keys much better, produce better output, etc.
b9952639 106
eabd66e6 107* Added sqlt-diagram.pl and sqlt-graphviz.pl as CLI frontends to the
108 graphical producers
b9952639 109
eabd66e6 110* Added sql_translator.cgi as a web-form frontend to graphical producers
150797b1 111
eabd66e6 112* Expanded test suite
d3e95970 113
114# -----------------------------------------------------------
d6b47dd5 115# 0.01 2003-02-27
f6aed479 116# -----------------------------------------------------------
117
7c67b302 118* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
119 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
120
121* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
122
123* HTML producer now uses stylesheets to allow easy customization of colors
124
125* Many bug fixes to most every module
126
127* Added "sqlt-dumper" script to help create a script for dumping
128 a database a la "mysqldump"
129
130* Reversed the arrowheads on the graphical producers to show the
131 relationships in a more standard way
132
133* Changes all included script names to start with "sqlt"
134
135* Added capturing and printing most embedded table and field comments