Sorry it took so long - it's been a busy week. Here's a patch:
Code:
Index: MySQLMan.pm
===================================================================
RCS file: mysqlman/MySQLMan.pm,v
retrieving revision 1.28
diff -u -r1.28 MySQLMan.pm
--- MySQLMan.pm 10 Jun 2008 03:59:24 -0000 1.28
+++ MySQLMan.pm 25 Apr 2009 03:09:56 -0000
@@ -2942,8 +2942,9 @@
}
$col_spec .= ' ' . $IN->param("attributes_$i") . ' ';
$col_spec .= $IN->param("null_$i") . ' ';
- if ( $IN->param("default_$i") ) {
- $col_spec .= 'DEFAULT ' . $DBH->quote( $IN->param("default_$i") ) . ' ';
+ my $default = $IN->param("default_$i");
+ if (length $default) {
+ $col_spec .= 'DEFAULT ' . $DBH->quote($default) . ' ';
}
$col_spec .= $IN->param("extra_$i");
Adrian