Added TTSchema changes.
[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
19
c4bf7f53 20# -----------------------------------------------------------
21# 0.06 2004-05-13
22# -----------------------------------------------------------
23* Added SQL::Translator::Manual
24
25* Installation process now uses Module::Build
26
27* Added new "Dumper" producer
28
3e069fa1 29* Changed the native SQL Fairy XML format to a fixed mapping.
30 *NB:* You should convert your existing XML schema. See the
31 SQL::Translator::Parser::XML::SQLFairy docs.
32
33* Added producers: TT::Base and TT::Table.
34
eabd66e6 35# -----------------------------------------------------------
7c67b302 36# 0.05 2004-02-27
37# -----------------------------------------------------------
bc40219c 38* Added "COMMENT ON *" syntax to PostgreSQL parser
39
40* Some fixes to Oracle parser as reported by Gail Binkley
41
42* Added support in PostgreSQL parser for all "ALTER TABLE" statements
7c67b302 43
44* Now distributing sqlt-diff script as it's pretty usable
45
46* Added new options to sqlt-graph and GraphViz producer (Dave Cash)
47
48# -----------------------------------------------------------
d6b47dd5 49# 0.04 2003-11-07
eabd66e6 50# -----------------------------------------------------------
b9952639 51
d6b47dd5 52* Increased version of Constants module to 1.41 to avoid a problem
53 where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused
54 CPAN
55
56* Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than
57 setting them dynamically) so that automated tests would pass
58
59# -----------------------------------------------------------
60# 0.03 2003-11-06
61# -----------------------------------------------------------
62
63* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
64 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
65
66* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
67
68* HTML producer now uses stylesheets to allow easy customization of colors
69
70* Many bug fixes to most every module
71
72* Added "sqlt-dumper" script to help create a script for dumping
73 a database a la "mysqldump"
74
75* Reversed the arrowheads on the graphical producers to show the
76 relationships in a more standard way
77
78* Changes all included script names to start with "sqlt"
79
80* Added capturing and printing most embedded table and field comments
b9952639 81
eabd66e6 82# -----------------------------------------------------------
83# 0.02 2003-06-17
84# -----------------------------------------------------------
b9952639 85
eabd66e6 86* Added parsers for Excel and Oracle
b9952639 87
eabd66e6 88* Removed Sybase parser because it didn't actually work
b9952639 89
eabd66e6 90* Added ClassDBI, Diagram, GraphViz, HTML, POD, SQLite, Sybase producers
b9952639 91
eabd66e6 92* Added Schema classes to represent schema as objects
b9952639 93
eabd66e6 94* Removed "Raw" producer in favor of the Schema classes
b9952639 95
eabd66e6 96* Removed "Validator" class as the Schema classes validate themselves
b9952639 97
eabd66e6 98* Improved all existing parsers and producers, expanding them to
99 handle foreign keys much better, produce better output, etc.
b9952639 100
eabd66e6 101* Added sqlt-diagram.pl and sqlt-graphviz.pl as CLI frontends to the
102 graphical producers
b9952639 103
eabd66e6 104* Added sql_translator.cgi as a web-form frontend to graphical producers
150797b1 105
eabd66e6 106* Expanded test suite
d3e95970 107
108# -----------------------------------------------------------
d6b47dd5 109# 0.01 2003-02-27
f6aed479 110# -----------------------------------------------------------
111
7c67b302 112* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
113 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
114
115* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
116
117* HTML producer now uses stylesheets to allow easy customization of colors
118
119* Many bug fixes to most every module
120
121* Added "sqlt-dumper" script to help create a script for dumping
122 a database a la "mysqldump"
123
124* Reversed the arrowheads on the graphical producers to show the
125 relationships in a more standard way
126
127* Changes all included script names to start with "sqlt"
128
129* Added capturing and printing most embedded table and field comments