rendered paste bodyglobal $amp_conf;
// my way
$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 ''
)";
global $amp_conf;
if ($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3"))
$sql = "CREATE TABLE IF NOT EXISTS announcement (
announcement_id integer NOT NULL PRIMARY KEY auto
( (($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 ''
)";