 INSERT INTO tender_location (tender_id, location_id) VALUES
 (1, 8),
 (2, 1),
-(2, 2),
-(3, 13),
-(4, 24),
-(5, 7),
-(6, 15),
-(6, 22),
-(7, 4),
-(7, 5),
-(8, 17),
-(8, 18),
-(9, 3),
-(10, 25),
-(11, 6);
+(3, 2),
+(4, 13),
+(5, 24),
+(6, 7),
+(7, 15),
+(8, 22),
+(9, 4),
+(10, 5),
+(11, 17),
+(12, 18),
+(13, 3),
+(14, 25),
+(15, 6),
+(16, 5),
+(17, 17),
+(18, 18),
+(19, 3),
+(20, 3),
+(21, 5),
+(22, 17),
+(23, 18),
+(24, 3),
+(25, 25),
+(26, 6),
+(27, 5),
+(28, 17),
+(29, 18),
+(30, 3),
+(31, 3);
 
 INSERT INTO user_role (user_id, role_id) VALUES
 (1, 2),

('Product', NULL),
('Meat', 7),
('Fish', 7),
('Milk', 7);


INSERT INTO tender (author_id, title, create_date, end_date, status_id, suitable_price, description) VALUES
(1, 'Meal', CURDATE(), CURDATE(), 1, 1000000.00, NULL),
(2, 'Materials', CURDATE(), CURDATE(), 2, 500000.00, NULL),
(3, 'Haus Building', CURDATE(), CURDATE(), 3, 1600000.00, NULL),
(4, 'Cars', CURDATE(), CURDATE(), 2, 9900000.00, NULL),
(5, 'Animals', CURDATE(), CURDATE(), 1, 19000000.00, NULL),
(6, 'Tourism', CURDATE(), CURDATE(), 3, 23000000.00, NULL),
(7, 'Industry', CURDATE(), CURDATE(), 1, 450000.00, NULL),
(8, 'Products', CURDATE(), CURDATE(), 1, 113000000.00, NULL),
(4, 'Building Service', CURDATE(), CURDATE(), 2, 14000000.00, NULL),
(2, 'Furniture', CURDATE(), CURDATE(), 2, 76000000.00, NULL),
(3, 'All in 0ne', CURDATE(), CURDATE(), 2, 59000000.00, NULL);


INSERT INTO proposal (discount_percentage, discount_currency, description, seller_id, tender_id) VALUES

('Cats', 'P', 3),
('Puffin', 'P', 4),
('Ovcharka', 'P', 5),
('Penguins', 'P', 6),
('Juises', 'P', 7),
('Salami', 'P', 8),
('Gold fish', 'P', 9),
('jogurt', 'P', 10),
('Build team', 'S', 1),
('Excavator', 'S', 1),
('Hrejder', 'S', 1),
('Audi-7', 'P', 11),
('BMW', 'P', 11),
('Kia', 'P', 11);


INSERT INTO unit (quantity, measurement_id, item_id, tender_id) VALUES
(500, 1, 10, 9),
(100, 5, 6, 5),
(5300, 5, 11, 5),
(1200, 6, 1, 3),
(2300, 5, 1, 2),
(1000, 1, 8, 1),
(666, 5, 1, 3),
(999, 5, 3, 4),
(1023, 3, 7, 10),
(512, 5, 2, 5),
(500, 8, 12, 11),
(500, 1, 10, 12),
(100, 8, 11, 13),
(5300, 8, 12, 14),
(1200, 5, 14, 15),
(2300, 5, 16, 16),
(1000, 8, 11, 17),
(666, 8, 13, 18),
(999, 3, 7, 19),
(1023, 1, 8, 20),
(512, 1, 9, 21),
(800, 1, 10, 12),
(1400, 8, 11, 13),
(2300, 8, 12, 14),
(5000, 5, 14, 15),
(4300, 5, 16, 16),
(8000, 8, 11, 17),
(766, 8, 13, 18),
(899, 3, 7, 19),
(2023, 1, 8, 20),
(812, 1, 9, 21);

INSERT INTO checked_profile (profile_id, moderator_id, status_id) VALUES
(1,1,1),
