CREATE TABLE Clients__Compiled
(
    Client BIGINT UNSIGNED NOT NULL,
    Module BIGINT UNSIGNED NOT NULL,
    Quantity INT UNSIGNED NOT NULL,
    PRIMARY KEY ( Client,Module ),
    FOREIGN KEY ( Client ) REFERENCES Zone ( id) ON DELETE CASCADE ON UPDATE CASCADE,
    FOREIGN KEY ( Module ) REFERENCES Module ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Number of modules allowed to each customer";
