All pastes #352174 Raw Edit

Mine

public text v1 · immutable
·published 2007-02-12 17:08 UTC
rendered paste body
global $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 ''
)";