CREATE TABLE CustomerDispatch
(
    Customer BIGINT UNSIGNED DEFAULT NULL,
    Name VARCHAR(50) DEFAULT NULL,
    Dispatcher BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( Customer ),
    KEY ( Name ),
    FOREIGN KEY ( Customer ) REFERENCES Zone ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Customer dispatch ids for kamailio dispatcher";
