<commit_before>USE tender;

INSERT INTO checked_status (name) VALUES
('Open'),
('In progress'),
('Checked'),
('Denied');


INSERT INTO tender_status (name) VALUES
('Open'),
('In progress'),
('Close');


INSERT INTO conflict_status (name) VALUE
('Open'),
('In progress'),
('resolved');


INSERT INTO role (name) VALUES
('admin'),
('moderator'),
('seller'),
('customer');


INSERT INTO measurement (name) VALUES
('Kg'),
('Km'),
('Liter'),
('Box'),
('Unit'),
('Ton'),
('Sm'),
('Humen/Hour');


INSERT INTO address (city, street, building_number, postcode) VALUES 
('Vilnohirsk', 'Stepova', 1, 27500),
('Drohobych', 'Khmelnitsky', 5, 29000),
('Kiev', 'Moskovska', 21, 01015),
('Nizhyn', 'Vosstaniya', 8, 16500),
('Dnipropetrovsk', 'Yuzhnaya', 12, 22300),
('Donetsk', 'Dzerzhinsky', 14, 12500),
('Kiev', 'Solomenskaya', 21, 26600),
('Odessa', 'Bunin', 32, 24500),
('Simferopol', 'Timoshenko', 55, 23300),
('Kiev', '<NAME>', 7, 07500),
('Kiev', '<NAME>', 9, 12500),
('Alchevsk', 'Moskovskaya', 34, 32500),
('Novoukrayinka', '<NAME>', 55, 21500),
('Lviv', 'Kravchenko', 2, 26600),
('Odessa', 'Bugaevskaya', 3, 25600);


INSERT INTO company (name, srn, email, logo, address_id) VALUES 
('Vilnohirsk Mining Metallurgical Plant', 121345, '<EMAIL>', null, 1),
('<NAME>', 122345, '<EMAIL>', null, 2),
('Econom-servis Gp CffInfo', 123345, '<EMAIL>', null, 3),
('Epcf Syaivo LtdInfo', 124345, '<EMAIL>', null, 4),
('Planet Service', 125345, '<EMAIL>', null, 5),
('Global Titan Distribution Inc', 126345, '<EMAIL>', null, 6),
('Sea Electronics', 127345, '<EMAIL>', null, 7),
('Kaalbye Logistics Ltd', 128345, '<EMAIL>', null, 8),
('Energy Xxii', 129345, '<EMAIL>', null, 9),
('Eurocom Components', 120345, '<EMAIL>', null, 10),
('Natural Foods', 102345, '<EMAIL>', null, 11),
('<NAME>', 112345, '<EMAIL>', null, 12),
('Polymercontainer Plant', 122345, '<EMAIL>', null, 13),
('Xado Corp', 132345, '<EMAIL>', null, 14),
('Garbuz Studio', 142345, '<EMAIL>', null, 15);


INSERT INTO user (login, password, create_date) VALUES
('<EMAIL>','arlekin',CURDATE()),
('<EMAIL>','<PASSWORD>',CURDATE()),
('<EMAIL>','pupkin',CURDATE()),
('<EMAIL>','dver88',CURDATE()),
('<EMAIL>','<PASSWORD>',CURDATE()),
('<EMAIL>','ole4ka',CURDATE()),
('<EMAIL>','123qwerty',CURDATE()),
('<EMAIL>','vasa567',CURDATE());


INSERT INTO profile (icon, first_name, last_name, birthday, telephone, checked, person, user_id, company_id) VALUES 
(null, 'Ivan', 'Nesamay', '1986-05-28', '55-559-5', false, 'L', 1, 1),
(null, 'Vasja', 'Pupkin', '1966-02-18', '55-559-5', false, 'L', 2, 2),
(null, 'Kolja', 'Qwerty', '1996-01-02', '55-559-5', false, 'L', 3, 3),
(null, 'Olja', 'Semenova', '1984-07-09', '55-559-5', false, 'L', 4, 4),
(null, 'Katja', 'Moros', '1985-07-08', '55-559-5', false, 'L', 5, 5),
(null, 'Nasar', 'Havruliv', '1976-06-08', '55-559-5', false, 'L', 6, 6),
(null, 'Vasul', 'Sobol', '1989-02-02', '55-559-5', false, 'L', 7, 7),
(null, 'Oksana', 'Sobol', '1983-08-01', '55-559-5', false, 'L', 8, 8);


INSERT INTO location (name) VALUES 
('Autonomous Republic of Crimea'),
('Cherkasy Region'),
('Chernihiv Region'), 
('Chernivtski Region'), 
('Dnipropetrovsk Region'), 
('Donetsk Region'),
('Ivano-Frankivsk Region'),
('Kharkiv Region'),
('Kherson Region'), 
('Khmelnytsky Region'),
('Kirovograd Region'),
('Kyiv Region'),
('Luhansk Region'),
('Lviv Region'),
('Mykolayiv Region'),
('Odesa Region'),
('Poltava Region'),
('Rivne Region'),
('Sumy Region'),
('Ternopil Region'),
('Vinnytsya Region'),
('Volyn region'),
('Zakarpattya Region'),
('Zaporizhzhya Region'),
('Zhytomyr Region');


INSERT INTO deal_status (name) VALUES 
('open'),
('in progress'),
('close');


INSERT INTO category (name, parent) VALUES
('Building', NULL),
('Animals', NULL),
('Pet', 2),
('Exotic', 2),
('Dogs', 3),
('Birds', 3),
('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
(10, null, 'If you wil take all', 1, 10),
(20, null, null, 1, 9),
(30, null, 'and free delivery', 2, 8),
(50, null, null, 3, 7),
(null, 10000.00, null, 4, 6),
(null, 5000.00, null, 5, 5),
(null, 8000.00, null, 6, 4),
(null, 1400.00, null, 7, 3),
(null, 1500.00, null, 8, 2),
(null, 500.00, null, 4, 1),
(null, 5000.00, null, 1, 7);


INSERT INTO item (name, type, category_id) VALUES
('Rocks', 'P', 1),
('Dogs', 'P', 2),
('Cats', 'P', 3),
('Puffin', 'P', 4),
('Ovcharka', 'P', 5),
('Penguins', 'P', 6),
('Juises', 'P', 7),<commit_msg>fixed allTables.sql<commit_after>USE tender;

INSERT INTO checked_status (name) VALUES
('Open'),
('In progress'),
('Checked'),
('Denied');


INSERT INTO tender_status (name) VALUES
('Open'),
('In progress'),
('Close');


INSERT INTO conflict_status (name) VALUE
('Open'),
('In progress'),
('resolved');


INSERT INTO role (name) VALUES
('admin'),
('moderator'),
('seller'),
('customer');


INSERT INTO measurement (name) VALUES
('Kg'),
('Km'),
('Liter'),
('Box'),
('Unit'),
('Ton'),
('Sm'),
('Humen/Hour');


INSERT INTO address (city, street, building_number, postcode) VALUES 
('Vilnohirsk', 'Stepova', 1, 27500),
('Drohobych', 'Khmelnitsky', 5, 29000),
('Kiev', 'Moskovska', 21, 01015),
('Nizhyn', 'Vosstaniya', 8, 16500),
('Dnipropetrovsk', 'Yuzhnaya', 12, 22300),
('Donetsk', 'Dzerzhinsky', 14, 12500),
('Kiev', 'Solomenskaya', 21, 26600),
('Odessa', 'Bunin', 32, 24500),
('Simferopol', 'Timoshenko', 55, 23300),
('Kiev', '<NAME>', 7, 07500),
('Kiev', '<NAME>', 9, 12500),
('Alchevsk', 'Moskovskaya', 34, 32500),
('Novoukrayinka', '<NAME>', 55, 21500),
('Lviv', 'Kravchenko', 2, 26600),
('Odessa', 'Bugaevskaya', 3, 25600);


INSERT INTO company (name, srn, email, logo, address_id) VALUES 
('Vilnohirsk Mining Metallurgical Plant', 121345, '<EMAIL>', null, 1),
('<NAME>', 122345, '<EMAIL>', null, 2),
('Econom-servis Gp CffInfo', 123345, '<EMAIL>', null, 3),
('Epcf Syaivo LtdInfo', 124345, '<EMAIL>', null, 4),
('Planet Service', 125345, '<EMAIL>', null, 5),
('Global Titan Distribution Inc', 126345, '<EMAIL>', null, 6),
('Sea Electronics', 127345, '<EMAIL>', null, 7),
('Kaalbye Logistics Ltd', 128345, '<EMAIL>', null, 8),
('Energy Xxii', 129345, '<EMAIL>', null, 9),
('Eurocom Components', 120345, '<EMAIL>', null, 10),
('Natural Foods', 102345, '<EMAIL>', null, 11),
('<NAME>', 112345, '<EMAIL>', null, 12),
('Polymercontainer Plant', 122345, '<EMAIL>', null, 13),
('Xado Corp', 132345, '<EMAIL>', null, 14),
('Garbuz Studio', 142345, '<EMAIL>', null, 15);


INSERT INTO user (login, password, create_date) VALUES
('<EMAIL>','arlekin',CURDATE()),
('<EMAIL>','<PASSWORD>',CURDATE()),
('<EMAIL>','pupkin',CURDATE()),
('<EMAIL>','<PASSWORD>',CURDATE()),
('<EMAIL>','<PASSWORD>',CURDATE()),
('<EMAIL>','ole4ka',CURDATE()),
('<EMAIL>','123qwerty',CURDATE()),
('<EMAIL>','vasa567',CURDATE());


INSERT INTO profile (icon, first_name, last_name, birthday, telephone, checked, person, user_id, company_id) VALUES 
(null, 'Ivan', 'Nesamay', '1986-05-28', '55-559-5', false, 'L', 1, 1),
(null, 'Vasja', 'Pupkin', '1966-02-18', '55-559-5', false, 'L', 2, 2),
(null, 'Kolja', 'Qwerty', '1996-01-02', '55-559-5', false, 'L', 3, 3),
(null, 'Olja', 'Semenova', '1984-07-09', '55-559-5', false, 'L', 4, 4),
(null, 'Katja', 'Moros', '1985-07-08', '55-559-5', false, 'L', 5, 5),
(null, 'Nasar', 'Havruliv', '1976-06-08', '55-559-5', false, 'L', 6, 6),
(null, 'Vasul', 'Sobol', '1989-02-02', '55-559-5', false, 'L', 7, 7),
(null, 'Oksana', 'Sobol', '1983-08-01', '55-559-5', false, 'L', 8, 8);


INSERT INTO location (name) VALUES 
('Autonomous Republic of Crimea'),
('Cherkasy Region'),
('Chernihiv Region'), 
('Chernivtski Region'), 
('Dnipropetrovsk Region'), 
('Donetsk Region'),
('Ivano-Frankivsk Region'),
('Kharkiv Region'),
('Kherson Region'), 
('Khmelnytsky Region'),
('Kirovograd Region'),
('Kyiv Region'),
('Luhansk Region'),
('Lviv Region'),
('Mykolayiv Region'),
('Odesa Region'),
('Poltava Region'),
('Rivne Region'),
('Sumy Region'),
('Ternopil Region'),
('Vinnytsya Region'),
('Volyn region'),
('Zakarpattya Region'),
('Zaporizhzhya Region'),
('Zhytomyr Region');


INSERT INTO deal_status (name) VALUES 
('open'),
('in progress'),
('close');


INSERT INTO category (name, parent) VALUES
('Building', NULL),
('Animals', NULL),
('Pet', 2),
('Exotic', 2),
('Dogs', 3),
('Birds', 3),
('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, 'I want buy 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, 'Need animals', CURDATE(), '2014-06-04', 2, 9900000.00, NULL),
(5, 'Animals', '2014-05-28', '2014-06-18', 2, 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, 'Need products', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Products', CURDATE(),'2014-06-15', 2, 14000000.00, NULL),
(2, 'I want buy products', CURDATE(), '2014-06-18', 2, 76000000.00, NULL),
(3, 'All in one', CURDATE(), '2014-06-22', 2, 59000000.00, NULL),
(1, 'Products', '2014-06-10', '2014-06-25', 1, 1000000.00, NULL),
(2, 'Need workers for build haus', '2014-05-11', '2014-06-16', 2, 500000.00, NULL),
(3, '<NAME> ', '2014-04-25', CURDATE(), 3, 1600000.00, NULL),
(4, 'Need cars for big firm', CURDATE(), '2014-06-22', 2, 9900000.00, NULL),
(5, 'Cars for my firm', '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 and building', '2014-06-07', '2014-06-28', 1, 450000.00, NULL),
(8, 'Need products', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Need roducts', 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, 'I want find 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 for our firm', '2014-06-08', '2014-06-17', 1, 113000000.00, NULL),
(4, 'Products for me', 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
(10, null, 'If you wil take all', 1, 10),
(20, null, null, 1, 9),
(30, null, 'and free delivery', 2, 8),
(50, null, null, 3, 7),
(null, 10000.00, null, 4, 6),
(null, 5000.00, null, 5, 5),
(null, 8000.00, null, 6, 4),
(null, 1400.00, null, 7, 3),
(null, 1500.00, null, 8, 2),
(null, 500.00, null, 4, 1),
(null, 5000.00, null, 1, 7);


INSERT INTO item (name, type, category_id) VALUES
('Rocks', 'P', 1),
('Dogs', 'P', 2),
('Cats', 'P', 3),
('Puffin', 'P', 4),
('Ovcharka', 'P', 5),
('Penguins', 'P', 6),
('Juises', 'P', 7),
{'fraction_non_alphanumeric': 0.2677088787493455, 'fraction_numerical': 0.17390979130825043, 'mean_word_length': 5.881111682964488, 'pattern_counts': {'":': 0, '<': 65, '<?xml version=': 0, '>': 65, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3730254', 'n_tokens_mistral': 7324, 'n_tokens_neox': 5498, 'n_words': 1529}