[Phpgroupware-cvs] phpgwapi/inc class.schema_proc_array.inc.php, 1.2.2.2, 1.2.2.3 class.schema_proc_pgsql.inc.php, 1.5.2.6, 1.5.2.7

[Alejandro Borges (lex) <address@hidden>]

Update of /cvsroot/phpgroupware/phpgwapi/inc
In directory subversions:/tmp/cvs-serv25658/inc

Modified Files:
      Tag: Version-0_9_16-branch
        class.schema_proc_array.inc.php 
        class.schema_proc_pgsql.inc.php 
Log Message:
Fixes upgrade bugs and stuff.... About the upgrade process problems though...we 
discovered that those
happen because of timeouts in php and apache configs. We will further document 
this in the documentation
so that all know. After that, we deem the upgrade process ready for production.


Index: class.schema_proc_array.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc_array.inc.php,v
retrieving revision 1.2.2.2
retrieving revision 1.2.2.3
diff -C2 -d -r1.2.2.2 -r1.2.2.3
*** class.schema_proc_array.inc.php     10 Oct 2003 08:38:29 -0000      1.2.2.2
--- class.schema_proc_array.inc.php     3 Dec 2003 01:26:58 -0000       1.2.2.3
***************
*** 156,160 ****
                        }
  
!                       return Rrue;
                }
  
--- 156,160 ----
                        }
  
!                       return True;
                }
  

Index: class.schema_proc_pgsql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc_pgsql.inc.php,v
retrieving revision 1.5.2.6
retrieving revision 1.5.2.7
diff -C2 -d -r1.5.2.6 -r1.5.2.7
*** class.schema_proc_pgsql.inc.php     1 Nov 2003 22:42:28 -0000       1.5.2.6
--- class.schema_proc_pgsql.inc.php     3 Dec 2003 01:26:58 -0000       1.5.2.7
***************
*** 183,186 ****
--- 183,187 ----
                function GetIXSQL($sFields)
                {
+                       $this->indexes_sql[$sFields] = "CREATE INDEX 
__index_name__ ON __table_name__ USING btree ($sFields)";
                        return '';
                }
***************
*** 634,637 ****
--- 635,639 ----
                {
                        global $DEBUG;
+                       unset($this->indexes_sql);
                        if ($oProc->_GetTableSQL($sTableName, $aTableDef, 
$sTableSQL, $sSequenceSQL))
                        {
***************
*** 644,649 ****
  
                                $query = "CREATE TABLE $sTableName 
($sTableSQL)";
  
!                               return !!($oProc->m_odb->query($query));
                        }
  
--- 646,669 ----
  
                                $query = "CREATE TABLE $sTableName 
($sTableSQL)";
+                               //echo 'sql' .$query . "\n";
  
!                               $result = !!($oProc->m_odb->query($query));
!                               if($result==True)
!                               {
!                                       echo  '<pre>';
!                                       print_r($this->indexes_sql);
!                                       echo '</pre>';
!                                       if(is_array($this->indexes_sql) && 
count($this->indexes_sql)>0)
!                                       {
!                                               foreach($this->indexes_sql as 
$key => $sIndexSQL)
!                                               {
!                                                       $ix_name = 
str_replace(',','_',$key).'_'.$sTableName.'_idx';
!                                                       $IndexSQL = 
str_replace(array('__index_name__','__table_name__'), 
array($ix_name,$sTableName), $sIndexSQL);
!                                                       
$oProc->m_odb->query($IndexSQL);
!                                               }
!                                       }                       
!                               }
!                               return $result;
!                               //return !!($oProc->m_odb->query($query));      
                        
                        }