CREATE TABLE LCROverseas
(
    VoIPTrunk BIGINT UNSIGNED DEFAULT NULL,
    Prefix VARCHAR(50) 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",
    Priority INT DEFAULT 35000,
    BillingNumber VARCHAR(50) DEFAULT NULL,
    UNIQUE KEY ( VoIPTrunk, Prefix ),
    KEY ( Prefix, VoIPTrunk )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Least cost routing table for non-nanpa numbers";
