INSERT IGNORE INTO `company` (`uuid`, `aindex`, `name`, `enabled`, `migrated`, `ensure_required`, `migration`, `migration_target`, `StartTime`, `business_id`, `business_id_check`, `UpdateTime`, `datasource`, `street_post`, `zip_code_visit`, `city_visit`, `zip_code`, `city`, `address_visit`, `street_visit`, `notes`, `state`, `email`, `customer_value`, `area_uusimaa`, `area_varsinais`, `area_kymenlaakso`, `area_hame`, `area_satakunta`, `area_pohjanmaa`, `area_pohjois`, `area_lappi`, `devgroup_paine`, `devgroup_kemikaali`, `devgroup_nestekaasu`, `devgroup_maakaasu`, `devgroup_biokaasu`, `devgroup_vakadr`, `devgroup_a2`, `devgroup_g`, `devgroup_other`, `role_manufacturer`, `role_energyplant`, `role_government`, `role_processplant`, `role_transport`, `inspection_institution`, `inspection_date_next`, `inspection_overdue_count`, `inspection_upcoming_count`, `inspection_soon_count`, `ped_licence`) VALUES ('3894415e-9842-4b67-80cd-b98cd53302ca', '10450', 'Contoso Ltd', '1', '0', '1', '', '', '2021-04-29 10:02:16', '', '2', '2025-04-11 04:54:02', '', '', '', '', '', '', '', '', 'TestiX', 'active', '', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0');
INSERT IGNORE INTO `company` (`uuid`, `aindex`, `name`, `enabled`, `migrated`, `ensure_required`, `migration`, `migration_target`, `StartTime`, `business_id`, `business_id_check`, `UpdateTime`, `datasource`, `street_post`, `zip_code_visit`, `city_visit`, `zip_code`, `city`, `address_visit`, `street_visit`, `notes`, `state`, `email`, `customer_value`, `area_uusimaa`, `area_varsinais`, `area_kymenlaakso`, `area_hame`, `area_satakunta`, `area_pohjanmaa`, `area_pohjois`, `area_lappi`, `devgroup_paine`, `devgroup_kemikaali`, `devgroup_nestekaasu`, `devgroup_maakaasu`, `devgroup_biokaasu`, `devgroup_vakadr`, `devgroup_a2`, `devgroup_g`, `devgroup_other`, `role_manufacturer`, `role_energyplant`, `role_government`, `role_processplant`, `role_transport`, `inspection_institution`, `inspection_date_next`, `inspection_overdue_count`, `inspection_upcoming_count`, `inspection_soon_count`, `ped_licence`) VALUES ('c5dc4139-9bb5-4977-836d-3989421722fb', '10553', 'Möttönen Oy', '1', '0', '1', '', '', '2022-02-25 08:32:53', '8851303-7', '7', '2024-12-13 06:00:01', '', 'Möttöskatu 12', '02100', 'Säkylä', '02100', 'Säkylä', '', 'Tuotekatu 1', '', 'active', 'info@vodera.fi', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', 'admitted', '2025-03-13', '1', '1', '1', '1');
INSERT IGNORE INTO `company` (`uuid`, `aindex`, `name`, `enabled`, `migrated`, `ensure_required`, `migration`, `migration_target`, `StartTime`, `business_id`, `business_id_check`, `UpdateTime`, `datasource`, `street_post`, `zip_code_visit`, `city_visit`, `zip_code`, `city`, `address_visit`, `street_visit`, `notes`, `state`, `email`, `customer_value`, `area_uusimaa`, `area_varsinais`, `area_kymenlaakso`, `area_hame`, `area_satakunta`, `area_pohjanmaa`, `area_pohjois`, `area_lappi`, `devgroup_paine`, `devgroup_kemikaali`, `devgroup_nestekaasu`, `devgroup_maakaasu`, `devgroup_biokaasu`, `devgroup_vakadr`, `devgroup_a2`, `devgroup_g`, `devgroup_other`, `role_manufacturer`, `role_energyplant`, `role_government`, `role_processplant`, `role_transport`, `inspection_institution`, `inspection_date_next`, `inspection_overdue_count`, `inspection_upcoming_count`, `inspection_soon_count`, `ped_licence`) VALUES ('d4fdf94c-d88d-4f23-8986-17cec6878d7f', '10681', 'Contoso 2', '1', '0', '0', '', '', '2023-01-10 05:49:33', '', '2', '2025-04-11 05:09:06', '', '', '', '', '', '', '', '', 'TESTAUS', '', '', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0');
INSERT IGNORE INTO `company` (`uuid`, `aindex`, `name`, `enabled`, `migrated`, `ensure_required`, `migration`, `migration_target`, `StartTime`, `business_id`, `business_id_check`, `UpdateTime`, `datasource`, `street_post`, `zip_code_visit`, `city_visit`, `zip_code`, `city`, `address_visit`, `street_visit`, `notes`, `state`, `email`, `customer_value`, `area_uusimaa`, `area_varsinais`, `area_kymenlaakso`, `area_hame`, `area_satakunta`, `area_pohjanmaa`, `area_pohjois`, `area_lappi`, `devgroup_paine`, `devgroup_kemikaali`, `devgroup_nestekaasu`, `devgroup_maakaasu`, `devgroup_biokaasu`, `devgroup_vakadr`, `devgroup_a2`, `devgroup_g`, `devgroup_other`, `role_manufacturer`, `role_energyplant`, `role_government`, `role_processplant`, `role_transport`, `inspection_institution`, `inspection_date_next`, `inspection_overdue_count`, `inspection_upcoming_count`, `inspection_soon_count`, `ped_licence`) VALUES ('729b7f26-b770-4243-85cc-289d2f65a6cb', '10930', 'Testityönantaja Oy', '1', '0', '1', '', '', '2024-10-25 14:08:52', '1234567-1', '0', '2025-04-11 04:53:25', '', 'Uhrilähteenkatu 8', '20250', 'Turku', '20250', 'Turku', '', 'Uhrilähteenkatu 8', '', 'passive', 'info@testityontantaja.fi', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0');
