CREATE TABLE LCR
(
    source_id BIGINT UNSIGNED DEFAULT NULL,
    channel VARCHAR(50) DEFAULT NULL COMMENT "First %s is the phone number",
    prefix VARCHAR(35) DEFAULT NULL COMMENT "May include the phone extension",
    rewrite VARCHAR(35) DEFAULT NULL COMMENT "Rewrite with %s",
    cost DECIMAL(10,6) DEFAULT NULL COMMENT "We take the lowest cost for the given channel",
    premium TINYINT DEFAULT 1,
    BestEffort TINYINT DEFAULT 0,
    t38 TINYINT DEFAULT 0,
    priority INT DEFAULT 35000,
    HostedPrice DECIMAL(10,6) DEFAULT NULL,
    BillingNumber VARCHAR(50) DEFAULT NULL,
    KEY ( source_id ),
    UNIQUE KEY source_id_2 ( source_id,prefix ),
    KEY ( prefix )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Least cost routing table";
