<?php

global $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()); }
}

?>