[Phpgroupware-cvs] phpgwapi/inc/class.schema_proc.inc.php, 1.2.2.10

[nomail]

Update of /phpgwapi/inc
Modified Files:
        Branch: Version-0_9_16-branch
          class.schema_proc.inc.php

date: 2004/06/30 06:25:59;  author: skwashd;  state: Exp;  lines: +10 -6

Log Message:
fix for bug #6163
=====================================================================
Index: phpgwapi/inc/class.schema_proc.inc.php
diff -u phpgwapi/inc/class.schema_proc.inc.php:1.2.2.9 
phpgwapi/inc/class.schema_proc.inc.php:1.2.2.10
--- phpgwapi/inc/class.schema_proc.inc.php:1.2.2.9      Fri Mar 12 02:41:24 2004
+++ phpgwapi/inc/class.schema_proc.inc.php      Wed Jun 30 06:25:59 2004
@@ -425,17 +425,21 @@
                                {
                                        $sFieldSQL .= ' NOT NULL';
                                }
-
-                               if($sDefault != '')
+                               
+                               if($sDefault == '0')
+                               {
+                                       $sFieldSQL .= " DEFAULT 0";
+                               }                                               
                
+                               elseif(intval($sDefault) == 0 && $sDefault != 
'')
                                {
                                        if($DEBUG) { echo'<br>_GetFieldSQL(): 
Calling TranslateDefault for "' . $sDefault . '"'; }
                                        // Get default DDL - useful for 
differences in date defaults (eg, now() vs. getdate())
                                        $sTranslatedDefault = 
$this->m_oTranslator->TranslateDefault($sDefault);
-                                       $sFieldSQL .= " DEFAULT 
$sTranslatedDefault";
+                                       $sFieldSQL .= " DEFAULT 
'$sTranslatedDefault'";
                                }
-                               elseif($sDefault == '0')
+                               elseif($sDefault)
                                {
-                                       $sFieldSQL .= " DEFAULT '0'";
+                                       $sFieldSQL .= " DEFAULT $sDefault";
                                }
                                if($DEBUG) { echo'<br>_GetFieldSQL(): Outgoing 
SQL:   ' . $sFieldSQL; }
                                return true;