
INSERT INTO `animals` (`id`, `animal`, `created_at`, `updated_at`) VALUES
(1, 'Aves', NULL, NULL),
(2, 'Bovino', NULL, NULL),
(3, 'Caprino', NULL, NULL),
(4, 'Ovino', NULL, NULL),
(5, 'Suino', NULL, NULL),
(6, 'Outros', NULL, NULL);


INSERT INTO `app_config` (`id`, `setting`, `value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'MOSAP', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(2, 'app_title', 'MOSAP', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(3, 'app_keyword', 'ultimate sms, codeglen, bulk sms, sms, sms marketing', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(4, 'license', '033443d6-2255-4987-9ef7-837629786b11', '2023-09-23 11:29:24', '2023-09-23 06:36:33'),
(5, 'license_type', 'Regular License', '2023-09-23 11:29:24', '2023-09-23 06:36:33'),
(6, 'valid_domain', 'yes', '2023-09-23 11:29:24', '2023-09-23 06:36:33'),
(7, 'from_email', 'noreply@jurisdocs.ao', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(8, 'from_name', 'PDAC', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(9, 'company_address', 'House#11, Block#B, <br>Rampura<br>Banasree Project<br>Dhaka<br>1219<br>Bangladesh', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(10, 'software_version', '3.7.0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(11, 'footer_text', 'Copyright © 2024 | Desenvolvido por Mwango Click -', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(12, 'app_logo', 'images/logo/fa90021a78699bbb565302726c00c93a.png', '2023-09-23 11:29:24', '2023-09-25 21:16:28'),
(13, 'app_favicon', 'images/logo/428eedaaee070f72c0a4f14aa08be0c4.png', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(14, 'country', 'Angola', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(15, 'timezone', 'Africa/Luanda', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(16, 'app_stage', 'live', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(17, 'maintenance_mode', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(18, 'maintenance_mode_message', 'We\'re undergoing a bit of scheduled maintenance.', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(19, 'maintenance_mode_end', 'Jan 5, 2021 15:37:25', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(20, 'php_bin_path', '/usr/bin/php', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(21, 'driver', 'smtp', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(22, 'host', 'mail.jurisdocs.ao', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(23, 'username', 'noreply@jurisdocs.ao', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(24, 'password', 'Mb2016@mb', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(25, 'port', '465', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(26, 'encryption', 'ssl', '2023-09-23 11:29:24', '2023-09-25 17:59:51'),
(27, 'date_format', 'd/m/Y', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(28, 'language', 'pt', '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(29, 'client_registration', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(30, 'registration_verification', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(31, 'two_factor', '1', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(32, 'two_factor_send_by', 'email', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(33, 'captcha_in_login', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(34, 'captcha_in_client_registration', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(35, 'captcha_site_key', '6LcJxjcpAAAAAPB8AwR4J7RHeErBrWszQ2yomfCl', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(36, 'captcha_secret_key', '6LcJxjcpAAAAAAUTiKWZX9_hwPHk28e4ux0MdE_-', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(37, 'login_with_facebook', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(38, 'facebook_client_id', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(39, 'facebook_client_secret', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(40, 'login_with_twitter', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(41, 'twitter_client_id', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(42, 'twitter_client_secret', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(43, 'login_with_google', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(44, 'google_client_id', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(45, 'google_client_secret', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(46, 'login_with_github', '0', '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(47, 'github_client_id', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(48, 'github_client_secret', NULL, '2023-09-23 11:29:24', '2024-05-12 17:34:27'),
(49, 'notification_sms_gateway', '5eddfce2b68e6', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(50, 'notification_sender_id', 'PDAC', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(51, 'notification_phone', '8801721970168', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(52, 'notification_from_name', 'PDAC', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(53, 'notification_email', 'akasham67@gmail.com', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(54, 'sender_id_notification_email', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(55, 'sender_id_notification_sms', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(56, 'user_registration_notification_email', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(57, 'user_registration_notification_sms', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(58, 'subscription_notification_email', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(59, 'subscription_notification_sms', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(60, 'keyword_notification_email', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(61, 'keyword_notification_sms', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(62, 'phone_number_notification_email', '1', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(63, 'phone_number_notification_sms', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(64, 'block_message_notification_email', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(65, 'block_message_notification_sms', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(66, 'unsubscribe_message', 'Reply Stop to unsubscribe', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(67, 'custom_script', NULL, '2023-09-23 11:29:24', '2024-05-10 03:13:39'),
(68, 'login_notification_email', '0', '2023-09-23 11:29:24', '2023-09-23 11:29:24'),
(69, 'customer_permissions', '[\"view_mi\",\"approve_mi\",\"reject_mi\",\"view_reports\",\"access_backend\"]', '2023-09-23 11:29:24', '2024-05-10 04:58:55'),
(70, 'sms_available', '10417', NULL, '2024-05-21 12:35:03');


INSERT INTO `bank` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 'MOSAP', 1, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(2, 'BFA - Banco de Fomento Angola S.A.', 2, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(3, 'Banco Sol S.A.', 3, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(4, 'BIC - Banco BIC S.A.', 4, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(5, 'BAI - Banco Angolano de Investimentos S.A.', 5, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(6, 'BPC - Banco de Poupança e Crédito S.A', 6, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(7, 'Atlântico - Banco Millenium Atlântico S.A.', 7, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(8, 'BNI - Banco de Negócios Internacional S.A', 8, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(9, 'Standard Bank de Angola S.A', 9, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(10, 'Standard Chartered Bank Angola', 10, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(11, 'Banco Yetu, S.A.', 11, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(12, 'Banco VTB África, S.A', 12, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(13, 'Finibanco Angola S.A.', 13, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(14, 'Banco Keve S.A.', 14, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(15, 'Banco Valor S.A.', 15, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(16, 'Banco Prestígio, S.A', 16, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(17, 'Banco de Negócios Internacional S.A.', 17, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(18, 'Banco BAI Microfinanças S.A.', 18, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(19, 'Banco de Investimento Rural, S.A', 19, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(20, 'Banco Económico S.A.', 20, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(21, 'Banco da China Limitada - Sucursal em Luanda, S.A', 21, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(22, 'Banco de Desenvolvimento de Angola S.A', 22, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(23, 'Banco de Comércio e Indústria S.A', 23, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(24, 'Banco de Crédito do Sul, S.A.', 24, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(25, 'Banco Caixa Geral Angola, S.A.', 25, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(26, 'Banco Comercial do Huambo S.A.', 26, '2024-05-19 08:56:37', '2024-05-19 08:56:37'),
(27, 'Banco Comercial Angolano S.A.', 27, '2024-05-19 08:56:37', '2024-05-19 08:56:37');



INSERT INTO `category` (`id`, `uid`, `name`, `status`, `template_id`, `created_at`, `updated_at`) VALUES
(1, '63ccdac8-7596-49ba-9983-d99ee8909e4f', 'Candidatura Inválida', 1, 4, '2024-06-23 23:45:38', '2024-06-23 23:45:38'),
(2, '3d2a1b88-d73e-46d3-a4da-d1e0005b822a', 'Recusada por falta de área', 1, 11, '2024-06-23 23:45:38', '2024-06-23 23:45:38'),
(3, '371dfe4b-5611-4e43-94e2-44d3538ede95', 'Recusado por dívida', 1, NULL, '2024-06-24 00:33:02', '2024-06-24 00:33:02'),
(4, 'e06e0279-72d4-42c7-951e-71a965b1b7c1', 'Recusada por falta de documentação legal', 1, 12, '2024-06-24 00:33:02', '2024-06-24 00:33:02'),
(5, 'd53501f7-fa9d-458b-9041-280465d9dda6', 'Desistência do Proponente', 1, 5, '2024-07-15 13:38:50', '2024-07-15 13:38:50');



INSERT INTO `city` (`id`, `name`, `code`, `province_id`, `created_at`, `updated_at`) VALUES
(9, 'balombo', 201, 1, NULL, NULL),
(10, 'bocoio', 202, 1, NULL, NULL),
(11, 'cubal', 203, 1, NULL, NULL),
(12, 'menongue', 501, 2, NULL, NULL),
(13, 'cuanhama', 801, 3, NULL, NULL),
(14, 'chibia', 701, 4, NULL, NULL),
(15, 'quipungo', 702, 4, NULL, NULL),
(16, 'bibala', 1601, 5, NULL, NULL);



INSERT INTO `comunas` (`id`, `comuna`, `city_id`, `created_at`, `updated_at`) VALUES
(1, 'balombo', 9, NULL, NULL),
(2, 'chindumbo', 9, NULL, NULL),
(3, 'chindungo', 9, NULL, NULL),
(4, 'maca mambolo', 9, NULL, NULL),
(5, 'bocoio', 10, NULL, NULL),
(6, 'chila', 10, NULL, NULL),
(7, 'cubal do lumbo', 10, NULL, NULL),
(8, 'monte Belo', 10, NULL, NULL),
(9, 'passe', 10, NULL, NULL),
(10, 'capupa', 11, NULL, NULL),
(11, 'cubal', 11, NULL, NULL),
(12, 'lambala', 11, NULL, NULL),
(13, 'tumbulo', 11, NULL, NULL),
(14, 'calumdo', 12, NULL, NULL),
(15, 'cueio', 12, NULL, NULL),
(16, 'menongue/missombo', 12, NULL, NULL),
(17, 'Evale', 13, NULL, NULL),
(18, 'mongwa', 13, NULL, NULL),
(19, 'nehone Cafima', 13, NULL, NULL),
(20, 'Ondjiva', 13, NULL, NULL),
(21, 'tchomporo Oximolo', 13, NULL, NULL),
(22, 'capunda Cavilongo', 14, NULL, NULL),
(23, 'chibia', 14, NULL, NULL),
(24, 'Jau', 14, NULL, NULL),
(25, 'Quihita', 14, NULL, NULL),
(26, 'Quipungo', 15, NULL, NULL),
(27, 'Bibala', 16, NULL, NULL),
(28, 'caitou', 16, NULL, NULL),
(29, 'capangombe', 16, NULL, NULL),
(30, 'lola', 16, NULL, NULL);



INSERT INTO `countries` (`id`, `name`, `iso_code`, `country_code`, `status`, `created_at`, `updated_at`, `uid`) VALUES
(1, 'Afghanistan', 'AF', '93', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4dff5d'),
(2, 'Albania', 'AL', '355', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e0883'),
(3, 'Algeria', 'DZ', '213', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e10f5'),
(4, 'American Samoa', 'AS', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e2dae'),
(5, 'Andorra', 'AD', '376', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e35cc'),
(6, 'Angola', 'AO', '244', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e3d67'),
(7, 'Anguilla', 'AI', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e456c'),
(8, 'Antigua', 'AG', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e4d69'),
(9, 'Argentina', 'AR', '54', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e54b5'),
(10, 'Armenia', 'AM', '374', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e5c80'),
(11, 'Aruba', 'AW', '297', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e64de'),
(12, 'Australia', 'AU', '61', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e6cc3'),
(13, 'Austria', 'AT', '43', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e7464'),
(14, 'Azerbaijan', 'AZ', '994', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e7c07'),
(15, 'Bahrain', 'BH', '973', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e83a2'),
(16, 'Bangladesh', 'BD', '880', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e8b53'),
(17, 'Barbados', 'BB', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e92a4'),
(18, 'Belarus', 'BY', '375', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4e99f7'),
(19, 'Belgium', 'BE', '32', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ea1e5'),
(20, 'Belize', 'BZ', '501', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4eaa2d'),
(21, 'Benin', 'BJ', '229', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4eb2c9'),
(22, 'Bermuda', 'BM', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4eba90'),
(23, 'Bhutan', 'BT', '975', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ec297'),
(24, 'Bolivia', 'BO', '591', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ecb19'),
(25, 'Bosnia and Herzegovina', 'BA', '387', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ed412'),
(26, 'Botswana', 'BW', '267', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ee822'),
(27, 'Brazil', 'BR', '55', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4eefa9'),
(28, 'British Indian Ocean Territory', 'IO', '246', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4ef76a'),
(29, 'British Virgin Islands', 'VG', '1', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4eff88'),
(30, 'Brunei', 'BN', '673', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f0ba5'),
(31, 'Bulgaria', 'BG', '359', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f13c1'),
(32, 'Burkina Faso', 'BF', '226', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f1bf6'),
(33, 'Burma Myanmar', 'MM', '95', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f23d7'),
(34, 'Burundi', 'BI', '257', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f32a1'),
(35, 'Cambodia', 'KH', '855', 1, '2023-09-23 10:29:24', '2023-09-23 10:29:24', '650f74d4f3a37'),
(36, 'Cameroon', 'CM', '237', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d4f423b'),
(37, 'Canada', 'CA', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50086b'),
(38, 'Cape Verde', 'CV', '238', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5016b5'),
(39, 'Cayman Islands', 'KY', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d501f3f'),
(40, 'Central African Republic', 'CF', '236', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d502768'),
(41, 'Chad', 'TD', '235', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d503084'),
(42, 'Chile', 'CL', '56', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d503e77'),
(43, 'China', 'CN', '86', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d504626'),
(44, 'Colombia', 'CO', '57', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d504df1'),
(45, 'Comoros', 'KM', '269', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50562a'),
(46, 'Cook Islands', 'CK', '682', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50656a'),
(47, 'Costa Rica', 'CR', '506', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d506d78'),
(48, 'Côte d\'Ivoire', 'CI', '225', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d507532'),
(49, 'Croatia', 'HR', '385', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d507cb9'),
(50, 'Cuba', 'CU', '53', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d508cff'),
(51, 'Cyprus', 'CY', '357', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d509562'),
(52, 'Czech Republic', 'CZ', '420', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d509c37'),
(53, 'Democratic Republic of Congo', 'CD', '243', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50a2e2'),
(54, 'Denmark', 'DK', '45', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50a97c'),
(55, 'Djibouti', 'DJ', '253', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50b058'),
(56, 'Dominica', 'DM', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50b6fd'),
(57, 'Dominican Republic', 'DO', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50be08'),
(58, 'Ecuador', 'EC', '593', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50c4a3'),
(59, 'Egypt', 'EG', '20', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50cb51'),
(60, 'El Salvador', 'SV', '503', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50e01d'),
(61, 'Equatorial Guinea', 'GQ', '240', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50ec3b'),
(62, 'Eritrea', 'ER', '291', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d50f8e3'),
(63, 'Estonia', 'EE', '372', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d510547'),
(64, 'Ethiopia', 'ET', '251', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d511189'),
(65, 'Falkland Islands', 'FK', '500', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d511de7'),
(66, 'Faroe Islands', 'FO', '298', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d512ce4'),
(67, 'Federated States of Micronesia', 'FM', '691', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5138f9'),
(68, 'Fiji', 'FJ', '679', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d514774'),
(69, 'Finland', 'FI', '358', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d515595'),
(70, 'France', 'FR', '33', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d516204'),
(71, 'French Guiana', 'GF', '594', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d516ce1'),
(72, 'French Polynesia', 'PF', '689', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5177ef'),
(73, 'Gabon', 'GA', '241', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d518223'),
(74, 'Georgia', 'GE', '995', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d518bd9'),
(75, 'Germany', 'DE', '49', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51964e'),
(76, 'Ghana', 'GH', '233', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51a01d'),
(77, 'Gibraltar', 'GI', '350', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51a82d'),
(78, 'Greece', 'GR', '30', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51b0a4'),
(79, 'Greenland', 'GL', '299', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51bbb5'),
(80, 'Grenada', 'GD', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51c654'),
(81, 'Guadeloupe', 'GP', '590', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51cdb0'),
(82, 'Guam', 'GU', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51d5b3'),
(83, 'Guatemala', 'GT', '502', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51ddba'),
(84, 'Guinea', 'GN', '224', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51eeee'),
(85, 'Guinea-Bissau', 'GW', '245', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51f6da'),
(86, 'Guyana', 'GY', '592', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d51ff95'),
(87, 'Haiti', 'HT', '509', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5207cd'),
(88, 'Honduras', 'HN', '504', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d520fc3'),
(89, 'Hong Kong', 'HK', '852', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5217d4'),
(90, 'Hungary', 'HU', '36', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d522007'),
(91, 'Iceland', 'IS', '354', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d522854'),
(92, 'India', 'IN', '91', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d523108'),
(93, 'Indonesia', 'ID', '62', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5241dd'),
(94, 'Iran', 'IR', '98', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5249cd'),
(95, 'Iraq', 'IQ', '964', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5251c7'),
(96, 'Ireland', 'IE', '353', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52664a'),
(97, 'Israel', 'IL', '972', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52766d'),
(98, 'Italy', 'IT', '39', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d528b8d'),
(99, 'Jamaica', 'JM', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d529473'),
(100, 'Japan', 'JP', '81', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d529c90'),
(101, 'Jordan', 'JO', '962', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52a474'),
(102, 'Kazakhstan', 'KZ', '7', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52ad79'),
(103, 'Kenya', 'KE', '254', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52b6fe'),
(104, 'Kiribati', 'KI', '686', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52bf40'),
(105, 'Kosovo', 'XK', '381', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52c774'),
(106, 'Kuwait', 'KW', '965', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52d975'),
(107, 'Kyrgyzstan', 'KG', '996', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52e1d2'),
(108, 'Laos', 'LA', '856', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52e9de'),
(109, 'Latvia', 'LV', '371', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52f113'),
(110, 'Lebanon', 'LB', '961', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d52fb66'),
(111, 'Lesotho', 'LS', '266', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5305d4'),
(112, 'Liberia', 'LR', '231', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d530f22'),
(113, 'Libya', 'LY', '218', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53176d'),
(114, 'Liechtenstein', 'LI', '423', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d533dc1'),
(115, 'Lithuania', 'LT', '370', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d534cbf'),
(116, 'Luxembourg', 'LU', '352', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5356e3'),
(117, 'Macau', 'MO', '853', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d536084'),
(118, 'Macedonia', 'MK', '389', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d536a42'),
(119, 'Madagascar', 'MG', '261', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d537264'),
(120, 'Malawi', 'MW', '265', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d537a45'),
(121, 'Malaysia', 'MY', '60', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5382bb'),
(122, 'Maldives', 'MV', '960', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d538eca'),
(123, 'Mali', 'ML', '223', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d539e11'),
(124, 'Malta', 'MT', '356', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53a683'),
(125, 'Marshall Islands', 'MH', '692', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53ae3a'),
(126, 'Martinique', 'MQ', '596', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53b728'),
(127, 'Mauritania', 'MR', '222', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53bfe1'),
(128, 'Mauritius', 'MU', '230', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53c878'),
(129, 'Mayotte', 'YT', '262', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53d438'),
(130, 'Mexico', 'MX', '52', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53e2d9'),
(131, 'Moldova', 'MD', '373', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53eaac'),
(132, 'Monaco', 'MC', '377', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53f308'),
(133, 'Mongolia', 'MN', '976', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d53fb6c'),
(134, 'Montenegro', 'ME', '382', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54032e'),
(135, 'Montserrat', 'MS', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5409cc'),
(136, 'Morocco', 'MA', '212', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d541082'),
(137, 'Mozambique', 'MZ', '258', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5417ce'),
(138, 'Namibia', 'NA', '264', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5420ac'),
(139, 'Nauru', 'NR', '674', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d542a84'),
(140, 'Nepal', 'NP', '977', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d543912'),
(141, 'Netherlands', 'NL', '31', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54415e'),
(142, 'Netherlands Antilles', 'AN', '599', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54492d'),
(143, 'New Caledonia', 'NC', '687', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d545c97'),
(144, 'New Zealand', 'NZ', '64', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5465ff'),
(145, 'Nicaragua', 'NI', '505', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d546f27'),
(146, 'Niger', 'NE', '227', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54798a'),
(147, 'Nigeria', 'NG', '234', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5483cb'),
(148, 'Niue', 'NU', '683', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d548bff'),
(149, 'Norfolk Island', 'NF', '672', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5493f3'),
(150, 'North Korea', 'KP', '850', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d549c26'),
(151, 'Northern Mariana Islands', 'MP', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54aa98'),
(152, 'Norway', 'NO', '47', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54b324'),
(153, 'Oman', 'OM', '968', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54ba72'),
(154, 'Pakistan', 'PK', '92', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54c1aa'),
(155, 'Palau', 'PW', '680', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54c8d7'),
(156, 'Palestine', 'PS', '970', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54d092'),
(157, 'Panama', 'PA', '507', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54d851'),
(158, 'Papua New Guinea', 'PG', '675', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54df11'),
(159, 'Paraguay', 'PY', '595', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54e5a7'),
(160, 'Peru', 'PE', '51', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54ed1e'),
(161, 'Philippines', 'PH', '63', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d54fd68'),
(162, 'Poland', 'PL', '48', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55052b'),
(163, 'Portugal', 'PT', '351', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d550d40'),
(164, 'Puerto Rico', 'PR', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55177e'),
(165, 'Qatar', 'QA', '974', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d551eef'),
(166, 'Republic of the Congo', 'CG', '242', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5525f0'),
(167, 'Réunion', 'RE', '262', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d552cd9'),
(168, 'Romania', 'RO', '40', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5533f8'),
(169, 'Russia', 'RU', '7', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d553b8c'),
(170, 'Rwanda', 'RW', '250', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d554daf'),
(171, 'Saint Barthélemy', 'BL', '590', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5558fa'),
(172, 'Saint Helena', 'SH', '290', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d555fba'),
(173, 'Saint Kitts and Nevis', 'KN', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55701b'),
(174, 'Saint Martin', 'MF', '590', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d557694'),
(175, 'Saint Pierre and Miquelon', 'PM', '508', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d557d3d'),
(176, 'Saint Vincent and the Grenadines', 'VC', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5583b0'),
(177, 'Samoa', 'WS', '685', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d558b37'),
(178, 'San Marino', 'SM', '378', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55a8b4'),
(179, 'São Tomé and Príncipe', 'ST', '239', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55b645'),
(180, 'Saudi Arabia', 'SA', '966', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55c238'),
(181, 'Senegal', 'SN', '221', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55ce31'),
(182, 'Serbia', 'RS', '381', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d55ec90'),
(183, 'Seychelles', 'SC', '248', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d561030'),
(184, 'Sierra Leone', 'SL', '232', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5686fa'),
(185, 'Singapore', 'SG', '65', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d56970c'),
(186, 'Slovakia', 'SK', '421', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d56b4a7'),
(187, 'Slovenia', 'SI', '386', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d56c553'),
(188, 'Solomon Islands', 'SB', '677', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d56f05a'),
(189, 'Somalia', 'SO', '252', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d571736'),
(190, 'South Africa', 'ZA', '27', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d572842'),
(191, 'South Korea', 'KR', '82', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d573c25'),
(192, 'Spain', 'ES', '34', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57659c'),
(193, 'Sri Lanka', 'LK', '94', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5784dd'),
(194, 'St. Lucia', 'LC', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d579c5b'),
(195, 'Sudan', 'SD', '249', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57ac29'),
(196, 'Suriname', 'SR', '597', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57bdc4'),
(197, 'Swaziland', 'SZ', '268', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57cd70'),
(198, 'Sweden', 'SE', '46', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57e688'),
(199, 'Switzerland', 'CH', '41', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d57f681'),
(200, 'Syria', 'SY', '963', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d580c4a'),
(201, 'Taiwan', 'TW', '886', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d581be3'),
(202, 'Tajikistan', 'TJ', '992', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5833ac'),
(203, 'Tanzania', 'TZ', '255', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d584335'),
(204, 'Thailand', 'TH', '66', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d585a7b'),
(205, 'The Bahamas', 'BS', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d586a42'),
(206, 'The Gambia', 'GM', '220', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d588149'),
(207, 'Timor-Leste', 'TL', '670', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5890de'),
(208, 'Togo', 'TG', '228', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d58a8cd'),
(209, 'Tokelau', 'TK', '690', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d58b867'),
(210, 'Tonga', 'TO', '676', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d58cf70'),
(211, 'Trinidad and Tobago', 'TT', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d58df60'),
(212, 'Tunisia', 'TN', '216', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d58f6bf'),
(213, 'Turkey', 'TR', '90', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5906d7'),
(214, 'Turkmenistan', 'TM', '993', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d591db0'),
(215, 'Turks and Caicos Islands', 'TC', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d592ce2'),
(216, 'Tuvalu', 'TV', '688', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d594460'),
(217, 'Uganda', 'UG', '256', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59540a'),
(218, 'Ukraine', 'UA', '380', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d596cda'),
(219, 'United Arab Emirates', 'AE', '971', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d597eac'),
(220, 'United Kingdom', 'GB', '44', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d599311'),
(221, 'United States', 'US', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59a45b'),
(222, 'Uruguay', 'UY', '598', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59b9b0'),
(223, 'US Virgin Islands', 'VI', '1', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59c91d'),
(224, 'Uzbekistan', 'UZ', '998', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59e17e'),
(225, 'Vanuatu', 'VU', '678', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d59f120'),
(226, 'Vatican City', 'VA', '39', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a084f'),
(227, 'Venezuela', 'VE', '58', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a1821'),
(228, 'Vietnam', 'VN', '84', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a2f89'),
(229, 'Wallis and Futuna', 'WF', '681', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a3f21'),
(230, 'Yemen', 'YE', '967', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a562b'),
(231, 'Zambia', 'ZM', '260', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a65e6'),
(232, 'Zimbabwe', 'ZW', '263', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25', '650f74d5a7cc5');



INSERT INTO `cultures` (`id`, `cultura`, `created_at`, `updated_at`) VALUES
(1, 'Feijão', NULL, NULL),
(2, 'Cebola', NULL, NULL),
(3, 'Batata Doce', NULL, NULL),
(4, 'Cenoura', NULL, NULL),
(5, 'Mandioca', NULL, NULL),
(6, 'Repolho', NULL, NULL),
(7, 'Milho', NULL, NULL),
(8, 'Batata Rena', NULL, NULL),
(9, 'Massango', NULL, NULL),
(10, 'Alho', NULL, NULL),
(11, 'Massambala', NULL, NULL),
(12, 'Outros', NULL, NULL);




INSERT INTO `email_templates` (`id`, `uid`, `name`, `slug`, `subject`, `content`, `status`, `created_at`, `updated_at`) VALUES
(1, '650f74d6c5cdf', 'Customer Registration', 'customer_registration', 'Welcome to {app_name}', 'Hi {first_name} {last_name},\n                                      Welcome to {app_name}! This message is an automated reply to your User Access request. Login to your User panel by using the details below:\n                                      {login_url}\n                                      Email: {email_address}\n                                      Password: {password}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(2, '650f74d6c77ac', 'Customer Registration Verification', 'registration_verification', 'Registration Verification From {app_name}', 'Hi,\n                                      Welcome to {app_name}! This message is an automated reply to your account verification request. Please click the url below to verify your email address: <a href=\"{verification_url}\" target=\"_blank\">{verification_url}</a>\n                                      If you did not create an account, no further action is required.\n                                      ', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(3, '650f74d6c85ba', 'Password Reset', 'password_reset', '{app_name} New Password', 'Hi {first_name} {last_name},\n                                      Password Reset Successfully! This message is an automated reply to your password reset request. Login to your account to set up your all details by using the details below:\n                                      {login_url}\n                                      Email: {email_address}\n                                      Password: {password}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(4, '650f74d6c9d5a', 'Forgot Password', 'forgot_password', '{app_name} password change request', 'Hi {first_name} {last_name},\n                                      Password Reset Successfully! This message is an automated reply to your password reset request. Click this link to reset your password:\n                                      {forgot_password_link}\n                                      Notes: Until your password has been changed, your current password will remain valid. The Forgot Password Link will be available for a limited time only.', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(5, '650f74d6ca876', 'Login Notification', 'login_notification', 'Your {app_name} Login Information', 'Hi,\n                                      You successfully logged in to {app_name} on {time} from ip {ip_address}.  If you did not login, please contact our support immediately.', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(6, '650f74d6cb19b', 'Customer Registration Notification', 'registration_notification', 'New customer registered to {app_name}', 'Hi,\n                                      New customer named {first_name} {last_name} registered. Login to your portal to show details.\n                                      {customer_profile_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(7, '650f74d6cba23', 'Sender ID Notification', 'sender_id_notification', 'New sender id requested to {app_name}', 'Hi,\n                                      New sender id {sender_id} requested. Login to your portal to show details.\n                                      {sender_id_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(8, '650f74d6cc639', 'Subscription Notification', 'subscription_notification', 'New subscription to {app_name}', 'Hi,\n                                      New subscription made on {app_name}. Login to your portal to show details.\n                                      {invoice_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(9, '650f74d6ccf28', 'Keyword purchase Notification', 'keyword_purchase_notification', 'New keyword sale on {app_name}', 'Hi,\n                                      New keyword sale made on {app_name}. Login to your portal to show details.\n                                      {keyword_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(10, '650f74d6cd7ef', 'Phone number purchase Notification', 'number_purchase_notification', 'New phone number sale on {app_name}', 'Hi,\n                                      New phone number sale made on {app_name}. Login to your portal to show details.\n                                      {number_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26'),
(11, '650f74d6ce77a', 'Sender ID Confirmation', 'sender_id_confirmation', 'Sender ID Confirmation on {app_name}', 'Hi,\n                                      You sender id mark as: {status}. Login to your portal to show details.\n                                      {sender_id_url}', 1, '2023-09-23 10:29:26', '2023-09-23 10:29:26');



INSERT INTO `fontecreditos` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
(1, 'fada', NULL, NULL),
(2, 'kwenda', NULL, NULL),
(3, 'pdac', NULL, NULL),
(4, 'outros', NULL, NULL);



INSERT INTO `fonteinstrumentos` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
(1, 'Crédito Agrícola', NULL, NULL),
(2, 'Caixa comunitárias', NULL, NULL),
(3, 'Mercado Aberto', NULL, NULL),
(4, 'Administração Pública', NULL, NULL),
(5, 'Fundo Próprio', NULL, NULL);



INSERT INTO `identificacaos` (`id`, `identificação`, `created_at`, `updated_at`) VALUES
(1, 'Bilhete de Identidade', NULL, NULL),
(2, 'Cartão de Eleitor', NULL, NULL),
(3, 'Cartão de Municipe', NULL, NULL),
(4, 'Certidão de Nascimento', NULL, NULL),
(5, 'Outros', NULL, NULL);


INSERT INTO `jrmi` (`id`, `parameter`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Candidatura Inválida', 'Candidatura com Respostas Inválidas', '2023-11-13 19:46:57', '2023-11-13 21:58:27'),
(2, 'Desistência do Proponente', 'O Proponente perdeu Interesse na Altura da Consulta com o Provedor de Serviço', '2023-11-13 19:50:19', '2023-11-13 19:50:19'),
(3, 'Cadeia de Valor', 'Recusado por não serem contempladas as cadeias de valor do PDAC.', '2023-11-13 19:53:13', '2023-11-13 19:53:13'),
(4, 'Actividade Inelegível', 'O tipo de negócio desejado pelo proponente não faz parte da carteira de negócios do PDAC.', '2023-11-13 19:54:20', '2023-11-13 19:54:20'),
(5, 'Falta de acesso', 'O acesso ao empreendimento é defeituoso.', '2023-11-13 19:55:28', '2023-11-13 19:55:28'),
(6, 'Falta de área', 'A empresa foi contactada/visitada e reúne os requisitos mas não dispões de área necessária de (10ha).', '2023-11-13 19:56:28', '2023-11-13 19:56:28'),
(7, 'Falta de documentação legal', 'A empresa está sem titulo de terra, alvará, certidão e outros documentos.', '2023-11-13 19:57:43', '2023-11-13 19:57:43'),
(8, 'Falta dos 10%', 'Por não reunir os requisitos: Crédito mal parado, sem 10%, para contribuir, documentação legal em falta e falta de experiencia etc.', '2023-11-13 19:59:11', '2023-11-13 19:59:11'),
(9, 'Zona inelegível', 'O Proponente encontra-se fora da Área de Intervenção do Projecto.', '2023-11-13 20:04:43', '2023-11-13 20:04:43'),
(10, 'Dívida', 'O Proponente tem crédito mal parado e não tem condições de pagar.', '2023-11-13 20:05:57', '2023-11-13 20:05:57'),
(11, 'NIF errado', NULL, '2023-11-13 20:12:19', '2023-11-13 20:12:19');




INSERT INTO `languages` (`id`, `name`, `code`, `iso_code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'us', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(2, 'French', 'fr', 'fr', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(3, 'Chinese', 'zh', 'cn', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(4, 'Spanish', 'es', 'es', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(5, 'Portuguese', 'pt', 'ao', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(6, 'Arabic', 'ar', 'sa', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(7, 'Italian', 'it', 'it', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(8, 'Korean', 'ko', 'kr', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25'),
(9, 'Slovenian', 'sl', 'sk', 1, '2023-09-23 10:29:25', '2023-09-23 10:29:25');


INSERT INTO `pacotes` (`id`, `pacote`, `created_at`, `updated_at`) VALUES
(1, 'Pacote 1', NULL, NULL),
(2, 'Pacote 2', NULL, NULL),
(3, 'Pacote 3', NULL, NULL);


INSERT INTO `permissions` (`id`, `uid`, `role_id`, `name`, `created_at`, `updated_at`) VALUES
(473, '65b3878163810', 1, 'access backend', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(474, '65b3878165096', 1, 'view customer', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(475, '65b387816611f', 1, 'delete customer', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(476, '65b38781674cc', 1, 'approve MI', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(477, '65b387816886e', 1, 'reject MI', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(478, '65b3878169e7a', 1, 'validate', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(479, '65b387816af2c', 1, 'cancel MI', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(480, '65b387816bf0b', 1, 'view business_plan', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(481, '65b387816d444', 1, 'approve business_plan', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(482, '65b387816e3e1', 1, 'reject business_plan', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(483, '65b387816f41a', 1, 'cancel business_plan', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(484, '65b387817052c', 1, 'view category', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(485, '65b3878171a0a', 1, 'create category', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(486, '65b3878178580', 1, 'edit category', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(487, '65b38781799f1', 1, 'delete category', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(488, '65b387817ae73', 1, 'view message', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(489, '65b387817c0dc', 1, 'create message', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(490, '65b387817d0a6', 1, 'delete message', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(491, '65b387817dfc8', 1, 'view templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(492, '65b387817f06a', 1, 'create templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(493, '65b387818012f', 1, 'edit templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(494, '65b3878181232', 1, 'delete templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(495, '65b3878182377', 1, 'view administrator', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(496, '65b38781833cc', 1, 'create administrator', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(497, '65b3878184450', 1, 'edit administrator', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(498, '65b3878185397', 1, 'delete administrator', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(499, '65b3878186501', 1, 'view roles', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(500, '65b38781874bd', 1, 'create roles', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(501, '65b3878188367', 1, 'edit roles', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(502, '65b3878189468', 1, 'delete roles', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(503, '65b387818a732', 1, 'general settings', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(504, '65b387818ba88', 1, 'authentication settings', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(505, '65b387818cad0', 1, 'notifications settings', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(506, '65b387818da5c', 1, 'localization settings', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(507, '65b387818ea3d', 1, 'view background_jobs', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(508, '65b387818fc09', 1, 'view province', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(509, '65b3878190c80', 1, 'create province', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(510, '65b3878191d0e', 1, 'edit province', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(511, '65b3878192d52', 1, 'delete province', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(512, '65b3878193cd8', 1, 'view jrmi', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(513, '65b3878194d0f', 1, 'create jrmi', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(514, '65b3878195e5f', 1, 'edit jrmi', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(515, '65b3878196e0a', 1, 'delete jrmi', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(516, '65b3878198914', 1, 'view email_templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(517, '65b3878199fd0', 1, 'update email_templates', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(518, '65b387819b042', 1, 'view sms_history', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(519, '65b387819bffc', 1, 'access backend', '2024-01-26 05:20:49', '2024-01-26 05:20:49'),
(581, '65e9e0d2cb867', 6, 'access backend', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(582, '65e9e0d2cc7e1', 6, 'view customer', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(583, '65e9e0d2cdc70', 6, 'view business_plan', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(584, '65e9e0d2cff01', 6, 'view category', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(585, '65e9e0d2d1225', 6, 'view message', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(586, '65e9e0d2d262d', 6, 'view templates', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(587, '65e9e0d2d36b6', 6, 'view administrator', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(588, '65e9e0d2d471a', 6, 'view roles', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(589, '65e9e0d2d570a', 6, 'view province', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(590, '65e9e0d2d6df9', 6, 'view jrmi', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(591, '65e9e0d2d7f90', 6, 'view email_templates', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(592, '65e9e0d2d921a', 6, 'view sms_history', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(593, '65e9e0d2da4ca', 6, 'access backend', '2024-03-07 10:44:18', '2024-03-07 10:44:18'),
(665, '66413583b8df2', 3, 'access backend', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(666, '66413583ba777', 3, 'view business_plan', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(667, '66413583bb736', 3, 'approve business_plan', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(668, '66413583bc9e2', 3, 'reject business_plan', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(669, '66413583bd9ac', 3, 'cancel business_plan', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(670, '66413583be6fb', 3, 'view category', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(671, '66413583c0d94', 3, 'create category', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(672, '66413583c1d6d', 3, 'edit category', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(673, '66413583c2fca', 3, 'delete category', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(674, '66413583c412b', 3, 'view message', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(675, '66413583c4fcb', 3, 'create message', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(676, '66413583c62a1', 3, 'view templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(677, '66413583c72ee', 3, 'create templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(678, '66413583c8215', 3, 'edit templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(679, '66413583c9419', 3, 'delete templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(680, '66413583ca480', 3, 'view administrator', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(681, '66413583cb2b5', 3, 'view roles', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(682, '66413583ce6ed', 3, 'general settings', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(683, '66413583cf7d9', 3, 'authentication settings', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(684, '66413583d0608', 3, 'notifications settings', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(685, '66413583d14fa', 3, 'localization settings', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(686, '66413583d22c9', 3, 'view background_jobs', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(687, '66413583d3202', 3, 'view province', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(688, '66413583d416e', 3, 'view jrmi', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(689, '66413583d53be', 3, 'view email_templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(690, '66413583d6306', 3, 'update email_templates', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(691, '66413583d775c', 3, 'view sms_history', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(692, '66413583d86fb', 3, 'access backend', '2024-05-12 16:32:51', '2024-05-12 16:32:51'),
(693, '664135934fb12', 5, 'access backend', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(694, '6641359350c1a', 5, 'view customer', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(695, '6641359351caa', 5, 'delete customer', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(696, '6641359352cba', 5, 'approve MI', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(697, '6641359353cb1', 5, 'reject MI', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(698, '66413593550f5', 5, 'validate', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(699, '6641359355f27', 5, 'cancel MI', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(700, '6641359356d0c', 5, 'view category', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(701, '6641359357a1e', 5, 'create category', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(702, '6641359358754', 5, 'edit category', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(703, '66413593598ee', 5, 'delete category', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(704, '664135935a678', 5, 'view message', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(705, '664135935b61c', 5, 'create message', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(706, '664135935c425', 5, 'view templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(707, '664135935d76a', 5, 'create templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(708, '664135935e720', 5, 'edit templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(709, '664135935fc6d', 5, 'delete templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(710, '6641359360b1c', 5, 'view administrator', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(711, '6641359361ad8', 5, 'create administrator', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(712, '6641359362b25', 5, 'edit administrator', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(713, '6641359363b31', 5, 'delete administrator', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(714, '6641359364d5e', 5, 'view roles', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(715, '66413593666c3', 5, 'create roles', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(716, '6641359367a28', 5, 'edit roles', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(717, '6641359369e1a', 5, 'delete roles', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(718, '664135936b12f', 5, 'general settings', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(719, '664135936cbec', 5, 'authentication settings', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(720, '664135936dde5', 5, 'notifications settings', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(721, '664135936ecbe', 5, 'localization settings', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(722, '664135936fb0a', 5, 'view background_jobs', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(723, '6641359370a5e', 5, 'view province', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(724, '66413593719bb', 5, 'create province', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(725, '66413593727eb', 5, 'edit province', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(726, '6641359373661', 5, 'delete province', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(727, '664135937495c', 5, 'view jrmi', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(728, '6641359375a66', 5, 'create jrmi', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(729, '6641359376970', 5, 'edit jrmi', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(730, '66413593779f8', 5, 'delete jrmi', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(731, '6641359379064', 5, 'view email_templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(732, '664135937a1a9', 5, 'update email_templates', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(733, '664135937b174', 5, 'view sms_history', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(734, '664135937c378', 5, 'access backend', '2024-05-12 16:33:07', '2024-05-12 16:33:07'),
(735, '664135bd4037a', 2, 'access backend', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(736, '664135bd417e5', 2, 'view customer', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(737, '664135bd430b6', 2, 'approve MI', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(738, '664135bd4460c', 2, 'reject MI', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(739, '664135bd454df', 2, 'cancel MI', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(740, '664135bd46588', 2, 'view business_plan', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(741, '664135bd476ea', 2, 'view sms_history', '2024-05-12 16:33:49', '2024-05-12 16:33:49'),
(742, '664135bd489a8', 2, 'access backend', '2024-05-12 16:33:49', '2024-05-12 16:33:49');



INSERT INTO `posicaos` (`id`, `posicao`, `created_at`, `updated_at`) VALUES
(1, 'Presidente', NULL, NULL),
(2, 'Vice Presidente', NULL, NULL),
(3, 'Secretário', NULL, NULL),
(4, 'Chefe de Produção', NULL, NULL),
(5, 'Tesoureiro', NULL, NULL);




INSERT INTO `preparacaoterras` (`id`, `preparacao`, `created_at`, `updated_at`) VALUES
(1, 'animal', NULL, NULL),
(2, 'manual', NULL, NULL),
(3, 'mecanizada', NULL, NULL);



INSERT INTO `province` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'benguela', 1, NULL, NULL),
(2, 'cuando_cubango', 1, NULL, NULL),
(3, 'cunene', 1, NULL, NULL),
(4, 'huila', 1, NULL, NULL),
(5, 'namibe', 1, NULL, NULL);




INSERT INTO `roles` (`id`, `uid`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, '650f74d5e4914', 'administrador do Sistema', 1, '2023-09-23 12:29:25', '2023-12-03 00:57:14');



INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(2, 2),
(4, 1),
(5, 3),
(7, 3),
(8, 3),
(9, 3),
(10, 3),
(11, 5),
(12, 2),
(13, 2),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(25, 2),
(26, 2),
(27, 2),
(28, 2),
(29, 2),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 5),
(46, 3),
(47, 1),
(48, 6),
(49, 6),
(50, 6),
(51, 6),
(52, 6),
(55, 6),
(56, 6),
(57, 2),
(58, 2),
(59, 2),
(60, 2),
(61, 2),
(62, 2),
(63, 2),
(64, 2),
(65, 2),
(66, 2),
(67, 2),
(68, 2),
(69, 2),
(70, 2);




INSERT INTO `sementerias` (`id`, `sementeira`, `created_at`, `updated_at`) VALUES
(1, 'manual', NULL, NULL),
(2, 'tração_animal', NULL, NULL),
(3, 'mecanizada', NULL, NULL);



INSERT INTO `sistemaregas` (`id`, `seistema`, `created_at`, `updated_at`) VALUES
(1, 'Rega por Aspersão', NULL, NULL),
(2, 'Gota a Gota', NULL, NULL),
(3, 'Irrigação por Sulco', NULL, NULL),
(4, 'Irrigação por Inundação', NULL, NULL),
(5, 'Outros', NULL, NULL);



INSERT INTO `templates` (`id`, `uid`, `name`, `type`, `message`, `status`, `created_at`, `updated_at`, `sender_id`, `dlt_template_id`, `dlt_category`, `approved`) VALUES
(1, '655de61a3f4e3', 'Em análise UFCP', '2', 'Caro proponente {prop_name},\r\no PDAC tem o prazer de lhe comunicar que o seu Plano de Negócio foi elaborado e deu entrada na Unidade dos Financiamentos do Projecto, para a devida análise e decisão.\r\nObrigado!', 1, '2023-11-22 01:29:30', '2024-01-13 20:13:33', NULL, NULL, NULL, 'in_review'),
(2, '655deab8530ff', 'Aprovado CTI', '2', 'Caro proponente {prop_name},\r\no PDAC informa que o seu Plano de Negócio foi apreciado pelo Comité Técnico de Investimento e mereceu o parecer favorável deste órgão, e deverá ser contactado para iniciar o processo de contratualização da operação.\r\nObrigado!', 1, '2023-11-22 01:49:12', '2024-01-13 20:12:26', NULL, NULL, NULL, 'in_review'),
(3, '655f988fd5ff3', 'MI Aprovada', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse está aprovada e passará para fase de elaboração do Plano de Negócio. Será contactado no prazo máximo de 5 dias úteis.', 1, '2023-11-23 09:23:11', '2024-01-13 20:11:38', NULL, NULL, NULL, 'in_review'),
(4, '655f98e1666ee', 'Candidatura Inválida', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse está invalidada por não preencher devidamente o formulário ou ter colocado dados não fidedignos.', 1, '2023-11-23 09:24:33', '2024-01-13 20:10:57', NULL, NULL, NULL, 'in_review'),
(5, '655f99249b1ad', 'Desistência do Proponente', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse está cancelada a seu pedido.', 1, '2023-11-23 09:25:40', '2024-01-13 20:10:27', NULL, NULL, NULL, 'in_review'),
(6, '655f998fc17a1', 'Em análise', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse está em análise. Será contactado no prazo máximo de 15 dias.', 1, '2023-11-23 09:27:27', '2024-01-13 20:09:43', NULL, NULL, NULL, 'in_review'),
(7, '655f99f008ab8', 'MI Duplicada', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi colocada repetidamente com o mesmo NIF. Por esse motivo a mesma será cancelada.', 1, '2023-11-23 09:29:04', '2024-01-13 20:09:16', NULL, NULL, NULL, 'in_review'),
(8, '655f9a8464a41', 'Pendente por falta de documento', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse está pendente por não reunir toda documentação necessária para elaboração do Plano de Negócio.', 1, '2023-11-23 09:31:32', '2024-01-13 20:08:39', NULL, NULL, NULL, 'in_review'),
(9, '655f9af16c03d', 'Recusada por Actividade Inelegível', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada por pretender desenvolver cadeias de valor inelegíveis para o Projecto.', 1, '2023-11-23 09:33:21', '2024-01-13 20:07:53', NULL, NULL, NULL, 'in_review'),
(10, '655f9b33adf75', 'Recusada por falta de acesso', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada devido a impossibilidade de acesso o que não possibilita a equipa de assistência técnica chegar ao local de empreendimento.', 1, '2023-11-23 09:34:27', '2024-01-13 20:07:23', NULL, NULL, NULL, 'in_review'),
(11, '655f9b908333d', 'Recusada por falta de área', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada por não possuir área necessária em hectares suficientes para elaboração de um Plano de Negócio.', 1, '2023-11-23 09:36:00', '2024-01-13 20:06:49', NULL, NULL, NULL, 'in_review'),
(12, '655f9be84590d', 'Recusada por falta de documentação legal', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada por falta de documentação legal.', 1, '2023-11-23 09:37:28', '2024-01-13 20:06:17', NULL, NULL, NULL, 'in_review'),
(13, '655f9c34803be', 'Recusada por falta dos 10%', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada por não possuir recursos suficientes para contribuir no Plano de Negócios.', 1, '2023-11-23 09:38:44', '2024-01-13 20:05:41', NULL, NULL, NULL, 'in_review'),
(14, '655f9c739cf1e', 'Recusada zona inelegível', '1', 'Caro proponente {prop_name}, informamos que a sua Manifestação de Interesse foi recusada por estar numa zona não elegível para o Projecto.', 1, '2023-11-23 09:39:47', '2024-01-13 20:05:03', NULL, NULL, NULL, 'in_review'),
(15, '655f9edd38174', 'PN em elaboração', '2', 'Caro proponente {prop_name}, informamos que o seu Plano de Negócio está em elaboração pela equipa de assistência técnica e deverá ser imediatamente contactado e receberá visitas constantes na sua propriedade.', 1, '2023-11-23 09:50:05', '2024-01-13 20:04:31', NULL, NULL, NULL, 'in_review'),
(16, '655f9f942c785', 'PN Elaborado', '2', 'Caro proponente {prop_name}, informamos que o seu Plano de Negócio está concluído. Deverá ser contactado imediatamente pela equipa de assistência técnica e receberá uma cópia do seu Projecto que deverá ser aprovado por si.', 1, '2023-11-23 09:53:08', '2024-01-13 20:03:47', NULL, NULL, NULL, 'in_review'),
(17, '656bb2ca6be4a', 'Fin. Aprovado UFCP', '2', 'Caro proponente {prop_name},\r\no PDAC informa que o seu Plano de Negócio foi apreciado pelo Comité Técnico de Investimento e mereceu o parecer favorável deste órgão, e deverá ser contactado para iniciar o processo de contratualização da operação.\r\nObrigado!', 1, '2023-12-02 22:42:18', '2024-01-13 20:02:46', NULL, NULL, NULL, 'in_review'),
(18, '656bb36038dc1', 'Em preparação p/ envio Banco Comercial', '2', 'Caro proponente {prop_name},\r\no PDAC informa que o seu Plano de Negócio foi apreciado pelo Comité Técnico de Investimento e mereceu o parecer favorável deste órgão.\r\nNo prazo de 3 dias, a contar de hoje, o Plano de Negócio será submetido para os Bancos parceiros do Projecto, para a devida análise e decisão.\r\nObrigado!', 1, '2023-12-02 22:44:48', '2024-01-13 20:02:17', NULL, NULL, NULL, 'in_review'),
(19, '656bb3aedc916', 'Em análise no Banco Comercial', '2', 'Caro proponente {prop_name},\r\no PDAC informa que o seu Plano de Negócio está em análise no Banco X. Tão logo tenhamos uma decisão, deverá ser contactado.\r\nObrigado!', 1, '2023-12-02 22:46:06', '2024-01-13 20:01:50', NULL, NULL, NULL, 'in_review'),
(20, '656bb3eee2fb1', 'Desfavorável CTI', '2', 'Caro proponente {prop_name},\r\no PDAC lamenta informar que após apreciação do seu Plano de Negócio, em sede do Comité Técnico de Investimento, o mesmo obteve parecer desfavorável deste órgão.\r\nObrigado!', 1, '2023-12-02 22:47:10', '2024-01-13 20:01:18', NULL, NULL, NULL, 'in_review'),
(21, '656bb432e7a8f', 'Fin. Aprovado Banco Comercial', '2', 'Caro proponente {prop_name},\r\no PDAC tem o prazer de lhe comunicar que o seu Plano de Negócio foi aprovado pelo Banco X, e deverá ser contactado para a iniciar o processo de contratualização da operação.\r\nObrigado!', 1, '2023-12-02 22:48:18', '2024-01-13 20:00:46', NULL, NULL, NULL, 'in_review'),
(22, '656bb46e5f630', 'Recusado pelo Banco Comercial', '2', 'Caro proponente {prop_name},\r\no PDAC lamenta informar que o seu Plano de Negócio foi recusado pelo Banco X.\r\nObrigado!', 1, '2023-12-02 22:49:18', '2024-01-13 19:59:35', NULL, NULL, NULL, 'in_review'),
(23, '664b2bfda7fe0', 'MI Registada', '1', 'Caro proponente {prop_name}, o PDAC informa que a sua Manifestação de Interesse foi registada com sucesso. Doravante iremos enviar mensagens para informar o estado do seu processo. Obrigado.', 1, '2024-05-20 05:54:53', '2024-05-20 05:54:53', NULL, NULL, NULL, 'in_review');



INSERT INTO `tipoamanhos` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
(1, 'adubação', NULL, NULL),
(2, 'sacha', NULL, NULL),
(3, 'amontoa', NULL, NULL),
(4, 'outros', NULL, NULL);



INSERT INTO `tipofertilizantes` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
(1, 'orgânico', NULL, NULL),
(2, 'inorgânico', NULL, NULL);




INSERT INTO `tipo_organizacaos` (`id`, `organizacao`, `created_at`, `updated_at`) VALUES
(1, 'nenhuma', NULL, NULL),
(2, 'cooperativa', NULL, NULL),
(3, 'associação', NULL, NULL),
(4, 'outros', NULL, NULL);



INSERT INTO `topicolheitas` (`id`, `tipo`, `created_at`, `updated_at`) VALUES
(1, 'manual', NULL, NULL),
(2, 'mecanizada', NULL, NULL);


INSERT INTO `users` (`id`, `uid`, `api_token`, `first_name`, `last_name`, `numero_extensionist`, `email`, `email_verified_at`, `password`, `status`, `image`, `sms_unit`, `user_type`, `phone`, `is_admin`, `active_portal`, `two_factor`, `two_factor_code`, `two_factor_expires_at`, `two_factor_backup_code`, `locale`, `timezone`, `last_access_at`, `last_login_ip`, `provider`, `provider_id`, `remember_token`, `created_at`, `updated_at`, `api_sending_server`) VALUES
(1, '650f74d65eb3d', '1|5gLDMDbwA8MzBwwlzORuk3aexn7IjeNRbnjyd4PH', 'Joaquim', 'Manuel', '', 'jm@mwangoclick.ao', '2023-09-23 10:29:26', '$2y$10$N7GVbV3WAna6hg2jbHuAD.4SOSwu55p8bEgsqH2ce7p/aF9J20F4S', 1, 'app/profile/avatar-1.jpg', NULL, 'admin', NULL, 1, 'admin', 0, 962588, '2024-05-12 22:44:55', NULL, 'pt', 'Africa/Luanda', '2024-07-29 10:45:29', '127.0.0.1', NULL, NULL, 'trNIVqKrwIJaqX4NkWxC3qIfuboL4ElegjKoL23kHnIKUgiThWAFTAfellPk', '2023-09-23 10:29:26', '2024-07-29 10:45:29', NULL);


