ALTER TABLE `productcategory` ADD `sequence` int(2) NOT NULL DEFAULT 0 AFTER `mageId`, ADD INDEX (`sequence`);

DROP TABLE IF EXISTS `productcategoryimage`;
CREATE TABLE `productcategoryimage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `productcategoryId` int(10) unsigned NOT NULL,
  `imageAssetId` varchar(32) NOT NULL,
  `wooCommerceId` varchar(10),
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `createdById` int(10) unsigned NOT NULL DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedById` int(10) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),
  KEY `productcategoryId` (`productcategoryId`),
  KEY `imageAssetId` (`imageAssetId`),
  KEY `wooCommerceId` (`wooCommerceId`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
