1 Revision history for Perl extension DBIx::DBSchema.
4 - consolidate multiple ALTER TABLE statements for efficiency
6 0.40 Sat Dec 17 17:03:51 PST 2011
7 - doc: sql_update_schema link to sql_add_column misspelled
8 - Pg: fix mapping for DOUBLE PRECISION type to avoid needless alter cols
9 - mysql: implement altering column types & lengths
11 0.39 Fri Mar 26 20:24:58 PDT 2010
12 - mysql: TEXT->LONGTEXT
13 - mysql: when reverse engineering, transform a default of
14 CURRENT_TIMESTAMP into the more common NOW()
15 - mysql: fix reverse-engineering of empty string default
17 0.38 Thu Jan 14 15:26:13 PST 2010
18 - Bump version number for ->quoted_default availability & default
19 reverse-engineering changes
22 - Patch from Slavin Rezic <srezic@cpan.org> to prevent quoting around
23 numeric defaults in Pg.
24 - Pg: use default_db_schema when adding SERIAL columns instead of
26 - Pg: Initial support for handling changes to a column's type or size.
27 - Case sensitivity fix for Slavin's patch to prevent quoting around
28 numeric defaults in Pg.
29 - Column default values: refactor handling, improve Pg reverse
30 engineering and implement schema changes.
32 0.36 Thu Dec 13 17:49:35 PST 2007
33 - Patch from ISHIGAKI@cpan.org to suppress unnecessary warnings about
34 undefined local_options, thanks!
35 - fix bug preventing adding new columns as primary keys under Pg
37 0.35 Mon Oct 29 18:58:36 PDT 2007
38 - Fix minor breakage (pretty_print) resulting from Jesse's changes.
39 - Update mysql driver to handle BIGSERIAL columns
40 - Update Column.pm, move all mysql and Pg-specific code to DBD driver
42 - Update Table.pm, add local_options
43 - Fix mysql NULL reverse-engineering and updating code
45 0.34 Sun Aug 19 10:08:51 PDT 2007
46 - More work on update schema from Slaven Rezic <srezic@cpan.org>,
48 + implement table dropping (closes: CPAN#27936)
49 + implement column dropping (closes: CPAN#27896)
50 - Fix to quiet warnings from internal use of old API from Jesse Vincent
51 <jesse+cpan@fsck.com>, thanks! (closes: CPAN#27958)
52 - Make table dropping optional, not the default.
54 0.33 Thu Jun 28 18:46:15 PDT 2007
55 - Overhaul of index representation: indices (both normal and unique)
56 now have names and are DBIx::DBSchema::Index objects
57 - update_schema now handles indices!
58 - Bump version numbers in Table.pm, Column.pm and DBD.pm
59 - Pg reverse-engineering fix for column order in multi-column indices,
60 to prevent needless drop/add of identical indices
61 - mysql reverse-engineering patch from Brian Phillips
62 <bphillips@cpan.org>, closes: CPAN#17582, thanks!
63 - mysql NAME vs NAME_lc patch from Ralf Hack <ralf@beetlecraft.net>,
64 closes: CPAN#16715, thanks!
65 - mysql fix for additional column data from Chris Mungall
66 <cjm@fruitfly.org>, closes: CPAN#20859, thanks!
67 - SQLite SERIAL patch from IN SUK JOUNG <i.joung@gmail.com>, and fix
68 for mis-application of said patch from Slaven Rezic
69 <srezic@cpan.org>, thanks!
70 - Update README wrt current CVS info and URL, closes: CPAN#27577
72 0.32 Wed Apr 18 15:02:25 PDT 2007
73 - increment the version numbers in Column.pm and Table.pm and the
74 "use" statements accordingly
75 - Error reporting for load constructor
76 - Update documentation wrt supported databases and new update_schema
78 - Fixes for dropping nullability on old Pg (<= 7.2)
79 - Fixes for adding nullability on old Pg (<= 7.3)
80 - Throw a warning if pg_server_version is unavailable, assume >= 7.3
81 - fix POD error in DBSchema::DBD::SQLite that confused pod2man and
82 prevented the documentation from being installed. Patch from Niko
83 Tyni <ntyni@iki.fi>, thanks!
85 0.31 Thu Mar 30 05:28:20 PST 2006
86 - more schema update stuff:
87 - added Column::sql_alter_column
88 - added Table::sql_alter_table
89 - added DBSchema::sql_update_schema and DBSchema::update_schema
91 0.30 Thu Feb 16 16:43:01 PST 2006
93 - Remove buggy debugging from Column.pm
94 - Remove removed TODO from MANIFEST
96 0.29 Thu Feb 16 13:54:42 PST 2006
97 - Column::sql_add_column fix when adding primary keys to Pg 7.2.x
98 - workaround for PAUSE parsing of DBIx::DBSchema::DBD::Pg version: move
99 DBD::Pg verison checking after $VERSION declaration, thanks Andreas!
100 - kludge: allow scalar ref default to force quoting off, to add things
101 like functions and empty values as defaults
102 - Move TODO file to DBSchema.pm and DBS/Column.pm BUGS sections
104 0.28 Wed Nov 30 09:46:47 PST 2005
105 - Initial SQLite support from Jesse Vincent
106 - fix typo in DBIx::DBSchema::DBD POD doc
108 0.27 Mon Aug 15 23:31:54 PDT 2005
109 - MySQL patch for enum types from Andy Orr
110 - new Column::sql_add_column method!
112 0.26 Thu Apr 7 01:09:53 PDT 2005
113 - ask for "public" db schema only from Pg
115 0.25 Wed Apr 6 16:12:38 PDT 2005
116 - depend on DBD::Pg 1.32 or 1.41+ (1.40 was bunk)
118 0.24 Fri Mar 11 02:20:55 PST 2005
119 - Oracle driver from Daniel Hanks <hanksdc@about-inc.com> and Peter
120 Bowen <pbowen@aboutws.com>.
121 - Switch from FreezeThaw to Storable, keep ability to read old files
123 0.23 Mon Feb 16 17:35:54 PST 2004
124 - Update Pg dependancy to 1.32
125 - Update the simple load test so it skips DBIx::DBSchema::DBD::Pg if
126 DBD::Pg 1.32 is not installed.
128 0.22 Thu Oct 23 15:18:21 PDT 2003
129 - Pg reverse-engineering fix: varchar with no limit
130 - Pg needs (unreleased) DBD::Pg 1.30 (or deb 1.22-2... interesting)
132 0.21 Thu Sep 19 05:04:18 PDT 2002
133 - Pg reverse-engineering fix: now sets default
135 0.20 Mon Mar 4 04:58:34 2002
136 - documentation updates
137 - fix Column->new when using named params
138 - fix Pg driver reverse-engineering length of numeric columns:
139 translate 655362 to 10,2, etc.
140 - fix Pg driver reverse-engineering of text columns (don't have a
143 0.19 Tue Oct 23 08:49:12 2001
144 - documentation for %typemap
145 - preliminary Sybase driver from Charles Shapiro
146 <charles.shapiro@numethods.com> and Mitchell J. Friedman
147 <mitchell.friedman@numethods.com>.
148 - Fix Column::line to return a scalar as documented, not a list.
149 - Should finally eliminate the Use of uninitialized value at
150 ... DBIx/DBSchema/Column.pm line 251
152 0.18 Fri Aug 10 17:07:28 2001
153 - Added Table::delcolumn
154 - patch from Charles Shapiro <cshapiro@numethods.com> to add
155 `ORDER BY a.attnum' to the SQL in DBIx::DBSchema::DBD::Pg::columns
157 0.17 Sat Jul 7 17:55:33 2001
158 - Rework Table->new interface for named params
159 - Fixes for Pg blobs, yay!
160 - MySQL doesn't need non-standard index syntax anymore (since 3.22).
161 - patch from Mark Ethan Trostler <mark@zzo.com> for generating
162 tables without indices.
164 0.16 Fri Jan 5 15:55:50 2001
165 - Don't overflow index names.
167 0.15 Fri Nov 24 23:39:16 2000
168 - MySQL handling of BOOL type (change to TINYINT)
170 0.14 Tue Oct 24 14:43:16 2000
171 - MySQL handling of SERIAL type (change to INTEGER AUTO_INCREMENT)
173 0.13 Wed Oct 11 10:47:13 2000
174 - fixed up type mapping foo, added default values, added named
175 parameters to Column->new, fixed quoting of default values
177 0.11 Sun Sep 28 02:16:25 2000
178 - oops, original verison got 0.10, so this one will get 0.11
180 0.01 Sun Sep 17 07:57:35 2000
181 - original version; created by h2xs 1.19