X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FProducer.pm;h=10d437cd86596656972c9963f65da00d79a42e1b;hb=d4f84dd192edc7a64a0b1a9923f1bafc0bc5ef9d;hp=9f4d3d097ad726a3760d15eb1292cc29b1cde0e7;hpb=ed53eb28a3221df420a24ca7b2db1dc72ac3c8d1;p=dbsrgits%2FSQL-Translator.git

diff --git a/lib/SQL/Translator/Producer.pm b/lib/SQL/Translator/Producer.pm
index 9f4d3d0..10d437c 100644
--- a/lib/SQL/Translator/Producer.pm
+++ b/lib/SQL/Translator/Producer.pm
@@ -1,7 +1,7 @@
 package SQL::Translator::Producer;
 
 # -------------------------------------------------------------------
-# $Id: Producer.pm,v 1.8 2006-06-07 16:28:59 schiffbruechige Exp $
+# $Id: Producer.pm 1440 2009-01-17 16:31:57Z jawnsy $
 # -------------------------------------------------------------------
 # Copyright (C) 2002-4 SQLFairy Authors
 #
@@ -21,8 +21,6 @@ package SQL::Translator::Producer;
 # -------------------------------------------------------------------
 
 use strict;
-use vars qw($VERSION);
-$VERSION = sprintf "%d.%02d", q$Revision: 1.8 $ =~ /(\d+)\.(\d+)/;
 
 sub produce { "" }
 
@@ -34,9 +32,7 @@ sub produce { "" }
 ## They are special per Producer, and provide support for the old 'now()'
 ## default value exceptions
 sub _apply_default_value {
-  my (undef, $field_ref, $default, $exceptions, $noquote) = @_;
-
-  my @noquote = (defined $noquote)?@$noquote:();
+  my (undef, $field_ref, $default, $exceptions) = @_;
 
   if ($exceptions and ! ref $default) {
     for (my $i = 0; $i < @$exceptions; $i += 2) {
@@ -51,11 +47,10 @@ sub _apply_default_value {
     }
   }
 
-  my $qc = (grep m/^$default$/, @noquote)?"":"'"; 
   if (ref $default) {
       $$field_ref .= " DEFAULT $$default";
   } else {
-      $$field_ref .= " DEFAULT $qc$default$qc";
+      $$field_ref .= " DEFAULT '$default'";
   }
 
 }