CREATE TABLE ResellerPriceList
(
    Item BIGINT UNSIGNED NOT NULL,
    Zone BIGINT UNSIGNED NOT NULL,
    Price DECIMAL(7,2) NOT NULL,
    PRIMARY KEY ( Item,Zone )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Modified price list by customer";
