new blob typemaps, Pg now has a sane blob type!

diff --git a/DBSchema/DBD/Pg.pm b/DBSchema/DBD/Pg.pm
index 23ab42b..ad1613d 100644 (file)
--- a/DBSchema/DBD/Pg.pm
+++ b/DBSchema/DBD/Pg.pm
@@ -8,7 +8,8 @@ $VERSION = '0.02';
 @ISA = qw(DBIx::DBSchema::DBD);
 
 %typemap = (
-  'BLOB' => 'TEXT',
+  'BLOB' => 'BYTEA',
+  'LONG VARBINARY' => 'BYTEA',
 );
 
 =head1 NAME

diff --git a/DBSchema/DBD/mysql.pm b/DBSchema/DBD/mysql.pm
index 3d64477..f3804dd 100644 (file)
--- a/DBSchema/DBD/mysql.pm
+++ b/DBSchema/DBD/mysql.pm
@@ -8,9 +8,10 @@ $VERSION = '0.03';
 @ISA = qw(DBIx::DBSchema::DBD);
 
 %typemap = (
-  'TIMESTAMP' => 'DATETIME',
-  'SERIAL'    => 'INTEGER',
-  'BOOL'      => 'TINYINT',
+  'TIMESTAMP'      => 'DATETIME',
+  'SERIAL'         => 'INTEGER',
+  'BOOL'           => 'TINYINT',
+  'LONG VARBINARY' => 'LONGBLOB',
 );
 
 =head1 NAME