 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),

('Cats', 'P', 3),
('Puffin', 'P', 4),
('Ovcharka', 'P', 5),
('Penguins', 'S', 6),
('Juises', 'S', 7),
('Salami', 'S', 8),
('Gold fish', 'S', 9),
('jogurt', 'S', 10),
('Dolmantin', 'S', 5);


INSERT INTO unit (quantity, measurement_id, item_id, tender_id) VALUES
(500, 1, 10, 9),
(100, 2, 9, 5),
(5300, 3, 8, 5),
(1200, 4, 7, 3),
(2300, 5, 6, 2),
(1000, 6, 5, 1),
(666, 3, 4, 3),
(999, 1, 3, 4),
(1023, 4, 2, 10),
(512, 3, 1, 5);


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

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


INSERT INTO tender (author_id, title, create_date, end_date, status_id, suitable_price, description) VALUES
(1, 'Meal', '2014-06-10', '2014-07-10', 1, 1000000.00, NULL),
(2, 'Materials', CURDATE(), '2014-06-03', 2, 500000.00, NULL),
(3, 'Haus Building', '2014-04-10', CURDATE(), 3, 1600000.00, NULL),
(4, 'Animals', CURDATE(), '2014-06-04', 2, 9900000.00, NULL),
(5, 'Animals', '2014-06-08', '2014-06-18', 1, 19000000.00, NULL),
(6, 'Tourism', '2014-04-12', CURDATE(), 3, 23000000.00, NULL),
(7, 'Industry', '2014-06-07', '2014-06-28', 1, 450000.00, NULL),
(8, 'Products', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Products', CURDATE(),'2014-06-15', 2, 14000000.00, NULL),
(2, 'Products', CURDATE(), '2014-06-18', 2, 76000000.00, NULL),
(3, 'All in 0ne', CURDATE(), '2014-06-22', 2, 59000000.00, NULL),
(1, 'Products', '2014-06-10', '2014-06-25', 1, 1000000.00, NULL),
(2, 'Need workers', '2014-05-11', '2014-06-16', 2, 500000.00, NULL),
(3, 'Haus Building', '2014-04-25', CURDATE(), 3, 1600000.00, NULL),
(4, 'Cars', CURDATE(), '2014-06-22', 2, 9900000.00, NULL),
(5, 'Cars', '2014-06-09', '2014-06-19', 1, 19000000.00, NULL),
(6, 'Haus Building', '2014-04-12', '2014-06-11', 2, 23000000.00, NULL),
(7, 'Industry', '2014-06-07', '2014-06-28', 1, 450000.00, NULL),
(8, 'Products', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Products', CURDATE(),'2014-06-15', 2, 14000000.00, NULL),
(2, 'Products', CURDATE(), '2014-06-18', 2, 76000000.00, NULL),
(1, 'Products', '2014-06-10', '2014-06-25', 1, 1000000.00, NULL),
(2, 'Need workers', '2014-05-11', '2014-06-16', 2, 500000.00, NULL),
(3, 'Haus Building', '2014-04-25', CURDATE(), 3, 1600000.00, NULL),
(4, 'Cars', CURDATE(), '2014-06-22', 2, 9900000.00, NULL),
(5, 'Cars', '2014-06-09', '2014-06-19', 1, 19000000.00, NULL),
(6, 'Haus Building', '2014-04-12', '2014-06-11', 2, 23000000.00, NULL),
(7, 'Industry', '2014-06-07', '2014-06-28', 1, 450000.00, NULL),
(8, 'Products', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Products', CURDATE(),'2014-06-15', 2, 14000000.00, NULL),
(2, 'Products', CURDATE(), '2014-06-18', 2, 76000000.00, NULL);



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