From 0408865ffd562798e0891cf907dfcbb1fa17f2cb Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 16 Feb 2006 14:19:51 +0000 Subject: [PATCH] 0.29 --- Changes | 3 ++- DBSchema/Column.pm | 9 ++++----- README | 4 ++-- TODO | 2 ++ 4 files changed, 10 insertions(+), 8 deletions(-) diff --git a/Changes b/Changes index 6dd85e1..5a9a1e0 100644 --- a/Changes +++ b/Changes @@ -1,9 +1,10 @@ Revision history for Perl extension DBIx::DBSchema. -0.29 unreleased +0.29 Thu Feb 16 06:12:42 PST 2006 - Column::sql_add_column fix when adding primary keys to Pg 7.2.x - workaround for PAUSE parsing of DBIx::DBSchema::DBD::Pg version: move DBD::Pg verison checking after $VERSION declaration, thanks Andreas! + - allow setting an empty default value 0.28 Wed Nov 30 09:46:47 PST 2005 - Initial SQLite support from Jesse Vincent diff --git a/DBSchema/Column.pm b/DBSchema/Column.pm index e1e03c7..38afbf1 100644 --- a/DBSchema/Column.pm +++ b/DBSchema/Column.pm @@ -9,7 +9,7 @@ use DBIx::DBSchema::_util qw(_load_driver); #@ISA = qw(Exporter); @ISA = qw(); -$VERSION = '0.04'; +$VERSION = '0.05'; =head1 NAME @@ -261,8 +261,7 @@ sub line { my $null = $self->null; my $default; - if ( defined($self->default) && $self->default ne '' - && ref($dbh) + if ( defined($self->default) && ref($dbh) # false laziness: nicked from FS::Record::_quote && ( $self->default !~ /^\-?\d+(\.\d+)?$/ || $type =~ /(char|binary|blob|text)$/i @@ -315,8 +314,8 @@ with a database handle or data source including a valid username and password - a DBI connection will be opened and the quoting and type mapping will be more reliable. -If passed a DBI data source (or handle) such as `DBI:mysql:database', will use -PostgreSQL-specific syntax. Non-standard syntax for other engines (if +If passed a DBI data source (or handle) such as `DBI:Pg:dbname=database', will +use PostgreSQL-specific syntax. Non-standard syntax for other engines (if applicable) may also be supported in the future. =cut diff --git a/README b/README index 6d3b137..d5b4b6c 100644 --- a/README +++ b/README @@ -12,7 +12,7 @@ schema from an existing database. You can save the schema to disk and restore it from different process. Most importantly, DBIx::DBSchema can write SQL CREATE statements for different databases from a single source. -Currently supported databases are MySQL, PostgreSQL, Oracle and Sybase. +Currently supported databases are MySQL, PostgreSQL, Oracle, Sybase and SQLite. DBIx::DBSchema will attempt to use generic SQL syntax for other databases. Assistance adding support for other databases is welcomed. See the DBIx::DBSchema::DBD manpage, "Driver Writer's Guide and Base Class". @@ -39,4 +39,4 @@ A mailing list is available. Send a blank message to Homepage: -$Id: README,v 1.11 2005-03-11 10:17:53 ivan Exp $ +$Id: README,v 1.12 2006-02-16 14:19:51 ivan Exp $ diff --git a/TODO b/TODO index 3cd57ad..c1136fc 100644 --- a/TODO +++ b/TODO @@ -2,6 +2,8 @@ named indices (index representation needs an overhaul) multiple primary keys (oracle, db2, others?) +foreign keys and other constraints + better documentation for Column::sql_add_column Additional transformations (deleted, modified columns, added/modified/indices -- 2.11.0