CREATE TABLE TiberDM.CategoryDim (
    id                  MEDIUMINT   NOT NULL AUTO_INCREMENT,
    categoryName        Varchar(1024)  NOT NULL,
    parentCategoryId    MEDIUMINT   NULL,
    PRIMARY KEY (id)
);

Create Unique Index CategoryDim_Uidx01
On TiberDM.CategoryDim (categoryName, parentCategoryId);
;

