CREATE TABLE `productcategoryebaymapping` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `productCategoryId` int(10) unsigned NOT NULL DEFAULT 0,
    `ebayCategoryId` int(10) unsigned NOT NULL DEFAULT 0,
    `name` varchar(100) NOT NULL DEFAULT '',
    `namePath` varchar(255) NOT NULL DEFAULT '',
    `requiredAspects` json NULL,
    `active` tinyint(1) NOT NULL DEFAULT '1',
    `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `createdById` int unsigned NOT NULL DEFAULT '0',
    `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updatedById` int unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `createdById` (`createdById`),
    KEY `updatedById` (`updatedById`),
    KEY `productCategoryId` (`productCategoryId`),
    KEY `ebayCategoryId` (`ebayCategoryId`),
    KEY `name` (`name`),
    KEY `namePath` (`namePath`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
