-- Minimal test table to isolate batch submit (expected_weight, comment).
-- Run: mysql -u root -p bt < migrations/create_data_test_table.sql
-- Or run the SQL in your MySQL client.

CREATE TABLE IF NOT EXISTS `data_test` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `product` varchar(200) NOT NULL,
  `items` varchar(200) NOT NULL,
  `batch_no` varchar(200) NOT NULL,
  `expected_weight` varchar(200) NOT NULL DEFAULT '',
  `actual_weight` varchar(200) NOT NULL,
  `scan_time` varchar(200) NOT NULL,
  `operator` varchar(200) NOT NULL,
  `analyst` varchar(200) NOT NULL,
  `scan_date` varchar(200) DEFAULT NULL,
  `teamLead` varchar(100) DEFAULT NULL,
  `mdn` varchar(200) DEFAULT '',
  `date_manufacturer` varchar(200) DEFAULT NULL,
  `expiry_date` varchar(200) DEFAULT NULL,
  `factory` varchar(5) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
