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