CREATE TABLE DID2Zone
(
    DID VARCHAR(15) DEFAULT NULL,
    Node BIGINT UNSIGNED DEFAULT NULL,
    Zone VARCHAR(50) DEFAULT NULL,
    ChannelUse VARCHAR(20) DEFAULT NULL,
    Dispatch BIGINT UNSIGNED DEFAULT NULL,
    Provider BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( DID ),
    FOREIGN KEY ( Node ) REFERENCES nodes ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Zones by DID ( needed for kamailio dispatcher )";
