1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
# -----------------------------------------------------------
# 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
|
