Witam. Nie wiem czy o to chodziło:
CREATE TABLE `reports_2023` (
`id` smallint(6) NOT NULL,
`filling_date` date NOT NULL,
`uid` text NOT NULL,
`po` text NOT NULL,
`syrup_lot` text NOT NULL,
`filled_bottles` text NOT NULL,
`filling_start_time` text NOT NULL,
`filling_finish_time` text NOT NULL,
`average_weight` text NOT NULL,
`line_run_rate` text NOT NULL,
`line_availability` text NOT NULL,
`line_number` text NOT NULL,
`waste_price` text NOT NULL,
`waste_number` text NOT NULL,
`line_downtime` text NOT NULL,
`filling_time` text NOT NULL,
`nominal_weight` text NOT NULL,
`planned_bottles` text NOT NULL,
`real_bottles` text NOT NULL,
`planned_litres` text NOT NULL,
`real_litres` text NOT NULL,
`planned_filling_time` text NOT NULL,
`bottle_size` text NOT NULL,
`box_size` text NOT NULL,
`syrup_name` text NOT NULL,
`packed_bottles` text NOT NULL,
`product_lot` text NOT NULL,
`live_filled` text NOT NULL,
`live_date` date NOT NULL,
`is_trial` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `reports_2023`
--
INSERT INTO `reports_2023` (`id`, `filling_date`, `uid`, `po`, `syrup_lot`, `filled_bottles`, `filling_start_time`, `filling_finish_time`, `average_weight`, `line_run_rate`, `line_availability`, `line_number`, `waste_price`, `waste_number`, `line_downtime`, `filling_time`, `nominal_weight`, `planned_bottles`, `real_bottles`, `planned_litres`, `real_litres`, `planned_filling_time`, `bottle_size`, `box_size`, `syrup_name`, `packed_bottles`, `product_lot`, `live_filled`, `live_date`, `is_trial`) VALUES
(16, '2023-01-06', '4020-B500-6-UK', '00813', '007', '28226', '06:00', '09:20', '610.98', '8000', '450', '1', '265', 'waste', '22', '190', '610.0', '25366', '25873.32', '12936.66', '12936.66', '212', '50', '6', '4020 Elderflower Cordial 6x500ml', '28176', '006-007/2023', '', '2023-01-06', ''),
(17, '2023-01-06', '4001-B500-6-AU', '00807', '005', '10242', '09:45', '12:30', '601.4', '8000', '450', '1', '265', 'waste', '-48', '125', '601.0', '10254', '20398', '10198.98', '10198.98', '77', '50', '6', '4001 Elderflower and Rose Cordial 6x500ml', '10242', '006-005/2023', '', '2023-01-06', ''),
(18, '2023-01-06', '4001-B500-6-US', '00807', '005', '756', '09:45', '12:30', '601.4', '8000', '450', '1', '265', 'waste', '-129', '135', '601.0', '756', '20398', '10198.98', '10198.98', '6', '50', '6', '4001 Elderflower and Rose Cordial 6x500ml', '756', '006-005/2023', '', '2023-01-06', ''),
(19, '2023-01-06', '4001-B500-6-UK', '00807', '005', '9503', '09:45', '12:30', '601.4', '8000', '450', '1', '265', 'waste', '-54', '125', '601.0', '8988', '20398', '10198.98', '10198.98', '71', '50', '6', '4001 Elderflower and Rose Cordial 6x500ml', '9438', '006-005/2023', '', '2023-01-06', '');
--
ALTER TABLE `reports_2023`
ADD PRIMARY KEY (`id`);
ALTER TABLE `reports_2023`
MODIFY `id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
COMMIT;