DROP TABLE IF EXISTS `content_category`;
CREATE TABLE `content_category` (
                                    `id` int NOT NULL AUTO_INCREMENT,
                                    `parent_id` int NOT NULL,
                                    `image_id` int NOT NULL,
                                    `desc` text NOT NULL,
                                    `status` tinyint(1) NOT NULL,
                                    `level` int DEFAULT NULL,
                                    `date_add` datetime NOT NULL,
                                    `date_edit` datetime DEFAULT NULL,
                                    `image` varchar(250) DEFAULT NULL,
                                    `icon` varchar(250) NOT NULL,
                                    `viewed` int NOT NULL,
                                    `shop_id` int NOT NULL DEFAULT '1',
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;