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