DROP TABLE IF EXISTS `publishers`;
CREATE TABLE `publishers` (
                              `id` int NOT NULL AUTO_INCREMENT,
                              `publisher_id` int NOT NULL,
                              `name` varchar(150) NOT NULL,
                              `description` text NOT NULL,
                              `image` varchar(255) NOT NULL,
                              `seo_url` varchar(250) NOT NULL,
                              `xml_id` varchar(100) NOT NULL,
                              `status` tinyint(1) NOT NULL DEFAULT '0',
                              `admin_status` tinyint(1) NOT NULL DEFAULT '0',
                              `delete_status` tinyint(1) NOT NULL DEFAULT '0',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;