CREATE TABLE AsteriskMusicOnHold
(
    name VARCHAR(80) NOT NULL,
    directory VARCHAR(255) NOT NULL DEFAULT "",
    application VARCHAR(255) NOT NULL DEFAULT "",
    mode VARCHAR(80) NOT NULL DEFAULT "",
    digit CHAR(1) NOT NULL DEFAULT "",
    sort VARCHAR(16) NOT NULL DEFAULT "",
    format VARCHAR(16) NOT NULL DEFAULT "",
    PRIMARY KEY ( name )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Music on hold classes ( link with Omnity )";
