-- migrate:up
CREATE TABLE `transfer_bandung_record` (
  `id` int NOT NULL AUTO_INCREMENT,
  `part_number` varchar(255) NOT NULL,
  `quantity` int NOT NULL,
  `transfer_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=542 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- migrate:down
DROP TABLE IF EXISTS online_products_bandung;