[Phpgroupware-cvs] CVS: setup/inc class.schema_proc_mysql.inc.php,1.6,1.7

[Miles Lott <address@hidden>]

Update of /cvsroot/phpgroupware/setup/inc
In directory subversions:/tmp/cvs-serv19957

Modified Files:
        class.schema_proc_mysql.inc.php 
Log Message:
Added patch from Ralf Becker to calculate precision from largest enum value
when doing sql to schema_proc array conversion



Index: class.schema_proc_mysql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/setup/inc/class.schema_proc_mysql.inc.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** class.schema_proc_mysql.inc.php     11 Jan 2002 03:40:59 -0000      1.6
--- class.schema_proc_mysql.inc.php     17 Feb 2002 20:10:29 -0000      1.7
***************
*** 168,172 ****
                                case 'enum':
                                        /* Here comes a nasty assumption */
!                                       $sTranslated =  "'type' => 'varchar', 
'precision' => 255";
                                        break;
                                case 'varchar':
--- 168,173 ----
                                case 'enum':
                                        /* Here comes a nasty assumption */
!                                       /* $sTranslated =  "'type' => 
'varchar', 'precision' => 255"; */
!                                       $sTranslated =  "'type' => 'varchar', 
'precision' => $iPrecision";
                                        break;
                                case 'varchar':
***************
*** 224,228 ****
                                $prec = ereg_replace(')','',$colinfo[1]);
                                $scales = explode(',',$prec);
!                               if ($scales[1])
                                {
                                        $prec  = $scales[0];
--- 225,242 ----
                                $prec = ereg_replace(')','',$colinfo[1]);
                                $scales = explode(',',$prec);
! 
!                               if($colinfo[0] == 'enum')
!                               {
!                                       /* set prec to length of longest 
enum-value */
!                                       for($prec=0; list($nul,$name) = 
@each($scales);)
!                                       {
!                                               if($prec < (strlen($name) - 2))
!                                               {
!                                                       /* -2 as name is like 
"'name'" */
!                                                       $prec = (strlen($name) 
- 2);
!                                               }
!                                       }
!                               }
!                               elseif ($scales[1])
                                {
                                        $prec  = $scales[0];