asterisk queues postgresql create script

gistfile1.txt

CREATE TABLE asterisk_queue (
    name VARCHAR(128) NOT NULL,
    musiconhold VARCHAR(128),
    announce VARCHAR(128),
    context VARCHAR(128),
    timeout INTEGER,
    ringinuse VARCHAR(3),
    setinterfacevar VARCHAR(3),
    setqueuevar VARCHAR(3),
    setqueueentryvar VARCHAR(3),
    monitor_format VARCHAR(8),
    membermacro VARCHAR(512),
    membergosub VARCHAR(512),
    queue_youarenext VARCHAR(128),
    queue_thereare VARCHAR(128),
    queue_callswaiting VARCHAR(128),
    queue_quantity1 VARCHAR(128),
    queue_quantity2 VARCHAR(128),
    queue_holdtime VARCHAR(128),
    queue_minutes VARCHAR(128),
    queue_minute VARCHAR(128),
    queue_seconds VARCHAR(128),
    queue_thankyou VARCHAR(128),
    queue_callerannounce VARCHAR(128),
    queue_reporthold VARCHAR(128),
    announce_frequency INTEGER,
    announce_to_first_user VARCHAR(3),
    min_announce_frequency INTEGER,
    announce_round_seconds INTEGER,
    announce_holdtime VARCHAR(128),
    announce_position VARCHAR(128),
    announce_position_limit INTEGER,
    periodic_announce VARCHAR(50),
    periodic_announce_frequency INTEGER,
    relative_periodic_announce VARCHAR(3),
    random_periodic_announce VARCHAR(3),
    retry INTEGER,
    wrapuptime INTEGER,
    penaltymemberslimit INTEGER,
    autofill VARCHAR(3),
    monitor_type VARCHAR(128),
    autopause VARCHAR(3),
    autopausedelay INTEGER,
    autopausebusy VARCHAR(3),
    autopauseunavail VARCHAR(3),
    maxlen INTEGER,
    servicelevel INTEGER,
    strategy VARCHAR(16),
    joinempty VARCHAR(128),
    leavewhenempty VARCHAR(128),
    reportholdtime VARCHAR(3),
    memberdelay INTEGER,
    weight INTEGER,
    timeoutrestart VARCHAR(3),
    defaultrule VARCHAR(128),
    timeoutpriority VARCHAR(128),
    PRIMARY KEY (name)
);

CREATE TABLE asterisk_queue_member (
    queue_name VARCHAR(80) NOT NULL,
    interface VARCHAR(80) NOT NULL,
    uniqueid VARCHAR(80) NOT NULL,
    membername VARCHAR(80),
    state_interface VARCHAR(80),
    penalty INTEGER,
    paused INTEGER,
    PRIMARY KEY (queue_name, interface)
);
CREATE TABLE asterisk_queue_rule (
    rule_name VARCHAR(80) NOT NULL,
    time VARCHAR(32) NOT NULL,
    min_penalty VARCHAR(32) NOT NULL,
    max_penalty VARCHAR(32) NOT NULL
);

CREATE TABLE "asterisk_queue_log" (
"id" SERIAL,
"time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL,
"callid" character varying(50) NOT NULL,
"queuename" character varying(50) NOT NULL,
"agent" character varying(50) NOT NULL,
"event" character varying(20) NOT NULL,
"data"  varchar(100) NOT NULL DEFAULT '',
"data1" character varying(50) NOT NULL default '',
"data2" character varying(50) NOT NULL default '',
"data3" character varying(50) NOT NULL default '',
"data4" character varying(50) NOT NULL default '',
"data5" character varying(50) NOT NULL default '',
CONSTRAINT queue_log_pkey PRIMARY KEY (id)
);

CREATE INDEX queue_idx ON asterisk_queue_log (queuename);
CREATE INDEX event_idx ON asterisk_queue_log (event);

GRANT ALL ON asterisk_queue_log TO asterisk;
GRANT ALL ON asterisk_queue_log_id_seq  TO asterisk;