 ('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);
+('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, 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);
-
+(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),

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

INSERT INTO user_role (user_id, role_id) VALUES
(1, 2),

('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
