Show
Ignore:
Timestamp:
07/24/08 21:44:11 (5 years ago)
Author:
mbrevda
Message:

re #2922, update sql order

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • modules/branches/2.5/disa/install.php

    r6168 r6174  
    2323} 
    2424 
    25 //update to 2.5, add hangup 
    26 //  ALTER TABLE `disa` CHANGE `hangup` `hangup` VARCHAR( 10 ) 
    27  
    28 $sql = "SELECT hangup FROM disa"; 
    29 $check = $db->getRow($sql, DB_FETCHMODE_ASSOC); 
    30 if(DB::IsError($check)) { 
    31 $sql = 'ALTER TABLE `disa` CHANGE `hangup` `hangup` VARCHAR( 10 )'; 
    32   $result = $db->query($sql); 
    33   if(DB::IsError($result)) { 
    34     die_freepbx($result->getDebugInfo()); 
    35   } 
    36 } 
    3725   
    3826// Manage upgrade from DISA 1.0 
    …… 
    6048} 
    6149 
     50//update to 2.5, add hangup 
     51//  ALTER TABLE `disa` CHANGE `hangup` `hangup` VARCHAR( 10 ) 
     52 
     53$sql = "SELECT hangup FROM disa"; 
     54$check = $db->getRow($sql, DB_FETCHMODE_ASSOC); 
     55if(DB::IsError($check)) { 
     56$sql = 'ALTER TABLE `disa` CHANGE `hangup` `hangup` VARCHAR( 10 )'; 
     57  $result = $db->query($sql); 
     58  if(DB::IsError($result)) { 
     59    die_freepbx($result->getDebugInfo()); 
     60  } 
     61} 
    6262 
    6363?>