DROP TABLE IF EXISTS `product_stock_history`;
CREATE TABLE `product_stock_history` (
                                         `id` int NOT NULL AUTO_INCREMENT,
                                         `product_list_id` int NOT NULL,
                                         `invoice_no` varchar(150) DEFAULT NULL,
                                         `customer_id` int DEFAULT NULL,
                                         `user_id` int DEFAULT NULL,
                                         `price` decimal(15,4) DEFAULT NULL,
                                         `quantity` int DEFAULT '0',
                                         `description` text,
                                         `warehouse_id` int DEFAULT NULL,
                                         `shelf_id` int DEFAULT NULL,
                                         `stock_type` enum('G','Ç') DEFAULT NULL COMMENT 'G-Giriş, Ç-Çıkış',
                                         `insert_date` datetime DEFAULT CURRENT_TIMESTAMP,
                                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;