DROP TABLE IF EXISTS `blog_list`;
CREATE TABLE `blog_list` (
                             `id` int NOT NULL AUTO_INCREMENT,
                             `title` text NOT NULL,
                             `category_id` int NOT NULL,
                             `author_id` int NOT NULL,
                             `image_id` int NOT NULL,
                             `desc` text NOT NULL,
                             `image` varchar(150) DEFAULT NULL,
                             `api_image` varchar(150) DEFAULT NULL,
                             `status` tinyint(1) NOT NULL,
                             `sort` int NOT NULL,
                             `viewed` int NOT NULL,
                             `date_added` datetime NOT NULL,
                             `date_edit` datetime DEFAULT NULL,
                             `shop_id` int NOT NULL DEFAULT '1',
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;