Untitled

<?phpglobal $db;global $amp_conf;$sql = "CREATE TABLE IF NOT EXISTS announcement (        announcement_id integer NOT NULL PRIMARY KEY" .        ( (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3"))  ? "AUTOINCREMENT":"AUTO_INCREMENT") ."        description VARCHAR( 50 ) ,        recording VARCHAR( 255 ) ,        allow_skip INT,        post_dest VARCHAR( 255 ) ,        return_ivr TINYINT(1) NOT NULL DEFAULT 0,        noanswer TINYINT(1) NOT NULL DEFAULT 0,        repeat VARCHAR(2) NOT NULL DEFAULT '')";// Version 0.3 adds auto-return to IVR$sql = "SELECT return_ivr FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) {        // add new field    $sql = "ALTER TABLE announcement ADD return_ivr TINYINT(1) NOT NULL DEFAULT 0;";    $result = $db->query($sql);    if(DB::IsError($result)) { die($result->getDebugInfo()); }}// Version 0.4 adds auto-return to IVR$sql = "SELECT noanswer FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) {        // add new field    $sql = "ALTER TABLE announcement ADD noanswer TINYINT(1) NOT NULL DEFAULT 0;";    $result = $db->query($sql);    if(DB::IsError($result)) { die($result->getDebugInfo()); }}// Version 0.6 adds repeat$sql = "SELECT repeat FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) {        // add new field    $sql = "ALTER TABLE announcement ADD repeat VARCHAR(2) NOT NULL DEFAULT '';";    $result = $db->query($sql);    if(DB::IsError($result)) { die($result->getDebugInfo()); }}?>