CREATE TABLE TelcoExchanges
(
    exch CHAR(6) NOT NULL,
    rc VARCHAR(50) DEFAULT NULL,
    region CHAR(2) DEFAULT NULL,
    rc_lat DECIMAL(10,6) DEFAULT NULL,
    rc_lon DECIMAL(10,6) DEFAULT NULL,
    udate TIMESTAMP NOT NULL DEFAULT "CURRENT_TIMESTAMP" ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY ( exch )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="NANPA Telco exchanges";
