-- ============================================
-- AUTO-GENERATED COMPLETE VENDOR RESEED
-- ============================================
ALTER TABLE public.profiles DISABLE ROW LEVEL SECURITY;
ALTER TABLE public.vendors DISABLE ROW LEVEL SECURITY;

CREATE OR REPLACE FUNCTION public.create_user(user_id uuid, email text, password text, user_role text) RETURNS void AS $$
BEGIN
    INSERT INTO auth.users (instance_id, id, aud, role, email, encrypted_password, email_confirmed_at, raw_app_meta_data, raw_user_meta_data, created_at, updated_at)
    VALUES ('00000000-0000-0000-0000-000000000000', user_id, 'authenticated', 'authenticated', email, crypt(password, gen_salt('bf')), NOW(), 
    jsonb_build_object('provider', 'email', 'providers', ARRAY['email']), jsonb_build_object('role', user_role), NOW(), NOW());
    INSERT INTO auth.identities (id, provider_id, user_id, identity_data, provider, last_sign_in_at, created_at, updated_at)
    VALUES (gen_random_uuid(), gen_random_uuid(), user_id, format('{"sub":"%s","email":"%s"}', user_id::text, email)::jsonb, 'email', NOW(), NOW(), NOW());
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;


-- VENDORS FOR AUSTRIA
SELECT public.create_user('039193e4-0824-42ae-a4e0-b1e4d6dfa4da', 'procurement@medtronicaustria.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('039193e4-0824-42ae-a4e0-b1e4d6dfa4da', 'procurement@medtronicaustria.com', 'Michael Williams', 'vendor', 'Medtronic Austria GmbH', '+390-8718064', '93 Main St, City Center, 55389, Austria', 'City Center', 'Austria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('3f597d0a-d68c-4d44-845e-1ca47994a1c6', '039193e4-0824-42ae-a4e0-b1e4d6dfa4da', 'Medtronic Austria GmbH', 'REG-327491', 'Pharmaceuticals', 4.2, 'Michael Williams', 'procurement@medtronicaustria.com', '+390-8718064', '93 Main St, City Center, 55389, Austria', 'City Center', 'Austria', true, '', '{"Austria"}', '{"Pharmaceuticals"}', '5fb1fb77-1ef7-4ef4-a02e-be86c391d64c', 'distributor');
SELECT public.create_user('55a3e088-7f55-4f72-a7b1-68e2e6c58ff1', 'procurement@siemensaustria.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('55a3e088-7f55-4f72-a7b1-68e2e6c58ff1', 'procurement@siemensaustria.com', 'John Johnson', 'vendor', 'Siemens Healthineers Austria GmbH', '+929-6690704', '863 Industrial Way, Industrial District, 58287, Austria', 'Industrial District', 'Austria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('aef9c78e-0351-459a-bcb7-ba10e24ab60f', '55a3e088-7f55-4f72-a7b1-68e2e6c58ff1', 'Siemens Healthineers Austria GmbH', 'REG-364984', 'Pharmaceuticals', 4.7, 'John Johnson', 'procurement@siemensaustria.com', '+929-6690704', '863 Industrial Way, Industrial District, 58287, Austria', 'Industrial District', 'Austria', true, '', '{"Austria"}', '{"Pharmaceuticals"}', '7b404fe0-48ad-408c-bc16-b34167862ca4', 'distributor');
SELECT public.create_user('e8216a5e-0eda-43ad-90c3-01a16e0ec086', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e8216a5e-0eda-43ad-90c3-01a16e0ec086', 'procurement@international.com', 'Sarah Johnson', 'vendor', 'International Pharma Handels GmbH', '+341-4881389', '771 Business Park, Industrial District, 49274, Austria', 'Industrial District', 'Austria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('3740de5e-16df-46e6-99c7-24eaa325cd67', 'e8216a5e-0eda-43ad-90c3-01a16e0ec086', 'International Pharma Handels GmbH', 'REG-225532', 'Branded Pharma', 4.9, 'Sarah Johnson', 'procurement@international.com', '+341-4881389', '771 Business Park, Industrial District, 49274, Austria', 'Industrial District', 'Austria', true, 'ATU721818607', '{"Austria"}', '{"Branded Pharma","Vaccines","Pharmaceuticals"}', '034c5596-3bac-4bfd-a0be-9dfcec5229b4', 'distributor');
SELECT public.create_user('791259bd-14a3-4187-aadf-606b3ce87fc2', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('791259bd-14a3-4187-aadf-606b3ce87fc2', 'procurement@international.com', 'Lisa Williams', 'vendor', 'International Medizintechnik AG', '+494-1485795', '445 Business Park, Business Quarter, 19897, Austria', 'Business Quarter', 'Austria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('db5abacb-1e62-4cb6-8716-057f6d8c0beb', '791259bd-14a3-4187-aadf-606b3ce87fc2', 'International Medizintechnik AG', 'REG-592523', 'Diagnostics', 3.5, 'Lisa Williams', 'procurement@international.com', '+494-1485795', '445 Business Park, Business Quarter, 19897, Austria', 'Business Quarter', 'Austria', true, 'ATU566004103', '{"Austria"}', '{"Diagnostics","Generic Drugs","Cardiology","Vaccines","Radiology"}', '0f793cdc-fd62-4ea3-98d2-11e1101cfb75', 'distributor');
SELECT public.create_user('34960b80-4e5e-4c51-bb5d-0cfe069c6138', 'procurement@regional.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('34960b80-4e5e-4c51-bb5d-0cfe069c6138', 'procurement@regional.com', 'John Johnson', 'vendor', 'Regional Medizintechnik AG', '+497-4173211', '59 Business Park, City Center, 57401, Austria', 'City Center', 'Austria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('842b7974-167a-4bb3-938f-1b383dbbcf82', '34960b80-4e5e-4c51-bb5d-0cfe069c6138', 'Regional Medizintechnik AG', 'REG-842490', 'Biologics', 4.3, 'John Johnson', 'procurement@regional.com', '+497-4173211', '59 Business Park, City Center, 57401, Austria', 'City Center', 'Austria', true, 'ATU153433399', '{"Austria"}', '{"Biologics","OTC","Vaccines"}', '98f809d1-e90a-4489-9908-822168ada80b', 'distributor');

-- VENDORS FOR BELGIUM
SELECT public.create_user('b2f804f8-77d0-49c0-ae70-6c03d97f0fb2', 'procurement@casa.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('b2f804f8-77d0-49c0-ae70-6c03d97f0fb2', 'procurement@casa.com', 'David Brown', 'vendor', 'Casa N.V.', '+737-8879231', '724 Commerce Blvd, Business Quarter, 42932, Belgium', 'Business Quarter', 'Belgium', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f2eb3718-ce30-4068-93da-2ed0fe963baf', 'b2f804f8-77d0-49c0-ae70-6c03d97f0fb2', 'Casa N.V.', 'REG-655783', 'Pharmaceuticals', 4.2, 'David Brown', 'procurement@casa.com', '+737-8879231', '724 Commerce Blvd, Business Quarter, 42932, Belgium', 'Business Quarter', 'Belgium', true, '', '{"Belgium"}', '{"Pharmaceuticals"}', 'a0e5860b-0ec6-4bec-9a78-de6e0e42651b', 'distributor');
SELECT public.create_user('0e3665ea-90d8-4a5f-acc7-2c7afabcfe27', 'procurement@fagron.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0e3665ea-90d8-4a5f-acc7-2c7afabcfe27', 'procurement@fagron.com', 'Sarah Davis', 'vendor', 'Fagron Belgium N.V.', '+423-8479895', '552 Industrial Way, Business Quarter, 68337, Belgium', 'Business Quarter', 'Belgium', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('db3a8cf4-8afa-42b9-96c0-147dac969b1c', '0e3665ea-90d8-4a5f-acc7-2c7afabcfe27', 'Fagron Belgium N.V.', 'REG-215622', 'Pharmaceuticals', 3.6, 'Sarah Davis', 'procurement@fagron.com', '+423-8479895', '552 Industrial Way, Business Quarter, 68337, Belgium', 'Business Quarter', 'Belgium', true, '', '{"Belgium"}', '{"Pharmaceuticals"}', 'ce1108a1-3d7a-4cef-814b-2d037f53ab8f', 'distributor');
SELECT public.create_user('c88e335d-b825-447c-b1d5-3277f65751fb', 'procurement@medtronicbelgium.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c88e335d-b825-447c-b1d5-3277f65751fb', 'procurement@medtronicbelgium.com', 'John Jones', 'vendor', 'Medtronic Belgium S.A.', '+576-3533922', '811 Commerce Blvd, Business Quarter, 14224, Belgium', 'Business Quarter', 'Belgium', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('b9063a45-a97d-4917-bd03-241f88d93586', 'c88e335d-b825-447c-b1d5-3277f65751fb', 'Medtronic Belgium S.A.', 'REG-468175', 'Pharmaceuticals', 3.5, 'John Jones', 'procurement@medtronicbelgium.com', '+576-3533922', '811 Commerce Blvd, Business Quarter, 14224, Belgium', 'Business Quarter', 'Belgium', true, '', '{"Belgium"}', '{"Pharmaceuticals"}', '63a710fd-80d6-4652-b6fc-f0b6fcf3e9b5', 'distributor');
SELECT public.create_user('164c2480-749d-4d3b-a845-9533e5c43231', 'procurement@j&jbelgium.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('164c2480-749d-4d3b-a845-9533e5c43231', 'procurement@j&jbelgium.com', 'Michael Jones', 'vendor', 'Johnson & Johnson Medical Belgium', '+597-8086218', '665 Commerce Blvd, Business Quarter, 16952, Belgium', 'Business Quarter', 'Belgium', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('b2f6bfae-3047-4236-97fe-72d61145f975', '164c2480-749d-4d3b-a845-9533e5c43231', 'Johnson & Johnson Medical Belgium', 'REG-636670', 'Pharmaceuticals', 4.9, 'Michael Jones', 'procurement@j&jbelgium.com', '+597-8086218', '665 Commerce Blvd, Business Quarter, 16952, Belgium', 'Business Quarter', 'Belgium', true, '', '{"Belgium"}', '{"Pharmaceuticals"}', '1e087090-55a3-47c9-8ef2-e2a3d1b50e48', 'distributor');
SELECT public.create_user('6d014bad-4cd4-4522-b639-7e2e009ae3bd', 'procurement@nordic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6d014bad-4cd4-4522-b639-7e2e009ae3bd', 'procurement@nordic.com', 'John Williams', 'vendor', 'Nordic Pharma Belgium NV', '+330-9266499', '615 Commerce Blvd, Business Quarter, 25874, Belgium', 'Business Quarter', 'Belgium', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('4d80f2ce-5d26-4b4c-83c5-869500809f45', '6d014bad-4cd4-4522-b639-7e2e009ae3bd', 'Nordic Pharma Belgium NV', 'REG-196124', 'Patient Monitoring', 3.9, 'John Williams', 'procurement@nordic.com', '+330-9266499', '615 Commerce Blvd, Business Quarter, 25874, Belgium', 'Business Quarter', 'Belgium', true, 'BE0841494616', '{"Belgium"}', '{"Patient Monitoring","Branded Pharma","Dental","Anesthesia","Radiology"}', '36cd52c2-c9e8-4c99-9336-8e6b3dec746c', 'distributor');

-- VENDORS FOR BULGARIA
SELECT public.create_user('c0817c78-2ed1-4503-8805-2a34988d613e', 'procurement@medtronicbulgaria.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c0817c78-2ed1-4503-8805-2a34988d613e', 'procurement@medtronicbulgaria.com', 'Emma Davis', 'vendor', 'Medtronic Bulgaria EOOD', '+945-7622645', '528 Main St, Business Quarter, 97447, Bulgaria', 'Business Quarter', 'Bulgaria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('4b85a145-03de-4fdb-bc4f-96a918d511f3', 'c0817c78-2ed1-4503-8805-2a34988d613e', 'Medtronic Bulgaria EOOD', 'REG-324788', 'Pharmaceuticals', 3.6, 'Emma Davis', 'procurement@medtronicbulgaria.com', '+945-7622645', '528 Main St, Business Quarter, 97447, Bulgaria', 'Business Quarter', 'Bulgaria', true, '', '{"Bulgaria"}', '{"Pharmaceuticals"}', '022e56e7-9258-491d-a7ef-80a22351e5ae', 'distributor');
SELECT public.create_user('36415d49-309e-4026-a6ba-88a7b726b475', 'procurement@united.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('36415d49-309e-4026-a6ba-88a7b726b475', 'procurement@united.com', 'David Williams', 'vendor', 'United Pharma Bulgaria EOOD', '+757-9604438', '698 Commerce Blvd, Industrial District, 51606, Bulgaria', 'Industrial District', 'Bulgaria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('14f488f2-61e3-4d13-bef3-744a22c96701', '36415d49-309e-4026-a6ba-88a7b726b475', 'United Pharma Bulgaria EOOD', 'REG-101771', 'Cardiology', 3.8, 'David Williams', 'procurement@united.com', '+757-9604438', '698 Commerce Blvd, Industrial District, 51606, Bulgaria', 'Industrial District', 'Bulgaria', true, 'BG816997791', '{"Bulgaria"}', '{"Cardiology","Wound Care"}', 'bc139c27-15f0-4ea5-8218-d74894f7b490', 'distributor');
SELECT public.create_user('ae747eff-bb36-49fa-ada2-d55e20e78d8f', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ae747eff-bb36-49fa-ada2-d55e20e78d8f', 'procurement@allied.com', 'Emma Smith', 'vendor', 'Allied Healthcare BG', '+728-5929113', '645 Business Park, City Center, 74836, Bulgaria', 'City Center', 'Bulgaria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('4d5650f1-fb70-48ad-a3d2-c482dd141763', 'ae747eff-bb36-49fa-ada2-d55e20e78d8f', 'Allied Healthcare BG', 'REG-658022', 'Pharmaceuticals', 4.7, 'Emma Smith', 'procurement@allied.com', '+728-5929113', '645 Business Park, City Center, 74836, Bulgaria', 'City Center', 'Bulgaria', true, 'BG391577236', '{"Bulgaria"}', '{"Pharmaceuticals","Vaccines"}', 'c761b79d-4951-42b4-9bc1-faa166f52d55', 'distributor');
SELECT public.create_user('8ebc5f4e-db23-49e5-8f7a-4097349fa5a6', 'procurement@direct.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('8ebc5f4e-db23-49e5-8f7a-4097349fa5a6', 'procurement@direct.com', 'Lisa Williams', 'vendor', 'Direct Healthcare BG', '+260-6220415', '556 Main St, City Center, 54602, Bulgaria', 'City Center', 'Bulgaria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f5dfca83-9157-4d72-ac04-4ca36bec65d0', '8ebc5f4e-db23-49e5-8f7a-4097349fa5a6', 'Direct Healthcare BG', 'REG-422975', 'Dental', 4.3, 'Lisa Williams', 'procurement@direct.com', '+260-6220415', '556 Main St, City Center, 54602, Bulgaria', 'City Center', 'Bulgaria', true, 'BG561676943', '{"Bulgaria"}', '{"Dental","Laboratory","Wound Care","Consumables"}', '94136021-a5c9-4e03-a9cb-b9f85094a753', 'distributor');
SELECT public.create_user('b0fe2663-bf6f-4c42-b2cc-4b801189dd55', 'procurement@select.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('b0fe2663-bf6f-4c42-b2cc-4b801189dd55', 'procurement@select.com', 'David Smith', 'vendor', 'Select Healthcare BG', '+512-6788944', '141 Industrial Way, Business Quarter, 21211, Bulgaria', 'Business Quarter', 'Bulgaria', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('b3ec9678-8759-49fb-a523-e1de469718b5', 'b0fe2663-bf6f-4c42-b2cc-4b801189dd55', 'Select Healthcare BG', 'REG-843329', 'Radiology', 4.0, 'David Smith', 'procurement@select.com', '+512-6788944', '141 Industrial Way, Business Quarter, 21211, Bulgaria', 'Business Quarter', 'Bulgaria', true, 'BG647804068', '{"Bulgaria"}', '{"Radiology","Anesthesia","Dental","OTC","Cardiology"}', '17d12a1b-2b34-4c7e-9cf4-06536e0c99ac', 'distributor');

-- VENDORS FOR CROATIA
SELECT public.create_user('17cd91aa-f1ac-4ff3-8298-f6a767b2578e', 'procurement@medtroniccroatia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('17cd91aa-f1ac-4ff3-8298-f6a767b2578e', 'procurement@medtroniccroatia.com', 'Sarah Davis', 'vendor', 'Medtronic Croatia d.o.o.', '+934-2956339', '319 Industrial Way, Industrial District, 86717, Croatia', 'Industrial District', 'Croatia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('31cccba5-dad2-4b5a-a495-3f433697224b', '17cd91aa-f1ac-4ff3-8298-f6a767b2578e', 'Medtronic Croatia d.o.o.', 'REG-368985', 'Pharmaceuticals', 4.9, 'Sarah Davis', 'procurement@medtroniccroatia.com', '+934-2956339', '319 Industrial Way, Industrial District, 86717, Croatia', 'Industrial District', 'Croatia', true, '', '{"Croatia"}', '{"Pharmaceuticals"}', '5700475a-6b7e-487d-bb23-602280eff7f5', 'distributor');
SELECT public.create_user('d62198e0-cb69-432f-bad4-19e8b4a69eae', 'procurement@care.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d62198e0-cb69-432f-bad4-19e8b4a69eae', 'procurement@care.com', 'Sarah Jones', 'vendor', 'Care Medical Croatia', '+705-8543888', '221 Commerce Blvd, City Center, 16239, Croatia', 'City Center', 'Croatia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('bff64c25-b470-4efa-a7c1-154f7254e2ac', 'd62198e0-cb69-432f-bad4-19e8b4a69eae', 'Care Medical Croatia', 'REG-629940', 'Anesthesia', 4.2, 'Sarah Jones', 'procurement@care.com', '+705-8543888', '221 Commerce Blvd, City Center, 16239, Croatia', 'City Center', 'Croatia', true, 'HR  494720999', '{"Croatia"}', '{"Anesthesia","Pharmaceuticals","Optical","Generic Drugs","Cardiology"}', '5fca73ff-fb97-4be9-af0a-7401ba12f46f', 'distributor');
SELECT public.create_user('5881a47c-9fe6-4d16-8c4d-5b21a7d85b9d', 'procurement@sanus.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('5881a47c-9fe6-4d16-8c4d-5b21a7d85b9d', 'procurement@sanus.com', 'Michael Davis', 'vendor', 'Sanus Pharma Croatia d.o.o.', '+654-7727154', '926 Industrial Way, Business Quarter, 71765, Croatia', 'Business Quarter', 'Croatia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e942d1f3-97af-4e9c-9f70-d993ff7459a8', '5881a47c-9fe6-4d16-8c4d-5b21a7d85b9d', 'Sanus Pharma Croatia d.o.o.', 'REG-131163', 'Anesthesia', 4.0, 'Michael Davis', 'procurement@sanus.com', '+654-7727154', '926 Industrial Way, Business Quarter, 71765, Croatia', 'Business Quarter', 'Croatia', true, 'HR  914512238', '{"Croatia"}', '{"Anesthesia","Dental","Consumables","Radiology"}', '8a1b986e-17fe-4dfb-a956-37d1d22abf0a', 'distributor');
SELECT public.create_user('59308651-d20b-49cc-a4ba-dbe16439446b', 'procurement@vita.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('59308651-d20b-49cc-a4ba-dbe16439446b', 'procurement@vita.com', 'Sarah Brown', 'vendor', 'Vita Pharma Croatia d.o.o.', '+896-8984943', '275 Main St, Business Quarter, 76105, Croatia', 'Business Quarter', 'Croatia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5ee967ca-c8d4-4575-ba22-b28d27c0e5b4', '59308651-d20b-49cc-a4ba-dbe16439446b', 'Vita Pharma Croatia d.o.o.', 'REG-640058', 'Pharmaceuticals', 3.5, 'Sarah Brown', 'procurement@vita.com', '+896-8984943', '275 Main St, Business Quarter, 76105, Croatia', 'Business Quarter', 'Croatia', true, 'HR  836608316', '{"Croatia"}', '{"Pharmaceuticals","Surgery","Optical","Vaccines"}', '3bad5bc3-44aa-47bf-85d9-4df19a2b0c8a', 'distributor');
SELECT public.create_user('177dfc37-fb83-4a18-a25e-ca5577bbae90', 'procurement@premier.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('177dfc37-fb83-4a18-a25e-ca5577bbae90', 'procurement@premier.com', 'Emma Jones', 'vendor', 'Premier Medical Croatia', '+562-7282274', '729 Main St, Business Quarter, 44042, Croatia', 'Business Quarter', 'Croatia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0b209471-693e-4e8a-9138-5a1017ef3087', '177dfc37-fb83-4a18-a25e-ca5577bbae90', 'Premier Medical Croatia', 'REG-466438', 'Wound Care', 3.5, 'Emma Jones', 'procurement@premier.com', '+562-7282274', '729 Main St, Business Quarter, 44042, Croatia', 'Business Quarter', 'Croatia', true, 'HR  619397982', '{"Croatia"}', '{"Wound Care","Optical"}', 'dff73dca-1134-4011-a54d-9185a1e1c800', 'distributor');

-- VENDORS FOR CYPRUS
SELECT public.create_user('206b4542-c301-4b00-a9b4-27b67d6b05d2', 'procurement@medtroniccyprus.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('206b4542-c301-4b00-a9b4-27b67d6b05d2', 'procurement@medtroniccyprus.com', 'David Brown', 'vendor', 'Medtronic Cyprus Ltd', '+864-4121326', '965 Commerce Blvd, Industrial District, 77317, Cyprus', 'Industrial District', 'Cyprus', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('3ee873a4-6e6d-4605-b1dd-d3843a5b448e', '206b4542-c301-4b00-a9b4-27b67d6b05d2', 'Medtronic Cyprus Ltd', 'REG-334344', 'Pharmaceuticals', 3.7, 'David Brown', 'procurement@medtroniccyprus.com', '+864-4121326', '965 Commerce Blvd, Industrial District, 77317, Cyprus', 'Industrial District', 'Cyprus', true, '', '{"Cyprus"}', '{"Pharmaceuticals"}', '01b8469e-134b-41c4-8020-916a2d139b78', 'distributor');
SELECT public.create_user('0ac36af5-99df-4ed6-aa49-2b4a886bbc1e', 'procurement@continental.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0ac36af5-99df-4ed6-aa49-2b4a886bbc1e', 'procurement@continental.com', 'Emma Williams', 'vendor', 'Continental Distribution Cyprus', '+248-4782845', '196 Main St, Business Quarter, 45880, Cyprus', 'Business Quarter', 'Cyprus', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ef0e5b1b-b805-4472-b536-fe0256912c1a', '0ac36af5-99df-4ed6-aa49-2b4a886bbc1e', 'Continental Distribution Cyprus', 'REG-949392', 'Branded Pharma', 4.8, 'Emma Williams', 'procurement@continental.com', '+248-4782845', '196 Main St, Business Quarter, 45880, Cyprus', 'Business Quarter', 'Cyprus', true, 'CY939938859A', '{"Cyprus"}', '{"Branded Pharma","OTC","Pharmaceuticals","Biologics"}', '4368f6df-ae49-4916-a9bc-5be10a13cbc7', 'distributor');
SELECT public.create_user('d22dd400-adb0-4195-9045-fba6acb4c869', 'procurement@direct.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d22dd400-adb0-4195-9045-fba6acb4c869', 'procurement@direct.com', 'Michael Jones', 'vendor', 'Direct Medical Cyprus', '+596-4378174', '945 Industrial Way, Industrial District, 88219, Cyprus', 'Industrial District', 'Cyprus', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('57f39ccd-4ef9-462f-be2e-3c2167746d50', 'd22dd400-adb0-4195-9045-fba6acb4c869', 'Direct Medical Cyprus', 'REG-961570', 'Generic Drugs', 4.2, 'Michael Jones', 'procurement@direct.com', '+596-4378174', '945 Industrial Way, Industrial District, 88219, Cyprus', 'Industrial District', 'Cyprus', true, 'CY472694756A', '{"Cyprus"}', '{"Generic Drugs","Pharmaceuticals","Biologics"}', '2ed43569-1946-45fe-a7f0-acf3787c445a', 'distributor');
SELECT public.create_user('ab78834b-b6a3-495f-937b-f7db282f072f', 'procurement@medica.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ab78834b-b6a3-495f-937b-f7db282f072f', 'procurement@medica.com', 'Sarah Davis', 'vendor', 'Medica Medical Cyprus', '+584-2506705', '555 Commerce Blvd, Business Quarter, 65602, Cyprus', 'Business Quarter', 'Cyprus', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('aa50a1e1-3927-412f-99dc-1455e2c49cde', 'ab78834b-b6a3-495f-937b-f7db282f072f', 'Medica Medical Cyprus', 'REG-925455', 'Generic Drugs', 3.8, 'Sarah Davis', 'procurement@medica.com', '+584-2506705', '555 Commerce Blvd, Business Quarter, 65602, Cyprus', 'Business Quarter', 'Cyprus', true, 'CY315772385A', '{"Cyprus"}', '{"Generic Drugs","Dental","Anesthesia","Surgery"}', '950e3e04-9cb7-4483-ae52-65c49f9db29f', 'distributor');
SELECT public.create_user('a61d65d4-ace5-482c-89cd-78943f0eb1f9', 'procurement@standard.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a61d65d4-ace5-482c-89cd-78943f0eb1f9', 'procurement@standard.com', 'John Brown', 'vendor', 'Standard Healthcare CY', '+708-4885533', '402 Commerce Blvd, City Center, 42797, Cyprus', 'City Center', 'Cyprus', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e35e19cd-73c5-44b5-9cc1-ebfc551863f2', 'a61d65d4-ace5-482c-89cd-78943f0eb1f9', 'Standard Healthcare CY', 'REG-111908', 'OTC', 3.5, 'John Brown', 'procurement@standard.com', '+708-4885533', '402 Commerce Blvd, City Center, 42797, Cyprus', 'City Center', 'Cyprus', true, 'CY563759810A', '{"Cyprus"}', '{"OTC","Branded Pharma"}', '07e98aec-627b-49ce-8fe4-25c2765beacb', 'distributor');

-- VENDORS FOR DENMARK
SELECT public.create_user('e6a75219-599b-4a0b-8d0f-770b5f17268b', 'procurement@tjellesen.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e6a75219-599b-4a0b-8d0f-770b5f17268b', 'procurement@tjellesen.com', 'Sarah Brown', 'vendor', 'Tjellesen Max Jenne A/S', '+680-7631290', '547 Main St, Industrial District, 91792, Denmark', 'Industrial District', 'Denmark', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('efe72013-80eb-48df-a586-5eea9e52103f', 'e6a75219-599b-4a0b-8d0f-770b5f17268b', 'Tjellesen Max Jenne A/S', 'REG-817876', 'Pharmaceuticals', 4.5, 'Sarah Brown', 'procurement@tjellesen.com', '+680-7631290', '547 Main St, Industrial District, 91792, Denmark', 'Industrial District', 'Denmark', true, '', '{"Denmark"}', '{"Pharmaceuticals"}', '2ef96664-39b8-443f-9d45-ea9b8190c58b', 'distributor');
SELECT public.create_user('223611dc-5a5d-4420-be5a-5058763866ea', 'procurement@coloplast.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('223611dc-5a5d-4420-be5a-5058763866ea', 'procurement@coloplast.com', 'Michael Smith', 'vendor', 'Coloplast A/S', '+239-1371489', '336 Commerce Blvd, City Center, 14864, Denmark', 'City Center', 'Denmark', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('34b43d68-423f-4772-9244-0b7e67f6973e', '223611dc-5a5d-4420-be5a-5058763866ea', 'Coloplast A/S', 'REG-571776', 'Pharmaceuticals', 3.8, 'Michael Smith', 'procurement@coloplast.com', '+239-1371489', '336 Commerce Blvd, City Center, 14864, Denmark', 'City Center', 'Denmark', true, '', '{"Denmark"}', '{"Pharmaceuticals"}', '4f1033cd-737f-446f-9399-c17c8e506f75', 'distributor');
SELECT public.create_user('c4c25e84-ad7a-4d9c-8556-99b353b6c107', 'procurement@ambu.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c4c25e84-ad7a-4d9c-8556-99b353b6c107', 'procurement@ambu.com', 'Michael Brown', 'vendor', 'Ambu A/S', '+121-1714681', '706 Commerce Blvd, Business Quarter, 46604, Denmark', 'Business Quarter', 'Denmark', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('68e35a54-bb8a-429f-8e42-1f56fd239340', 'c4c25e84-ad7a-4d9c-8556-99b353b6c107', 'Ambu A/S', 'REG-124361', 'Pharmaceuticals', 4.8, 'Michael Brown', 'procurement@ambu.com', '+121-1714681', '706 Commerce Blvd, Business Quarter, 46604, Denmark', 'Business Quarter', 'Denmark', true, '', '{"Denmark"}', '{"Pharmaceuticals"}', '35d0e4ae-2b9b-4ef0-ba1f-edf6df1c17dc', 'distributor');
SELECT public.create_user('04910a88-322f-4ff1-b671-1197bcfa5c18', 'procurement@demant.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('04910a88-322f-4ff1-b671-1197bcfa5c18', 'procurement@demant.com', 'Sarah Brown', 'vendor', 'William Demant Holding A/S', '+105-2096078', '823 Main St, Industrial District, 12491, Denmark', 'Industrial District', 'Denmark', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('6512f817-8368-4782-994f-c492ce18420c', '04910a88-322f-4ff1-b671-1197bcfa5c18', 'William Demant Holding A/S', 'REG-524918', 'Pharmaceuticals', 4.7, 'Sarah Brown', 'procurement@demant.com', '+105-2096078', '823 Main St, Industrial District, 12491, Denmark', 'Industrial District', 'Denmark', true, '', '{"Denmark"}', '{"Pharmaceuticals"}', '0a2986ea-3311-4ba8-998d-3eee3acca2a5', 'distributor');
SELECT public.create_user('03468cc6-b1f5-41f1-bff8-bd71f299247f', 'procurement@care.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('03468cc6-b1f5-41f1-bff8-bd71f299247f', 'procurement@care.com', 'Michael Johnson', 'vendor', 'Care Medical Denmark', '+863-5346206', '841 Main St, Industrial District, 84645, Denmark', 'Industrial District', 'Denmark', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('2d1a3a0b-3913-4867-ad71-87fe995a1dc4', '03468cc6-b1f5-41f1-bff8-bd71f299247f', 'Care Medical Denmark', 'REG-389841', 'Biologics', 4.5, 'Michael Johnson', 'procurement@care.com', '+863-5346206', '841 Main St, Industrial District, 84645, Denmark', 'Industrial District', 'Denmark', true, 'DK473950265', '{"Denmark"}', '{"Biologics","Anesthesia","OTC"}', '8880ec63-6d79-4d36-976d-9de561945f7a', 'distributor');

-- VENDORS FOR ESTONIA
SELECT public.create_user('65201b37-1460-4941-968d-569d9821a899', 'procurement@medtronicestonia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('65201b37-1460-4941-968d-569d9821a899', 'procurement@medtronicestonia.com', 'Emma Brown', 'vendor', 'Medtronic Estonia OÜ', '+285-9933388', '396 Main St, Industrial District, 79312, Estonia', 'Industrial District', 'Estonia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('8648caca-6514-49a7-9729-8f5e4f6d7736', '65201b37-1460-4941-968d-569d9821a899', 'Medtronic Estonia OÜ', 'REG-613050', 'Pharmaceuticals', 4.7, 'Emma Brown', 'procurement@medtronicestonia.com', '+285-9933388', '396 Main St, Industrial District, 79312, Estonia', 'Industrial District', 'Estonia', true, '', '{"Estonia"}', '{"Pharmaceuticals"}', '16574810-cd10-4ada-85b6-062822e2d0b5', 'distributor');
SELECT public.create_user('1278dbbd-7cfd-4ba1-8bf2-b523c0d7519c', 'procurement@max.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1278dbbd-7cfd-4ba1-8bf2-b523c0d7519c', 'procurement@max.com', 'Emma Brown', 'vendor', 'Max Medical Estonia', '+436-2226024', '781 Business Park, Industrial District, 35005, Estonia', 'Industrial District', 'Estonia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e22eadbd-1c1b-42d9-b5d0-a956fae41476', '1278dbbd-7cfd-4ba1-8bf2-b523c0d7519c', 'Max Medical Estonia', 'REG-521606', 'Branded Pharma', 3.9, 'Emma Brown', 'procurement@max.com', '+436-2226024', '781 Business Park, Industrial District, 35005, Estonia', 'Industrial District', 'Estonia', true, 'EE937143534', '{"Estonia"}', '{"Branded Pharma","Vaccines","Pharmaceuticals","Biologics"}', 'bd616198-b1e4-4571-a811-7374e8c04743', 'distributor');
SELECT public.create_user('26868254-697b-4dab-ba36-b58b9d55bdc5', 'procurement@prime.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('26868254-697b-4dab-ba36-b58b9d55bdc5', 'procurement@prime.com', 'Michael Jones', 'vendor', 'Prime Distribution Estonia', '+413-6202362', '448 Main St, City Center, 66284, Estonia', 'City Center', 'Estonia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('baf78b6d-a070-48ff-a854-95b59941255c', '26868254-697b-4dab-ba36-b58b9d55bdc5', 'Prime Distribution Estonia', 'REG-592881', 'Generic Drugs', 4.9, 'Michael Jones', 'procurement@prime.com', '+413-6202362', '448 Main St, City Center, 66284, Estonia', 'City Center', 'Estonia', true, 'EE783080848', '{"Estonia"}', '{"Generic Drugs","Vaccines","Biologics"}', 'f9c77a51-3646-44b4-9df7-19c12716a4cb', 'distributor');
SELECT public.create_user('313f3a8a-d166-45d1-915f-9f1bc479775f', 'procurement@alpine.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('313f3a8a-d166-45d1-915f-9f1bc479775f', 'procurement@alpine.com', 'Emma Williams', 'vendor', 'Alpine Medical Estonia', '+164-7672534', '879 Commerce Blvd, Business Quarter, 21047, Estonia', 'Business Quarter', 'Estonia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('49c22699-4139-406f-9be7-a9c934715098', '313f3a8a-d166-45d1-915f-9f1bc479775f', 'Alpine Medical Estonia', 'REG-983686', 'Generic Drugs', 3.6, 'Emma Williams', 'procurement@alpine.com', '+164-7672534', '879 Commerce Blvd, Business Quarter, 21047, Estonia', 'Business Quarter', 'Estonia', true, 'EE897049038', '{"Estonia"}', '{"Generic Drugs","Pharmaceuticals"}', 'ef33cb2c-686e-4ca4-be6f-e16779ddfc04', 'distributor');
SELECT public.create_user('ff96e6ea-7364-466a-a11d-5f9a4d82814b', 'procurement@max.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ff96e6ea-7364-466a-a11d-5f9a4d82814b', 'procurement@max.com', 'Michael Johnson', 'vendor', 'Max Healthcare EE', '+396-3536363', '761 Business Park, Business Quarter, 46059, Estonia', 'Business Quarter', 'Estonia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('67c1ee4e-0427-4ccd-8909-128ec4e2f281', 'ff96e6ea-7364-466a-a11d-5f9a4d82814b', 'Max Healthcare EE', 'REG-893041', 'Consumables', 4.5, 'Michael Johnson', 'procurement@max.com', '+396-3536363', '761 Business Park, Business Quarter, 46059, Estonia', 'Business Quarter', 'Estonia', true, 'EE297766827', '{"Estonia"}', '{"Consumables","Wound Care","Orthopedics","Dental"}', '977f91d5-281a-4ea0-a851-07e8b7126a7a', 'distributor');

-- VENDORS FOR FINLAND
SELECT public.create_user('6540f16f-bc70-4c26-b73c-ef4367fd9da0', 'procurement@medtronicfinland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6540f16f-bc70-4c26-b73c-ef4367fd9da0', 'procurement@medtronicfinland.com', 'Emma Brown', 'vendor', 'Medtronic Finland Oy', '+312-4059016', '874 Commerce Blvd, Business Quarter, 95949, Finland', 'Business Quarter', 'Finland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ec14309e-f99c-4de3-b52a-ba86ee8e2c38', '6540f16f-bc70-4c26-b73c-ef4367fd9da0', 'Medtronic Finland Oy', 'REG-220634', 'Pharmaceuticals', 4.8, 'Emma Brown', 'procurement@medtronicfinland.com', '+312-4059016', '874 Commerce Blvd, Business Quarter, 95949, Finland', 'Business Quarter', 'Finland', true, '', '{"Finland"}', '{"Pharmaceuticals"}', 'e0414433-d670-40c2-8a05-0e2ba73a6bc2', 'distributor');
SELECT public.create_user('cfe7710e-9397-43d7-b999-206dabbb2d4f', 'procurement@baltic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cfe7710e-9397-43d7-b999-206dabbb2d4f', 'procurement@baltic.com', 'John Smith', 'vendor', 'Baltic Healthcare FI', '+649-3403258', '796 Main St, City Center, 40758, Finland', 'City Center', 'Finland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c7cda0f3-5662-41b8-b009-58fdede2e7af', 'cfe7710e-9397-43d7-b999-206dabbb2d4f', 'Baltic Healthcare FI', 'REG-718717', 'Wound Care', 4.3, 'John Smith', 'procurement@baltic.com', '+649-3403258', '796 Main St, City Center, 40758, Finland', 'City Center', 'Finland', true, 'FI154787081', '{"Finland"}', '{"Wound Care","Patient Monitoring","Anesthesia"}', '7f448e02-79e1-42e3-b24e-d843ba217c84', 'distributor');
SELECT public.create_user('ac584227-4c15-4133-80a5-a9db8537663d', 'procurement@standard.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ac584227-4c15-4133-80a5-a9db8537663d', 'procurement@standard.com', 'Lisa Smith', 'vendor', 'Standard Pharma Finland Oy', '+549-4472311', '723 Main St, Industrial District, 88458, Finland', 'Industrial District', 'Finland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('4f39343c-c967-46b3-926e-d378cc5b182e', 'ac584227-4c15-4133-80a5-a9db8537663d', 'Standard Pharma Finland Oy', 'REG-338318', 'OTC', 3.6, 'Lisa Smith', 'procurement@standard.com', '+549-4472311', '723 Main St, Industrial District, 88458, Finland', 'Industrial District', 'Finland', true, 'FI103263792', '{"Finland"}', '{"OTC","Branded Pharma"}', '44fb8928-860b-49e3-9a6f-011a1b895081', 'distributor');
SELECT public.create_user('6a8bca9c-e8d3-4bc2-8f77-7e4e8421b12b', 'procurement@life.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6a8bca9c-e8d3-4bc2-8f77-7e4e8421b12b', 'procurement@life.com', 'Lisa Davis', 'vendor', 'Life Distribution Finland', '+426-5688237', '313 Commerce Blvd, Business Quarter, 62702, Finland', 'Business Quarter', 'Finland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('bdaa65a4-6fb7-4fc8-9b83-4654df8393f7', '6a8bca9c-e8d3-4bc2-8f77-7e4e8421b12b', 'Life Distribution Finland', 'REG-297799', 'Laboratory', 4.4, 'Lisa Davis', 'procurement@life.com', '+426-5688237', '313 Commerce Blvd, Business Quarter, 62702, Finland', 'Business Quarter', 'Finland', true, 'FI834858560', '{"Finland"}', '{"Laboratory","Radiology","Optical","Diagnostics"}', '7164b384-fb6e-43a5-a5a2-b848d277b8ff', 'distributor');
SELECT public.create_user('865d0350-3183-4b03-8c91-6e884eef62f9', 'procurement@euro.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('865d0350-3183-4b03-8c91-6e884eef62f9', 'procurement@euro.com', 'Lisa Johnson', 'vendor', 'Euro Medical Finland', '+921-8058878', '950 Industrial Way, Industrial District, 30764, Finland', 'Industrial District', 'Finland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7465fabc-b4b6-4b12-9c47-d496e0bde4ef', '865d0350-3183-4b03-8c91-6e884eef62f9', 'Euro Medical Finland', 'REG-788285', 'OTC', 3.7, 'Lisa Johnson', 'procurement@euro.com', '+921-8058878', '950 Industrial Way, Industrial District, 30764, Finland', 'Industrial District', 'Finland', true, 'FI470596144', '{"Finland"}', '{"OTC","Pharmaceuticals","Biologics","Generic Drugs"}', 'a67a124d-fee0-4dca-997b-bf1c64397447', 'distributor');

-- VENDORS FOR FRANCE
SELECT public.create_user('0743a431-1c9e-4d9d-a0a7-62077b049f15', 'procurement@ocp.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0743a431-1c9e-4d9d-a0a7-62077b049f15', 'procurement@ocp.com', 'John Davis', 'vendor', 'OCP Répartition SA', '+695-2446253', '849 Main St, City Center, 89231, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('31c53974-c30c-40d5-9c53-63c41b47228f', '0743a431-1c9e-4d9d-a0a7-62077b049f15', 'OCP Répartition SA', 'REG-641688', 'Pharmaceuticals', 3.6, 'John Davis', 'procurement@ocp.com', '+695-2446253', '849 Main St, City Center, 89231, France', 'City Center', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', 'cb2b9e6b-e89c-4cb6-ba20-17cf64aae4c0', 'distributor');
SELECT public.create_user('4465c47c-47d0-4268-a203-60f9b5b4c413', 'procurement@alliancehealthcarefrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('4465c47c-47d0-4268-a203-60f9b5b4c413', 'procurement@alliancehealthcarefrance.com', 'John Williams', 'vendor', 'Alliance Healthcare France SAS', '+704-2605480', '45 Industrial Way, Industrial District, 97232, France', 'Industrial District', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fd28d4a1-d33b-4862-81f5-1935e8d5ae57', '4465c47c-47d0-4268-a203-60f9b5b4c413', 'Alliance Healthcare France SAS', 'REG-425808', 'Pharmaceuticals', 3.9, 'John Williams', 'procurement@alliancehealthcarefrance.com', '+704-2605480', '45 Industrial Way, Industrial District, 97232, France', 'Industrial District', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', 'f2f94b59-c55d-429d-a347-7beacc160822', 'distributor');
SELECT public.create_user('f21f083a-34e8-480a-84df-1871d9a01cdc', 'procurement@cerp.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f21f083a-34e8-480a-84df-1871d9a01cdc', 'procurement@cerp.com', 'Emma Johnson', 'vendor', 'CERP Bretagne Atlantique', '+501-5168171', '157 Main St, Business Quarter, 98665, France', 'Business Quarter', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('67b67a26-eb93-49e5-aec0-8c1b97ef7c18', 'f21f083a-34e8-480a-84df-1871d9a01cdc', 'CERP Bretagne Atlantique', 'REG-651790', 'Pharmaceuticals', 4.2, 'Emma Johnson', 'procurement@cerp.com', '+501-5168171', '157 Main St, Business Quarter, 98665, France', 'Business Quarter', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', 'b4ce105a-2b79-4355-bdc6-398b8aff8356', 'distributor');
SELECT public.create_user('d64f68b5-d5ce-4680-952d-ed427a3bf881', 'procurement@medtronicfrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d64f68b5-d5ce-4680-952d-ed427a3bf881', 'procurement@medtronicfrance.com', 'David Davis', 'vendor', 'Medtronic France S.A.S.', '+199-8360031', '917 Business Park, Business Quarter, 79352, France', 'Business Quarter', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c8a2fda5-90c3-4b56-95cb-8cf19b7e3304', 'd64f68b5-d5ce-4680-952d-ed427a3bf881', 'Medtronic France S.A.S.', 'REG-828136', 'Pharmaceuticals', 4.7, 'David Davis', 'procurement@medtronicfrance.com', '+199-8360031', '917 Business Park, Business Quarter, 79352, France', 'Business Quarter', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', 'f8778460-09a9-430c-8820-e198ab90e0e9', 'distributor');
SELECT public.create_user('86089569-a6c3-4efe-bb67-5dbb2e10fe7a', 'procurement@j&jmedicalfrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('86089569-a6c3-4efe-bb67-5dbb2e10fe7a', 'procurement@j&jmedicalfrance.com', 'Emma Davis', 'vendor', 'Johnson & Johnson Medical France', '+823-3550571', '246 Business Park, City Center, 72584, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('58e944ff-548d-4339-ad7f-8531b4520817', '86089569-a6c3-4efe-bb67-5dbb2e10fe7a', 'Johnson & Johnson Medical France', 'REG-979238', 'Pharmaceuticals', 3.8, 'Emma Davis', 'procurement@j&jmedicalfrance.com', '+823-3550571', '246 Business Park, City Center, 72584, France', 'City Center', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', '95798b23-3763-4930-bb01-cfb21c87f0a6', 'distributor');
SELECT public.create_user('37de00de-1fca-4931-ab0d-2541481b863e', 'procurement@gehealthcarefrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('37de00de-1fca-4931-ab0d-2541481b863e', 'procurement@gehealthcarefrance.com', 'Michael Williams', 'vendor', 'GE Healthcare France', '+642-5711041', '954 Main St, City Center, 65342, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fc7367db-e488-43b9-a0d5-5af75a65955c', '37de00de-1fca-4931-ab0d-2541481b863e', 'GE Healthcare France', 'REG-715852', 'Pharmaceuticals', 3.9, 'Michael Williams', 'procurement@gehealthcarefrance.com', '+642-5711041', '954 Main St, City Center, 65342, France', 'City Center', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', '93827d35-b297-47e7-a7b7-3009a2eded09', 'distributor');
SELECT public.create_user('3ca14aff-7102-47b9-900f-cdb317e06ec8', 'procurement@philipshealthcarefrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('3ca14aff-7102-47b9-900f-cdb317e06ec8', 'procurement@philipshealthcarefrance.com', 'David Johnson', 'vendor', 'Philips France S.A.S.', '+510-7252164', '612 Industrial Way, City Center, 83240, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('9de58a33-c61e-4d41-9613-67d9de0d8173', '3ca14aff-7102-47b9-900f-cdb317e06ec8', 'Philips France S.A.S.', 'REG-907804', 'Pharmaceuticals', 4.6, 'David Johnson', 'procurement@philipshealthcarefrance.com', '+510-7252164', '612 Industrial Way, City Center, 83240, France', 'City Center', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', 'd7f599dc-63ac-4eea-9641-e65c42384435', 'distributor');
SELECT public.create_user('89b49c89-ce9c-4c8b-ae3d-aa6631140eb4', 'procurement@strykerfrance.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('89b49c89-ce9c-4c8b-ae3d-aa6631140eb4', 'procurement@strykerfrance.com', 'David Davis', 'vendor', 'Stryker France S.A.S.', '+503-9561110', '224 Industrial Way, City Center, 41845, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c890690e-0a08-4f67-8a95-34a5676ce042', '89b49c89-ce9c-4c8b-ae3d-aa6631140eb4', 'Stryker France S.A.S.', 'REG-168113', 'Pharmaceuticals', 4.4, 'David Davis', 'procurement@strykerfrance.com', '+503-9561110', '224 Industrial Way, City Center, 41845, France', 'City Center', 'France', true, '', '{"France"}', '{"Pharmaceuticals"}', '619d4bab-f249-4145-91c6-d681a63f94de', 'distributor');
SELECT public.create_user('89d01949-4edc-4533-a3e6-15b0c0e4873c', 'procurement@premier.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('89d01949-4edc-4533-a3e6-15b0c0e4873c', 'procurement@premier.com', 'John Williams', 'vendor', 'Premier Healthcare FR', '+766-2775528', '802 Business Park, City Center, 99727, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('4df0f1f6-8995-4c80-b12d-d5962e17fd11', '89d01949-4edc-4533-a3e6-15b0c0e4873c', 'Premier Healthcare FR', 'REG-577336', 'Generic Drugs', 4.3, 'John Williams', 'procurement@premier.com', '+766-2775528', '802 Business Park, City Center, 99727, France', 'City Center', 'France', true, 'FR  121960414', '{"France"}', '{"Generic Drugs","Biologics","Pharmaceuticals","Vaccines"}', '08bc0b8e-3884-4dc0-a6b5-62fcd8d054d9', 'distributor');
SELECT public.create_user('85267728-d25d-4316-8d32-c95c9bbd7c4d', 'procurement@med.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('85267728-d25d-4316-8d32-c95c9bbd7c4d', 'procurement@med.com', 'Michael Williams', 'vendor', 'Med Healthcare FR', '+905-1136712', '246 Business Park, City Center, 76634, France', 'City Center', 'France', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('36e1c59e-9e4c-4b38-8c92-a572faa5373b', '85267728-d25d-4316-8d32-c95c9bbd7c4d', 'Med Healthcare FR', 'REG-913524', 'Biologics', 4.8, 'Michael Williams', 'procurement@med.com', '+905-1136712', '246 Business Park, City Center, 76634, France', 'City Center', 'France', true, 'FR  255123994', '{"France"}', '{"Biologics","Vaccines"}', '80fda387-bee6-4cbe-826e-dcda671be59c', 'distributor');

-- VENDORS FOR GERMANY
SELECT public.create_user('22ffcbb5-8e3b-4f45-b1da-7b8fca404b40', 'procurement@phoenix.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('22ffcbb5-8e3b-4f45-b1da-7b8fca404b40', 'procurement@phoenix.com', 'John Jones', 'vendor', 'Phoenix Pharma SE', '+142-1616226', '582 Industrial Way, City Center, 69868, Germany', 'City Center', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e73e9221-75e9-4fae-8ddd-6e5d65fcfae7', '22ffcbb5-8e3b-4f45-b1da-7b8fca404b40', 'Phoenix Pharma SE', 'REG-524435', 'Pharmaceuticals', 4.7, 'John Jones', 'procurement@phoenix.com', '+142-1616226', '582 Industrial Way, City Center, 69868, Germany', 'City Center', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '2afacb96-e741-42ad-93df-bb04fa0b58b0', 'distributor');
SELECT public.create_user('48e2e43c-88b9-439b-bf05-8dd6a328646b', 'procurement@alliancehealthcare.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('48e2e43c-88b9-439b-bf05-8dd6a328646b', 'procurement@alliancehealthcare.com', 'Lisa Davis', 'vendor', 'Alliance Healthcare Deutschland GmbH', '+707-5969105', '944 Commerce Blvd, Industrial District, 97637, Germany', 'Industrial District', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('226f09cb-ba10-42b7-ae75-249c3035b714', '48e2e43c-88b9-439b-bf05-8dd6a328646b', 'Alliance Healthcare Deutschland GmbH', 'REG-306363', 'Pharmaceuticals', 4.4, 'Lisa Davis', 'procurement@alliancehealthcare.com', '+707-5969105', '944 Commerce Blvd, Industrial District, 97637, Germany', 'Industrial District', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '80d904d0-e3ac-4190-b07c-dcc35e21f589', 'distributor');
SELECT public.create_user('ccc68c17-e799-4b93-abe7-ae87eaa4f39a', 'procurement@gehe.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ccc68c17-e799-4b93-abe7-ae87eaa4f39a', 'procurement@gehe.com', 'John Smith', 'vendor', 'Gehe Pharma Handel GmbH', '+691-8081001', '593 Business Park, Business Quarter, 36847, Germany', 'Business Quarter', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ce2091d1-2d97-4533-a97c-4949be985c8b', 'ccc68c17-e799-4b93-abe7-ae87eaa4f39a', 'Gehe Pharma Handel GmbH', 'REG-881519', 'Pharmaceuticals', 4.2, 'John Smith', 'procurement@gehe.com', '+691-8081001', '593 Business Park, Business Quarter, 36847, Germany', 'Business Quarter', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '9ff7b26d-bd5e-432a-9b9f-d61836cf300d', 'distributor');
SELECT public.create_user('e6beed50-5310-4ae3-8526-c906a8b37867', 'procurement@noweda.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e6beed50-5310-4ae3-8526-c906a8b37867', 'procurement@noweda.com', 'Emma Williams', 'vendor', 'Noweda eG', '+297-1106643', '39 Commerce Blvd, Industrial District, 60537, Germany', 'Industrial District', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d968084f-9350-42fc-b6f5-22d62076e83f', 'e6beed50-5310-4ae3-8526-c906a8b37867', 'Noweda eG', 'REG-634204', 'Pharmaceuticals', 4.9, 'Emma Williams', 'procurement@noweda.com', '+297-1106643', '39 Commerce Blvd, Industrial District, 60537, Germany', 'Industrial District', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '93035f49-67b5-45bb-a8db-70f67960a332', 'distributor');
SELECT public.create_user('f72e7d62-9a68-4efb-a6b4-ccc6a2ff17da', 'procurement@freseniusmedicalcare.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f72e7d62-9a68-4efb-a6b4-ccc6a2ff17da', 'procurement@freseniusmedicalcare.com', 'David Smith', 'vendor', 'Fresenius Medical Care Deutschland GmbH', '+796-7542876', '157 Industrial Way, Industrial District, 23020, Germany', 'Industrial District', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('bd0999bb-576b-4f4a-9373-15548f792f6f', 'f72e7d62-9a68-4efb-a6b4-ccc6a2ff17da', 'Fresenius Medical Care Deutschland GmbH', 'REG-596969', 'Pharmaceuticals', 4.6, 'David Smith', 'procurement@freseniusmedicalcare.com', '+796-7542876', '157 Industrial Way, Industrial District, 23020, Germany', 'Industrial District', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '98529450-9db8-40cf-a50a-b8ea188dc0f7', 'distributor');
SELECT public.create_user('0c883f1a-9455-42bf-baba-a1136722e1d3', 'procurement@siemenshealthineers.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0c883f1a-9455-42bf-baba-a1136722e1d3', 'procurement@siemenshealthineers.com', 'David Brown', 'vendor', 'Siemens Healthineers Distribution GmbH', '+456-6482399', '61 Commerce Blvd, Industrial District, 35941, Germany', 'Industrial District', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f00c159e-9d5c-4812-9f9d-e621b3f7722b', '0c883f1a-9455-42bf-baba-a1136722e1d3', 'Siemens Healthineers Distribution GmbH', 'REG-712716', 'Pharmaceuticals', 4.1, 'David Brown', 'procurement@siemenshealthineers.com', '+456-6482399', '61 Commerce Blvd, Industrial District, 35941, Germany', 'Industrial District', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '63cf7621-01fb-4cb7-8f17-624ad63cc564', 'distributor');
SELECT public.create_user('dcda73a6-67d2-4b7c-ad1b-68800bc85df0', 'procurement@dräger.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('dcda73a6-67d2-4b7c-ad1b-68800bc85df0', 'procurement@dräger.com', 'Michael Johnson', 'vendor', 'Drägerwerk AG & Co. KGaA', '+964-1159710', '928 Business Park, City Center, 51800, Germany', 'City Center', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f5f8d9ea-acc3-49ae-9d66-390f233878ee', 'dcda73a6-67d2-4b7c-ad1b-68800bc85df0', 'Drägerwerk AG & Co. KGaA', 'REG-699688', 'Pharmaceuticals', 4.8, 'Michael Johnson', 'procurement@dräger.com', '+964-1159710', '928 Business Park, City Center, 51800, Germany', 'City Center', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '583ce089-5e28-4961-8be1-61ee87cbf823', 'distributor');
SELECT public.create_user('8b0ec812-dcd3-4574-bfc2-b41d2dea767c', 'procurement@b.braun.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('8b0ec812-dcd3-4574-bfc2-b41d2dea767c', 'procurement@b.braun.com', 'David Williams', 'vendor', 'B. Braun Melsungen AG', '+178-4787952', '754 Commerce Blvd, City Center, 52709, Germany', 'City Center', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a3332e4e-e9f6-451f-a41f-5026b7955dee', '8b0ec812-dcd3-4574-bfc2-b41d2dea767c', 'B. Braun Melsungen AG', 'REG-156404', 'Pharmaceuticals', 4.9, 'David Williams', 'procurement@b.braun.com', '+178-4787952', '754 Commerce Blvd, City Center, 52709, Germany', 'City Center', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '6230f21b-ceca-4e1a-942c-054d422359eb', 'distributor');
SELECT public.create_user('6fed7567-2daa-4a24-aa82-06c04e051b7b', 'procurement@karlstorz.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6fed7567-2daa-4a24-aa82-06c04e051b7b', 'procurement@karlstorz.com', 'Sarah Smith', 'vendor', 'Karl Storz SE & Co. KG', '+841-6928268', '284 Commerce Blvd, Business Quarter, 57047, Germany', 'Business Quarter', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e3b56d90-34c6-4f34-96c5-28d3a92ff5c1', '6fed7567-2daa-4a24-aa82-06c04e051b7b', 'Karl Storz SE & Co. KG', 'REG-570883', 'Pharmaceuticals', 4.6, 'Sarah Smith', 'procurement@karlstorz.com', '+841-6928268', '284 Commerce Blvd, Business Quarter, 57047, Germany', 'Business Quarter', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', 'c477ff47-2e8a-4fc0-abc8-566dddf30aad', 'distributor');
SELECT public.create_user('f90132f4-6ceb-4a0e-9eeb-7b5401ce2c94', 'procurement@olympusmedical.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f90132f4-6ceb-4a0e-9eeb-7b5401ce2c94', 'procurement@olympusmedical.com', 'Emma Smith', 'vendor', 'Olympus Europa SE & Co. KG', '+584-7853823', '483 Industrial Way, Business Quarter, 64232, Germany', 'Business Quarter', 'Germany', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('391bbaf2-6e2d-4302-8049-3957e679ba73', 'f90132f4-6ceb-4a0e-9eeb-7b5401ce2c94', 'Olympus Europa SE & Co. KG', 'REG-984577', 'Pharmaceuticals', 3.9, 'Emma Smith', 'procurement@olympusmedical.com', '+584-7853823', '483 Industrial Way, Business Quarter, 64232, Germany', 'Business Quarter', 'Germany', true, '', '{"Germany"}', '{"Pharmaceuticals"}', '50e6347a-1335-4af4-a327-b57a9cf6eff9', 'distributor');

-- VENDORS FOR GREECE
SELECT public.create_user('d65deae0-d4b8-424c-95d7-904ab91d8c98', 'procurement@medtronicgreece.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d65deae0-d4b8-424c-95d7-904ab91d8c98', 'procurement@medtronicgreece.com', 'Lisa Smith', 'vendor', 'Medtronic Hellas S.A.', '+918-9133874', '488 Industrial Way, Business Quarter, 21286, Greece', 'Business Quarter', 'Greece', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('40ec6a88-539f-4191-b8d0-fe4a96296d6f', 'd65deae0-d4b8-424c-95d7-904ab91d8c98', 'Medtronic Hellas S.A.', 'REG-571270', 'Pharmaceuticals', 4.8, 'Lisa Smith', 'procurement@medtronicgreece.com', '+918-9133874', '488 Industrial Way, Business Quarter, 21286, Greece', 'Business Quarter', 'Greece', true, '', '{"Greece"}', '{"Pharmaceuticals"}', '85c11406-f643-4705-9439-bc335ca87128', 'distributor');
SELECT public.create_user('59b930d4-8af0-4414-9e55-4df1d797f86e', 'procurement@bbraungreece.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('59b930d4-8af0-4414-9e55-4df1d797f86e', 'procurement@bbraungreece.com', 'Lisa Williams', 'vendor', 'B Braun Hellas S.A.', '+625-7136522', '704 Industrial Way, Industrial District, 11999, Greece', 'Industrial District', 'Greece', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('65d01127-b8eb-4231-aa4c-00fc025ead21', '59b930d4-8af0-4414-9e55-4df1d797f86e', 'B Braun Hellas S.A.', 'REG-792166', 'Pharmaceuticals', 3.6, 'Lisa Williams', 'procurement@bbraungreece.com', '+625-7136522', '704 Industrial Way, Industrial District, 11999, Greece', 'Industrial District', 'Greece', true, '', '{"Greece"}', '{"Pharmaceuticals"}', '1543fb46-1c14-432a-96fd-940615808f08', 'distributor');
SELECT public.create_user('30ef88df-d60c-4594-ba34-02e5e40d286b', 'procurement@global.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('30ef88df-d60c-4594-ba34-02e5e40d286b', 'procurement@global.com', 'David Jones', 'vendor', 'Global Medical Greece', '+837-7764929', '478 Commerce Blvd, Industrial District, 18950, Greece', 'Industrial District', 'Greece', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('701b0638-8fee-4d2d-b982-84cad0102a04', '30ef88df-d60c-4594-ba34-02e5e40d286b', 'Global Medical Greece', 'REG-127641', 'Vaccines', 4.5, 'David Jones', 'procurement@global.com', '+837-7764929', '478 Commerce Blvd, Industrial District, 18950, Greece', 'Industrial District', 'Greece', true, 'EL696318263', '{"Greece"}', '{"Vaccines","Generic Drugs","Pharmaceuticals"}', '155f3405-f968-49d0-8c93-51a5873b87b2', 'distributor');
SELECT public.create_user('15ea2c83-d3cd-4f42-b1c9-fd45a0d5da2e', 'procurement@pan-european.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('15ea2c83-d3cd-4f42-b1c9-fd45a0d5da2e', 'procurement@pan-european.com', 'David Davis', 'vendor', 'Pan-European Distribution Greece', '+707-6233414', '494 Commerce Blvd, Industrial District, 95312, Greece', 'Industrial District', 'Greece', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('34b84543-76be-47c8-90fb-de071df04524', '15ea2c83-d3cd-4f42-b1c9-fd45a0d5da2e', 'Pan-European Distribution Greece', 'REG-905465', 'Anesthesia', 4.0, 'David Davis', 'procurement@pan-european.com', '+707-6233414', '494 Commerce Blvd, Industrial District, 95312, Greece', 'Industrial District', 'Greece', true, 'EL928467676', '{"Greece"}', '{"Anesthesia","Dental","Cardiology","Consumables"}', 'b5ed4334-777f-491d-aa0a-063a0232a983', 'distributor');
SELECT public.create_user('f6abe028-ed64-46a5-9a54-e260d2d48ba2', 'procurement@sanus.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f6abe028-ed64-46a5-9a54-e260d2d48ba2', 'procurement@sanus.com', 'Emma Johnson', 'vendor', 'Sanus Healthcare GR', '+206-7427223', '276 Industrial Way, City Center, 78239, Greece', 'City Center', 'Greece', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('bccb631c-b3f0-4443-bded-ac5848b75a6e', 'f6abe028-ed64-46a5-9a54-e260d2d48ba2', 'Sanus Healthcare GR', 'REG-686051', 'Optical', 4.5, 'Emma Johnson', 'procurement@sanus.com', '+206-7427223', '276 Industrial Way, City Center, 78239, Greece', 'City Center', 'Greece', true, 'EL301243273', '{"Greece"}', '{"Optical","Patient Monitoring","Orthopedics","OTC"}', '305688c7-03ff-4e8a-8994-fc0e1977e6b9', 'distributor');

-- VENDORS FOR HUNGARY
SELECT public.create_user('00ac848a-4e73-4d66-92b8-ba699e202708', 'procurement@medtronichungary.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('00ac848a-4e73-4d66-92b8-ba699e202708', 'procurement@medtronichungary.com', 'Sarah Jones', 'vendor', 'Medtronic Hungary Kft', '+649-8011864', '761 Commerce Blvd, Business Quarter, 76497, Hungary', 'Business Quarter', 'Hungary', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('44e4c9ec-70cd-46ae-85ff-b8fb5e74179e', '00ac848a-4e73-4d66-92b8-ba699e202708', 'Medtronic Hungary Kft', 'REG-651364', 'Pharmaceuticals', 4.0, 'Sarah Jones', 'procurement@medtronichungary.com', '+649-8011864', '761 Commerce Blvd, Business Quarter, 76497, Hungary', 'Business Quarter', 'Hungary', true, '', '{"Hungary"}', '{"Pharmaceuticals"}', '0f386264-07be-475c-906b-8c9f7fffec57', 'distributor');
SELECT public.create_user('ef608491-697b-426c-ae8c-4f91b768cb32', 'procurement@siemenshungary.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ef608491-697b-426c-ae8c-4f91b768cb32', 'procurement@siemenshungary.com', 'Michael Johnson', 'vendor', 'Siemens Healthineers Kft', '+595-3451118', '994 Industrial Way, Industrial District, 95949, Hungary', 'Industrial District', 'Hungary', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('be46a023-9097-4db7-a0bc-9534bb239a11', 'ef608491-697b-426c-ae8c-4f91b768cb32', 'Siemens Healthineers Kft', 'REG-674751', 'Pharmaceuticals', 4.2, 'Michael Johnson', 'procurement@siemenshungary.com', '+595-3451118', '994 Industrial Way, Industrial District, 95949, Hungary', 'Industrial District', 'Hungary', true, '', '{"Hungary"}', '{"Pharmaceuticals"}', '7bf63c21-730c-4e4c-a4b5-6be82161f17e', 'distributor');
SELECT public.create_user('894d1ee4-a201-4db6-8513-920112e84d39', 'procurement@optima.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('894d1ee4-a201-4db6-8513-920112e84d39', 'procurement@optima.com', 'Lisa Williams', 'vendor', 'Optima Pharma Hungary Kft', '+798-6438556', '524 Commerce Blvd, City Center, 82092, Hungary', 'City Center', 'Hungary', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('6bf5e038-bc48-41e1-a3a7-2b2c58ca03b3', '894d1ee4-a201-4db6-8513-920112e84d39', 'Optima Pharma Hungary Kft', 'REG-641077', 'Optical', 4.7, 'Lisa Williams', 'procurement@optima.com', '+798-6438556', '524 Commerce Blvd, City Center, 82092, Hungary', 'City Center', 'Hungary', true, 'HU783098234', '{"Hungary"}', '{"Optical","Radiology","Laboratory"}', 'dd79a379-5ea2-440e-91ed-eee124041e8b', 'distributor');
SELECT public.create_user('0a7c75a4-39cf-4d1c-887e-15d46f834e4b', 'procurement@select.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0a7c75a4-39cf-4d1c-887e-15d46f834e4b', 'procurement@select.com', 'Sarah Brown', 'vendor', 'Select Pharma Hungary Kft', '+411-4953776', '821 Main St, City Center, 90996, Hungary', 'City Center', 'Hungary', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('df6456ca-dcc9-4236-ad2f-0d9ada641f0d', '0a7c75a4-39cf-4d1c-887e-15d46f834e4b', 'Select Pharma Hungary Kft', 'REG-949700', 'Optical', 4.7, 'Sarah Brown', 'procurement@select.com', '+411-4953776', '821 Main St, City Center, 90996, Hungary', 'City Center', 'Hungary', true, 'HU250184093', '{"Hungary"}', '{"Optical","Laboratory","Consumables","Cardiology"}', '25d40763-d1e5-448f-9ddf-4b53e28215a4', 'distributor');
SELECT public.create_user('c20f1ed2-4573-45d7-b42c-fc3719e9bf86', 'procurement@continental.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c20f1ed2-4573-45d7-b42c-fc3719e9bf86', 'procurement@continental.com', 'David Smith', 'vendor', 'Continental Pharma Hungary Kft', '+795-9571657', '231 Industrial Way, Industrial District, 15403, Hungary', 'Industrial District', 'Hungary', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e74f99c8-aeca-4c93-b7ad-4276e97a4e76', 'c20f1ed2-4573-45d7-b42c-fc3719e9bf86', 'Continental Pharma Hungary Kft', 'REG-401706', 'Orthopedics', 3.7, 'David Smith', 'procurement@continental.com', '+795-9571657', '231 Industrial Way, Industrial District, 15403, Hungary', 'Industrial District', 'Hungary', true, 'HU541451380', '{"Hungary"}', '{"Orthopedics","Consumables","Wound Care"}', '0b5e241e-5438-44d8-adbd-32389a35b76d', 'distributor');

-- VENDORS FOR IRELAND
SELECT public.create_user('ae4432c8-2422-45bd-b23d-8f433589dc57', 'procurement@medtronicireland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ae4432c8-2422-45bd-b23d-8f433589dc57', 'procurement@medtronicireland.com', 'David Smith', 'vendor', 'Medtronic Ireland', '+173-2132577', '887 Main St, Industrial District, 77320, Ireland', 'Industrial District', 'Ireland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('cc2764dd-3626-4ca7-a8ee-506877b94a92', 'ae4432c8-2422-45bd-b23d-8f433589dc57', 'Medtronic Ireland', 'REG-570452', 'Pharmaceuticals', 3.8, 'David Smith', 'procurement@medtronicireland.com', '+173-2132577', '887 Main St, Industrial District, 77320, Ireland', 'Industrial District', 'Ireland', true, '', '{"Ireland"}', '{"Pharmaceuticals"}', 'ffdc0297-a4d0-49a5-a843-4d331b4006b5', 'distributor');
SELECT public.create_user('cb38834e-6d44-4d17-bcb1-f0d71a7fd5f0', 'procurement@strykerireland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cb38834e-6d44-4d17-bcb1-f0d71a7fd5f0', 'procurement@strykerireland.com', 'David Brown', 'vendor', 'Stryker Ireland Ltd', '+268-9640257', '327 Industrial Way, City Center, 35017, Ireland', 'City Center', 'Ireland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('30f9f0ca-63db-42d9-99b8-1f56361aed60', 'cb38834e-6d44-4d17-bcb1-f0d71a7fd5f0', 'Stryker Ireland Ltd', 'REG-408959', 'Pharmaceuticals', 3.9, 'David Brown', 'procurement@strykerireland.com', '+268-9640257', '327 Industrial Way, City Center, 35017, Ireland', 'City Center', 'Ireland', true, '', '{"Ireland"}', '{"Pharmaceuticals"}', 'cc045236-c81a-4cb2-8e55-d6b00c19e0a8', 'distributor');
SELECT public.create_user('4ba7552f-8a66-4257-a228-9ccb9b771db1', 'procurement@optima.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('4ba7552f-8a66-4257-a228-9ccb9b771db1', 'procurement@optima.com', 'John Williams', 'vendor', 'Optima Medical Ireland', '+119-7119951', '231 Main St, Industrial District, 89316, Ireland', 'Industrial District', 'Ireland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('cc3bb9ac-7aa9-4e75-acfb-d3165b105a71', '4ba7552f-8a66-4257-a228-9ccb9b771db1', 'Optima Medical Ireland', 'REG-359810', 'Anesthesia', 4.0, 'John Williams', 'procurement@optima.com', '+119-7119951', '231 Main St, Industrial District, 89316, Ireland', 'Industrial District', 'Ireland', true, 'IE103861232A', '{"Ireland"}', '{"Anesthesia","Optical"}', 'fac9d9d2-006a-4453-80bf-de64ebd9f303', 'distributor');
SELECT public.create_user('61d37c9a-76f4-4b2c-b54d-7072e538b7e3', 'procurement@pan-european.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('61d37c9a-76f4-4b2c-b54d-7072e538b7e3', 'procurement@pan-european.com', 'Lisa Davis', 'vendor', 'Pan-European Pharma Ireland Ltd', '+570-7812041', '96 Main St, Industrial District, 91058, Ireland', 'Industrial District', 'Ireland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('72fd19c5-fec0-4c43-98b8-73309f2c552a', '61d37c9a-76f4-4b2c-b54d-7072e538b7e3', 'Pan-European Pharma Ireland Ltd', 'REG-252955', 'Pharmaceuticals', 4.4, 'Lisa Davis', 'procurement@pan-european.com', '+570-7812041', '96 Main St, Industrial District, 91058, Ireland', 'Industrial District', 'Ireland', true, 'IE794754535A', '{"Ireland"}', '{"Pharmaceuticals","Vaccines"}', 'ab9c15b3-1183-4dbf-8e0d-ac142666b1c9', 'distributor');
SELECT public.create_user('099ea178-8853-42d9-9416-89a389931fb7', 'procurement@sanus.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('099ea178-8853-42d9-9416-89a389931fb7', 'procurement@sanus.com', 'Lisa Johnson', 'vendor', 'Sanus Healthcare IE', '+437-4862996', '576 Business Park, Industrial District, 55857, Ireland', 'Industrial District', 'Ireland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5c87b07d-de1e-4b28-8289-278a6db7dcc5', '099ea178-8853-42d9-9416-89a389931fb7', 'Sanus Healthcare IE', 'REG-826894', 'Generic Drugs', 4.0, 'Lisa Johnson', 'procurement@sanus.com', '+437-4862996', '576 Business Park, Industrial District, 55857, Ireland', 'Industrial District', 'Ireland', true, 'IE365004410A', '{"Ireland"}', '{"Generic Drugs","Branded Pharma","Biologics"}', '0035aef4-1305-48da-abb2-5d5974ca7ff4', 'distributor');

-- VENDORS FOR ITALY
SELECT public.create_user('d2e2947a-ac6f-4379-a536-1a4b3f8be687', 'procurement@farmasfera.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d2e2947a-ac6f-4379-a536-1a4b3f8be687', 'procurement@farmasfera.com', 'Lisa Smith', 'vendor', 'FarmaSfera S.p.A.', '+954-1378440', '48 Industrial Way, Industrial District, 32679, Italy', 'Industrial District', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d82d5e34-5778-4456-9c3c-aa1d90e0869c', 'd2e2947a-ac6f-4379-a536-1a4b3f8be687', 'FarmaSfera S.p.A.', 'REG-767778', 'Pharmaceuticals', 4.3, 'Lisa Smith', 'procurement@farmasfera.com', '+954-1378440', '48 Industrial Way, Industrial District, 32679, Italy', 'Industrial District', 'Italy', true, '', '{"Italy"}', '{"Pharmaceuticals"}', 'f1d5b07d-4164-4e33-82c2-f330e7f522d7', 'distributor');
SELECT public.create_user('6e54131f-41a7-48fb-9577-1db5b172d434', 'procurement@cmfarmaceutici.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6e54131f-41a7-48fb-9577-1db5b172d434', 'procurement@cmfarmaceutici.com', 'David Johnson', 'vendor', 'Gruppo C.M. Farmaceutici S.p.A.', '+149-4490957', '243 Industrial Way, Industrial District, 64854, Italy', 'Industrial District', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a7c5ba44-cbd5-4c3e-b6f8-78a815c69291', '6e54131f-41a7-48fb-9577-1db5b172d434', 'Gruppo C.M. Farmaceutici S.p.A.', 'REG-506896', 'Pharmaceuticals', 4.8, 'David Johnson', 'procurement@cmfarmaceutici.com', '+149-4490957', '243 Industrial Way, Industrial District, 64854, Italy', 'Industrial District', 'Italy', true, '', '{"Italy"}', '{"Pharmaceuticals"}', '72d018b4-fcfc-4bcf-8df6-37fee4159bc9', 'distributor');
SELECT public.create_user('98eae9fa-b904-4240-a38a-4e7c5cbd2cd0', 'procurement@medtronicitalia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('98eae9fa-b904-4240-a38a-4e7c5cbd2cd0', 'procurement@medtronicitalia.com', 'John Brown', 'vendor', 'Medtronic Italia S.p.A.', '+273-4104251', '748 Industrial Way, Industrial District, 86927, Italy', 'Industrial District', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fb5a00b9-22c5-4332-a6f5-c4182bde51e6', '98eae9fa-b904-4240-a38a-4e7c5cbd2cd0', 'Medtronic Italia S.p.A.', 'REG-646592', 'Pharmaceuticals', 4.9, 'John Brown', 'procurement@medtronicitalia.com', '+273-4104251', '748 Industrial Way, Industrial District, 86927, Italy', 'Industrial District', 'Italy', true, '', '{"Italy"}', '{"Pharmaceuticals"}', 'ec4af7f3-f8d3-4ba2-9dd9-3e41169cf46b', 'distributor');
SELECT public.create_user('f4e4af00-7c65-4752-bbbc-e5a3a3dbc79f', 'procurement@siemensitaly.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f4e4af00-7c65-4752-bbbc-e5a3a3dbc79f', 'procurement@siemensitaly.com', 'Lisa Johnson', 'vendor', 'Siemens Healthineers Italy S.p.A.', '+516-8586243', '655 Business Park, Industrial District, 82496, Italy', 'Industrial District', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e74817c9-d583-45f4-ab71-9add09f0e411', 'f4e4af00-7c65-4752-bbbc-e5a3a3dbc79f', 'Siemens Healthineers Italy S.p.A.', 'REG-237070', 'Pharmaceuticals', 4.6, 'Lisa Johnson', 'procurement@siemensitaly.com', '+516-8586243', '655 Business Park, Industrial District, 82496, Italy', 'Industrial District', 'Italy', true, '', '{"Italy"}', '{"Pharmaceuticals"}', '7c4e1727-fa77-49d1-b994-b6e61b207572', 'distributor');
SELECT public.create_user('905c4cf7-83e5-467e-ae2f-59657463992d', 'procurement@freseniusitalia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('905c4cf7-83e5-467e-ae2f-59657463992d', 'procurement@freseniusitalia.com', 'Sarah Brown', 'vendor', 'Fresenius Medical Care Italia S.p.A.', '+902-4724833', '336 Commerce Blvd, City Center, 49097, Italy', 'City Center', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('351796a6-b60c-41e4-8c43-bf4cb3a1e759', '905c4cf7-83e5-467e-ae2f-59657463992d', 'Fresenius Medical Care Italia S.p.A.', 'REG-354016', 'Pharmaceuticals', 4.8, 'Sarah Brown', 'procurement@freseniusitalia.com', '+902-4724833', '336 Commerce Blvd, City Center, 49097, Italy', 'City Center', 'Italy', true, '', '{"Italy"}', '{"Pharmaceuticals"}', 'd5a95070-8cb4-4e96-9f18-0d33d72f7e3c', 'distributor');
SELECT public.create_user('8d9d0265-890f-449d-ab03-6c45e1ef903a', 'procurement@advanced.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('8d9d0265-890f-449d-ab03-6c45e1ef903a', 'procurement@advanced.com', 'Sarah Jones', 'vendor', 'Advanced Pharma Italia S.p.A.', '+236-9086484', '33 Commerce Blvd, City Center, 80122, Italy', 'City Center', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fb7c1c8b-7a59-425d-af3e-3b488e2db547', '8d9d0265-890f-449d-ab03-6c45e1ef903a', 'Advanced Pharma Italia S.p.A.', 'REG-750914', 'Biologics', 3.7, 'Sarah Jones', 'procurement@advanced.com', '+236-9086484', '33 Commerce Blvd, City Center, 80122, Italy', 'City Center', 'Italy', true, 'IT  434087741', '{"Italy"}', '{"Biologics","Patient Monitoring","Consumables"}', '345b97b3-7882-460b-9650-db682bbd0a55', 'distributor');
SELECT public.create_user('523b471f-a552-4b49-8fd1-b4d3445d6cfd', 'procurement@baltic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('523b471f-a552-4b49-8fd1-b4d3445d6cfd', 'procurement@baltic.com', 'Emma Smith', 'vendor', 'Baltic Medical Italy', '+689-9201402', '793 Business Park, Industrial District, 71539, Italy', 'Industrial District', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('84c803ca-76cc-42e2-8326-8b4d2ad09833', '523b471f-a552-4b49-8fd1-b4d3445d6cfd', 'Baltic Medical Italy', 'REG-943084', 'Vaccines', 3.8, 'Emma Smith', 'procurement@baltic.com', '+689-9201402', '793 Business Park, Industrial District, 71539, Italy', 'Industrial District', 'Italy', true, 'IT  855861927', '{"Italy"}', '{"Vaccines","Generic Drugs"}', '2776391a-8f20-499c-87f9-58fa3bcaffbc', 'distributor');
SELECT public.create_user('5176fe44-9212-4dcd-86b5-d668116d21ad', 'procurement@pro.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('5176fe44-9212-4dcd-86b5-d668116d21ad', 'procurement@pro.com', 'David Williams', 'vendor', 'Pro Medical Italy', '+933-8961072', '677 Industrial Way, City Center, 72795, Italy', 'City Center', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('e47b2a81-ad6d-4e37-b7a7-45d2bf262163', '5176fe44-9212-4dcd-86b5-d668116d21ad', 'Pro Medical Italy', 'REG-444713', 'Vaccines', 4.9, 'David Williams', 'procurement@pro.com', '+933-8961072', '677 Industrial Way, City Center, 72795, Italy', 'City Center', 'Italy', true, 'IT  626433998', '{"Italy"}', '{"Vaccines","Pharmaceuticals","OTC","Biologics"}', '9b7d06ca-989f-496f-9f9b-3f74b9fcc2e2', 'distributor');
SELECT public.create_user('79b4e264-0af0-4553-99b3-02248afb88f7', 'procurement@pro.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('79b4e264-0af0-4553-99b3-02248afb88f7', 'procurement@pro.com', 'Sarah Williams', 'vendor', 'Pro Pharma Italia S.p.A.', '+617-8851725', '622 Commerce Blvd, City Center, 77439, Italy', 'City Center', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('28f26c34-bffc-499a-b4a4-f0f06d592c82', '79b4e264-0af0-4553-99b3-02248afb88f7', 'Pro Pharma Italia S.p.A.', 'REG-699074', 'Orthopedics', 4.7, 'Sarah Williams', 'procurement@pro.com', '+617-8851725', '622 Commerce Blvd, City Center, 77439, Italy', 'City Center', 'Italy', true, 'IT  884697696', '{"Italy"}', '{"Orthopedics","Anesthesia"}', '27d140fd-2d04-4818-80d9-207f14395f98', 'distributor');
SELECT public.create_user('26aadee6-929f-49d9-b09e-e956c1864c36', 'procurement@nova.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('26aadee6-929f-49d9-b09e-e956c1864c36', 'procurement@nova.com', 'Emma Davis', 'vendor', 'Nova Healthcare IT', '+848-5655962', '168 Industrial Way, Business Quarter, 75688, Italy', 'Business Quarter', 'Italy', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('141eb6d9-f8ba-4b9a-aeda-515b8b879c8d', '26aadee6-929f-49d9-b09e-e956c1864c36', 'Nova Healthcare IT', 'REG-749698', 'Vaccines', 3.8, 'Emma Davis', 'procurement@nova.com', '+848-5655962', '168 Industrial Way, Business Quarter, 75688, Italy', 'Business Quarter', 'Italy', true, 'IT  235791307', '{"Italy"}', '{"Vaccines","Pharmaceuticals"}', 'e9936163-a6dc-4638-9aa6-8a732b9ec859', 'distributor');

-- VENDORS FOR LATVIA
SELECT public.create_user('945c4790-1cde-4a11-9aa1-64f5dcceb628', 'procurement@medtroniclatvia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('945c4790-1cde-4a11-9aa1-64f5dcceb628', 'procurement@medtroniclatvia.com', 'Michael Johnson', 'vendor', 'Medtronic Latvia SIA', '+436-6335935', '446 Industrial Way, Business Quarter, 23481, Latvia', 'Business Quarter', 'Latvia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('06e9b0f4-fc29-4df2-8e38-22c44003d946', '945c4790-1cde-4a11-9aa1-64f5dcceb628', 'Medtronic Latvia SIA', 'REG-274909', 'Pharmaceuticals', 3.9, 'Michael Johnson', 'procurement@medtroniclatvia.com', '+436-6335935', '446 Industrial Way, Business Quarter, 23481, Latvia', 'Business Quarter', 'Latvia', true, '', '{"Latvia"}', '{"Pharmaceuticals"}', '6be860e4-c44c-4832-b510-354e4cf935ea', 'distributor');
SELECT public.create_user('9abd8d27-d557-47a3-82a9-7b48fcaf6b82', 'procurement@thera.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9abd8d27-d557-47a3-82a9-7b48fcaf6b82', 'procurement@thera.com', 'David Williams', 'vendor', 'Thera Medical Latvia', '+947-4797118', '277 Main St, Industrial District, 14036, Latvia', 'Industrial District', 'Latvia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a130e71c-9072-4f87-be85-68d4513edbf3', '9abd8d27-d557-47a3-82a9-7b48fcaf6b82', 'Thera Medical Latvia', 'REG-417423', 'Laboratory', 4.2, 'David Williams', 'procurement@thera.com', '+947-4797118', '277 Main St, Industrial District, 14036, Latvia', 'Industrial District', 'Latvia', true, 'LV  548698504', '{"Latvia"}', '{"Laboratory","Patient Monitoring","Radiology","Generic Drugs","Optical"}', 'd60253d1-2e2a-4986-bcc3-9f04002dbe48', 'distributor');
SELECT public.create_user('d818bd71-1608-4756-85c7-f1a8fa14d73b', 'procurement@alpine.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d818bd71-1608-4756-85c7-f1a8fa14d73b', 'procurement@alpine.com', 'John Jones', 'vendor', 'Alpine Healthcare LV', '+667-6439837', '972 Commerce Blvd, Industrial District, 80869, Latvia', 'Industrial District', 'Latvia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7ad4a510-7e8f-4345-bbe2-da8a38cab436', 'd818bd71-1608-4756-85c7-f1a8fa14d73b', 'Alpine Healthcare LV', 'REG-489735', 'Pharmaceuticals', 4.5, 'John Jones', 'procurement@alpine.com', '+667-6439837', '972 Commerce Blvd, Industrial District, 80869, Latvia', 'Industrial District', 'Latvia', true, 'LV  950879242', '{"Latvia"}', '{"Pharmaceuticals","Radiology","Consumables","Anesthesia","Orthopedics"}', '17e683d4-607b-4b75-b821-7eb0f50b6367', 'distributor');
SELECT public.create_user('ad264871-5e0c-465d-9828-2ab520c53a8f', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ad264871-5e0c-465d-9828-2ab520c53a8f', 'procurement@international.com', 'Lisa Jones', 'vendor', 'International Distribution Latvia', '+929-5933328', '493 Business Park, City Center, 79214, Latvia', 'City Center', 'Latvia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('16dd7e64-ef8b-4db5-9fdf-41c7342f0ce4', 'ad264871-5e0c-465d-9828-2ab520c53a8f', 'International Distribution Latvia', 'REG-680242', 'Wound Care', 4.0, 'Lisa Jones', 'procurement@international.com', '+929-5933328', '493 Business Park, City Center, 79214, Latvia', 'City Center', 'Latvia', true, 'LV  637377070', '{"Latvia"}', '{"Wound Care","Biologics","Diagnostics"}', 'f345540b-dbfa-40dc-b48e-25da49172373', 'distributor');
SELECT public.create_user('0435b2e5-9a6d-4712-996c-040f29c0afdc', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0435b2e5-9a6d-4712-996c-040f29c0afdc', 'procurement@allied.com', 'Sarah Davis', 'vendor', 'Allied Pharma Latvia SIA', '+709-7885376', '893 Main St, Industrial District, 43548, Latvia', 'Industrial District', 'Latvia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fe9f532f-3d19-4e09-9ac0-53774d15a6cb', '0435b2e5-9a6d-4712-996c-040f29c0afdc', 'Allied Pharma Latvia SIA', 'REG-676417', 'Pharmaceuticals', 4.7, 'Sarah Davis', 'procurement@allied.com', '+709-7885376', '893 Main St, Industrial District, 43548, Latvia', 'Industrial District', 'Latvia', true, 'LV  755661585', '{"Latvia"}', '{"Pharmaceuticals","Biologics"}', 'edbc4ef3-978c-40e4-a3d6-8336bb3fbe36', 'distributor');

-- VENDORS FOR LITHUANIA
SELECT public.create_user('0c543ef0-891a-4a52-bc78-8a7e175dd28e', 'procurement@medtroniclithuania.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0c543ef0-891a-4a52-bc78-8a7e175dd28e', 'procurement@medtroniclithuania.com', 'Sarah Williams', 'vendor', 'Medtronic Lithuania UAB', '+914-6352910', '809 Commerce Blvd, Industrial District, 59396, Lithuania', 'Industrial District', 'Lithuania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('950edca2-d41e-4fb1-a7f4-77117f70f84e', '0c543ef0-891a-4a52-bc78-8a7e175dd28e', 'Medtronic Lithuania UAB', 'REG-449711', 'Pharmaceuticals', 4.2, 'Sarah Williams', 'procurement@medtroniclithuania.com', '+914-6352910', '809 Commerce Blvd, Industrial District, 59396, Lithuania', 'Industrial District', 'Lithuania', true, '', '{"Lithuania"}', '{"Pharmaceuticals"}', '1667c989-ee84-4a2d-851c-b94c92ed3242', 'distributor');
SELECT public.create_user('c99d6d1d-5ed6-4467-b9ad-644ef5a90413', 'procurement@nova.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c99d6d1d-5ed6-4467-b9ad-644ef5a90413', 'procurement@nova.com', 'David Johnson', 'vendor', 'Nova Medical Lithuania', '+433-8518873', '243 Main St, Business Quarter, 38943, Lithuania', 'Business Quarter', 'Lithuania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1d8e9c42-9acf-47c8-b495-29723bd45996', 'c99d6d1d-5ed6-4467-b9ad-644ef5a90413', 'Nova Medical Lithuania', 'REG-516108', 'Consumables', 4.2, 'David Johnson', 'procurement@nova.com', '+433-8518873', '243 Main St, Business Quarter, 38943, Lithuania', 'Business Quarter', 'Lithuania', true, 'LT   335174730', '{"Lithuania"}', '{"Consumables","Anesthesia"}', '6a03411e-8666-470f-8f88-84af33538b75', 'distributor');
SELECT public.create_user('a79e99b9-9d48-46ff-9aab-ab244709017c', 'procurement@nordic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a79e99b9-9d48-46ff-9aab-ab244709017c', 'procurement@nordic.com', 'John Jones', 'vendor', 'Nordic Healthcare LT', '+132-8498877', '507 Main St, City Center, 30992, Lithuania', 'City Center', 'Lithuania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f83a69a8-8cdf-430a-989e-a1a8c4b13e39', 'a79e99b9-9d48-46ff-9aab-ab244709017c', 'Nordic Healthcare LT', 'REG-988624', 'Dental', 4.8, 'John Jones', 'procurement@nordic.com', '+132-8498877', '507 Main St, City Center, 30992, Lithuania', 'City Center', 'Lithuania', true, 'LT   582420115', '{"Lithuania"}', '{"Dental","Anesthesia"}', '7b2b22b5-8b91-4996-9b6d-4909488a4388', 'distributor');
SELECT public.create_user('cf513053-7760-4029-a9ef-0779f44ca934', 'procurement@trusted.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cf513053-7760-4029-a9ef-0779f44ca934', 'procurement@trusted.com', 'Sarah Williams', 'vendor', 'Trusted Healthcare LT', '+390-3346328', '749 Main St, Business Quarter, 19236, Lithuania', 'Business Quarter', 'Lithuania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1cf6982b-285c-4d70-a769-4c7259af662f', 'cf513053-7760-4029-a9ef-0779f44ca934', 'Trusted Healthcare LT', 'REG-767980', 'Branded Pharma', 3.9, 'Sarah Williams', 'procurement@trusted.com', '+390-3346328', '749 Main St, Business Quarter, 19236, Lithuania', 'Business Quarter', 'Lithuania', true, 'LT   849083067', '{"Lithuania"}', '{"Branded Pharma","Biologics","Vaccines","Generic Drugs"}', '180510fa-750c-4526-83d1-82e78530d923', 'distributor');
SELECT public.create_user('d11f65c7-ee57-466a-9ebe-2c629b9776c8', 'procurement@mediterranean.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d11f65c7-ee57-466a-9ebe-2c629b9776c8', 'procurement@mediterranean.com', 'Lisa Brown', 'vendor', 'Mediterranean Distribution Lithuania', '+865-3112881', '745 Commerce Blvd, City Center, 46852, Lithuania', 'City Center', 'Lithuania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('edb63fbb-f819-4eef-bb5c-c1d44746ce00', 'd11f65c7-ee57-466a-9ebe-2c629b9776c8', 'Mediterranean Distribution Lithuania', 'REG-913738', 'Biologics', 3.6, 'Lisa Brown', 'procurement@mediterranean.com', '+865-3112881', '745 Commerce Blvd, City Center, 46852, Lithuania', 'City Center', 'Lithuania', true, 'LT   462449347', '{"Lithuania"}', '{"Biologics","Branded Pharma","Generic Drugs"}', 'f08ccdb0-2df1-4bbd-bf74-4cce8f0dc324', 'distributor');

-- VENDORS FOR LUXEMBOURG
SELECT public.create_user('b759d2ce-8ac3-430c-b78e-6b0cf0858470', 'procurement@medtronicluxembourg.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('b759d2ce-8ac3-430c-b78e-6b0cf0858470', 'procurement@medtronicluxembourg.com', 'David Davis', 'vendor', 'Medtronic Luxembourg S.à r.l.', '+807-1440666', '285 Industrial Way, Business Quarter, 91261, Luxembourg', 'Business Quarter', 'Luxembourg', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('cbf34768-15a5-437e-a99c-28d5c1dcd8fc', 'b759d2ce-8ac3-430c-b78e-6b0cf0858470', 'Medtronic Luxembourg S.à r.l.', 'REG-541441', 'Pharmaceuticals', 3.5, 'David Davis', 'procurement@medtronicluxembourg.com', '+807-1440666', '285 Industrial Way, Business Quarter, 91261, Luxembourg', 'Business Quarter', 'Luxembourg', true, '', '{"Luxembourg"}', '{"Pharmaceuticals"}', '5cc5eb05-4238-4085-a311-88de577cb5d2', 'distributor');
SELECT public.create_user('e402f241-9abe-4de7-80f6-f2170b6c035d', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e402f241-9abe-4de7-80f6-f2170b6c035d', 'procurement@international.com', 'Emma Johnson', 'vendor', 'International Pharma Luxembourg S.à r.l.', '+946-1917828', '822 Business Park, City Center, 61963, Luxembourg', 'City Center', 'Luxembourg', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('bec17191-bdcb-4496-9235-113c0244c234', 'e402f241-9abe-4de7-80f6-f2170b6c035d', 'International Pharma Luxembourg S.à r.l.', 'REG-237744', 'Cardiology', 4.5, 'Emma Johnson', 'procurement@international.com', '+946-1917828', '822 Business Park, City Center, 61963, Luxembourg', 'City Center', 'Luxembourg', true, 'LU512233626', '{"Luxembourg"}', '{"Cardiology","Laboratory"}', '80706eb3-007b-410f-bcb0-492360025f72', 'distributor');
SELECT public.create_user('e94ab797-6b03-4930-a0a3-6f98cd7bfb8e', 'procurement@mediterranean.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e94ab797-6b03-4930-a0a3-6f98cd7bfb8e', 'procurement@mediterranean.com', 'Sarah Williams', 'vendor', 'Mediterranean Medical Luxembourg', '+720-7179122', '808 Industrial Way, City Center, 16688, Luxembourg', 'City Center', 'Luxembourg', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ee1da66e-2ab7-4c3f-a0c0-d3cd454f9a33', 'e94ab797-6b03-4930-a0a3-6f98cd7bfb8e', 'Mediterranean Medical Luxembourg', 'REG-930551', 'Branded Pharma', 4.9, 'Sarah Williams', 'procurement@mediterranean.com', '+720-7179122', '808 Industrial Way, City Center, 16688, Luxembourg', 'City Center', 'Luxembourg', true, 'LU338195640', '{"Luxembourg"}', '{"Branded Pharma","OTC","Pharmaceuticals","Generic Drugs"}', '09531df5-9d8d-4840-a9a1-0727911fc2fe', 'distributor');
SELECT public.create_user('553b52f6-f27c-4f8e-a1f6-3ce422e0a5db', 'procurement@global.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('553b52f6-f27c-4f8e-a1f6-3ce422e0a5db', 'procurement@global.com', 'Sarah Jones', 'vendor', 'Global Pharma Luxembourg S.à r.l.', '+110-2385187', '630 Main St, City Center, 70515, Luxembourg', 'City Center', 'Luxembourg', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5173742e-c01d-4264-acc2-b61fc214efd4', '553b52f6-f27c-4f8e-a1f6-3ce422e0a5db', 'Global Pharma Luxembourg S.à r.l.', 'REG-146730', 'OTC', 4.0, 'Sarah Jones', 'procurement@global.com', '+110-2385187', '630 Main St, City Center, 70515, Luxembourg', 'City Center', 'Luxembourg', true, 'LU998199020', '{"Luxembourg"}', '{"OTC","Vaccines","Generic Drugs","Branded Pharma"}', '3e00217e-0e10-4188-a341-084b958ccf56', 'distributor');
SELECT public.create_user('34057e0f-4634-4b24-a155-3f55c1c5c347', 'procurement@first.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('34057e0f-4634-4b24-a155-3f55c1c5c347', 'procurement@first.com', 'John Davis', 'vendor', 'First Medical Luxembourg', '+811-3155878', '828 Industrial Way, Industrial District, 54206, Luxembourg', 'Industrial District', 'Luxembourg', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('8a989d85-6fa5-4f99-878b-d78b7f75c6e1', '34057e0f-4634-4b24-a155-3f55c1c5c347', 'First Medical Luxembourg', 'REG-330630', 'Laboratory', 4.0, 'John Davis', 'procurement@first.com', '+811-3155878', '828 Industrial Way, Industrial District, 54206, Luxembourg', 'Industrial District', 'Luxembourg', true, 'LU590649956', '{"Luxembourg"}', '{"Laboratory","Optical","Anesthesia","Radiology"}', '751e006b-abba-43c5-84db-cd02ff1265ce', 'distributor');

-- VENDORS FOR MALTA
SELECT public.create_user('bb0a481f-8a07-4059-aa00-1fe65702a255', 'procurement@medtronicmalta.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('bb0a481f-8a07-4059-aa00-1fe65702a255', 'procurement@medtronicmalta.com', 'John Brown', 'vendor', 'Medtronic Malta Ltd', '+244-6967774', '39 Commerce Blvd, Industrial District, 58455, Malta', 'Industrial District', 'Malta', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0a5738c5-8478-4a0e-83c6-e6125c7d2408', 'bb0a481f-8a07-4059-aa00-1fe65702a255', 'Medtronic Malta Ltd', 'REG-798150', 'Pharmaceuticals', 3.8, 'John Brown', 'procurement@medtronicmalta.com', '+244-6967774', '39 Commerce Blvd, Industrial District, 58455, Malta', 'Industrial District', 'Malta', true, '', '{"Malta"}', '{"Pharmaceuticals"}', 'c3481572-b793-4c23-baf3-646cf8364741', 'distributor');
SELECT public.create_user('cff52156-f8b5-47e8-a6ed-d68cd7ee2813', 'procurement@max.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cff52156-f8b5-47e8-a6ed-d68cd7ee2813', 'procurement@max.com', 'David Davis', 'vendor', 'Max Pharma Malta Ltd', '+144-2725938', '900 Industrial Way, Business Quarter, 27278, Malta', 'Business Quarter', 'Malta', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ba0a26e6-9645-4eb1-bd92-8bb51f763320', 'cff52156-f8b5-47e8-a6ed-d68cd7ee2813', 'Max Pharma Malta Ltd', 'REG-453030', 'Surgery', 4.2, 'David Davis', 'procurement@max.com', '+144-2725938', '900 Industrial Way, Business Quarter, 27278, Malta', 'Business Quarter', 'Malta', true, 'MT264290133', '{"Malta"}', '{"Surgery","Laboratory","Orthopedics","Wound Care"}', '52e557bf-5020-4e50-8c0f-cf85e4e846f3', 'distributor');
SELECT public.create_user('2e4b436b-d6cf-4b5a-95e2-f8078146ffbf', 'procurement@pan-european.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('2e4b436b-d6cf-4b5a-95e2-f8078146ffbf', 'procurement@pan-european.com', 'John Davis', 'vendor', 'Pan-European Medical Malta', '+188-7771328', '263 Industrial Way, Industrial District, 50100, Malta', 'Industrial District', 'Malta', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('069a58d3-bd18-4fd6-809f-32dfa11342ed', '2e4b436b-d6cf-4b5a-95e2-f8078146ffbf', 'Pan-European Medical Malta', 'REG-620595', 'Radiology', 4.0, 'John Davis', 'procurement@pan-european.com', '+188-7771328', '263 Industrial Way, Industrial District, 50100, Malta', 'Industrial District', 'Malta', true, 'MT311675730', '{"Malta"}', '{"Radiology","Anesthesia","Pharmaceuticals","Patient Monitoring"}', '8d396fca-a4ff-4eae-a05b-a7484024f03f', 'distributor');
SELECT public.create_user('b5922caa-8988-4887-9b47-d30a172581e6', 'procurement@pharma.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('b5922caa-8988-4887-9b47-d30a172581e6', 'procurement@pharma.com', 'Sarah Williams', 'vendor', 'Pharma Healthcare MT', '+323-1438522', '616 Main St, Industrial District, 94691, Malta', 'Industrial District', 'Malta', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a39c4cfa-fb9d-4f7f-9cac-e8d0c09394bb', 'b5922caa-8988-4887-9b47-d30a172581e6', 'Pharma Healthcare MT', 'REG-398425', 'OTC', 4.0, 'Sarah Williams', 'procurement@pharma.com', '+323-1438522', '616 Main St, Industrial District, 94691, Malta', 'Industrial District', 'Malta', true, 'MT672800913', '{"Malta"}', '{"OTC","Vaccines"}', '6bfad35f-b924-411b-8cea-dcb60a37f87f', 'distributor');
SELECT public.create_user('72c158b4-308c-44ac-b721-40ee5d326187', 'procurement@quality.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('72c158b4-308c-44ac-b721-40ee5d326187', 'procurement@quality.com', 'David Jones', 'vendor', 'Quality Healthcare MT', '+359-7973072', '779 Business Park, City Center, 84155, Malta', 'City Center', 'Malta', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7cac3098-05c8-4a30-b4e4-510631a17290', '72c158b4-308c-44ac-b721-40ee5d326187', 'Quality Healthcare MT', 'REG-877083', 'Pharmaceuticals', 4.9, 'David Jones', 'procurement@quality.com', '+359-7973072', '779 Business Park, City Center, 84155, Malta', 'City Center', 'Malta', true, 'MT500503392', '{"Malta"}', '{"Pharmaceuticals","Biologics","Generic Drugs"}', 'd6936235-68aa-4d31-a0d1-1d57262297ae', 'distributor');

-- VENDORS FOR NETHERLANDS
SELECT public.create_user('000d1d66-a3d0-4cbc-9acd-19d8caf48a94', 'procurement@centrafarm.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('000d1d66-a3d0-4cbc-9acd-19d8caf48a94', 'procurement@centrafarm.com', 'Lisa Jones', 'vendor', 'Centrafarm B.V.', '+956-2973747', '632 Main St, Business Quarter, 65417, Netherlands', 'Business Quarter', 'Netherlands', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('02b9449d-fb38-4f37-bb2e-0cc1b31712d0', '000d1d66-a3d0-4cbc-9acd-19d8caf48a94', 'Centrafarm B.V.', 'REG-261601', 'Pharmaceuticals', 4.5, 'Lisa Jones', 'procurement@centrafarm.com', '+956-2973747', '632 Main St, Business Quarter, 65417, Netherlands', 'Business Quarter', 'Netherlands', true, '', '{"Netherlands"}', '{"Pharmaceuticals"}', '4c98f62b-8c54-4567-86ab-5bcf5ef2ff9a', 'distributor');
SELECT public.create_user('4241db1c-2e5f-44e9-9b97-392110d2c928', 'procurement@alliancehealthcarenl.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('4241db1c-2e5f-44e9-9b97-392110d2c928', 'procurement@alliancehealthcarenl.com', 'John Jones', 'vendor', 'Alliance Healthcare Nederland B.V.', '+848-7332677', '789 Industrial Way, City Center, 50559, Netherlands', 'City Center', 'Netherlands', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f43b2925-6d43-4ae3-847e-b49b12740ef0', '4241db1c-2e5f-44e9-9b97-392110d2c928', 'Alliance Healthcare Nederland B.V.', 'REG-600302', 'Pharmaceuticals', 3.7, 'John Jones', 'procurement@alliancehealthcarenl.com', '+848-7332677', '789 Industrial Way, City Center, 50559, Netherlands', 'City Center', 'Netherlands', true, '', '{"Netherlands"}', '{"Pharmaceuticals"}', '889164c7-6fcc-4ba6-aedb-a0bcafb34e8f', 'distributor');
SELECT public.create_user('9b0cc4d2-4439-402a-ba07-b409932368dd', 'procurement@medtronicnl.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9b0cc4d2-4439-402a-ba07-b409932368dd', 'procurement@medtronicnl.com', 'David Smith', 'vendor', 'Medtronic Netherlands B.V.', '+674-2284001', '923 Commerce Blvd, City Center, 54565, Netherlands', 'City Center', 'Netherlands', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('43bd320e-6511-4f30-beb9-542855615f23', '9b0cc4d2-4439-402a-ba07-b409932368dd', 'Medtronic Netherlands B.V.', 'REG-121243', 'Pharmaceuticals', 4.5, 'David Smith', 'procurement@medtronicnl.com', '+674-2284001', '923 Commerce Blvd, City Center, 54565, Netherlands', 'City Center', 'Netherlands', true, '', '{"Netherlands"}', '{"Pharmaceuticals"}', '0dc36410-f8eb-4629-a82d-3380794ecc5d', 'distributor');
SELECT public.create_user('3abbdc02-abd8-49df-ba45-3968c62cf47c', 'procurement@philipsnl.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('3abbdc02-abd8-49df-ba45-3968c62cf47c', 'procurement@philipsnl.com', 'Lisa Williams', 'vendor', 'Philips Healthcare Nederland B.V.', '+218-6239858', '764 Commerce Blvd, Industrial District, 73937, Netherlands', 'Industrial District', 'Netherlands', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('df0429b3-7ae1-41cb-a567-625f818d2502', '3abbdc02-abd8-49df-ba45-3968c62cf47c', 'Philips Healthcare Nederland B.V.', 'REG-986590', 'Pharmaceuticals', 4.5, 'Lisa Williams', 'procurement@philipsnl.com', '+218-6239858', '764 Commerce Blvd, Industrial District, 73937, Netherlands', 'Industrial District', 'Netherlands', true, '', '{"Netherlands"}', '{"Pharmaceuticals"}', '37f786ae-2174-437e-911e-729ad6be9a8b', 'distributor');
SELECT public.create_user('9668bd7a-4095-4d1f-8c85-b44c91527cae', 'procurement@siemensnl.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9668bd7a-4095-4d1f-8c85-b44c91527cae', 'procurement@siemensnl.com', 'Michael Smith', 'vendor', 'Siemens Healthineers Nederland B.V.', '+782-1726291', '915 Main St, Industrial District, 33416, Netherlands', 'Industrial District', 'Netherlands', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('11843d01-7d39-41f0-9f40-f3a2c0d1948c', '9668bd7a-4095-4d1f-8c85-b44c91527cae', 'Siemens Healthineers Nederland B.V.', 'REG-889771', 'Pharmaceuticals', 4.2, 'Michael Smith', 'procurement@siemensnl.com', '+782-1726291', '915 Main St, Industrial District, 33416, Netherlands', 'Industrial District', 'Netherlands', true, '', '{"Netherlands"}', '{"Pharmaceuticals"}', '0aac9ef6-a729-4a66-9914-95775633dcd5', 'distributor');

-- VENDORS FOR NORWAY
SELECT public.create_user('addaa92d-1940-4f66-9327-b122bcbfbc78', 'procurement@medtronicnorway.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('addaa92d-1940-4f66-9327-b122bcbfbc78', 'procurement@medtronicnorway.com', 'David Williams', 'vendor', 'Medtronic Norge AS', '+191-7485133', '705 Business Park, Business Quarter, 61687, Norway', 'Business Quarter', 'Norway', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a5f90653-1119-4207-b8ef-9cd8b3a9f320', 'addaa92d-1940-4f66-9327-b122bcbfbc78', 'Medtronic Norge AS', 'REG-758244', 'Pharmaceuticals', 3.6, 'David Williams', 'procurement@medtronicnorway.com', '+191-7485133', '705 Business Park, Business Quarter, 61687, Norway', 'Business Quarter', 'Norway', true, '', '{"Norway"}', '{"Pharmaceuticals"}', 'ff35a35a-423a-46e8-a60c-f49f1833b195', 'distributor');
SELECT public.create_user('ff7fd2b8-91bf-4479-852c-e0cbdc23cab5', 'procurement@direct.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ff7fd2b8-91bf-4479-852c-e0cbdc23cab5', 'procurement@direct.com', 'John Jones', 'vendor', 'Direct Healthcare NO', '+216-5166016', '879 Business Park, Industrial District, 42395, Norway', 'Industrial District', 'Norway', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('2d12d25d-1262-4171-a595-a249f1df1094', 'ff7fd2b8-91bf-4479-852c-e0cbdc23cab5', 'Direct Healthcare NO', 'REG-145223', 'OTC', 3.5, 'John Jones', 'procurement@direct.com', '+216-5166016', '879 Business Park, Industrial District, 42395, Norway', 'Industrial District', 'Norway', true, 'NO182124570', '{"Norway"}', '{"OTC","Vaccines"}', 'f15f320b-5d6d-4c47-a98c-185b91c260bb', 'distributor');
SELECT public.create_user('8b0deb03-dd86-4767-9745-93f5e8745352', 'procurement@mediterranean.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('8b0deb03-dd86-4767-9745-93f5e8745352', 'procurement@mediterranean.com', 'Lisa Davis', 'vendor', 'Mediterranean Medical Norway', '+983-7488063', '541 Main St, City Center, 32384, Norway', 'City Center', 'Norway', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('922596da-de60-4218-8f2a-4f51d3e9935e', '8b0deb03-dd86-4767-9745-93f5e8745352', 'Mediterranean Medical Norway', 'REG-368572', 'Biologics', 4.2, 'Lisa Davis', 'procurement@mediterranean.com', '+983-7488063', '541 Main St, City Center, 32384, Norway', 'City Center', 'Norway', true, 'NO198106165', '{"Norway"}', '{"Biologics","Generic Drugs","Vaccines"}', 'f9779e96-c235-44b8-8927-29774a0e650d', 'distributor');
SELECT public.create_user('2bf391c5-3774-442e-8bba-21411401aa0a', 'procurement@pan-european.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('2bf391c5-3774-442e-8bba-21411401aa0a', 'procurement@pan-european.com', 'David Smith', 'vendor', 'Pan-European Pharma Norge AS', '+227-5686177', '800 Main St, Industrial District, 67166, Norway', 'Industrial District', 'Norway', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7dd2c0ca-a1c1-400e-af8a-fc57492b3966', '2bf391c5-3774-442e-8bba-21411401aa0a', 'Pan-European Pharma Norge AS', 'REG-433442', 'Anesthesia', 4.5, 'David Smith', 'procurement@pan-european.com', '+227-5686177', '800 Main St, Industrial District, 67166, Norway', 'Industrial District', 'Norway', true, 'NO194089064', '{"Norway"}', '{"Anesthesia","Laboratory","Consumables"}', '8373befd-6484-4064-b223-b78609032289', 'distributor');
SELECT public.create_user('cd883f7b-74b2-441c-ab2c-79809f2d331e', 'procurement@care.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cd883f7b-74b2-441c-ab2c-79809f2d331e', 'procurement@care.com', 'John Smith', 'vendor', 'Care Distribution Norway', '+768-4497202', '987 Business Park, Industrial District, 25612, Norway', 'Industrial District', 'Norway', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('caad97e7-7027-4146-ade9-8a36990baa83', 'cd883f7b-74b2-441c-ab2c-79809f2d331e', 'Care Distribution Norway', 'REG-129802', 'Vaccines', 3.8, 'John Smith', 'procurement@care.com', '+768-4497202', '987 Business Park, Industrial District, 25612, Norway', 'Industrial District', 'Norway', true, 'NO550421530', '{"Norway"}', '{"Vaccines","Branded Pharma","Generic Drugs","OTC"}', '64ec0dfb-2068-47bc-b9ba-89998a7b5df4', 'distributor');

-- VENDORS FOR POLAND
SELECT public.create_user('8c877b91-eccd-4d37-b61f-ef6983fe4ae1', 'procurement@pharmapartner.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('8c877b91-eccd-4d37-b61f-ef6983fe4ae1', 'procurement@pharmapartner.com', 'Lisa Williams', 'vendor', 'Pharma Partner Sp. z o.o.', '+146-7884444', '604 Main St, Industrial District, 57209, Poland', 'Industrial District', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ddc10e7a-d62f-4b2d-8b43-d2d0a5e4fba6', '8c877b91-eccd-4d37-b61f-ef6983fe4ae1', 'Pharma Partner Sp. z o.o.', 'REG-691729', 'Pharmaceuticals', 3.6, 'Lisa Williams', 'procurement@pharmapartner.com', '+146-7884444', '604 Main St, Industrial District, 57209, Poland', 'Industrial District', 'Poland', true, '', '{"Poland"}', '{"Pharmaceuticals"}', 'cde1b983-e99f-48cf-9ab5-59316af29cbb', 'distributor');
SELECT public.create_user('f0cb83c3-12f3-4a89-a247-114a0eb033a5', 'procurement@bbraunpoland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f0cb83c3-12f3-4a89-a247-114a0eb033a5', 'procurement@bbraunpoland.com', 'Michael Smith', 'vendor', 'B Braun Medical Poland Sp. z o.o.', '+639-9636637', '260 Main St, Business Quarter, 68486, Poland', 'Business Quarter', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('44c1d0e4-cfd9-4a3f-af74-8d7b6de1e0c9', 'f0cb83c3-12f3-4a89-a247-114a0eb033a5', 'B Braun Medical Poland Sp. z o.o.', 'REG-354866', 'Pharmaceuticals', 4.9, 'Michael Smith', 'procurement@bbraunpoland.com', '+639-9636637', '260 Main St, Business Quarter, 68486, Poland', 'Business Quarter', 'Poland', true, '', '{"Poland"}', '{"Pharmaceuticals"}', '595be984-eb45-4065-85da-0b94959fbd84', 'distributor');
SELECT public.create_user('3464487b-80cf-4e08-84fd-618996453ff7', 'procurement@siemenspoland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('3464487b-80cf-4e08-84fd-618996453ff7', 'procurement@siemenspoland.com', 'John Williams', 'vendor', 'Siemens Healthineers Polska Sp. z o.o.', '+826-5082475', '593 Business Park, Industrial District, 57047, Poland', 'Industrial District', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('96ff0c22-a1d1-462c-8140-bc02775310e7', '3464487b-80cf-4e08-84fd-618996453ff7', 'Siemens Healthineers Polska Sp. z o.o.', 'REG-522777', 'Pharmaceuticals', 4.3, 'John Williams', 'procurement@siemenspoland.com', '+826-5082475', '593 Business Park, Industrial District, 57047, Poland', 'Industrial District', 'Poland', true, '', '{"Poland"}', '{"Pharmaceuticals"}', 'bf02c7d5-5f50-4616-be4c-af0fc9d22afe', 'distributor');
SELECT public.create_user('e6afbc4c-4434-42ad-9f05-a3af3db77c27', 'procurement@clinic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e6afbc4c-4434-42ad-9f05-a3af3db77c27', 'procurement@clinic.com', 'Michael Brown', 'vendor', 'Clinic Distribution Poland', '+862-1906274', '722 Business Park, Industrial District, 65141, Poland', 'Industrial District', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('99389a24-53a7-4d4a-bda3-bf67b7a2dfa4', 'e6afbc4c-4434-42ad-9f05-a3af3db77c27', 'Clinic Distribution Poland', 'REG-240179', 'Optical', 4.2, 'Michael Brown', 'procurement@clinic.com', '+862-1906274', '722 Business Park, Industrial District, 65141, Poland', 'Industrial District', 'Poland', true, 'PL 805727573', '{"Poland"}', '{"Optical","Diagnostics","Dental"}', '02296094-f55e-490a-9fdd-00ed43543364', 'distributor');
SELECT public.create_user('66b15885-7999-4863-a01c-7e53f6138b5c', 'procurement@euro.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('66b15885-7999-4863-a01c-7e53f6138b5c', 'procurement@euro.com', 'John Jones', 'vendor', 'Euro Distribution Poland', '+573-7848903', '893 Industrial Way, City Center, 75614, Poland', 'City Center', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f2c43f5d-c342-4d54-b787-70bfec9ae4d8', '66b15885-7999-4863-a01c-7e53f6138b5c', 'Euro Distribution Poland', 'REG-242600', 'Laboratory', 3.9, 'John Jones', 'procurement@euro.com', '+573-7848903', '893 Industrial Way, City Center, 75614, Poland', 'City Center', 'Poland', true, 'PL 548951149', '{"Poland"}', '{"Laboratory","Surgery","Cardiology"}', '5a6cda4e-7c46-49bb-8eaa-f1d6b3ca299a', 'distributor');
SELECT public.create_user('c563ed32-9d9c-4e1c-b772-191c98760ce0', 'procurement@life.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c563ed32-9d9c-4e1c-b772-191c98760ce0', 'procurement@life.com', 'John Brown', 'vendor', 'Life Pharma Poland Sp. z o.o.', '+341-9527513', '455 Commerce Blvd, City Center, 50988, Poland', 'City Center', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('55bfcb7a-3c4d-430e-be83-d53b5d06480d', 'c563ed32-9d9c-4e1c-b772-191c98760ce0', 'Life Pharma Poland Sp. z o.o.', 'REG-114809', 'OTC', 4.5, 'John Brown', 'procurement@life.com', '+341-9527513', '455 Commerce Blvd, City Center, 50988, Poland', 'City Center', 'Poland', true, 'PL 246669086', '{"Poland"}', '{"OTC","Generic Drugs","Biologics","Branded Pharma"}', '9ee4c1a8-7b34-42a9-871c-00ed73df8b80', 'distributor');
SELECT public.create_user('9dfd85b8-6436-453c-98a4-b0f2dca3dcfc', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9dfd85b8-6436-453c-98a4-b0f2dca3dcfc', 'procurement@allied.com', 'Lisa Davis', 'vendor', 'Allied Distribution Poland', '+733-7427572', '105 Business Park, Business Quarter, 63122, Poland', 'Business Quarter', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a237bbec-7ac7-447c-8b84-06ea71fb15f9', '9dfd85b8-6436-453c-98a4-b0f2dca3dcfc', 'Allied Distribution Poland', 'REG-712870', 'Optical', 4.5, 'Lisa Davis', 'procurement@allied.com', '+733-7427572', '105 Business Park, Business Quarter, 63122, Poland', 'Business Quarter', 'Poland', true, 'PL 737878220', '{"Poland"}', '{"Optical","Laboratory","Patient Monitoring","Dental"}', 'eb245b01-a347-426a-8402-c307a3d818c9', 'distributor');
SELECT public.create_user('2153c963-9ed4-40c0-98b7-a2547099552a', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('2153c963-9ed4-40c0-98b7-a2547099552a', 'procurement@allied.com', 'John Jones', 'vendor', 'Allied Medical Poland', '+228-1541820', '796 Commerce Blvd, Business Quarter, 25024, Poland', 'Business Quarter', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c6f78453-17ad-4b97-a242-0723476c4a19', '2153c963-9ed4-40c0-98b7-a2547099552a', 'Allied Medical Poland', 'REG-884726', 'OTC', 3.5, 'John Jones', 'procurement@allied.com', '+228-1541820', '796 Commerce Blvd, Business Quarter, 25024, Poland', 'Business Quarter', 'Poland', true, 'PL 882254823', '{"Poland"}', '{"OTC","Vaccines","Wound Care","Generic Drugs"}', '13188eee-899c-460f-99f9-52e5f04e59d9', 'distributor');
SELECT public.create_user('6ca2c348-93be-4052-b095-d3099a068318', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6ca2c348-93be-4052-b095-d3099a068318', 'procurement@allied.com', 'Michael Johnson', 'vendor', 'Allied Pharma Poland Sp. z o.o.', '+288-2904507', '806 Industrial Way, Business Quarter, 41684, Poland', 'Business Quarter', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('02b3d885-8769-4bed-a7f2-32ebe18c6c05', '6ca2c348-93be-4052-b095-d3099a068318', 'Allied Pharma Poland Sp. z o.o.', 'REG-762720', 'Surgery', 3.9, 'Michael Johnson', 'procurement@allied.com', '+288-2904507', '806 Industrial Way, Business Quarter, 41684, Poland', 'Business Quarter', 'Poland', true, 'PL 857581836', '{"Poland"}', '{"Surgery","Patient Monitoring","Laboratory"}', 'c41aa2c1-0f20-46ca-b770-bf975203a1f7', 'distributor');
SELECT public.create_user('1b8732ef-9a30-4a82-9c58-a6d4ec4574ad', 'procurement@national.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1b8732ef-9a30-4a82-9c58-a6d4ec4574ad', 'procurement@national.com', 'Michael Jones', 'vendor', 'National Pharma Poland Sp. z o.o.', '+455-6920132', '831 Main St, City Center, 80469, Poland', 'City Center', 'Poland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ab1be73a-afb2-4910-9c53-7c34faa1d276', '1b8732ef-9a30-4a82-9c58-a6d4ec4574ad', 'National Pharma Poland Sp. z o.o.', 'REG-160386', 'Surgery', 4.2, 'Michael Jones', 'procurement@national.com', '+455-6920132', '831 Main St, City Center, 80469, Poland', 'City Center', 'Poland', true, 'PL 329608845', '{"Poland"}', '{"Surgery","Diagnostics","Wound Care"}', 'dd2b20fc-1403-4e6e-bb0c-acdfc8f62a42', 'distributor');

-- VENDORS FOR PORTUGAL
SELECT public.create_user('c9c753a9-d8fa-452c-95ca-d96f2efc7c22', 'procurement@medtronicportugal.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c9c753a9-d8fa-452c-95ca-d96f2efc7c22', 'procurement@medtronicportugal.com', 'Sarah Williams', 'vendor', 'Medtronic Portugal Lda', '+609-3793469', '831 Main St, Industrial District, 46552, Portugal', 'Industrial District', 'Portugal', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('26e8c58b-4c99-4ebf-a6e3-1fabb08b1f1d', 'c9c753a9-d8fa-452c-95ca-d96f2efc7c22', 'Medtronic Portugal Lda', 'REG-171179', 'Pharmaceuticals', 4.9, 'Sarah Williams', 'procurement@medtronicportugal.com', '+609-3793469', '831 Main St, Industrial District, 46552, Portugal', 'Industrial District', 'Portugal', true, '', '{"Portugal"}', '{"Pharmaceuticals"}', 'c3c86002-24c3-4c30-b0ef-10b90cab80c2', 'distributor');
SELECT public.create_user('d159bcd2-7c6d-4ce9-9cc1-7db1d88d2e6d', 'procurement@freseniusportugal.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d159bcd2-7c6d-4ce9-9cc1-7db1d88d2e6d', 'procurement@freseniusportugal.com', 'David Johnson', 'vendor', 'Fresenius Medical Care Portugal Lda', '+657-8733705', '852 Industrial Way, City Center, 84603, Portugal', 'City Center', 'Portugal', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7e62a31f-4a52-47a8-ba36-ab23c71fa2b2', 'd159bcd2-7c6d-4ce9-9cc1-7db1d88d2e6d', 'Fresenius Medical Care Portugal Lda', 'REG-645498', 'Pharmaceuticals', 4.3, 'David Johnson', 'procurement@freseniusportugal.com', '+657-8733705', '852 Industrial Way, City Center, 84603, Portugal', 'City Center', 'Portugal', true, '', '{"Portugal"}', '{"Pharmaceuticals"}', '49eb5f46-c39b-4d8a-bab6-3134f7133fe5', 'distributor');
SELECT public.create_user('c0afd347-96db-4c7c-8c2c-3555fbcd7d31', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c0afd347-96db-4c7c-8c2c-3555fbcd7d31', 'procurement@international.com', 'David Jones', 'vendor', 'International Healthcare PT', '+980-3940327', '263 Industrial Way, City Center, 85623, Portugal', 'City Center', 'Portugal', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('429c8aa8-a230-49ee-8baf-0a5517600464', 'c0afd347-96db-4c7c-8c2c-3555fbcd7d31', 'International Healthcare PT', 'REG-139368', 'Patient Monitoring', 4.2, 'David Jones', 'procurement@international.com', '+980-3940327', '263 Industrial Way, City Center, 85623, Portugal', 'City Center', 'Portugal', true, 'PT341227028', '{"Portugal"}', '{"Patient Monitoring","Optical","Dental","Cardiology"}', '6c65052a-578b-44ba-a3dd-2822bfb82ac9', 'distributor');
SELECT public.create_user('82094d4c-332a-4e9c-ab39-6c53c57ff31e', 'procurement@clinic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('82094d4c-332a-4e9c-ab39-6c53c57ff31e', 'procurement@clinic.com', 'Michael Davis', 'vendor', 'Clinic Medical Portugal', '+617-8206558', '625 Main St, Industrial District, 65611, Portugal', 'Industrial District', 'Portugal', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1daf2774-9ae0-4219-9d1e-efb5491942cb', '82094d4c-332a-4e9c-ab39-6c53c57ff31e', 'Clinic Medical Portugal', 'REG-136014', 'OTC', 4.1, 'Michael Davis', 'procurement@clinic.com', '+617-8206558', '625 Main St, Industrial District, 65611, Portugal', 'Industrial District', 'Portugal', true, 'PT413598153', '{"Portugal"}', '{"OTC","Vaccines"}', 'cc5ccd1b-bfa7-4547-928c-435dfb898c94', 'distributor');
SELECT public.create_user('900d0cfe-b455-44f1-abef-a28efdefd85d', 'procurement@premier.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('900d0cfe-b455-44f1-abef-a28efdefd85d', 'procurement@premier.com', 'David Brown', 'vendor', 'Premier Pharma Portugal Lda', '+643-3499361', '87 Commerce Blvd, Industrial District, 85164, Portugal', 'Industrial District', 'Portugal', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('609db3f3-2587-4994-a42d-88a316117683', '900d0cfe-b455-44f1-abef-a28efdefd85d', 'Premier Pharma Portugal Lda', 'REG-290482', 'Surgery', 4.8, 'David Brown', 'procurement@premier.com', '+643-3499361', '87 Commerce Blvd, Industrial District, 85164, Portugal', 'Industrial District', 'Portugal', true, 'PT263400093', '{"Portugal"}', '{"Surgery","Orthopedics","Anesthesia"}', '0ba87919-93cd-4aeb-985f-15ced24cae75', 'distributor');

-- VENDORS FOR ROMANIA
SELECT public.create_user('e2360073-4305-40ee-897f-da1e507ef3d9', 'procurement@medtronicromania.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e2360073-4305-40ee-897f-da1e507ef3d9', 'procurement@medtronicromania.com', 'Sarah Brown', 'vendor', 'Medtronic Romania SRL', '+327-3830781', '580 Business Park, City Center, 39311, Romania', 'City Center', 'Romania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f7f9d6c3-30a5-43b3-820c-714a421bb58c', 'e2360073-4305-40ee-897f-da1e507ef3d9', 'Medtronic Romania SRL', 'REG-983862', 'Pharmaceuticals', 4.8, 'Sarah Brown', 'procurement@medtronicromania.com', '+327-3830781', '580 Business Park, City Center, 39311, Romania', 'City Center', 'Romania', true, '', '{"Romania"}', '{"Pharmaceuticals"}', 'a0f606fb-11a3-4740-8e2c-60bb759c78a1', 'distributor');
SELECT public.create_user('74181447-6cad-4e9b-a53e-51eafd8285de', 'procurement@freseniusromania.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('74181447-6cad-4e9b-a53e-51eafd8285de', 'procurement@freseniusromania.com', 'Sarah Williams', 'vendor', 'Fresenius Medical Care Romania SRL', '+116-2787438', '367 Business Park, Industrial District, 77589, Romania', 'Industrial District', 'Romania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('94e77887-b108-4888-98b9-b7be1e1d71da', '74181447-6cad-4e9b-a53e-51eafd8285de', 'Fresenius Medical Care Romania SRL', 'REG-401495', 'Pharmaceuticals', 4.2, 'Sarah Williams', 'procurement@freseniusromania.com', '+116-2787438', '367 Business Park, Industrial District, 77589, Romania', 'Industrial District', 'Romania', true, '', '{"Romania"}', '{"Pharmaceuticals"}', '45e26be6-b15d-42d5-891e-fdc1b03495f4', 'distributor');
SELECT public.create_user('4d37393d-3ea3-41b7-a167-bfe9fd0396d8', 'procurement@international.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('4d37393d-3ea3-41b7-a167-bfe9fd0396d8', 'procurement@international.com', 'Emma Brown', 'vendor', 'International Pharma Romania SRL', '+646-9545176', '706 Main St, Business Quarter, 77972, Romania', 'Business Quarter', 'Romania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ec4c2bcc-8770-4ca0-ba4e-5dde60a36220', '4d37393d-3ea3-41b7-a167-bfe9fd0396d8', 'International Pharma Romania SRL', 'REG-733828', 'Patient Monitoring', 4.3, 'Emma Brown', 'procurement@international.com', '+646-9545176', '706 Main St, Business Quarter, 77972, Romania', 'Business Quarter', 'Romania', true, 'RO799178021', '{"Romania"}', '{"Patient Monitoring","Laboratory"}', 'e038261b-ff50-4a17-a1be-4913806d7710', 'distributor');
SELECT public.create_user('95f01b2d-0f87-422c-a3ea-0529687cb5e9', 'procurement@reliable.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('95f01b2d-0f87-422c-a3ea-0529687cb5e9', 'procurement@reliable.com', 'Emma Jones', 'vendor', 'Reliable Distribution Romania', '+521-1917711', '766 Business Park, City Center, 74655, Romania', 'City Center', 'Romania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('7f151d7d-ba6d-4019-9708-051bee83871d', '95f01b2d-0f87-422c-a3ea-0529687cb5e9', 'Reliable Distribution Romania', 'REG-291331', 'Pharmaceuticals', 3.9, 'Emma Jones', 'procurement@reliable.com', '+521-1917711', '766 Business Park, City Center, 74655, Romania', 'City Center', 'Romania', true, 'RO687989542', '{"Romania"}', '{"Pharmaceuticals","Branded Pharma"}', '4715c973-ecd3-4bc4-8d50-c13678a55326', 'distributor');
SELECT public.create_user('1119cd86-45b3-47a9-a9ed-fece91e8782c', 'procurement@allied.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1119cd86-45b3-47a9-a9ed-fece91e8782c', 'procurement@allied.com', 'Lisa Davis', 'vendor', 'Allied Pharma Romania SRL', '+344-1288891', '28 Main St, Business Quarter, 30070, Romania', 'Business Quarter', 'Romania', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0e093922-e298-4fcc-ab7f-6a7c61985f84', '1119cd86-45b3-47a9-a9ed-fece91e8782c', 'Allied Pharma Romania SRL', 'REG-600025', 'Laboratory', 3.6, 'Lisa Davis', 'procurement@allied.com', '+344-1288891', '28 Main St, Business Quarter, 30070, Romania', 'Business Quarter', 'Romania', true, 'RO422711898', '{"Romania"}', '{"Laboratory","Consumables","Cardiology"}', '9f4b3db5-835f-406f-ab2b-e9aabbebabd9', 'distributor');

-- VENDORS FOR SLOVAKIA
SELECT public.create_user('c197f20d-cef1-4b0d-a2c1-1853ed2082a1', 'procurement@medtronicslovakia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('c197f20d-cef1-4b0d-a2c1-1853ed2082a1', 'procurement@medtronicslovakia.com', 'Lisa Williams', 'vendor', 'Medtronic Slovakia s.r.o.', '+642-7401406', '248 Industrial Way, Industrial District, 24588, Slovakia', 'Industrial District', 'Slovakia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5eebd87b-e9cc-4ef2-a7de-347ff907016c', 'c197f20d-cef1-4b0d-a2c1-1853ed2082a1', 'Medtronic Slovakia s.r.o.', 'REG-919199', 'Pharmaceuticals', 4.8, 'Lisa Williams', 'procurement@medtronicslovakia.com', '+642-7401406', '248 Industrial Way, Industrial District, 24588, Slovakia', 'Industrial District', 'Slovakia', true, '', '{"Slovakia"}', '{"Pharmaceuticals"}', 'dfe71639-55cb-48a0-957e-f634576ffa87', 'distributor');
SELECT public.create_user('a391670e-d65f-42fc-81c7-23923a1278f3', 'procurement@vita.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a391670e-d65f-42fc-81c7-23923a1278f3', 'procurement@vita.com', 'Lisa Williams', 'vendor', 'Vita Pharma Slovakia s.r.o.', '+705-5174263', '329 Main St, Industrial District, 52905, Slovakia', 'Industrial District', 'Slovakia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5f813135-b72c-4c18-bc15-794098325e99', 'a391670e-d65f-42fc-81c7-23923a1278f3', 'Vita Pharma Slovakia s.r.o.', 'REG-793813', 'Wound Care', 4.8, 'Lisa Williams', 'procurement@vita.com', '+705-5174263', '329 Main St, Industrial District, 52905, Slovakia', 'Industrial District', 'Slovakia', true, 'SK 213475990', '{"Slovakia"}', '{"Wound Care","OTC","Vaccines"}', '78712fb4-1f9b-4947-bd66-2170c709c52d', 'distributor');
SELECT public.create_user('9faef783-2f19-4ada-ae21-96233ad61561', 'procurement@universal.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9faef783-2f19-4ada-ae21-96233ad61561', 'procurement@universal.com', 'Sarah Davis', 'vendor', 'Universal Medical Slovakia', '+921-4535110', '718 Business Park, Industrial District, 59140, Slovakia', 'Industrial District', 'Slovakia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('89b436b8-8d63-4ae4-b3fb-c39f9a0ed473', '9faef783-2f19-4ada-ae21-96233ad61561', 'Universal Medical Slovakia', 'REG-183503', 'Vaccines', 4.6, 'Sarah Davis', 'procurement@universal.com', '+921-4535110', '718 Business Park, Industrial District, 59140, Slovakia', 'Industrial District', 'Slovakia', true, 'SK 533889131', '{"Slovakia"}', '{"Vaccines","Optical","Surgery"}', '2be69e0d-aab9-48ca-ae5d-4828c0881aa4', 'distributor');
SELECT public.create_user('095eb108-90d7-4403-9a2b-dbcd7e053897', 'procurement@sanus.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('095eb108-90d7-4403-9a2b-dbcd7e053897', 'procurement@sanus.com', 'Michael Smith', 'vendor', 'Sanus Medical Slovakia', '+616-7393100', '875 Commerce Blvd, Business Quarter, 81605, Slovakia', 'Business Quarter', 'Slovakia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c0a89425-9717-4510-b3eb-74ec061da4f2', '095eb108-90d7-4403-9a2b-dbcd7e053897', 'Sanus Medical Slovakia', 'REG-386374', 'Branded Pharma', 3.8, 'Michael Smith', 'procurement@sanus.com', '+616-7393100', '875 Commerce Blvd, Business Quarter, 81605, Slovakia', 'Business Quarter', 'Slovakia', true, 'SK 738721365', '{"Slovakia"}', '{"Branded Pharma","Vaccines"}', '5bdbdf97-d956-4d03-b3ee-b3713ef6f2c4', 'distributor');
SELECT public.create_user('db5904ba-993e-42d6-a095-cae424fe68c6', 'procurement@quality.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('db5904ba-993e-42d6-a095-cae424fe68c6', 'procurement@quality.com', 'Lisa Jones', 'vendor', 'Quality Distribution Slovakia', '+440-1575515', '625 Industrial Way, Industrial District, 64975, Slovakia', 'Industrial District', 'Slovakia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1faa293b-e993-4c1f-b53a-8d518786f5b6', 'db5904ba-993e-42d6-a095-cae424fe68c6', 'Quality Distribution Slovakia', 'REG-174583', 'Radiology', 3.6, 'Lisa Jones', 'procurement@quality.com', '+440-1575515', '625 Industrial Way, Industrial District, 64975, Slovakia', 'Industrial District', 'Slovakia', true, 'SK 396880287', '{"Slovakia"}', '{"Radiology","Orthopedics"}', '8a16cbee-d175-4a87-b0ee-d920dd0b0b96', 'distributor');

-- VENDORS FOR SLOVENIA
SELECT public.create_user('07bca9c1-b95b-4f67-ab44-ed4ab0acaf07', 'procurement@medtronicslovenia.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('07bca9c1-b95b-4f67-ab44-ed4ab0acaf07', 'procurement@medtronicslovenia.com', 'Michael Brown', 'vendor', 'Medtronic d.o.o.', '+552-5849480', '851 Main St, Business Quarter, 71399, Slovenia', 'Business Quarter', 'Slovenia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fd45b700-1c6c-49af-b1a3-3844d8c226c1', '07bca9c1-b95b-4f67-ab44-ed4ab0acaf07', 'Medtronic d.o.o.', 'REG-107620', 'Pharmaceuticals', 4.1, 'Michael Brown', 'procurement@medtronicslovenia.com', '+552-5849480', '851 Main St, Business Quarter, 71399, Slovenia', 'Business Quarter', 'Slovenia', true, '', '{"Slovenia"}', '{"Pharmaceuticals"}', 'c88fb7ae-7c5d-4f7a-a300-adce21cac20a', 'distributor');
SELECT public.create_user('71910f04-bd4a-4ed9-b428-108bc163aa68', 'procurement@cura.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('71910f04-bd4a-4ed9-b428-108bc163aa68', 'procurement@cura.com', 'Emma Brown', 'vendor', 'Cura Medical Slovenia', '+302-1473222', '488 Main St, Industrial District, 78179, Slovenia', 'Industrial District', 'Slovenia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('476b6be2-157e-4384-8da0-eeb5dcb3ce97', '71910f04-bd4a-4ed9-b428-108bc163aa68', 'Cura Medical Slovenia', 'REG-119016', 'Biologics', 4.5, 'Emma Brown', 'procurement@cura.com', '+302-1473222', '488 Main St, Industrial District, 78179, Slovenia', 'Industrial District', 'Slovenia', true, 'SI417843555', '{"Slovenia"}', '{"Biologics","OTC","Branded Pharma","Generic Drugs"}', '7010c24d-3380-4a61-8a47-4ddda4f1fcb0', 'distributor');
SELECT public.create_user('9a3c7d25-f046-4df7-832b-d23ee18730e5', 'procurement@vita.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9a3c7d25-f046-4df7-832b-d23ee18730e5', 'procurement@vita.com', 'Emma Williams', 'vendor', 'Vita Pharma Slovenia d.o.o.', '+800-9175840', '104 Business Park, Business Quarter, 79597, Slovenia', 'Business Quarter', 'Slovenia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a13ca52a-dfec-4229-ae44-b1539a9e184e', '9a3c7d25-f046-4df7-832b-d23ee18730e5', 'Vita Pharma Slovenia d.o.o.', 'REG-118836', 'Cardiology', 3.5, 'Emma Williams', 'procurement@vita.com', '+800-9175840', '104 Business Park, Business Quarter, 79597, Slovenia', 'Business Quarter', 'Slovenia', true, 'SI940757230', '{"Slovenia"}', '{"Cardiology","Patient Monitoring"}', 'ae404c95-47c0-4dfe-af55-add6503dde38', 'distributor');
SELECT public.create_user('a12f1657-5e3c-4357-a7e3-08dd15201811', 'procurement@united.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a12f1657-5e3c-4357-a7e3-08dd15201811', 'procurement@united.com', 'David Williams', 'vendor', 'United Distribution Slovenia', '+362-5046799', '822 Main St, City Center, 62576, Slovenia', 'City Center', 'Slovenia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0d3159db-9896-4eca-af06-e80b89f440ae', 'a12f1657-5e3c-4357-a7e3-08dd15201811', 'United Distribution Slovenia', 'REG-603159', 'Generic Drugs', 4.8, 'David Williams', 'procurement@united.com', '+362-5046799', '822 Main St, City Center, 62576, Slovenia', 'City Center', 'Slovenia', true, 'SI659798130', '{"Slovenia"}', '{"Generic Drugs","Pharmaceuticals"}', 'b3783bbb-844d-486c-9521-a9d45751781b', 'distributor');
SELECT public.create_user('a27f6639-49ca-48ee-b683-f4f1f3bfc277', 'procurement@superior.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a27f6639-49ca-48ee-b683-f4f1f3bfc277', 'procurement@superior.com', 'Emma Smith', 'vendor', 'Superior Distribution Slovenia', '+797-2190111', '677 Business Park, City Center, 25443, Slovenia', 'City Center', 'Slovenia', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0a9b519c-7211-46eb-aca6-6c23f28e1473', 'a27f6639-49ca-48ee-b683-f4f1f3bfc277', 'Superior Distribution Slovenia', 'REG-291460', 'Optical', 4.8, 'Emma Smith', 'procurement@superior.com', '+797-2190111', '677 Business Park, City Center, 25443, Slovenia', 'City Center', 'Slovenia', true, 'SI626906106', '{"Slovenia"}', '{"Optical","Dental","Consumables","Radiology"}', '8a46cc0b-5a4a-41a7-a99b-f2e49bc3af2f', 'distributor');

-- VENDORS FOR SPAIN
SELECT public.create_user('1eab11cf-bb07-4d06-bfa3-161c2771190f', 'procurement@cofares.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1eab11cf-bb07-4d06-bfa3-161c2771190f', 'procurement@cofares.com', 'Michael Davis', 'vendor', 'Cofares S.A.', '+790-3146632', '557 Main St, Industrial District, 85491, Spain', 'Industrial District', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d8a42388-491b-468f-9a10-0c1367a0e6f2', '1eab11cf-bb07-4d06-bfa3-161c2771190f', 'Cofares S.A.', 'REG-865346', 'Pharmaceuticals', 3.5, 'Michael Davis', 'procurement@cofares.com', '+790-3146632', '557 Main St, Industrial District, 85491, Spain', 'Industrial District', 'Spain', true, '', '{"Spain"}', '{"Pharmaceuticals"}', 'b1878755-f74d-4a9f-8bbb-5ea935eef27e', 'distributor');
SELECT public.create_user('cdb3d5b8-71f9-4680-a623-bed400fbbf36', 'procurement@hefame.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('cdb3d5b8-71f9-4680-a623-bed400fbbf36', 'procurement@hefame.com', 'Lisa Johnson', 'vendor', 'Hefame S.A.', '+357-7183885', '57 Main St, Business Quarter, 52725, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('fc9c553b-19a8-4ebd-aec4-63a68bc02f17', 'cdb3d5b8-71f9-4680-a623-bed400fbbf36', 'Hefame S.A.', 'REG-864860', 'Pharmaceuticals', 4.9, 'Lisa Johnson', 'procurement@hefame.com', '+357-7183885', '57 Main St, Business Quarter, 52725, Spain', 'Business Quarter', 'Spain', true, '', '{"Spain"}', '{"Pharmaceuticals"}', '72235c41-5f8b-4af3-a1f7-58f670c07624', 'distributor');
SELECT public.create_user('1f9f60eb-f1b0-4081-a25a-d9375025442f', 'procurement@medtronicspain.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1f9f60eb-f1b0-4081-a25a-d9375025442f', 'procurement@medtronicspain.com', 'David Williams', 'vendor', 'Medtronic Iberica S.A.', '+507-8530501', '503 Main St, Business Quarter, 91608, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c3a3579f-3a08-4308-8f9d-4f3477e8c799', '1f9f60eb-f1b0-4081-a25a-d9375025442f', 'Medtronic Iberica S.A.', 'REG-847269', 'Pharmaceuticals', 4.1, 'David Williams', 'procurement@medtronicspain.com', '+507-8530501', '503 Main St, Business Quarter, 91608, Spain', 'Business Quarter', 'Spain', true, '', '{"Spain"}', '{"Pharmaceuticals"}', '1117b496-e9ae-4f07-b9c0-9950a568bd38', 'distributor');
SELECT public.create_user('40905949-22ba-437a-881d-00606cba30b6', 'procurement@freseniusspain.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('40905949-22ba-437a-881d-00606cba30b6', 'procurement@freseniusspain.com', 'Lisa Johnson', 'vendor', 'Fresenius Medical Care España S.A.', '+123-7705195', '828 Commerce Blvd, Business Quarter, 89514, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('82d6937e-b0d2-4deb-90ed-f9cb1fffa0c4', '40905949-22ba-437a-881d-00606cba30b6', 'Fresenius Medical Care España S.A.', 'REG-153660', 'Pharmaceuticals', 4.6, 'Lisa Johnson', 'procurement@freseniusspain.com', '+123-7705195', '828 Commerce Blvd, Business Quarter, 89514, Spain', 'Business Quarter', 'Spain', true, '', '{"Spain"}', '{"Pharmaceuticals"}', '3263abff-211d-47d7-ac65-354ba8a7c974', 'distributor');
SELECT public.create_user('019cb00e-b7eb-4cca-b24b-7e39b2c78372', 'procurement@rochediagnosticsspain.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('019cb00e-b7eb-4cca-b24b-7e39b2c78372', 'procurement@rochediagnosticsspain.com', 'Emma Williams', 'vendor', 'Roche Diagnostics Spain S.L.', '+126-3496856', '790 Main St, Business Quarter, 76736, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('85e78f05-6a23-44cc-9cc8-e344749b4c61', '019cb00e-b7eb-4cca-b24b-7e39b2c78372', 'Roche Diagnostics Spain S.L.', 'REG-185565', 'Pharmaceuticals', 4.6, 'Emma Williams', 'procurement@rochediagnosticsspain.com', '+126-3496856', '790 Main St, Business Quarter, 76736, Spain', 'Business Quarter', 'Spain', true, '', '{"Spain"}', '{"Pharmaceuticals"}', 'f71a39db-8f2f-44cb-b61f-e392f0bc2488', 'distributor');
SELECT public.create_user('ba5614d2-0cdc-4205-bca2-b98ca871e58b', 'procurement@prime.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ba5614d2-0cdc-4205-bca2-b98ca871e58b', 'procurement@prime.com', 'Emma Smith', 'vendor', 'Prime Healthcare ES', '+212-6188948', '438 Business Park, City Center, 48558, Spain', 'City Center', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('c473fede-4866-4b4e-9022-5dd26c0a49c2', 'ba5614d2-0cdc-4205-bca2-b98ca871e58b', 'Prime Healthcare ES', 'REG-726720', 'Biologics', 4.5, 'Emma Smith', 'procurement@prime.com', '+212-6188948', '438 Business Park, City Center, 48558, Spain', 'City Center', 'Spain', true, 'ES227737931A', '{"Spain"}', '{"Biologics","Branded Pharma","Pharmaceuticals","Generic Drugs"}', '6791ad67-d0cb-4ad8-85ef-4e73492e5a12', 'distributor');
SELECT public.create_user('9fb862fa-530e-4b8e-94a9-57bc013d8980', 'procurement@alpine.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9fb862fa-530e-4b8e-94a9-57bc013d8980', 'procurement@alpine.com', 'Emma Jones', 'vendor', 'Alpine Healthcare ES', '+225-2553780', '220 Commerce Blvd, Industrial District, 67364, Spain', 'Industrial District', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('add7a167-0cc1-42db-8cf9-96029a8f979d', '9fb862fa-530e-4b8e-94a9-57bc013d8980', 'Alpine Healthcare ES', 'REG-947094', 'Branded Pharma', 4.7, 'Emma Jones', 'procurement@alpine.com', '+225-2553780', '220 Commerce Blvd, Industrial District, 67364, Spain', 'Industrial District', 'Spain', true, 'ES538611919A', '{"Spain"}', '{"Branded Pharma","Generic Drugs","Biologics","Pharmaceuticals"}', '75a356ca-6443-4912-8b4b-b48c821495a1', 'distributor');
SELECT public.create_user('e37939a7-0493-4ab9-bd74-63bdee6a9c5f', 'procurement@baltic.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e37939a7-0493-4ab9-bd74-63bdee6a9c5f', 'procurement@baltic.com', 'John Brown', 'vendor', 'Baltic Medical Spain', '+812-2523963', '20 Main St, Business Quarter, 60810, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('6d02dd92-1f12-4907-8b4c-f996538c56e2', 'e37939a7-0493-4ab9-bd74-63bdee6a9c5f', 'Baltic Medical Spain', 'REG-224690', 'Vaccines', 4.0, 'John Brown', 'procurement@baltic.com', '+812-2523963', '20 Main St, Business Quarter, 60810, Spain', 'Business Quarter', 'Spain', true, 'ES213937732A', '{"Spain"}', '{"Vaccines","Branded Pharma","Generic Drugs"}', '18bd2235-0c67-4926-9c73-532c334f11b7', 'distributor');
SELECT public.create_user('40463524-329f-4e0e-be9e-d1c2552b4e54', 'procurement@mediterranean.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('40463524-329f-4e0e-be9e-d1c2552b4e54', 'procurement@mediterranean.com', 'Emma Williams', 'vendor', 'Mediterranean Pharma España S.A.', '+566-5407120', '515 Industrial Way, Industrial District, 67761, Spain', 'Industrial District', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1148f011-713b-4804-8ce2-3eb51cdf7c33', '40463524-329f-4e0e-be9e-d1c2552b4e54', 'Mediterranean Pharma España S.A.', 'REG-283257', 'Branded Pharma', 4.3, 'Emma Williams', 'procurement@mediterranean.com', '+566-5407120', '515 Industrial Way, Industrial District, 67761, Spain', 'Industrial District', 'Spain', true, 'ES622582477A', '{"Spain"}', '{"Branded Pharma","Vaccines","Pharmaceuticals","Biologics"}', '22d6ea40-a6bb-4e41-a515-cc2bdb64f192', 'distributor');
SELECT public.create_user('57254719-a8cf-423e-a45f-81cc7c40abea', 'procurement@advanced.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('57254719-a8cf-423e-a45f-81cc7c40abea', 'procurement@advanced.com', 'John Williams', 'vendor', 'Advanced Pharma España S.A.', '+617-3162374', '515 Main St, Business Quarter, 93683, Spain', 'Business Quarter', 'Spain', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d2fa1646-600c-4afa-8ee6-08e22ccec68a', '57254719-a8cf-423e-a45f-81cc7c40abea', 'Advanced Pharma España S.A.', 'REG-965609', 'Wound Care', 3.9, 'John Williams', 'procurement@advanced.com', '+617-3162374', '515 Main St, Business Quarter, 93683, Spain', 'Business Quarter', 'Spain', true, 'ES644540511A', '{"Spain"}', '{"Wound Care","Radiology","Anesthesia"}', '548783c8-43dd-4748-aa38-4958c15812dd', 'distributor');

-- VENDORS FOR SWEDEN
SELECT public.create_user('01ed591c-fc2d-4864-a1ec-40d3b52c383b', 'procurement@apotekensservice.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('01ed591c-fc2d-4864-a1ec-40d3b52c383b', 'procurement@apotekensservice.com', 'Emma Johnson', 'vendor', 'Apotekens Service AB', '+318-4224885', '240 Business Park, Business Quarter, 37920, Sweden', 'Business Quarter', 'Sweden', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('29d23d76-0415-470c-be20-599021e9c5e4', '01ed591c-fc2d-4864-a1ec-40d3b52c383b', 'Apotekens Service AB', 'REG-717529', 'Pharmaceuticals', 3.9, 'Emma Johnson', 'procurement@apotekensservice.com', '+318-4224885', '240 Business Park, Business Quarter, 37920, Sweden', 'Business Quarter', 'Sweden', true, '', '{"Sweden"}', '{"Pharmaceuticals"}', 'fd7e1350-10a3-4aa7-9cc7-c0d81ad128b0', 'distributor');
SELECT public.create_user('a2a4dc3b-b5f1-40fa-904c-7bdc94d961dd', 'procurement@medtronicsweden.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('a2a4dc3b-b5f1-40fa-904c-7bdc94d961dd', 'procurement@medtronicsweden.com', 'Sarah Smith', 'vendor', 'Medtronic AB', '+698-5969496', '45 Commerce Blvd, City Center, 89588, Sweden', 'City Center', 'Sweden', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('10a912ed-14c0-4823-9587-511e7c3323e5', 'a2a4dc3b-b5f1-40fa-904c-7bdc94d961dd', 'Medtronic AB', 'REG-547759', 'Pharmaceuticals', 4.8, 'Sarah Smith', 'procurement@medtronicsweden.com', '+698-5969496', '45 Commerce Blvd, City Center, 89588, Sweden', 'City Center', 'Sweden', true, '', '{"Sweden"}', '{"Pharmaceuticals"}', '3b409ec7-4268-4643-9ca4-9b0c517674a0', 'distributor');
SELECT public.create_user('5a49bbd6-c1ef-4ae9-8577-496c13c2cf76', 'procurement@getinge.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('5a49bbd6-c1ef-4ae9-8577-496c13c2cf76', 'procurement@getinge.com', 'Michael Williams', 'vendor', 'Getinge AB', '+217-7945189', '294 Business Park, Industrial District, 24721, Sweden', 'Industrial District', 'Sweden', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('8b2e02af-e37f-469f-8bee-cd62442a72bc', '5a49bbd6-c1ef-4ae9-8577-496c13c2cf76', 'Getinge AB', 'REG-163545', 'Pharmaceuticals', 4.7, 'Michael Williams', 'procurement@getinge.com', '+217-7945189', '294 Business Park, Industrial District, 24721, Sweden', 'Industrial District', 'Sweden', true, '', '{"Sweden"}', '{"Pharmaceuticals"}', '3f400050-aebb-4563-9ae5-0616d263ebd7', 'distributor');
SELECT public.create_user('f3223d9b-f5c3-4d63-b748-5272089a1ca4', 'procurement@elekta.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('f3223d9b-f5c3-4d63-b748-5272089a1ca4', 'procurement@elekta.com', 'John Smith', 'vendor', 'Elekta AB', '+943-6403344', '122 Main St, Business Quarter, 28028, Sweden', 'Business Quarter', 'Sweden', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('6b8f5641-9760-4478-bed4-1a9c422e3673', 'f3223d9b-f5c3-4d63-b748-5272089a1ca4', 'Elekta AB', 'REG-269206', 'Pharmaceuticals', 3.6, 'John Smith', 'procurement@elekta.com', '+943-6403344', '122 Main St, Business Quarter, 28028, Sweden', 'Business Quarter', 'Sweden', true, '', '{"Sweden"}', '{"Pharmaceuticals"}', '8d71a1f0-5d5f-4063-86d8-410d352e2a87', 'distributor');
SELECT public.create_user('463907d0-6410-4eaf-857b-c38080f765d6', 'procurement@continental.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('463907d0-6410-4eaf-857b-c38080f765d6', 'procurement@continental.com', 'Emma Jones', 'vendor', 'Continental Distribution Sweden', '+819-2346001', '428 Main St, City Center, 33756, Sweden', 'City Center', 'Sweden', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('171bc95f-c7eb-4d66-aebf-9aba2f557181', '463907d0-6410-4eaf-857b-c38080f765d6', 'Continental Distribution Sweden', 'REG-119121', 'Consumables', 3.9, 'Emma Jones', 'procurement@continental.com', '+819-2346001', '428 Main St, City Center, 33756, Sweden', 'City Center', 'Sweden', true, 'SE   847127598', '{"Sweden"}', '{"Consumables","Cardiology","Dental","Anesthesia"}', '8defae48-d0c6-4678-8cdd-3e2479489ee9', 'distributor');

-- VENDORS FOR SWITZERLAND
SELECT public.create_user('333d2e32-6a12-4a83-ba8f-38ef2036a79b', 'procurement@medtronicswitzerland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('333d2e32-6a12-4a83-ba8f-38ef2036a79b', 'procurement@medtronicswitzerland.com', 'John Smith', 'vendor', 'Medtronic (Schweiz) AG', '+311-2387836', '309 Commerce Blvd, City Center, 48459, Switzerland', 'City Center', 'Switzerland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('1636afae-e2c0-4531-9459-b8f52a0928e2', '333d2e32-6a12-4a83-ba8f-38ef2036a79b', 'Medtronic (Schweiz) AG', 'REG-349011', 'Pharmaceuticals', 4.0, 'John Smith', 'procurement@medtronicswitzerland.com', '+311-2387836', '309 Commerce Blvd, City Center, 48459, Switzerland', 'City Center', 'Switzerland', true, '', '{"Switzerland"}', '{"Pharmaceuticals"}', '83ac6214-b446-473d-99dc-4002d97914c8', 'distributor');
SELECT public.create_user('067dc32a-012c-42c0-9158-1c8ecaef4d3f', 'procurement@strykerswitzerland.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('067dc32a-012c-42c0-9158-1c8ecaef4d3f', 'procurement@strykerswitzerland.com', 'John Johnson', 'vendor', 'Stryker Switzerland AG', '+588-9640841', '321 Business Park, Industrial District, 95893, Switzerland', 'Industrial District', 'Switzerland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ef34ede5-fd47-4002-85d8-4fe6bc194164', '067dc32a-012c-42c0-9158-1c8ecaef4d3f', 'Stryker Switzerland AG', 'REG-729452', 'Pharmaceuticals', 4.2, 'John Johnson', 'procurement@strykerswitzerland.com', '+588-9640841', '321 Business Park, Industrial District, 95893, Switzerland', 'Industrial District', 'Switzerland', true, '', '{"Switzerland"}', '{"Pharmaceuticals"}', '3b89d090-0194-4be6-a8ed-a4abe2ecde21', 'distributor');
SELECT public.create_user('d1f6439f-379a-4808-97e3-e5a9b031fc03', 'procurement@zimmerbiometch.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('d1f6439f-379a-4808-97e3-e5a9b031fc03', 'procurement@zimmerbiometch.com', 'Sarah Smith', 'vendor', 'Zimmer Biomet Switzerland GmbH', '+727-6831787', '535 Main St, Industrial District, 98763, Switzerland', 'Industrial District', 'Switzerland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0fb8ffb4-78c0-4d56-8ed2-3ba42b2dc10a', 'd1f6439f-379a-4808-97e3-e5a9b031fc03', 'Zimmer Biomet Switzerland GmbH', 'REG-349147', 'Pharmaceuticals', 3.6, 'Sarah Smith', 'procurement@zimmerbiometch.com', '+727-6831787', '535 Main St, Industrial District, 98763, Switzerland', 'Industrial District', 'Switzerland', true, '', '{"Switzerland"}', '{"Pharmaceuticals"}', '52091506-e2e2-4cf5-8eb2-715b412c799f', 'distributor');
SELECT public.create_user('ea0ab3cf-2737-44a7-a1aa-51091558c29d', 'procurement@rochediagnosticsch.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ea0ab3cf-2737-44a7-a1aa-51091558c29d', 'procurement@rochediagnosticsch.com', 'Lisa Williams', 'vendor', 'Roche Diagnostics (Schweiz) AG', '+964-3240607', '138 Business Park, Industrial District, 28756, Switzerland', 'Industrial District', 'Switzerland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('5f1d7701-e6c4-4d02-9fa9-50b92bbd082a', 'ea0ab3cf-2737-44a7-a1aa-51091558c29d', 'Roche Diagnostics (Schweiz) AG', 'REG-181152', 'Pharmaceuticals', 4.5, 'Lisa Williams', 'procurement@rochediagnosticsch.com', '+964-3240607', '138 Business Park, Industrial District, 28756, Switzerland', 'Industrial District', 'Switzerland', true, '', '{"Switzerland"}', '{"Pharmaceuticals"}', '99810506-c360-4559-9a8b-afcdbb39007b', 'distributor');
SELECT public.create_user('209e6209-73c0-43b8-86b6-adcbc3abc316', 'procurement@global.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('209e6209-73c0-43b8-86b6-adcbc3abc316', 'procurement@global.com', 'Sarah Davis', 'vendor', 'Global Healthcare CH', '+793-5759063', '432 Industrial Way, Industrial District, 53189, Switzerland', 'Industrial District', 'Switzerland', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f0b3a627-aaa8-45b1-9f2f-a0accffc58df', '209e6209-73c0-43b8-86b6-adcbc3abc316', 'Global Healthcare CH', 'REG-424896', 'Vaccines', 4.5, 'Sarah Davis', 'procurement@global.com', '+793-5759063', '432 Industrial Way, Industrial District, 53189, Switzerland', 'Industrial District', 'Switzerland', true, 'CHE-192.544.256', '{"Switzerland"}', '{"Vaccines","Branded Pharma"}', 'd0ef1f61-9209-4121-abd4-4bef696a661f', 'distributor');

-- VENDORS FOR UNITED KINGDOM
SELECT public.create_user('1756fc62-3c65-49c7-a9a6-764dc5d1aa03', 'procurement@alliancehealthcareuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('1756fc62-3c65-49c7-a9a6-764dc5d1aa03', 'procurement@alliancehealthcareuk.com', 'David Williams', 'vendor', 'Alliance Healthcare (Distribution) Ltd', '+201-4698038', '253 Commerce Blvd, Industrial District, 64689, United Kingdom', 'Industrial District', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('9bf69d79-09b8-4541-a8e4-a461ecb890cd', '1756fc62-3c65-49c7-a9a6-764dc5d1aa03', 'Alliance Healthcare (Distribution) Ltd', 'REG-801480', 'Pharmaceuticals', 4.0, 'David Williams', 'procurement@alliancehealthcareuk.com', '+201-4698038', '253 Commerce Blvd, Industrial District, 64689, United Kingdom', 'Industrial District', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', '98144d89-786b-4f1c-8048-44cceacd7ff4', 'distributor');
SELECT public.create_user('0b0d2c1c-7d0f-4751-be3e-9b1a0e7e5053', 'procurement@phoenixuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('0b0d2c1c-7d0f-4751-be3e-9b1a0e7e5053', 'procurement@phoenixuk.com', 'Lisa Johnson', 'vendor', 'Phoenix Healthcare Distribution Ltd', '+219-8614177', '422 Commerce Blvd, City Center, 16727, United Kingdom', 'City Center', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('9e404c06-93f1-4822-96fa-4f30a886503f', '0b0d2c1c-7d0f-4751-be3e-9b1a0e7e5053', 'Phoenix Healthcare Distribution Ltd', 'REG-629399', 'Pharmaceuticals', 3.5, 'Lisa Johnson', 'procurement@phoenixuk.com', '+219-8614177', '422 Commerce Blvd, City Center, 16727, United Kingdom', 'City Center', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', 'ef252f3f-4d2f-41f3-ba12-f9c394cf8940', 'distributor');
SELECT public.create_user('6faf98c9-70c9-49cf-87fe-88c840739821', 'procurement@aah.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('6faf98c9-70c9-49cf-87fe-88c840739821', 'procurement@aah.com', 'Lisa Smith', 'vendor', 'AAH Pharmaceuticals Ltd', '+333-3716189', '711 Industrial Way, Industrial District, 25567, United Kingdom', 'Industrial District', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d4e4f7f1-6844-46ce-a246-d1a10f65ddc9', '6faf98c9-70c9-49cf-87fe-88c840739821', 'AAH Pharmaceuticals Ltd', 'REG-909623', 'Pharmaceuticals', 4.6, 'Lisa Smith', 'procurement@aah.com', '+333-3716189', '711 Industrial Way, Industrial District, 25567, United Kingdom', 'Industrial District', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', 'ef060b44-92b8-476f-843b-ee9da25d42d2', 'distributor');
SELECT public.create_user('4641c750-00d1-4c94-bc54-858972cf3e4a', 'procurement@medtronicuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('4641c750-00d1-4c94-bc54-858972cf3e4a', 'procurement@medtronicuk.com', 'Sarah Brown', 'vendor', 'Medtronic Ltd', '+807-9253283', '764 Industrial Way, Business Quarter, 73166, United Kingdom', 'Business Quarter', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ab9cabe4-a63a-488e-b393-6d68590d3af9', '4641c750-00d1-4c94-bc54-858972cf3e4a', 'Medtronic Ltd', 'REG-195693', 'Pharmaceuticals', 4.3, 'Sarah Brown', 'procurement@medtronicuk.com', '+807-9253283', '764 Industrial Way, Business Quarter, 73166, United Kingdom', 'Business Quarter', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', 'aaafee89-d216-470f-b151-f9353ccb8f1d', 'distributor');
SELECT public.create_user('ceeb04ae-9bd6-4ee8-b741-a516f2eadc86', 'procurement@smith&nephewuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ceeb04ae-9bd6-4ee8-b741-a516f2eadc86', 'procurement@smith&nephewuk.com', 'David Smith', 'vendor', 'Smith & Nephew Healthcare Ltd', '+944-1655566', '495 Commerce Blvd, Business Quarter, 77348, United Kingdom', 'Business Quarter', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('ec8a981a-12cf-45c9-a7bc-b734c89cbcc1', 'ceeb04ae-9bd6-4ee8-b741-a516f2eadc86', 'Smith & Nephew Healthcare Ltd', 'REG-258722', 'Pharmaceuticals', 3.7, 'David Smith', 'procurement@smith&nephewuk.com', '+944-1655566', '495 Commerce Blvd, Business Quarter, 77348, United Kingdom', 'Business Quarter', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', 'f2e497df-856c-4464-9de4-5dfc42f42ef2', 'distributor');
SELECT public.create_user('e651407e-7454-4be6-854e-98c02b56b5d1', 'procurement@siemensuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('e651407e-7454-4be6-854e-98c02b56b5d1', 'procurement@siemensuk.com', 'Lisa Johnson', 'vendor', 'Siemens Healthineers UK', '+632-4867354', '680 Main St, City Center, 92876, United Kingdom', 'City Center', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('a8e18030-9f73-473d-8adb-b5cd4674c590', 'e651407e-7454-4be6-854e-98c02b56b5d1', 'Siemens Healthineers UK', 'REG-214421', 'Pharmaceuticals', 4.0, 'Lisa Johnson', 'procurement@siemensuk.com', '+632-4867354', '680 Main St, City Center, 92876, United Kingdom', 'City Center', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', '67132684-1097-4c16-8168-b7c9aa59f063', 'distributor');
SELECT public.create_user('3db9e3e0-8c11-459b-b002-c07a05f44bc8', 'procurement@philipsuk.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('3db9e3e0-8c11-459b-b002-c07a05f44bc8', 'procurement@philipsuk.com', 'Sarah Johnson', 'vendor', 'Philips Healthcare UK', '+542-1059507', '601 Commerce Blvd, City Center, 27350, United Kingdom', 'City Center', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('f583138e-94b0-48f9-b2a2-7ccd25699d38', '3db9e3e0-8c11-459b-b002-c07a05f44bc8', 'Philips Healthcare UK', 'REG-800366', 'Pharmaceuticals', 3.5, 'Sarah Johnson', 'procurement@philipsuk.com', '+542-1059507', '601 Commerce Blvd, City Center, 27350, United Kingdom', 'City Center', 'United Kingdom', true, '', '{"United Kingdom"}', '{"Pharmaceuticals"}', '6b931298-adf6-4a12-92a3-9dff8e6c2113', 'distributor');
SELECT public.create_user('00615592-965b-4088-90c6-0a206f6887f3', 'procurement@health.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('00615592-965b-4088-90c6-0a206f6887f3', 'procurement@health.com', 'Sarah Williams', 'vendor', 'Health Medical UK', '+310-5755482', '641 Commerce Blvd, Industrial District, 18076, United Kingdom', 'Industrial District', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('d667036c-4024-4ba3-afd9-80567faf5be1', '00615592-965b-4088-90c6-0a206f6887f3', 'Health Medical UK', 'REG-106104', 'Cardiology', 4.6, 'Sarah Williams', 'procurement@health.com', '+310-5755482', '641 Commerce Blvd, Industrial District, 18076, United Kingdom', 'Industrial District', 'United Kingdom', true, 'GB490500604', '{"United Kingdom"}', '{"Cardiology","Dental","Laboratory","Diagnostics"}', 'cdc65d26-1dbf-4255-bb18-6cd2ef224c2c', 'distributor');
SELECT public.create_user('ad259925-a7f9-4be8-9ef2-1c22991fb0fa', 'procurement@national.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('ad259925-a7f9-4be8-9ef2-1c22991fb0fa', 'procurement@national.com', 'Michael Jones', 'vendor', 'National Pharma UK Ltd', '+930-6769818', '798 Industrial Way, City Center, 22553, United Kingdom', 'City Center', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('0108af0e-d055-4292-9e66-b6feb9177192', 'ad259925-a7f9-4be8-9ef2-1c22991fb0fa', 'National Pharma UK Ltd', 'REG-518734', 'Patient Monitoring', 4.1, 'Michael Jones', 'procurement@national.com', '+930-6769818', '798 Industrial Way, City Center, 22553, United Kingdom', 'City Center', 'United Kingdom', true, 'GB423324613', '{"United Kingdom"}', '{"Patient Monitoring","Radiology","Optical","Consumables"}', '096ba2c6-951d-431d-92d8-b86f43af9cfe', 'distributor');
SELECT public.create_user('9e8828cf-f12f-493d-b983-7fa21dd2c4a8', 'procurement@quality.com', 'Vendor@123', 'vendor');
INSERT INTO public.profiles (id, email, full_name, role, organization_name, phone, address, city, country, is_active) VALUES ('9e8828cf-f12f-493d-b983-7fa21dd2c4a8', 'procurement@quality.com', 'John Davis', 'vendor', 'Quality Healthcare UK', '+641-2172334', '967 Industrial Way, City Center, 91150, United Kingdom', 'City Center', 'United Kingdom', true);
INSERT INTO public.vendors (id, user_id, vendor_name, company_registration, vendor_type, rating, contact_person, contact_email, contact_phone, address, city, country, is_verified, vat_id, target_markets, interested_categories, duns_number, economic_role) VALUES ('36799d1b-fd81-456d-9838-1cd3b7305098', '9e8828cf-f12f-493d-b983-7fa21dd2c4a8', 'Quality Healthcare UK', 'REG-686094', 'Wound Care', 4.2, 'John Davis', 'procurement@quality.com', '+641-2172334', '967 Industrial Way, City Center, 91150, United Kingdom', 'City Center', 'United Kingdom', true, 'GB221030628', '{"United Kingdom"}', '{"Wound Care","Vaccines","Diagnostics"}', '593371bd-4e30-4d39-8658-5612c82247aa', 'distributor');

ALTER TABLE public.profiles ENABLE ROW LEVEL SECURITY;
ALTER TABLE public.vendors ENABLE ROW LEVEL SECURITY;

-- FINISHED: Created 175 Vendors