DROP TABLE IF EXISTS `product_brand`;
CREATE TABLE `product_brand` (
                                 `id` int NOT NULL AUTO_INCREMENT,
                                 `name` varchar(100) NOT NULL,
                                 `desc` text NOT NULL,
                                 `status` tinyint(1) NOT NULL,
                                 `date_added` datetime NOT NULL,
                                 `date_edit` datetime NOT NULL,
                                 `shop_id` int NOT NULL DEFAULT '1',
                                 `xml_id` varchar(55) NOT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;