

INSERT INTO offers (code,user_id,status,salutation,language,approx_volume_m3,excl_boxes_m3,recommended_total_m3,move_date,move_start,postal_from,postal_to,payment_method,compensation_eur,winner_flag,last_updated_at)
VALUES
('3609',1,'accepted','Mister','en',7.6,6,17,'2025-06-28','08:00:00','10551','10557','Prepayment',363.00,1,'2025-06-04 04:42:32'),
('3645',1,'accepted','Mister','en',NULL,6,NULL,'2025-06-04','08:00:00','10405','13359','Prepayment',331.32,1,'2025-06-04 04:40:00'),
('3626',1,'accepted','Mister','en',NULL,6,NULL,'2025-05-31','08:00:00','10557','10557','Prepayment',428.00,1,'2025-05-31 12:00:00'),
('3585',1,'accepted','Mister','en',NULL,6,NULL,'2025-05-30','08:00:00','20255','10969','Prepayment',619.00,1,'2025-05-30 12:00:00'),
('3568',1,'accepted','Mister','en',13.6,6,24.5,'2025-05-24','08:00:00','13509','10117','Prepayment',357.00,1,'2025-05-15 16:54:35');

INSERT INTO invoices (invoice_no,user_id,offer_id,email,amount_eur,date,pdf_path) VALUES
('MA-GS-P-972-005/25',1,1,'mustafa@ongee.de',363.00,'2025-06-29',NULL),
('MA-GS-P-972-004/25',1,2,'mustafa@ongee.de',331.32,'2025-06-05',NULL),
('MA-GS-P-972-003/25',1,3,'mustafa@ongee.de',428.00,'2025-06-01',NULL),
('MA-GS-P-972-002/25',1,4,'mustafa@ongee.de',619.00,'2025-05-31',NULL),
('MA-GS-P-972-001/25',1,5,'mustafa@ongee.de',357.00,'2025-05-25',NULL);

INSERT INTO penalties (user_id, points, reason) VALUES (1, -0.50, 'Adjustment');
