DROP TABLE IF EXISTS `product_list`;
CREATE TABLE `product_list` (
                                `id` int NOT NULL AUTO_INCREMENT,
                                `barcode` varchar(50) DEFAULT NULL,
                                `barcode1` varchar(15) DEFAULT NULL,
                                `barcode2` varchar(15) DEFAULT NULL,
                                `barcode3` varchar(15) DEFAULT NULL,
                                `barcode4` varchar(15) DEFAULT NULL,
                                `sample_book_code` varchar(50) DEFAULT NULL,
                                `code` varchar(30) DEFAULT NULL,
                                `supplier_code` varchar(150) DEFAULT NULL,
                                `category_id` int DEFAULT NULL,
                                `desc` text,
                                `image` varchar(150) DEFAULT NULL,
                                `api_image` varchar(150) DEFAULT NULL,
                                `location` varchar(150) DEFAULT NULL,
                                `options` text,
                                `details` text,
                                `categories` text,
                                `status` tinyint(1) DEFAULT NULL,
                                `sort` int DEFAULT NULL,
                                `date_added` datetime DEFAULT NULL,
                                `date_edit` datetime DEFAULT NULL,
                                `price` decimal(15,4) DEFAULT '0.0000',
                                `currency_id` int DEFAULT NULL,
                                `currency_code` varchar(5) DEFAULT NULL,
                                `brand_id` int DEFAULT NULL,
                                `supply_id` int DEFAULT NULL,
                                `viewed` int DEFAULT NULL,
                                `tax_id` int DEFAULT NULL,
                                `buying_price` decimal(15,4) DEFAULT NULL,
                                `dealer_price` decimal(15,4) DEFAULT NULL,
                                `sales_price` decimal(15,4) DEFAULT NULL,
                                `xml_id` varchar(155) DEFAULT NULL,
                                `is_options` tinyint(1) DEFAULT '0',
                                `shop_id` int DEFAULT NULL,
                                `author_id` int DEFAULT NULL,
                                `bookstore_id` int DEFAULT NULL,
                                `product_type` varchar(50) DEFAULT NULL,
                                `language` varchar(100) DEFAULT NULL,
                                `page_count` int DEFAULT NULL,
                                `unit` varchar(15) DEFAULT 'piece' COMMENT 'piece(Adet),pack(Paket),set,box(kutu)',
                                `min_stock` int DEFAULT NULL,
                                `is_new` tinyint(1) DEFAULT '0',
                                `is_bestseller` tinyint(1) DEFAULT '0',
                                `is_special` tinyint(1) DEFAULT '0',
                                `is_print` tinyint(1) DEFAULT '0',
                                `is_sales` tinyint(1) DEFAULT '0',
                                `is_reseller` tinyint(1) DEFAULT '0',
                                `class_id` int DEFAULT NULL,
                                `lesson_id` int DEFAULT NULL,
                                `type_id` int DEFAULT NULL,
                                `translate` varchar(100) DEFAULT NULL,
                                `redaction` varchar(100) DEFAULT NULL,
                                `director` varchar(100) DEFAULT NULL,
                                `editor` varchar(100) DEFAULT NULL,
                                `prepared` varchar(100) DEFAULT NULL,
                                `picture` varchar(100) DEFAULT NULL,
                                `cover_type_id` int DEFAULT NULL,
                                `page_type_id` int DEFAULT NULL,
                                `child_year_id` int DEFAULT NULL,
                                `print_count` int DEFAULT NULL,
                                `weight` decimal(15,2) DEFAULT NULL,
                                `desi` int DEFAULT NULL,
                                `width` float DEFAULT NULL,
                                `height` float DEFAULT NULL,
                                `length` float DEFAULT NULL,
                                `create_date` datetime DEFAULT NULL,
                                `print_date` datetime DEFAULT NULL,
                                `ship_date` datetime DEFAULT NULL,
                                `pre_order_date` datetime DEFAULT NULL,
                                `user_id` int DEFAULT '0',
                                `package_start` date DEFAULT NULL,
                                `package_end` date DEFAULT NULL,
                                `min_critic_stock` int DEFAULT NULL,
                                `max_critic_stock` int DEFAULT NULL,
                                `trash` tinyint(1) DEFAULT '0',
                                `unit_count` int DEFAULT '1',
                                `blur` tinyint DEFAULT '0',
                                PRIMARY KEY (`id`),
                                KEY `publisher_id` (`brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;