root/freepbx/trunk/upgrades/2.1beta1/tables.php

<?php

// Add default TONEZONE of 'us' if no TONEZONE exists already
$sql = "SELECT value FROM globals WHERE variable = 'TONEZONE' ";
$tz = $db->getRow($sql, DB_FETCHMODE_ASSOC);
if (!is_array($tz)) { // does not exist already
        // Default to 'us'
        $sql = "INSERT INTO globals (variable, value) VALUES ('TONEZONE', 'us') ";
        $result = $db->query($sql);
        if(DB::IsError($result)) {
                die($result->getDebugInfo());
        }
}

// Add column 'channel' to incoming routing
$sql = "SELECT channel FROM incoming";
$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);
if(DB::IsError($check)) {
        $sql = "ALTER TABLE incoming ADD channel VARCHAR( 20 ) DEFAULT \"\"";
        $result = $db->query($sql);
        if(DB::IsError($result)) {
                die($result->getDebugInfo());
        }
}

// Add default ALLOW_SIP_ANON of 'no' if no ALLOW_SIP_ANON exists already
$sql = "SELECT value FROM globals WHERE variable = 'ALLOW_SIP_ANON' ";
$asa = $db->getRow($sql, DB_FETCHMODE_ASSOC);
if (!is_array($asa)) { // does not exist already
        // Default to 'no'
        $sql = "INSERT INTO globals (variable, value) VALUES ('ALLOW_SIP_ANON', 'no') ";
        $result = $db->query($sql);
        if(DB::IsError($result)) {
                die($result->getDebugInfo());
        }
}

?>