CREATE TABLE `form_collectives` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int unsigned NOT NULL,
  `structure_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tabs',
  `submit_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'individual',
  `process_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'steps',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `generate` tinyint(1) NOT NULL DEFAULT '0',
  `cover_page` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `form_collectives_form_id_foreign` (`form_id`),
  CONSTRAINT `form_collectives_form_id_foreign` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table form_collectives_forms
# ------------------------------------------------------------

CREATE TABLE `form_collectives_forms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_collective_id` int unsigned NOT NULL,
  `form_id` int unsigned NOT NULL,
  `order` tinyint NOT NULL,
  `active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `form_collectives_forms_form_collective_id_foreign` (`form_collective_id`),
  KEY `form_collectives_forms_form_id_foreign` (`form_id`),
  CONSTRAINT `form_collectives_forms_form_collective_id_foreign` FOREIGN KEY (`form_collective_id`) REFERENCES `form_collectives` (`id`) ON DELETE CASCADE,
  CONSTRAINT `form_collectives_forms_form_id_foreign` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table form_field_children
# ------------------------------------------------------------

CREATE TABLE `form_field_children` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int unsigned NOT NULL,
  `parent_form_id` int unsigned NOT NULL,
  `name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `form_field_children_form_id_foreign` (`form_id`),
  CONSTRAINT `form_field_children_form_id_foreign` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table forms
# ------------------------------------------------------------

CREATE TABLE `forms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `registration_form` tinyint(1) DEFAULT '0',
  `collective` tinyint(1) NOT NULL DEFAULT '0',
  `workflow` tinyint(1) NOT NULL DEFAULT '0',
  `rules` tinyint(1) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `system_form` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `forms_title_unique` (`title`),
  UNIQUE KEY `forms_table_name_unique` (`table_name`),
  UNIQUE KEY `forms_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `forms` (`id`, `title`, `description`, `table_name`, `slug`, `form_type`, `registration_form`, `collective`, `workflow`, `rules`, `active`, `system_form`, `created_at`, `updated_at`)
VALUES
	(1,'Benefits Form','<p>This form is only for adding benefits. Only accessed by permissions.</p>','benefits','benefits-form','0',0,0,0,NULL,1,1,'2021-11-29 10:41:53','2021-11-29 13:46:38'),
	(8,'Project','<p>Internal Projects</p>','projects','project','general',0,0,0,NULL,1,1,'2021-12-16 08:58:12','2021-12-16 08:58:12'),
	(9,'Project Timelines',NULL,'project_timelines','project-timeline','general',0,0,0,NULL,1,1,'2021-12-16 09:04:56','2021-12-16 09:04:56'),
	(10,'New Born Allowance Registration Form','<p>This form is used for the new born registration.</p>','new_born_registrations','new-born-registration','registration',0,0,0,NULL,1,0,'2021-12-20 12:15:34','2021-12-20 22:15:59'),
	(11,'Beneficiaries Details',NULL,'beneficiaries_details','beneficiaries-detail','general',0,0,0,NULL,1,1,'2021-12-21 15:13:12','2021-12-21 15:13:12'),
	(12,'Caregivers Application Form',NULL,'caregivers_application_forms','caregivers-application-form','registration',0,0,0,NULL,1,0,'2021-12-21 19:10:40','2021-12-21 19:10:40'),
	(13,'Office use only',NULL,'office_use_onlies','office-use-only','registration',0,0,0,NULL,1,0,'2021-12-22 09:55:55','2021-12-22 09:55:55'),
	(14,'Complaint',NULL,'complaints','complaint','general',0,0,0,NULL,1,1,'2021-12-23 21:02:29','2021-12-23 21:02:29'),
	(15,'Funeral Allowance',NULL,'funeral_allowances','funeral-allowance','registration',0,0,0,NULL,1,0,'2022-01-11 14:28:01','2022-01-12 10:47:33'),
	(16,'Government Funded Maternity Leave',NULL,'government_funded_maternity_leaves','government-funded-maternity-leave','registration',0,0,0,NULL,1,0,'2022-01-13 12:30:10','2022-01-13 12:30:10'),
	(18,'Child Benefit',NULL,'child_benefits','child-benefit','registration',0,0,0,NULL,1,0,'2022-01-20 18:12:09','2022-01-20 18:12:09'),
	(19,'Old Age Pension Form',NULL,'old_age_pensions','old-age-pension','registration',0,0,0,NULL,1,0,'2022-01-27 16:43:47','2022-01-27 16:43:47'),
	(21,'MATERNITY LEAVE (GFPML)',NULL,'m_a_t_e_r_n_i_t_y_l_e_a_v_e_s','maternity-leave','registration',0,0,0,NULL,1,0,'2022-02-21 10:14:00','2022-02-21 10:14:00');



# Dump of table funeral_allowances
# ------------------------------------------------------------

CREATE TABLE `funeral_allowances` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `benefit_types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `f_i_r_s_t_n_a_m_e:` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_u_r_n_a_m_e:` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_births` date DEFAULT NULL,
  `date_deceaseds` date DEFAULT NULL,
  `g_e_n_d_e_rs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `i_s_l_a_n_ds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `v_i_l_l_a_g_es` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `f_i_r_s_t_n_a_m_e` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_u_r_n_a_m_e` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `death_certificates` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `death_refs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a/_c_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a/_c_nos` double(8,2) DEFAULT NULL,
  `f_i_r_s_t_n_a_m_es` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_u_r_n_a_m_es` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `a_c_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bci_account_numbers` double DEFAULT NULL,
  `uploads` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `1_expensesand_invoice_numbers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `1_costs` double DEFAULT NULL,
  `2expenses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `2costs` double DEFAULT NULL,
  `3expenses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `3costs` double DEFAULT NULL,
  `4expenses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `4costs` double DEFAULT NULL,
  `5expenses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `5costs` double DEFAULT NULL,
  `other_firstnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_s_u_r_n_a_m_es` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `beneficiaryrelationships` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contactnumbers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_dates` date DEFAULT NULL,
  `names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signatures` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_dates` date DEFAULT NULL,
  `additional_informations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recommendations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `application_receiveds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_received_dates` date DEFAULT NULL,
  `supporting_documents_dates` date DEFAULT NULL,
  `supplementary_documents_dates` date DEFAULT NULL,
  `referred_to_main_office_dates` date DEFAULT NULL,
  `o_island_application_nos` double DEFAULT NULL,
  `head_office_application_nos` double DEFAULT NULL,
  `app__received__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pay__period__dates` date DEFAULT NULL,
  `pay__amounts` double DEFAULT NULL,
  `other__payment__dates` date DEFAULT NULL,
  `other__payment__amounts` double DEFAULT NULL,
  `addition__voucher__nos` double DEFAULT NULL,
  `main__vchr__froms` date DEFAULT NULL,
  `first_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table government_funded_maternity_leaves
# ------------------------------------------------------------

CREATE TABLE `government_funded_maternity_leaves` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `islands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `villages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phones` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobiles` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `faxes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emails` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal__addresses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `emp__statuses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employment_sectors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `emps` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `industries` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `positions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `c__dates` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other__employers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `emp__residencies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rmd__nos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cinsf__nos` double DEFAULT NULL,
  `expected__delivery__dates` date DEFAULT NULL,
  `edd__files` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `declaration__full_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `declaration__signatures` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `declaration_dates` date DEFAULT NULL,
  `rmd__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rmd__signeds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rmd__dates` date DEFAULT NULL,
  `company__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business__rmds` double DEFAULT NULL,
  `employees__rmds` double DEFAULT NULL,
  `contact__people` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__islands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `emp__locations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__phones` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__mobiles` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__faxes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__emails` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp__postal__addresses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `account__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bci_account_numbers` double DEFAULT NULL,
  `commencement__dates` date DEFAULT NULL,
  `last__days` date DEFAULT NULL,
  `emp__contributions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirm__names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `years` double DEFAULT NULL,
  `months` double DEFAULT NULL,
  `signeds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date__confirms` date DEFAULT NULL,
  `outer__island__dates` date DEFAULT NULL,
  `outer__date__received__bies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office__outers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raro__date__receiveds` date DEFAULT NULL,
  `raro__receiveds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raro__outers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rsds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mfems` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vchr__nos` double DEFAULT NULL,
  `recommendations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rec__officers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office__signeds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secretary__statuses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secretary__signeds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secretary__dates` date DEFAULT NULL,
  `edd_files` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `commencement_dates` date DEFAULT NULL,
  `last_days` date DEFAULT NULL,
  `date_confirms` date DEFAULT NULL,
  `heading_residencies` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `declaration_full_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pregnancy_statuses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `edds` date DEFAULT NULL,
  `taxpayers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rmd_numbers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employer_endorsement_documents` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employer_endorsement_dates` date DEFAULT NULL,
  `employer_contributions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `government_funded_maternity_leaves` (`id`, `islands`, `villages`, `phones`, `mobiles`, `faxes`, `emails`, `postal__addresses`, `emp__statuses`, `employment_sectors`, `emps`, `industries`, `employers`, `positions`, `c__dates`, `other__employers`, `emp__residencies`, `rmd__nos`, `cinsf__nos`, `expected__delivery__dates`, `edd__files`, `created_at`, `updated_at`, `declaration__full_names`, `declaration__signatures`, `declaration_dates`, `rmd__names`, `rmd__signeds`, `rmd__dates`, `company__names`, `director__names`, `business__rmds`, `employees__rmds`, `contact__people`, `emp__islands`, `emp__locations`, `emp__phones`, `emp__mobiles`, `emp__faxes`, `emp__emails`, `emp__postal__addresses`, `account__names`, `bci_account_numbers`, `commencement__dates`, `last__days`, `emp__contributions`, `confirm__names`, `years`, `months`, `signeds`, `date__confirms`, `outer__island__dates`, `outer__date__received__bies`, `office__outers`, `raro__date__receiveds`, `raro__receiveds`, `raro__outers`, `rsds`, `mfems`, `vchr__nos`, `recommendations`, `rec__officers`, `office__signeds`, `secretary__statuses`, `secretary__signeds`, `secretary__dates`, `edd_files`, `commencement_dates`, `last_days`, `date_confirms`, `heading_residencies`, `declaration_full_names`, `pregnancy_statuses`, `edds`, `taxpayers`, `rmd_numbers`, `employer_endorsement_documents`, `employer_endorsement_dates`, `employer_contributions`)
VALUES
	(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:27:31','2022-02-22 09:27:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525651.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525651.jpeg','2022-02-22','Extended Paid Leave'),
	(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:27:14','2022-02-22 09:27:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525634.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525634.jpeg','2022-02-22','Extended Paid Leave'),
	(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:26:19','2022-02-22 09:26:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525579.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525579.jpeg','2022-02-22','Extended Paid Leave'),
	(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:26:02','2022-02-22 09:26:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525562.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525562.jpeg','2022-02-22','Extended Paid Leave'),
	(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:29:54','2022-02-22 09:29:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525794.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525794.jpeg','2022-02-22','Extended Paid Leave'),
	(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:30:30','2022-02-22 09:30:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525830.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525830.jpeg','2022-02-22','Extended Paid Leave'),
	(11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:31:26','2022-02-22 09:31:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525886.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525886.jpeg','2022-02-22','Extended Paid Leave'),
	(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:31:47','2022-02-22 09:31:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525907.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525907.jpeg','2022-02-22','Extended Paid Leave'),
	(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:32:10','2022-02-22 09:32:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645525930.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645525930.jpeg','2022-02-22','Extended Paid Leave'),
	(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:34:20','2022-02-22 09:34:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526060.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526060.jpeg','2022-02-22','Extended Paid Leave'),
	(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:35:27','2022-02-22 09:35:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526127.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526127.jpeg','2022-02-22','Extended Paid Leave'),
	(16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:36:33','2022-02-22 09:36:33',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526193.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526193.jpeg','2022-02-22','Extended Paid Leave'),
	(17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:37:15','2022-02-22 09:37:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526235.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526235.jpeg','2022-02-22','Extended Paid Leave'),
	(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:37:52','2022-02-22 09:37:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526272.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526272.jpeg','2022-02-22','Extended Paid Leave'),
	(19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-22 09:38:47','2022-02-22 09:38:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'default_1645526327.jpeg','2022-02-22','2022-02-22','2022-02-22','Yes','Frank Castle','Pregnant','2022-02-22','Yes','PO00909','default_1645526327.jpeg','2022-02-22','Extended Paid Leave'),
	(20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-03-09 15:28:13','2022-03-09 15:28:13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Yes',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8p7mwcdsf_(1)_1646843293.png','2022-03-01','2022-04-09','2022-03-09','Yes','Frank Castle','Pregnant','2022-03-01','Yes','PO00909','8p7mwcdsf_(1)_1646843293.png','2022-03-08','Top-Up Payment');



# Dump of table health_details
# ------------------------------------------------------------

CREATE TABLE `health_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `regID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `health_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_started` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirmed_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supporting_document` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'New',
  `removed` tinyint(1) DEFAULT '0',
  `addedBy` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `health_details` (`id`, `regID`, `health_type`, `date_started`, `confirmed_by`, `supporting_document`, `status`, `removed`, `addedBy`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'AITU-19930214-1-001','Visual','2022-06-15','General Hospital','public/applicants/14/health//profile.png','New',0,1,'2022-10-04 08:38:23','2022-10-04 08:38:23',NULL),
	(2,'MANG-19930616-1-007','Mobility','2022-08-08','General Hospital','public/applicants/14/health/Biometric.png','Verified',0,1,'2022-11-22 13:12:23','2022-11-22 13:12:23',NULL);



# Dump of table households
# ------------------------------------------------------------

CREATE TABLE `households` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reference_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` bigint NOT NULL,
  `head` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` bigint NOT NULL,
  `tenure` bigint NOT NULL,
  `income_status` bigint DEFAULT NULL,
  `headship` bigint DEFAULT NULL,
  `household_count` int DEFAULT '0',
  `location` bigint NOT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_unique` (`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `households` (`id`, `reference_id`, `type`, `head`, `area`, `tenure`, `income_status`, `headship`, `household_count`, `location`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'AA000001',118,'MANG-19930616-1-007',127,128,NULL,NULL,0,27,0,1,1,'2023-03-28 01:24:40','2023-03-28 13:51:14',NULL),
	(2,'AA000002',120,NULL,126,129,NULL,NULL,5,19,1,1,1,'2023-03-28 14:30:18','2023-04-12 19:47:16',NULL),
	(3,'AA000003',121,NULL,126,129,NULL,NULL,2,17,1,1,1,'2023-03-28 14:55:27','2023-04-12 13:11:37',NULL),
	(4,'AA000004',123,NULL,127,130,NULL,NULL,3,23,1,1,1,'2023-03-28 15:04:29','2023-04-12 13:09:25',NULL),
	(5,'AA000005',124,NULL,127,130,NULL,NULL,4,114,1,1,1,'2023-03-28 15:05:56','2023-04-12 12:56:30',NULL);



# Dump of table identification_details
# ------------------------------------------------------------

CREATE TABLE `identification_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `applicant_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiry` date DEFAULT NULL,
  `document` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'New',
  `removed` tinyint(1) DEFAULT '0',
  `addedBy` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `identification_details` (`id`, `applicant_number`, `id_type`, `id_number`, `expiry`, `document`, `status`, `removed`, `addedBy`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'ATIU-19900130-1-001','Passport','G2344888','1990-01-30',NULL,'New',0,1,'2022-02-16 21:05:06','2022-02-16 21:05:06',NULL),
	(2,'ATIU-19900130-1-001','Passport','G2344888','1990-01-30','public/identifications/ATIU-19900130-1-001/dwtb.jpg','New',1,1,'2022-02-16 23:03:09','2022-02-21 11:03:25',NULL),
	(3,'MANG-19930616-1-002','Passport','GR334532','2024-07-11',NULL,'New',0,1,'2022-02-17 14:43:59','2022-02-17 14:43:59',NULL),
	(4,'MANG-19930616-1-002','Birth Certificate','3444422110','1970-01-01',NULL,'New',0,1,'2022-02-17 14:43:59','2022-02-17 14:43:59',NULL),
	(15,'MANG-19930616-1-007','Passport','GR334532','2025-07-17','public/applicants/14/identifications/Ecobank_Logo_EN.png','Verified',1,1,'2022-02-17 16:04:08','2022-02-18 13:19:46',NULL),
	(16,'MITI-19900507-1-003','National Id','3444422110','1970-01-01','public/applicants/MITI-19900507-1-003/identifications//WBS_-_Friends_and_Family_Party_-_Blank.docx','New',0,1,'2022-02-17 16:04:08','2022-02-17 16:04:08',NULL),
	(17,'ALB-20100325-2-001','Tax Identification (Rmd)','GR334532','2022-12-16',NULL,'New',0,1,'2022-02-21 12:52:45','2022-02-21 15:11:19',NULL),
	(22,'AITU-19930214-1-001','Birth Certificate','G2344888','2023-03-02','public/applicants/14/identifications/passport.jpeg','On Hold',0,1,'2022-11-21 12:46:15','2022-11-21 13:47:18',NULL),
	(23,'AITU-19930214-1-001','National Id','G23448899','2023-02-23','public/applicants/14/identifications/national-card.jpg','New',0,1,'2022-11-21 14:15:09','2022-11-21 14:33:26',NULL),
	(24,'AITU-19930214-1-001','Marriage Certificate','45454665','2071-07-16','public/applicants/14/identifications/Ecobank_Logo_EN.png','Verified',0,1,'2022-11-21 14:40:38','2022-11-21 14:41:38',NULL),
	(25,'MANG-19900601-2-001','Passport','45454665','2023-07-14','public/applicants/17/identifications/passport.jpeg','Verified',0,2,'2022-12-01 14:20:08','2022-12-01 14:20:08',NULL),
	(26,'MANG-19930616-1-007','Passport','45454665','2022-12-30',NULL,'New',0,1,'2022-12-21 16:37:27','2022-12-21 16:37:27',NULL);



# Dump of table input_keys
# ------------------------------------------------------------

CREATE TABLE `input_keys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `input_keys` (`id`, `key`, `display`, `value`, `created_at`, `updated_at`)
VALUES
	(1,'gender','Gender','Male',NULL,NULL),
	(2,'gender','Gender','Female',NULL,NULL),
	(3,'gender','Gender','Other',NULL,NULL);



# Dump of table instances
# ------------------------------------------------------------

CREATE TABLE `instances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country_id` bigint DEFAULT NULL,
  `counties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `measurement_system_id` int DEFAULT NULL,
  `favicon_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `footer_logo_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bg_image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `currency_id` bigint DEFAULT NULL,
  `alt_currency_id` bigint DEFAULT NULL,
  `deployment_date` date DEFAULT NULL,
  `advisory_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `lms_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `copyright` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) DEFAULT '1',
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `instances` (`id`, `project_name`, `email`, `owner`, `contact`, `description`, `country_id`, `counties`, `measurement_system_id`, `favicon_url`, `logo_url`, `footer_logo_url`, `bg_image_url`, `currency_id`, `alt_currency_id`, `deployment_date`, `advisory_url`, `lms_url`, `copyright`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES
	(1,'Bewsys Claims System','info@bewsys.com','Bewsys Limited','0509394885',NULL,288,NULL,1,'app-uploads/instances/1/favicon/yzOxX9E7LRWhbXnXl1rHaJ2HpIDTYr5EDHxU5Yua.png.png','app-uploads/instances/1/logo/gPeYohPnAIDEeumaraLpI4oGSPJXBjgn0g5up8Dh.png.png','app-uploads/instances/1/logo/aum9vjW4ScVZ5EgVY5Kwfi4MgbihTcwTlFEiA7BB.png.png',NULL,93,261,'2022-10-01',NULL,NULL,'@2022 Alleviate by <a href=\"https://bewsys.com\" target=\"_blank\">Bewsys Limited</a>.',1,'1','1','2022-10-08 09:10:05','2022-10-13 10:39:21');



# Dump of table languages
# ------------------------------------------------------------

CREATE TABLE `languages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` char(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


INSERT INTO `languages` (`id`, `name`, `code`)
VALUES
	(1,'Afrikaans','AF'),
	(2,'Albanian','SQ'),
	(3,'Arabic','AR'),
	(4,'Armenian','HY'),
	(5,'Basque','EU'),
	(6,'Bengali','BN'),
	(7,'Bulgarian','BG'),
	(8,'Catalan','CA'),
	(9,'Cambodian','KM'),
	(10,'Chinese (Mandarin)','ZH'),
	(11,'Croatian','HR'),
	(12,'Czech','CS'),
	(13,'Danish','DA'),
	(14,'Dutch','NL'),
	(15,'English','EN'),
	(16,'Estonian','ET'),
	(17,'Fiji','FJ'),
	(18,'Finnish','FI'),
	(19,'French','FR'),
	(20,'Georgian','KA'),
	(21,'German','DE'),
	(22,'Greek','EL'),
	(23,'Gujarati','GU'),
	(24,'Hebrew','HE'),
	(25,'Hindi','HI'),
	(26,'Hungarian','HU'),
	(27,'Icelandic','IS'),
	(28,'Indonesian','ID'),
	(29,'Irish','GA'),
	(30,'Italian','IT'),
	(31,'Japanese','JA'),
	(32,'Javanese','JW'),
	(33,'Korean','KO'),
	(34,'Latin','LA'),
	(35,'Latvian','LV'),
	(36,'Lithuanian','LT'),
	(37,'Macedonian','MK'),
	(38,'Malay','MS'),
	(39,'Malayalam','ML'),
	(40,'Maltese','MT'),
	(41,'Maori','MI'),
	(42,'Marathi','MR'),
	(43,'Mongolian','MN'),
	(44,'Nepali','NE'),
	(45,'Norwegian','NO'),
	(46,'Persian','FA'),
	(47,'Polish','PL'),
	(48,'Portuguese','PT'),
	(49,'Punjabi','PA'),
	(50,'Quechua','QU'),
	(51,'Romanian','RO'),
	(52,'Russian','RU'),
	(53,'Samoan','SM'),
	(54,'Serbian','SR'),
	(55,'Slovak','SK'),
	(56,'Slovenian','SL'),
	(57,'Spanish','ES'),
	(58,'Swahili','SW'),
	(59,'Swedish','SV'),
	(60,'Tamil','TA'),
	(61,'Tatar','TT'),
	(62,'Telugu','TE'),
	(63,'Thai','TH'),
	(64,'Tibetan','BO'),
	(65,'Tonga','TO'),
	(66,'Turkish','TR'),
	(67,'Ukrainian','UK'),
	(68,'Urdu','UR'),
	(69,'Uzbek','UZ'),
	(70,'Vietnamese','VI'),
	(71,'Welsh','CY'),
	(72,'Xhosa','XH');



# Dump of table location_program
# ------------------------------------------------------------

CREATE TABLE `location_program` (
  `program_id` bigint unsigned NOT NULL,
  `location` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `location_program` (`program_id`, `location`, `created_at`, `updated_at`)
VALUES
	(2,17,NULL,NULL),
	(2,111,NULL,NULL),
	(2,18,NULL,NULL),
	(2,19,NULL,NULL),
	(2,20,NULL,NULL),
	(2,21,NULL,NULL);



# Dump of table lookup_codes
# ------------------------------------------------------------

CREATE TABLE `lookup_codes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `instance_id` int DEFAULT NULL,
  `lookupName` varchar(100) DEFAULT NULL,
  `lookupCode` varchar(100) DEFAULT NULL,
  `is_process` tinyint(1) DEFAULT '0',
  `system` tinyint(1) DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `activeFlag` int DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Lookup Codes';


INSERT INTO `lookup_codes` (`id`, `instance_id`, `lookupName`, `lookupCode`, `is_process`, `system`, `created_by`, `updated_by`, `activeFlag`, `created_at`, `updated_at`)
VALUES
	(1,NULL,'Gender','Gender',0,0,1,1,1,'2021-11-25','2021-11-25'),
	(2,NULL,'Villages',NULL,0,0,1,NULL,1,'2021-11-25','2021-11-25'),
	(3,NULL,'Benefit Status','BS',1,0,1,1,1,'2021-11-25','2021-12-10'),
	(4,NULL,'Benefit Types','BT',0,0,1,1,0,'2021-11-25','2021-11-25'),
	(5,NULL,'Boolean','Boolean',0,0,1,NULL,1,'2021-11-29','2021-11-29'),
	(6,NULL,'Yes Or No','YN',0,0,1,NULL,1,'2021-11-29','2021-11-29'),
	(7,NULL,'Project Management Status','PMS',1,0,1,NULL,1,'2021-12-16','2021-12-16'),
	(8,NULL,'Application Workflow','Workflow',1,0,8,1,1,'2021-12-21','2022-02-22'),
	(9,NULL,'Region','Reg',NULL,0,8,1,1,'2021-12-21','2023-03-13'),
	(10,NULL,'Payroll Status','PR',1,1,1,NULL,1,'2021-12-18','2021-12-18'),
	(11,NULL,'Complaint Categories','CC',0,1,1,NULL,1,'2021-12-23','2021-12-23'),
	(12,NULL,'Identification Types','ID Types',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(13,NULL,'Account Type','Account Type',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(14,NULL,'Banks','Banks',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(15,NULL,'Merchant Branches','Merchant Branches',NULL,0,1,1,1,'2022-02-17','2023-03-20'),
	(16,NULL,'Marital Status','Marital Status',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(17,NULL,'Marriage Type','Marriage Type',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(18,NULL,'Employment Sector','Employment Sector',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(19,NULL,'Employment Type','Employment Type',0,0,1,NULL,1,'2022-02-17','2022-02-17'),
	(20,NULL,'Documentation Type','Documentation Type',0,0,1,NULL,1,'2022-02-18','2022-02-18'),
	(21,NULL,'Impairments','Impairments',0,0,1,NULL,1,'2022-02-21','2022-02-21'),
	(22,NULL,'Family Relations','Family Relations',0,0,1,NULL,1,'2022-03-08','2022-03-08'),
	(23,0,'Office Type','OT',0,0,1,NULL,1,'2022-09-23','2022-09-23'),
	(24,0,'Benefit Class','BNC',0,0,1,NULL,1,'2022-10-07','2022-10-07'),
	(25,0,'Merchant Type','MT',NULL,0,1,1,1,'2022-10-11','2023-03-20'),
	(26,0,'Contact Type','Cct',0,0,1,NULL,1,'2022-10-11','2022-10-11'),
	(27,0,'Household Type','HHT',0,0,1,NULL,1,'2023-03-27','2023-03-27'),
	(28,0,'Household Areas','HHA',0,0,1,NULL,1,'2023-03-27','2023-03-27'),
	(29,0,'Household Tenure','HHT',0,0,1,NULL,1,'2023-03-27','2023-03-27'),
	(30,0,'Household Headship','HHH',0,0,1,NULL,1,'2023-03-27','2023-03-27'),
	(31,0,'Household Income Status','HHI',0,0,1,NULL,1,'2023-03-27','2023-03-27'),
	(32,0,'Program Partners','PP',0,0,1,NULL,1,'2023-04-11','2023-04-11'),
	(33,0,'Applicant Type','APT',0,0,1,NULL,1,'2023-04-14','2023-04-14'),
	(34,0,'Survey Type','ST',0,0,1,NULL,1,'2023-04-14','2023-04-14'),
	(35,0,'Survey Status','SS',0,0,1,NULL,1,'2023-04-14','2023-04-14'),
	(36,0,'Team Roles','TS',0,0,1,NULL,1,'2023-04-14','2023-04-14'),
	(37,0,'Educational Levels','EL',0,0,1,NULL,1,'2023-04-17','2023-04-17');



# Dump of table lookups
# ------------------------------------------------------------

CREATE TABLE `lookups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order` int DEFAULT '0',
  `instance_id` int DEFAULT NULL,
  `fullName` varchar(100) NOT NULL DEFAULT '',
  `shortName` varchar(100) DEFAULT NULL,
  `short_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `lookup_code_id` int DEFAULT NULL,
  `process_status` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `color_code` varchar(100) DEFAULT NULL,
  `activeFlag` tinyint(1) DEFAULT NULL,
  `process_action` tinyint(1) DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `lookups` (`id`, `order`, `instance_id`, `fullName`, `shortName`, `short_code`, `lookup_code_id`, `process_status`, `color_code`, `activeFlag`, `process_action`, `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES
	(1,NULL,NULL,'Male','M',NULL,1,NULL,NULL,1,0,1,1,'2021-11-25','2021-11-25'),
	(2,NULL,NULL,'Female','F',NULL,1,NULL,NULL,1,0,1,NULL,'2021-11-25','2021-11-25'),
	(3,NULL,NULL,'Pending',NULL,NULL,3,NULL,'#2894e6',1,0,1,1,'2021-11-26','2021-11-26'),
	(4,NULL,NULL,'Completed',NULL,NULL,3,NULL,'#05b339',1,0,1,NULL,'2021-11-26','2021-11-26'),
	(5,NULL,NULL,'True','True',NULL,5,NULL,'#000000',1,0,1,NULL,'2021-11-29','2021-11-29'),
	(6,NULL,NULL,'False','False',NULL,5,NULL,'#000000',1,0,1,NULL,'2021-11-29','2021-11-29'),
	(7,NULL,NULL,'Yes','Yes',NULL,6,NULL,'#000000',1,0,1,NULL,'2021-11-29','2021-11-29'),
	(8,NULL,NULL,'No','No',NULL,6,NULL,'#000000',1,0,1,NULL,'2021-11-29','2021-11-29'),
	(9,NULL,NULL,'Not Started','Not Started',NULL,7,NULL,'#000000',1,0,1,NULL,'2021-12-16','2021-12-16'),
	(10,NULL,NULL,'In Progress','In Progress',NULL,7,NULL,'#00a7fa',1,0,1,NULL,'2021-12-16','2021-12-16'),
	(11,NULL,NULL,'Completed','Completed',NULL,7,NULL,'#129900',1,0,1,NULL,'2021-12-16','2021-12-16'),
	(12,1,NULL,'Submit','Submitted',NULL,8,'New','#f50f0f',1,1,8,1,'2021-12-21','2022-02-22'),
	(13,4,NULL,'Recommendation','Recommended',NULL,8,'Processing','#fde808',0,0,8,1,'2021-12-21','2022-03-10'),
	(14,2,NULL,'Receive','Received',NULL,8,'Processing','#0c9d15',1,0,8,1,'2021-12-21','2022-03-09'),
	(15,11,NULL,'Cancel','Cancelled',NULL,8,'Cancelled','#f70808',0,101,8,1,'2021-12-21','2022-03-10'),
	(16,6,NULL,'Decision','Decided',NULL,8,'Ended','#199608',1,100,8,1,'2021-12-21','2022-03-10'),
	(17,NULL,NULL,'Upper West','Upper West','AITU',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(18,NULL,NULL,'Upper East','Upper East','ATIU',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(19,NULL,NULL,'North East','North East','MANG',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(20,NULL,NULL,'Savannah','Savannah','MANI',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(21,NULL,NULL,'Northern','Northern','MAUK',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(22,NULL,NULL,'Oti','Oti','MITI',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(23,NULL,NULL,'Bono East','Bono East','PALM',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(24,NULL,NULL,'Western North','Western North','PENH',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(25,NULL,NULL,'Ahafo','Ahafo','PUKA',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(26,NULL,NULL,'Ashanti','Ashanti','RAKA',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(27,NULL,NULL,'Eastern','Eastern','RARO',9,NULL,'#000000',1,0,8,1,'2021-12-21','2023-03-13'),
	(28,NULL,NULL,'Payment Complaint','payment complaint',NULL,11,NULL,'#c333d7',1,0,1,8,'2021-12-23','2022-01-19'),
	(29,NULL,NULL,'Category 2','category 2',NULL,11,NULL,'#ce1c1c',1,0,1,NULL,'2021-12-23','2021-12-23'),
	(30,NULL,NULL,'Category 3','category 3',NULL,11,NULL,'#00c291',1,0,1,NULL,'2021-12-23','2021-12-23'),
	(31,NULL,NULL,'Generated','Generated',NULL,10,NULL,'#3dc7f5',1,1,8,1,'2022-01-05','2022-01-27'),
	(32,NULL,NULL,'Processing','Processing',NULL,10,NULL,'#f4ce10',1,0,8,1,'2022-01-05','2022-01-27'),
	(33,NULL,NULL,'Approved','Approved',NULL,10,NULL,'#0c924d',1,100,8,1,'2022-01-05','2022-01-19'),
	(34,NULL,NULL,'Rejected','Reject',NULL,10,NULL,'#e71313',1,101,8,8,'2022-01-05','2022-01-19'),
	(35,3,NULL,'Review','Review',NULL,8,'Processing','#e7f524',1,0,8,1,'2022-01-20','2022-03-09'),
	(36,NULL,NULL,'Others','Others',NULL,1,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(37,NULL,NULL,'Passport','Passport',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(38,NULL,NULL,'National Id','National ID',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(39,NULL,NULL,'Birth Certificate','Birth Certificate',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(40,NULL,NULL,'Drivers License','Drivers license',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(41,NULL,NULL,'Tax Identification (Rmd)','Tax Identification',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(42,NULL,NULL,'Superannuation Fund','CINSF Number',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(43,NULL,NULL,'Current','Current',NULL,13,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(44,NULL,NULL,'Savings','Savings',NULL,13,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(45,NULL,NULL,'Bank Of Cook Islands','BCI',NULL,14,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(46,NULL,NULL,'Other','Other',NULL,14,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(47,NULL,NULL,'Atui','Atui',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(48,NULL,NULL,'Mauke','Mauke',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(49,NULL,NULL,'Rarotonga','Rarotonga',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(50,NULL,NULL,'Nassau','Nassau',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(51,NULL,NULL,'Pukapuka','Pukapuka',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(52,NULL,NULL,'Manihiki','Manihiki',NULL,15,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(53,NULL,NULL,'Marriage Certificate','Marriage Certificate',NULL,12,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(54,NULL,NULL,'Single','Single',NULL,16,NULL,'#000000',0,0,1,1,'2022-02-17','2022-02-17'),
	(55,NULL,NULL,'Married','Married',NULL,16,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(56,NULL,NULL,'Divorced','Divorced',NULL,16,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(57,NULL,NULL,'Separated','Separated',NULL,16,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(58,NULL,NULL,'Annulled','Annulled',NULL,16,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(59,NULL,NULL,'Ended By Death','Ended By Death',NULL,16,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(60,NULL,NULL,'Civil','Civil',NULL,17,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(61,NULL,NULL,'Religious','Religious',NULL,17,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(62,NULL,NULL,'Traditional','Traditional',NULL,17,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(63,NULL,NULL,'Public','Public',NULL,18,NULL,'#000000',1,0,1,1,'2022-02-17','2022-02-17'),
	(64,NULL,NULL,'Private','Private',NULL,18,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(65,NULL,NULL,'Unemployed','Unemployed',NULL,19,NULL,'#000000',0,0,1,1,'2022-02-17','2022-02-17'),
	(66,NULL,NULL,'Full-Time','Full-Time',NULL,19,NULL,'#000000',1,0,1,1,'2022-02-17','2022-02-17'),
	(67,NULL,NULL,'Part-Time','Part-Time',NULL,19,NULL,'#000000',1,0,1,1,'2022-02-17','2022-02-17'),
	(68,NULL,NULL,'Casual','Casual',NULL,19,NULL,'#000000',1,0,1,NULL,'2022-02-17','2022-02-17'),
	(69,NULL,NULL,'Residence','Residence',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(70,NULL,NULL,'Passport','Passport',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(71,NULL,NULL,'National Id','National ID',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(72,NULL,NULL,'Birth Certificate','Birth Certificate',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(73,NULL,NULL,'Tax Identification (Rmd)','Tax Identification',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(74,NULL,NULL,'Drivers License','Drivers license',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(75,NULL,NULL,'Superannuation Fund','CINSF Number',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(76,NULL,NULL,'Marriage Certificate','Marriage Certificate',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(77,NULL,NULL,'Bank Account','Bank Account',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(78,NULL,NULL,'Electricity Bill','Electricity Bill',NULL,20,NULL,'#000000',1,0,1,NULL,'2022-02-18','2022-02-18'),
	(79,NULL,NULL,'Visual','Visual',NULL,21,NULL,'#000000',1,0,1,1,'2022-02-21','2022-02-21'),
	(80,NULL,NULL,'Hearing','Hearing',NULL,21,NULL,'#000000',1,0,1,1,'2022-02-21','2022-02-21'),
	(81,NULL,NULL,'Mobility','Mobility',NULL,21,NULL,'#000000',1,0,1,1,'2022-02-21','2022-02-21'),
	(82,NULL,NULL,'Speech','Speech',NULL,21,NULL,'#000000',1,0,1,1,'2022-02-21','2022-02-21'),
	(83,NULL,NULL,'Chronic Fatigue, Pain Or Seizure','Medical',NULL,21,NULL,'#000000',1,0,1,1,'2022-02-21','2022-02-21'),
	(84,1,NULL,'Mother','Mother',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(85,2,NULL,'Father','Father',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(86,3,NULL,'Daughter','Daughter',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(87,NULL,NULL,'Son','Son',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(88,NULL,NULL,'Sister','Sister',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(89,NULL,NULL,'Brother','Brother',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(90,NULL,NULL,'Grandmother','Grandmother',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(91,NULL,NULL,'Grandfather','Grandfather',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(92,NULL,NULL,'Nephew','Nephew',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(93,NULL,NULL,'Niece','Niece',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-08','2022-03-08'),
	(94,7,NULL,'Appeal','Appealed',NULL,8,'Re-Submitted','#000000',1,0,1,NULL,'2022-03-09','2022-03-09'),
	(95,5,NULL,'Computation','Computated',NULL,8,'Processing','#000000',1,0,1,NULL,'2022-03-10','2022-03-10'),
	(96,8,NULL,'Review Payroll','Reviewed Payroll',NULL,8,'Processing','#000000',1,0,1,NULL,'2022-03-10','2022-03-10'),
	(97,9,NULL,'Pay','Paid',NULL,8,'Processing','#000000',1,0,1,NULL,'2022-03-10','2022-03-10'),
	(98,10,NULL,'Refund','Refunded',NULL,8,'Processing','#000000',1,0,1,NULL,'2022-03-10','2022-03-10'),
	(99,1,NULL,'Care Giver','Care Giver',NULL,22,'New','#000000',1,0,1,NULL,'2022-03-11','2022-03-11'),
	(100,1,0,'Head Office','HDQ',NULL,23,NULL,'#000000',1,0,1,NULL,'2022-09-25','2022-09-25'),
	(101,1,0,'Social Assistance (Nc)','SANC',NULL,24,NULL,'#000000',1,0,1,NULL,'2022-10-07','2022-10-07'),
	(102,2,0,'Social Insurance (C)','SIC',NULL,24,NULL,'#000000',1,0,1,NULL,'2022-10-07','2022-10-07'),
	(103,3,0,'Social Care (Nc)','SoC',NULL,24,NULL,'#000000',1,0,1,NULL,'2022-10-07','2022-10-07'),
	(104,4,0,'Labour Market (C/Nc)','LM',NULL,24,NULL,'#000000',1,0,1,NULL,'2022-10-07','2022-10-07'),
	(105,1,0,'Bank','Bank',NULL,25,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(106,2,0,'Savings And Loans','SL',NULL,25,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(107,1,0,'Residential Address','Res Add',NULL,26,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(108,2,0,'Postal Address','Post',NULL,26,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(109,3,0,'Mobile Number','Mobile',NULL,26,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(110,4,0,'Email','email',NULL,26,NULL,'#000000',1,0,1,NULL,'2022-10-11','2022-10-11'),
	(111,NULL,0,'Volta','Volta',NULL,9,NULL,'#000000',1,0,1,NULL,'2023-03-13','2023-03-13'),
	(112,NULL,0,'Western','Western',NULL,9,NULL,'#000000',1,0,1,NULL,'2023-03-13','2023-03-13'),
	(113,NULL,0,'Central','Central',NULL,9,NULL,'#000000',1,0,1,NULL,'2023-03-13','2023-03-13'),
	(114,NULL,0,'Greater Accra','Greater Accra',NULL,9,NULL,'#000000',1,0,1,NULL,'2023-03-13','2023-03-13'),
	(115,NULL,0,'Bono','Bono',NULL,9,NULL,'#000000',1,0,1,1,'2023-03-13','2023-03-13'),
	(116,3,0,'Store','Store',NULL,25,NULL,'#000000',1,0,1,NULL,'2023-03-20','2023-03-20'),
	(117,4,0,'Mobile Money','Momo',NULL,25,NULL,'#000000',1,0,1,NULL,'2023-03-20','2023-03-20'),
	(118,1,0,'Nuclear Family','Nuclear',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(119,2,0,'Extended Family','Extended',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(120,3,0,'Single-Parent Family','Single-Parent',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(121,4,0,'Blended Family','Blended',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(122,5,0,'Foster Family','Foster',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(123,6,0,'Multi-Generational Family','Multi-Generational',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(124,7,0,'Group Home','Group',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(125,8,0,'Cohousing Community','Cohousing',NULL,27,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(126,1,0,'Rural','RRL',NULL,28,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(127,2,0,'Urban','UBN',NULL,28,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(128,1,0,'Owner Occupied','Owner',NULL,29,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(129,2,0,'Renter Occupied','Renter',NULL,29,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(130,3,0,'Institutional Household','Institutional',NULL,29,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(131,1,0,'Male Headed','Male',NULL,30,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(132,2,0,'Female Headed','Female',NULL,30,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(133,3,0,'Elderly Headed','Elderly',NULL,30,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(134,1,0,'Low Income','Low',NULL,31,NULL,'#000000',1,0,1,1,'2023-03-27','2023-03-27'),
	(135,2,0,'Middle Income','Middle',NULL,31,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(136,3,0,'High Income','High',NULL,31,NULL,'#000000',1,0,1,NULL,'2023-03-27','2023-03-27'),
	(137,5,0,'Household','Household',NULL,26,NULL,'#000000',1,0,1,NULL,'2023-03-28','2023-03-28'),
	(138,1,0,'Private','Private',NULL,32,NULL,'#000000',1,0,1,NULL,'2023-04-11','2023-04-11'),
	(139,2,0,'International Organization','IO',NULL,32,NULL,'#000000',1,0,1,NULL,'2023-04-11','2023-04-11'),
	(140,3,0,'Government','Government',NULL,32,NULL,'#000000',1,0,1,NULL,'2023-04-11','2023-04-11'),
	(141,1,0,'Community Based Organisation','CBO',NULL,32,NULL,'#000000',1,0,1,1,'2023-04-11','2023-04-11'),
	(142,4,0,'Non Governamental Organisation','NGO',NULL,32,NULL,'#000000',1,0,1,NULL,'2023-04-11','2023-04-11'),
	(143,5,0,'Academia','Academia',NULL,32,NULL,'#000000',1,0,1,NULL,'2023-04-11','2023-04-11'),
	(144,1,0,'Beneficiary','Beneficiary',NULL,33,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(145,2,0,'Household','Household',NULL,33,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(146,1,0,'Household','Household',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(147,2,0,'Impact Assessment','Impact Assessment',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(148,3,0,'Needs Assessment','Needs Assessment',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(149,4,0,'Perception','Perception',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(150,5,0,'Monitoring and Evaluation','M&E',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(151,6,0,'Targeting','Targeting',NULL,34,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(152,2,0,'Closed','Closed',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(154,1,0,'Open','Open',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(155,3,0,'Draft','Draft',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(156,4,0,'In Progress','In Progress',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(157,5,0,'Completed','Completed',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(158,6,0,'Partially Done','Partial',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(159,7,0,'Paused','Paused',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(160,8,0,'Pending Review','Pending Review',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(161,9,0,'Rejected','Rejected',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(162,10,0,'Deleted','Deleted',NULL,35,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(163,1,0,'Lead','Lead',NULL,36,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(164,2,0,'Technical Writer','Writer',NULL,36,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(165,3,0,'Coordinator','Coordinator',NULL,36,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(166,4,0,'Driver','Driver',NULL,36,NULL,'#000000',1,0,1,NULL,'2023-04-14','2023-04-14'),
	(167,1,0,'Primary Education','Primary',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(168,2,0,'Secondary Education','Secondary',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(169,3,0,'Tertiary Education','Tertiary',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(170,4,0,'Vocational Education And Training','Vocational',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(171,5,0,'Adult Education','Adult',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(172,6,0,'Special Education','Special',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17'),
	(173,7,0,'Non-Formal Education','Non-formal',NULL,37,NULL,'#000000',1,0,1,NULL,'2023-04-17','2023-04-17');



# Dump of table marital_details
# ------------------------------------------------------------

CREATE TABLE `marital_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `applicant_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `marriage_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `spouse_ref_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `spouse_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marriage_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marriage_start_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marriage_end_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `addedBy` int unsigned NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `marital_details` (`id`, `applicant_number`, `marriage_status`, `spouse_ref_id`, `spouse_name`, `marriage_type`, `marriage_start_date`, `marriage_end_date`, `addedBy`, `status`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'MANG-19930616-1-007','Divorced','RT33311','Amalia Hanson','Tradional','06/18/2000','06/-08-2009',1,'Verified','2022-02-17 16:00:13','2022-03-09 13:59:01',NULL),
	(2,'MANG-19930616-1-007','Married','RT33311','Joyce Greg','Religious','06/18/2024',NULL,1,'Verified','2022-02-17 16:04:08','2022-03-09 13:59:01',NULL),
	(3,'ATIU-19900130-1-001','Choose',NULL,NULL,'Choose',NULL,NULL,1,'0','2022-02-21 08:49:25','2022-03-09 13:59:01',NULL),
	(4,'ALB-20100325-2-001','Married','ATIU-19900131-1-001','Husband','Civil','01/01/2022',NULL,1,'1','2022-02-21 12:52:45','2022-02-21 12:52:45',NULL),
	(5,'AITU-19930214-1-001','Married','RT33311','Pearl Sowa','Civil','2022-09-28','1970-01-01',1,'Verified','2022-09-30 14:30:28','2022-11-21 16:28:32',NULL),
	(6,'AITU-19930214-1-001','Separated','ATIU-00900131-1-001','Joyce Greg','Civil','2022-08-18','2022-11-01',1,'Verified','2022-11-21 16:40:40','2022-11-21 16:40:40',NULL);



# Dump of table master_payment_vouchers
# ------------------------------------------------------------

CREATE TABLE `master_payment_vouchers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `voucher_date` datetime NOT NULL,
  `voucher_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_date` date NOT NULL,
  `period` date DEFAULT NULL,
  `gross_pay` double NOT NULL DEFAULT '0',
  `tax` double unsigned NOT NULL DEFAULT '0',
  `netable_pay` double DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `approved_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `master_payment_vouchers` (`id`, `voucher_date`, `voucher_number`, `payment_date`, `period`, `gross_pay`, `tax`, `netable_pay`, `status`, `created_by`, `approved_by`, `created_at`, `updated_at`)
VALUES
	(10,'2022-10-22 00:00:00','PV-0010','2022-11-29','2022-10-01',17000,10,16000,'Pending Payment',1,NULL,'2022-10-22 08:34:20','2022-10-22 08:34:20');



# Dump of table measurement_systems
# ------------------------------------------------------------

CREATE TABLE `measurement_systems` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `measurement_systems` (`id`, `name`, `created_at`, `updated_at`)
VALUES
	(1,'Metric',NULL,NULL),
	(2,'Imperial',NULL,NULL);



# Dump of table measurement_units
# ------------------------------------------------------------

CREATE TABLE `measurement_units` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `measurement_system_id` bigint unsigned NOT NULL,
  `measurement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `measurement_units_measurement_system_id_foreign` (`measurement_system_id`),
  CONSTRAINT `measurement_units_measurement_system_id_foreign` FOREIGN KEY (`measurement_system_id`) REFERENCES `measurement_systems` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `measurement_units` (`id`, `measurement_system_id`, `measurement`, `unit`, `created_at`, `updated_at`)
VALUES
	(1,1,'Length','Metre','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(2,2,'Length','Yard','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(3,1,'Distance','Kilometre','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(4,2,'Distance','Mile','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(5,1,'Area','Hectare','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(6,2,'Area','Acre','2022-06-04 08:50:02','2022-06-04 08:51:16'),
	(7,1,'Volume','Litre','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(8,2,'Volume','Gallon','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(9,1,'Weight','Kilogram','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(10,2,'Weight','Pound','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(11,1,'Heavy_Weight','MetricTonne','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(12,2,'Heavy_Weight','Tonne','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(13,1,'Temperature','Celcius','2022-06-04 08:50:02','2022-06-04 08:51:17'),
	(14,2,'Temperature','Fahrenheit','2022-06-04 08:50:02',NULL);



# Dump of table migrations
# ------------------------------------------------------------

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES
	(1,'2014_10_12_000000_create_users_table',1),
	(2,'2014_10_12_100000_create_password_resets_table',1),
	(3,'2019_08_19_000000_create_failed_jobs_table',1),
	(4,'2019_12_14_000001_create_personal_access_tokens_table',1),
	(5,'2021_07_04_112559_create_user_profiles_table',2),
	(6,'2021_11_20_021044_laratrust_setup_tables',3),
	(7,'2021_11_22_101815_update_users_table',4),
	(8,'05_04_2020_000001_create_forms_table',5),
	(9,'2020_04_08_123236_create_lookup_options_table',5),
	(10,'2020_04_08_123503_create_options_table',5),
	(11,'2020_04_08_135958_create_fields_table',5),
	(12,'2020_04_08_135960_create_form_field_children_table',5),
	(13,'2020_04_17_082358_create_form_collectives_table',5),
	(14,'2020_04_17_083433_create_form_collectives_forms_table',5),
	(18,'2021_12_01_011439_create_benefit_registrations_table',6),
	(22,'2021_12_02_161834_create_benefit_form_options_table',7),
	(23,'2021_12_03_010133_create_benefit_verification_process_log_table',8),
	(25,'2021_12_06_124821_create_questionnaires_table',9),
	(26,'2022_07_28_161404_create_audits_table',10),
	(29,'2021_12_08_235127_create_beneficiaries_table',11),
	(30,'2021_12_09_002138_create_beneficiaries_form_mapping_table',11),
	(31,'2021_12_08_234559_create_black_box_table',12),
	(42,'2021_12_17_163218_create_payment_schedules_table',13),
	(43,'2021_12_18_090127_create_payrolls_table',13),
	(44,'2021_12_18_101218_create_payroll_history_table',13),
	(45,'2021_12_22_160142_create_payroll_verification_process_logs_table',14),
	(47,'2021_12_24_005919_create_complaints_feedback_stages_table',15),
	(48,'2021_12_30_113441_create_cases_table',16),
	(49,'2021_12_30_113444_create_cases_comments_stages_table',16),
	(51,'2022_01_18_151716_create_debt_recoveries_table',17),
	(53,'2022_01_27_205211_create_payroll_view_logs_table',18),
	(54,'2022_02_02_134120_create_beneficiaries_archived_logs_table',19),
	(56,'2022_02_02_142238_create_debt_recovery_amount_paid_history_table',20),
	(58,'2022_02_14_211234_create_applicant_registrations_table',21),
	(60,'2022_02_16_110931_create_account_details_table',22),
	(61,'2022_02_16_125827_create_contact_details_table',23),
	(63,'2022_02_16_210229_create_identification_details_table',24),
	(64,'2022_02_17_095011_create_input_keys_table',25),
	(67,'2022_02_17_111502_create_marital_details_table',26),
	(68,'2022_02_17_113554_create_employment_details_table',27),
	(71,'2022_02_21_133324_create_applications_processing_table',28),
	(76,'2022_03_08_105151_create_family_table',29),
	(77,'2014_10_00_000000_create_settings_table',30),
	(78,'2014_10_00_000001_add_group_column_on_settings_table',31),
	(79,'2023_03_30_104100_create_partners_table',32),
	(80,'2023_03_30_104112_create_programs_table',32),
	(86,'2023_03_30_110443_create_partner_program_table',33),
	(87,'2023_03_30_110621_create_program_user_table',33),
	(88,'2023_03_30_110716_create_location_program_table',33),
	(89,'2023_03_30_110839_create_benefit_program_table',33),
	(90,'2023_03_30_111012_create_currency_program_table',33);



# Dump of table new_born_registrations
# ------------------------------------------------------------

CREATE TABLE `new_born_registrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `application_types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_cert_refs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rmd_nos` double DEFAULT NULL,
  `tax_rates` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_refs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_exps` date DEFAULT NULL,
  `bci_bank_card__accountnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bci_account_numbers` double DEFAULT NULL,
  `first_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bef_dobs` date DEFAULT NULL,
  `genders` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `islands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `villages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phones` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobiles` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emails` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_addresses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bef_residencies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_bef_residencies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bef_permanent_dates` date DEFAULT NULL,
  `ci_arrivals` date DEFAULT NULL,
  `complete_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complete_surnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationships` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complete_numbers` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signatures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sign_dates` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table notifications
# ------------------------------------------------------------

CREATE TABLE `notifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `notification_type_id` int unsigned NOT NULL,
  `object_id` int unsigned DEFAULT NULL,
  `object_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `sent_at` datetime DEFAULT NULL,
  `sender_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notification_type_id_foreign` (`notification_type_id`),
  KEY `notifications_user_id_index` (`user_id`),
  KEY `notifications_sender_id_index` (`sender_id`),
  CONSTRAINT `notifications_notification_type_id_foreign` FOREIGN KEY (`notification_type_id`) REFERENCES `notifications_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `notifications` (`id`, `user_id`, `notification_type_id`, `object_id`, `object_type`, `title`, `message`, `is_read`, `sent_at`, `sender_id`)
VALUES
	(3,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',1,'2021-12-09 22:50:55',1),
	(4,2,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',0,'2021-12-09 22:55:19',1),
	(5,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',1,'2021-12-09 22:55:50',1),
	(6,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',1,'2021-12-09 22:55:52',1),
	(7,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',1,'2021-12-09 22:55:55',1),
	(8,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new in the application. Do not think this is all we have for you',1,'2021-12-09 22:57:06',1),
	(9,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new\n            in the application. Do not think this is all we have for you',0,'2021-12-16 07:07:03',1),
	(10,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new\n            in the application. Do not think this is all we have for you',0,'2021-12-16 07:07:05',1),
	(11,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new\n            in the application. Do not think this is all we have for you',1,'2021-12-16 07:07:06',1),
	(12,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new\n            in the application. Do not think this is all we have for you',1,'2021-12-16 07:07:07',1),
	(13,1,1,NULL,NULL,'Dashboard Alert for all users','This is a newly opened dashboard for all users to read notifications and see what we have created new\n            in the application. Do not think this is all we have for you',1,'2021-12-16 07:07:08',1);



# Dump of table notifications_type
# ------------------------------------------------------------

CREATE TABLE `notifications_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `notifications_type` (`id`, `subject`, `body`, `url`)
VALUES
	(1,'#{obj.id} Ticket closed','The ticket #{obj.id} was closed by {from.name}','http://tickets.com/{obj.id}');



# Dump of table office_class
# ------------------------------------------------------------

CREATE TABLE `office_class` (
  `id` int NOT NULL AUTO_INCREMENT,
  `class` varchar(150) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `office_class` (`id`, `class`, `status`, `created_at`, `updated_at`)
VALUES
	(1,'Hospital',1,'2021-12-14 11:20:39','2021-12-14 11:20:41'),
	(2,'Clinics and Medical Center',1,'2021-12-14 11:22:46','2021-12-14 11:22:48'),
	(3,'Nursing Home',1,'2021-12-14 11:23:26','2021-12-14 11:23:28'),
	(4,'Mental Health and Addiction Treatment Center',1,'2021-12-14 11:24:04','2021-12-14 11:24:06'),
	(5,'Birth Center',1,'2021-12-14 11:24:24','2021-12-14 11:24:25'),
	(6,'Hospice Care Facility',1,'2021-12-14 11:24:44','2021-12-14 11:24:47'),
	(7,'Dialysis Facility',1,'2021-12-14 11:25:12','2021-12-14 11:25:14'),
	(8,'Imaging and Radiology Centers',1,'2021-12-14 11:25:51','2021-12-14 11:25:52'),
	(9,'Orthopedic Rehabilitation Center',1,'2021-12-14 11:26:34','2021-12-14 11:26:37'),
	(10,'RHU',1,'2022-02-13 14:34:04','2022-02-13 14:34:05'),
	(11,'Infirmary',1,'2022-02-13 14:34:20','2022-02-13 14:34:21'),
	(12,'Psychiatric Care Facility',1,'2022-02-13 14:34:38','2022-02-13 14:34:40'),
	(13,'Birthing Home',1,'2022-02-13 14:35:11','2022-02-13 14:35:13'),
	(14,'Barangay Health Station',1,'2022-02-13 14:35:28','2022-02-13 14:35:30'),
	(15,'Municipal Health Office',1,'2022-02-13 14:38:05','2022-02-13 14:38:06'),
	(16,'Drug Abuse Treatment and Rehabilitation Centers',1,'2022-02-13 14:38:21','2022-02-13 14:38:22'),
	(17,'Social hygiene Clinic',1,'2022-02-13 14:38:34','2022-02-13 14:38:36'),
	(18,'General Clinic Laboratory',1,'2022-02-13 14:38:51','2022-02-13 14:38:53'),
	(19,'COVID-19 Testing Laboratory',1,'2022-02-13 14:39:08','2022-02-13 14:39:10'),
	(20,'Dialysis Clinic',1,'2022-02-13 14:39:21','2022-02-13 14:39:23'),
	(21,'Ambulatory Surgical Clinic',1,'2022-02-13 14:39:40','2022-02-13 14:39:42'),
	(22,'Administrative',1,'2022-02-14 12:33:21','2022-02-14 12:33:23');



# Dump of table office_healthcheck
# ------------------------------------------------------------

CREATE TABLE `office_healthcheck` (
  `id` int NOT NULL AUTO_INCREMENT,
  `office_id` int DEFAULT NULL,
  `health_check_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `office_healthcheck` (`id`, `office_id`, `health_check_id`, `created_at`, `updated_at`)
VALUES
	(45,3,1,'2022-02-03 20:38:49','2022-02-03 20:38:49'),
	(46,3,2,'2022-02-03 20:38:49','2022-02-03 20:38:49'),
	(47,3,4,'2022-02-03 20:38:49','2022-02-03 20:38:49'),
	(48,3,5,'2022-02-03 20:38:49','2022-02-03 20:38:49'),
	(49,2,1,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(50,2,2,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(51,2,4,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(52,2,5,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(53,2,7,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(54,2,8,'2022-02-03 20:40:46','2022-02-03 20:40:46'),
	(55,18,1,'2022-02-03 21:06:44','2022-02-03 21:06:44'),
	(56,18,2,'2022-02-03 21:06:44','2022-02-03 21:06:44'),
	(57,18,4,'2022-02-03 21:06:44','2022-02-03 21:06:44'),
	(58,18,5,'2022-02-03 21:06:44','2022-02-03 21:06:44'),
	(59,18,6,'2022-02-03 21:06:44','2022-02-03 21:06:44'),
	(60,18,8,'2022-02-03 21:06:44','2022-02-03 21:06:44');



# Dump of table office_ranks
# ------------------------------------------------------------

CREATE TABLE `office_ranks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rank` int DEFAULT NULL,
  `office_type` varchar(150) DEFAULT NULL,
  `rank_code` varchar(3) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `health_status` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `office_ranks` (`id`, `rank`, `office_type`, `rank_code`, `status`, `created_at`, `updated_at`, `health_status`)
VALUES
	(1,9,'System Office','SO',6,'2021-12-14 10:52:57','2021-12-14 10:52:59',0),
	(2,8,'System Administrator','SYS',6,'2021-12-14 10:53:42','2021-12-14 10:53:48',0),
	(3,7,'Department of Health KMITS','DOH',5,'2021-12-14 10:54:23','2021-12-14 10:54:25',0),
	(4,6,'Department of Health CPCB','CPC',5,'2021-12-14 11:04:56','2021-12-14 11:04:58',0),
	(5,5,'Department of Health CHD','CHD',5,'2021-12-14 11:05:32','2021-12-14 11:05:34',0),
	(6,4,'Provincial Health Office','PHO',5,'2021-12-14 11:05:56','2021-12-14 11:06:00',0),
	(7,3,'Municipal Health Office','MHO',5,'2021-12-14 11:06:56','2021-12-14 11:06:58',0),
	(8,2,'Barangay Health Center','BHO',5,'2021-12-14 11:09:08','2021-12-14 11:09:10',0),
	(9,1,'Health Facility','HCF',5,'2021-12-14 11:09:28','2021-12-14 11:09:30',1),
	(10,0,'General Public','GP',6,'2021-12-14 11:10:36','2021-12-14 11:10:38',0);



# Dump of table office_use_onlies
# ------------------------------------------------------------

CREATE TABLE `office_use_onlies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `officer_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `officer_dates` date DEFAULT NULL,
  `home_visits` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_infos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `officer_recommendations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `outer_recieved_bies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raro_received_bies` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outer_date_receiveds` date DEFAULT NULL,
  `raro_pay_periods` date DEFAULT NULL,
  `outer_supporting_docs` date DEFAULT NULL,
  `raro_payment_amounts` date DEFAULT NULL,
  `outer_supplementary_docs` date DEFAULT NULL,
  `raro_other_payments` date DEFAULT NULL,
  `outer_referals` date DEFAULT NULL,
  `raro_payments` date DEFAULT NULL,
  `outer_application_nos` date DEFAULT NULL,
  `raro_additional_voucher_nos` date DEFAULT NULL,
  `outer_head_app_nos` date DEFAULT NULL,
  `raro_main_vchrs` date DEFAULT NULL,
  `decisions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meeting_helds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `commitee_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_committees` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `committee_dates` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table offices
# ------------------------------------------------------------

CREATE TABLE `offices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `manager` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `lead` int DEFAULT NULL,
  `location` int DEFAULT NULL,
  `coverable_date` date DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `offices` (`id`, `code`, `name`, `manager`, `type`, `lead`, `location`, `coverable_date`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`)
VALUES
	(1,'001','Accra Circuit','1',100,2,22,'2022-09-05',1,'2022-09-23 12:52:33','2022-09-25 19:37:29',NULL,NULL),
	(2,'002','Tema','2',100,2,19,'2022-09-01',1,'2022-09-25 19:38:24','2022-09-25 19:38:24',NULL,NULL);



# Dump of table old_age_pensions
# ------------------------------------------------------------

CREATE TABLE `old_age_pensions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `first_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surnames` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dobs` date DEFAULT NULL,
  `islands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `genders` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bci_account_numbers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table options
# ------------------------------------------------------------

CREATE TABLE `options` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shortname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lookup_option_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table page_settings
# ------------------------------------------------------------

CREATE TABLE `page_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) DEFAULT NULL,
  `page_content` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `page_title` varchar(200) DEFAULT NULL,
  `page_description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `page_settings` (`id`, `page_name`, `page_content`, `created_at`, `updated_at`, `page_title`, `page_description`)
VALUES
	(1,'faq','<div class=\"card mb-1\">\r\n     <h6 class=\"mb-0 p-xl-4 p-3\" data-bs-toggle=\"collapse\" data-bs-target=\"#faq4\" aria-expanded=\"true\" aria-controls=\"faq4\">Where can i show the FAQ section on my website?\r\n</h6>\r\n <div id=\"faq4\" class=\"collapse show\" style=\"\">\r\n        <div class=\"card-body border-top\">\r\n               <p>Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et.</p>\r\n        </div>\r\n     </div>\r\n </div>','2021-11-29 21:45:48','2022-08-31 09:43:34','FAQ','Frequently Asked Questions\r\n\r\nThe following provides answers to some of the frequently asked questions about the application'),
	(2,'contact_us','<p>CONTACT INFORMATION<br />\r\n<br />\r\nSan Lazaro Compound, Tayuman, Sta. Cruz, Manila<br />\r\nPhilippines 1003<br />\r\nTelephone No. (632) 8651-7800<br />\r\n<br />\r\nTelephone No: (632) 8651-7800 local 5003-5004<br />\r\n(632) 165-364<br />\r\nEmail Address: callcenter@doh.gov.ph</p>\r\n\r\n<p>&nbsp;</p>','2021-11-29 21:46:05','2022-09-01 01:02:20','CONTACT US','San Lazaro Compound, Tayuman, Sta. Cruz, Manila'),
	(3,'about_us','<p>ABOUT US<br />\r\n<br />\r\nOver 700 children under age 5 die every day of diarrhoeal diseases due to lack of appropriate WASH services. UNICEF works in over 100 countries to help provide access to clean water and reliable sanitation, and to promote basic hygiene practices in rural and urban areas, including in emergency situations. We achieve better WASH results for children by:</p>','2021-11-29 21:46:18','2021-12-09 13:51:52','ABOUT US','Over 700 children under age 5 die every day of diarrhoeal diseases due to lack of appropriate WASH services.');



# Dump of table partner_program
# ------------------------------------------------------------

CREATE TABLE `partner_program` (
  `program_id` bigint unsigned NOT NULL,
  `partner_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `partner_program` (`program_id`, `partner_id`, `created_at`, `updated_at`)
VALUES
	(2,2,NULL,NULL),
	(2,1,NULL,NULL);



# Dump of table partners
# ------------------------------------------------------------

CREATE TABLE `partners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` bigint unsigned NOT NULL,
  `phone` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `logo_url` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) DEFAULT '1',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `partners` (`id`, `name`, `type`, `phone`, `email`, `website`, `description`, `logo_url`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES
	(1,'Ministry of Defence',140,'0557205684','program-gr-renade@mod.gov.gh',NULL,NULL,NULL,1,1,NULL,NULL,NULL),
	(2,'Ministry of Gender, Children and Social Protection',140,'0557205684','program-gr-renade@mod.gov.gh','https://mogcsp.gov.gh','MOGCSP exists to contribute to the development of the nation by achieving gender equality and equity, facilitate the enforcement of the rights of children, promote the integration and protection of the vulnerable, excluded and persons with disabilities in the development process through appropriate policies and strategies with adequate resources. We are committed to working with integrity, excellence and social justice.','app-uploads/programs/GVMkJR5CDt5sT1gxrNsNCm80PSjVwoZWPf0EDvBR.png',1,1,1,NULL,'2023-04-11 15:44:47'),
	(3,'UNICEF',139,'0557205684','info@unicef.org','http://unicef.org','The United Nations Children\'s Fund (UNICEF) is a specialized agency of the United Nations that is responsible for providing humanitarian and developmental assistance to children worldwide. Established in 1946, UNICEF operates in more than 190 countries and territories and is guided by the principles of the Convention on the Rights of the Child. UNICEF works with governments, civil society organizations, and other partners to provide health care, education, protection, and other essential services to children and their families, particularly those who are most vulnerable and marginalized. The organization focuses on reaching children in emergency and conflict situations, addressing the root causes of poverty and inequality, and promoting the participation of children and young people in decision-making processes that affect their lives.','app-uploads/programs/JBUBAsqfKGYBBtygHMIzC1canXNh48SwX6LLyCB8.png',1,1,1,'2023-04-11 13:14:02','2023-04-11 13:40:07');



# Dump of table password_resets
# ------------------------------------------------------------

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table pay_schedules
# ------------------------------------------------------------

CREATE TABLE `pay_schedules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` double NOT NULL,
  `cycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table payment_schedules
# ------------------------------------------------------------

CREATE TABLE `payment_schedules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `benefit_id` int unsigned NOT NULL,
  `cycle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `begin_period` date DEFAULT NULL,
  `end_period` date DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Recurring',
  `day_of_payment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1,16',
  `amount` double unsigned DEFAULT '0',
  `tax` double unsigned DEFAULT '0',
  `dob_field` int unsigned DEFAULT NULL,
  `pension_amount` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `funeral_amount` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `child_age_limit` tinyint unsigned DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `payment_schedules` (`id`, `benefit_id`, `cycle`, `begin_period`, `end_period`, `type`, `day_of_payment`, `amount`, `tax`, `dob_field`, `pension_amount`, `funeral_amount`, `child_age_limit`, `user_id`, `created_at`, `updated_at`)
VALUES
	(5,3,NULL,NULL,NULL,'Recurring','[\"1\",\"16\"]',100,0,NULL,NULL,NULL,NULL,1,'2022-01-18 17:02:30','2022-01-18 17:02:30'),
	(7,7,NULL,'2022-01-01','2022-12-01','One-Off','[\"25\"]',1920,10,NULL,NULL,NULL,NULL,1,'2022-01-19 12:39:32','2022-10-31 12:04:13'),
	(9,4,NULL,NULL,NULL,'One-Off','[\"3\"]',1000,10,NULL,NULL,NULL,NULL,8,'2022-01-20 17:36:15','2022-01-20 17:36:15'),
	(10,16,NULL,'2022-01-27','2022-04-13','Recurring','[\"2\",\"8\"]',230,21,NULL,'{\"60+\":{\"amount\":\"150\",\"tax\":\"17\"},\"65+\":{\"amount\":\"200\",\"tax\":\"17\"},\"70+\":{\"amount\":\"300\",\"tax\":\"20\"}}',NULL,NULL,1,'2022-01-27 14:33:21','2022-02-08 09:37:25'),
	(11,5,NULL,'2023-02-01','2023-02-28','Recurring','[\"2\",\"3\",\"8\",\"10\"]',200,0,NULL,NULL,NULL,NULL,1,'2022-02-02 12:54:07','2023-02-07 10:52:19'),
	(12,10,NULL,'2022-10-01','2026-10-01','One-Off','[\"3\"]',50,0,NULL,NULL,NULL,NULL,1,'2022-02-03 09:42:56','2022-10-24 13:23:55'),
	(13,17,NULL,'2022-02-18','2022-02-18','One-Off','[\"3\"]',0,0,NULL,NULL,NULL,NULL,1,'2022-02-19 00:09:55','2022-02-19 00:09:55'),
	(14,18,NULL,'2022-02-18','2022-02-18','Recurring','[\"4\"]',0,0,NULL,NULL,NULL,NULL,1,'2022-02-19 00:10:35','2022-02-19 00:10:35'),
	(15,19,NULL,'2022-02-18','2022-02-18','One-Off','[\"3\"]',0,0,NULL,NULL,NULL,NULL,1,'2022-02-19 00:20:40','2022-02-19 00:20:40'),
	(16,20,NULL,'2022-02-19','2022-02-19','Recurring','[\"3\",\"5\"]',1230,0,NULL,NULL,NULL,NULL,1,'2022-02-19 00:52:06','2022-02-19 00:52:06'),
	(17,21,NULL,'2022-01-01','2022-12-01','Recurring','1,16',0,0,NULL,NULL,NULL,NULL,1,'2022-10-10 10:04:34','2022-10-10 10:46:53'),
	(18,22,NULL,'2023-01-01','2023-12-01','Recurring','1,16',0,0,NULL,NULL,NULL,NULL,1,'2023-02-09 11:24:04','2023-02-09 11:29:41');



# Dump of table payment_vouchers
# ------------------------------------------------------------

CREATE TABLE `payment_vouchers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `applicant_ref_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `voucher_id` bigint NOT NULL,
  `benefit_id` bigint NOT NULL,
  `period` date DEFAULT NULL,
  `pay_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gross_pay` double NOT NULL DEFAULT '0',
  `tax` double unsigned NOT NULL DEFAULT '0',
  `netable_pay` double DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `approved_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `payment_vouchers` (`id`, `applicant_ref_no`, `voucher_id`, `benefit_id`, `period`, `pay_type`, `gross_pay`, `tax`, `netable_pay`, `status`, `created_by`, `approved_by`, `created_at`, `updated_at`)
VALUES
	(1,'AITU-19930214-1-001',10,10,'2022-01-01','Type 1',9000,10,8100,'Verified',1,1,'2022-10-25 06:04:34','2022-10-25 06:04:34'),
	(2,'ALB-20100325-2-001',10,10,'2022-02-01','Type 1',8000,0,8000,'Verified',1,1,'2022-10-25 06:04:34','2022-10-25 06:04:34');



# Dump of table payroll_history
# ------------------------------------------------------------

CREATE TABLE `payroll_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payroll_id` int unsigned NOT NULL,
  `benefit_id` int unsigned NOT NULL,
  `beneficiaries_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirmed_by` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table payroll_verification_process_logs
# ------------------------------------------------------------

CREATE TABLE `payroll_verification_process_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payroll_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL,
  `verification_process_id` int unsigned NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `payroll_verification_process_logs` (`id`, `payroll_id`, `user_id`, `verification_process_id`, `message`, `created_at`, `updated_at`)
VALUES
	(1,1,1,31,'Payroll has been generated.','2022-02-25 15:20:35','2022-02-25 15:20:35');



# Dump of table payroll_view_logs
# ------------------------------------------------------------

CREATE TABLE `payroll_view_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `payroll_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `payroll_view_logs` (`id`, `user_id`, `payroll_id`, `created_at`, `updated_at`)
VALUES
	(1,1,1,'2022-02-25 15:29:21','2022-02-25 15:29:21'),
	(2,1,1,'2022-02-25 15:41:16','2022-02-25 15:41:16'),
	(3,1,1,'2022-02-25 16:10:13','2022-02-25 16:10:13'),
	(4,1,1,'2022-02-25 16:10:16','2022-02-25 16:10:16'),
	(5,1,1,'2022-02-25 16:10:26','2022-02-25 16:10:26'),
	(6,1,1,'2022-02-25 16:17:35','2022-02-25 16:17:35'),
	(7,1,1,'2022-02-25 16:19:16','2022-02-25 16:19:16'),
	(8,1,1,'2022-02-25 16:21:24','2022-02-25 16:21:24'),
	(9,1,1,'2022-02-25 16:24:20','2022-02-25 16:24:20'),
	(10,1,1,'2022-02-25 16:24:49','2022-02-25 16:24:49'),
	(11,1,1,'2022-02-25 16:26:39','2022-02-25 16:26:39'),
	(12,1,1,'2022-02-25 16:27:14','2022-02-25 16:27:14'),
	(13,1,1,'2022-02-25 16:27:20','2022-02-25 16:27:20'),
	(14,1,1,'2022-02-26 20:13:08','2022-02-26 20:13:08'),
	(15,1,1,'2022-02-26 20:43:53','2022-02-26 20:43:53'),
	(16,1,1,'2022-02-26 20:44:08','2022-02-26 20:44:08'),
	(17,1,1,'2022-03-01 12:30:52','2022-03-01 12:30:52'),
	(18,1,1,'2022-03-09 08:42:52','2022-03-09 08:42:52'),
	(19,1,1,'2022-03-09 08:42:52','2022-03-09 08:42:52'),
	(20,1,1,'2022-03-14 13:53:08','2022-03-14 13:53:08');



# Dump of table payrolls
# ------------------------------------------------------------

CREATE TABLE `payrolls` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_schedule_id` int unsigned NOT NULL,
  `benefit_id` int unsigned NOT NULL,
  `payment_date` date NOT NULL,
  `beneficiaries_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `stage_lookup_id` int unsigned NOT NULL DEFAULT '0',
  `cleared` tinyint(1) NOT NULL DEFAULT '0',
  `rejected` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `responsible_role` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `approved_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `payrolls` (`id`, `payment_schedule_id`, `benefit_id`, `payment_date`, `beneficiaries_id`, `status`, `stage_lookup_id`, `cleared`, `rejected`, `created_by`, `responsible_role`, `approved_by`, `created_at`, `updated_at`)
VALUES
	(1,7,7,'2022-02-25','[13]',1,31,0,0,1,'1',NULL,'2022-02-25 15:20:35','2022-02-25 16:19:15');



# Dump of table permission_role
# ------------------------------------------------------------

CREATE TABLE `permission_role` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `permission_role` (`permission_id`, `role_id`)
VALUES
	(1,2),
	(2,2),
	(3,2),
	(4,2),
	(5,2),
	(6,2),
	(7,2),
	(8,2),
	(9,2),
	(13,2),
	(14,2),
	(15,2),
	(16,2),
	(18,2),
	(19,2),
	(21,2),
	(22,2),
	(24,2),
	(25,2),
	(1,3),
	(3,3),
	(7,3),
	(9,3),
	(10,3),
	(11,3),
	(13,3),
	(17,3),
	(19,3),
	(20,4),
	(27,4),
	(20,6),
	(22,6),
	(27,6),
	(11,7),
	(12,8),
	(24,8),
	(25,8),
	(26,8),
	(27,8),
	(28,8);



# Dump of table permission_user
# ------------------------------------------------------------

CREATE TABLE `permission_user` (
  `permission_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `permission_user_permission_id_foreign` (`permission_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table permissions
# ------------------------------------------------------------

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`)
VALUES
	(1,'add-user','Add User','Only for Users who can new users','2021-11-20 14:35:05','2021-11-20 18:56:44'),
	(2,'delete-user','Delete User',NULL,'2021-11-20 18:49:07','2021-11-20 18:49:07'),
	(3,'delete_roles','Delete User Role',NULL,'2021-11-25 21:40:03','2021-11-25 21:40:05'),
	(4,'set-lookup-options','Set Lookup Options',NULL,'2021-11-25 21:21:27','2021-11-25 21:21:27'),
	(5,'start-application-approval-process','Start Application Approval Process','Start Application Approval Process','2021-12-01 01:26:54','2021-12-01 01:26:54'),
	(6,'forms-building-manipulations','Forms Building & Manipulations','Forms Building & Manipulations','2021-12-01 01:27:58','2021-12-01 01:27:58'),
	(7,'add-edit-benefit','Add and Edit Benefit',NULL,'2022-01-31 08:47:18','2022-01-31 08:47:54'),
	(8,'archive-restore-delete-benefit','Archive and Restore and Delete Benefit',NULL,'2022-01-31 09:01:01','2022-01-31 09:01:01'),
	(9,'add-applicant','Add Applicant',NULL,'2022-01-31 09:01:21','2022-01-31 09:01:21'),
	(10,'view-applicant','View Applicant',NULL,'2022-01-31 09:01:31','2022-01-31 09:01:31'),
	(11,'edit-beneficiary','Edit Beneficiary',NULL,'2022-01-31 09:02:08','2022-01-31 09:02:08'),
	(12,'view-beneficiaries','View Beneficiaries',NULL,'2022-01-31 09:02:29','2022-01-31 09:02:29'),
	(13,'archive-restore-delete-beneficiaries','View Beneficiaries',NULL,'2022-01-31 09:02:46','2022-01-31 09:02:46'),
	(14,'perform-debt-recovery','Perform Debt Recovery',NULL,'2022-01-31 09:03:09','2022-01-31 09:03:09'),
	(15,'beneficiary-form-setup','Beneficiary Form Setup',NULL,'2022-01-31 09:03:19','2022-01-31 09:03:19'),
	(16,'record-payment','Record Payment After Payroll Approval',NULL,'2022-01-31 09:04:01','2022-01-31 09:04:01'),
	(17,'add-edit-project','Add and Edit Projects',NULL,'2022-01-31 09:04:30','2022-01-31 09:04:30'),
	(18,'archive-restore-delete-projects','Archive and Restore and Delete Projects',NULL,'2022-01-31 09:04:50','2022-01-31 09:04:50'),
	(19,'add-edit-complaint','Add and Edit Complaints',NULL,'2022-01-31 09:05:20','2022-01-31 09:05:20'),
	(20,'view-complaint','View Complaints',NULL,'2022-01-31 09:05:40','2022-01-31 09:26:59'),
	(21,'add-edit-case','Add and Edit Cases',NULL,'2022-01-31 09:05:57','2022-01-31 09:25:54'),
	(22,'view-case','View Cases',NULL,'2022-01-31 09:06:15','2022-01-31 09:06:15'),
	(23,'archive-restore-delete-cases','Archive and Restore and Delete Cases',NULL,'2022-01-31 09:06:33','2022-01-31 09:06:33'),
	(24,'generate-report','Generate Report',NULL,'2022-01-31 09:07:15','2022-01-31 09:07:15'),
	(25,'payroll-summary-report','Payroll Summary Report',NULL,'2022-01-31 09:07:28','2022-01-31 09:07:28'),
	(26,'add-and-edit-survey','Add and Edit Survey',NULL,'2022-01-31 09:17:57','2022-01-31 09:17:57'),
	(27,'view-survey','View Survey',NULL,'2022-01-31 09:18:41','2022-01-31 09:18:41'),
	(28,'payroll-process','Payroll Process',NULL,'2022-01-31 09:34:19','2022-01-31 09:34:19'),
	(29,'application-verification','Application Verification','Is involved in the Application verification process','2022-02-09 11:36:15','2022-02-09 11:36:15'),
	(30,'approval-process-setup','Approval process setup',NULL,'2022-02-09 12:14:21','2022-02-09 12:14:21');



# Dump of table program_user
# ------------------------------------------------------------

CREATE TABLE `program_user` (
  `program_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `program_user` (`program_id`, `user_id`, `created_at`, `updated_at`)
VALUES
	(2,21,NULL,NULL),
	(2,1,NULL,NULL),
	(2,2,NULL,NULL);



# Dump of table programs
# ------------------------------------------------------------

CREATE TABLE `programs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `document` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) DEFAULT '1',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `programs` (`id`, `name`, `description`, `document`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES
	(2,'National Youth Protection Scheme','Social Welfare Information Management System (SWIMS) refers to a web-based [1] system developed by the Government of Ghana to document and report on the provision of social welfare services (child protection, social protection, and gender-based violence) based on standard national data collection forms, workflows, referral pathways and standard operating procedures (SOPs).','app-uploads/programs/nohv38VMQab25g2KDwHNF4vIhxNk7jXnVx25Oto6.pdf',1,1,1,'2023-03-31 00:12:54','2023-04-11 15:21:46');



# Dump of table project_timelines
# ------------------------------------------------------------

CREATE TABLE `project_timelines` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `activity_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_dates` datetime DEFAULT NULL,
  `end_dates` datetime DEFAULT NULL,
  `statuses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `delayed_reasons` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table projects
# ------------------------------------------------------------

CREATE TABLE `projects` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `project_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_owners` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_costs` double DEFAULT NULL,
  `times` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recipient_beneficiaries` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `archived` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `islands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table questionnaires
# ------------------------------------------------------------

CREATE TABLE `questionnaires` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int unsigned NOT NULL,
  `benefit_id` int unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table record_trackers
# ------------------------------------------------------------

CREATE TABLE `record_trackers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `applicant_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_values` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `new_values` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `event` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `record_id` bigint unsigned DEFAULT NULL,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `evidences` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `request_by` bigint unsigned NOT NULL,
  `approved` tinyint DEFAULT '0',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'New',
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `record_trackers` (`id`, `applicant_number`, `old_values`, `new_values`, `event`, `table_name`, `field`, `record_id`, `reason`, `evidences`, `request_by`, `approved`, `status`, `comment`, `created_at`, `updated_at`)
VALUES
	(1,'AITU-19930214-1-001','{\"type\":\"Brother\",\"surname\":\"Sowa\",\"first_name\":\"Enoch\",\"other_name\":\"Adotey\",\"date_of_birth\":\"2022-07-01\",\"id_type\":\"Birth Certificate\",\"dependent_reference_id\":\"GHA9093883-23\",\"is_dependent\":\"Yes\"}','{\"type\":\"Son\",\"surname\":\"Sowa\",\"first_name\":\"Enoch\",\"other_name\":\"Adotey\",\"date_of_birth\":\"2022-07-01\",\"id_type\":\"Birth Certificate\",\"dependent_reference_id\":\"GHA9093883-23\",\"is_dependant\":\"Yes\"}','Updated','family','Family',3,'Nothing',NULL,1,0,'New',NULL,'2022-11-23 11:42:18','2022-11-23 18:40:24'),
	(2,'AITU-19930214-1-001','\"Female\"','\"Male\"','Update','applicants','genders',14,'Gender change',NULL,1,0,'In Progress','Working on it','2022-11-23 11:48:00','2022-11-23 12:08:24'),
	(3,'AITU-19930214-1-001','\"Mangaia\"','\"Mauke\"','Update','applicants','place_of_births',14,'Changed 3',NULL,1,0,'New',NULL,'2022-11-23 12:31:45','2022-11-23 12:32:19'),
	(4,'AITU-19930214-1-001','\"Cook Islands\"','\"Croatia\"','Update','applicants','country_of_births',14,'Change 6',NULL,1,0,'Verified','Accurate','2022-11-23 12:35:41','2022-11-26 12:33:05'),
	(5,'AITU-19930214-1-001','{\"type\":\"Father\",\"surname\":\"Gatey\",\"first_name\":\"Billy\",\"other_name\":\"Junior\",\"date_of_birth\":\"1971-02-17\",\"id_type\":\"National Id\",\"dependent_reference_id\":\"GP-909090\",\"is_dependent\":\"No\"}','{\"type\":\"Father\",\"surname\":\"Gatey\",\"first_name\":\"Billy\",\"other_name\":\"Junior\",\"date_of_birth\":\"1971-02-17\",\"id_type\":\"National Id\",\"dependent_reference_id\":\"GP-909090\",\"is_dependant\":\"No\"}','Deletion','family','Family',5,'Done',NULL,1,0,'Verified','Accurate','2022-11-23 18:32:23','2022-11-24 12:35:33'),
	(6,'AITU-19930214-1-001',NULL,'{\"type\":\"108\",\"island\":\"Aitutaki\",\"village\":\"Limpo\",\"postal_address\":\"12 Nii Ashaiboi Street.\"}','Addition','contact_details','Contact Detail',23,NULL,NULL,1,0,'New',NULL,'2022-11-24 12:38:20','2022-11-24 12:38:20'),
	(7,'AITU-19930214-1-001',NULL,'{\"type\":\"109\",\"mobile\":\"0244237891\",\"telephone\":\"0244237891\"}','Addition','contact_details','Contact Detail',24,NULL,NULL,1,0,'New',NULL,'2022-11-24 14:33:41','2022-11-24 14:33:42'),
	(8,'AITU-19930214-1-001','{\"type_name\":\"Mobile Number\",\"type\":109,\"mobile\":\"0501375124\",\"telephone\":\"0303339232\",\"email\":\"smith123@gmail.com\",\"postal_address\":\"P. O. Box RET Livingston\",\"upload_residency\":null,\"address\":\"Old Kent Road\",\"village\":\"Liansude\",\"island\":null,\"verified\":1,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',16,'Not in use',NULL,1,0,'Verified','Accurate','2022-11-24 16:25:36','2022-11-24 16:26:11'),
	(9,'AITU-19930214-1-001',NULL,'{\"type\":\"109\",\"mobile\":\"0244237891\"}','Addition','contact_details','Contact Detail',25,NULL,NULL,1,0,'New',NULL,'2022-11-25 08:25:49','2022-11-25 08:25:49'),
	(10,'AITU-19930214-1-001',NULL,'{\"type\":\"109\",\"mobile\":\"0501375124\"}','Addition','contact_details','Contact Detail',1,NULL,NULL,1,0,'New',NULL,'2022-11-25 09:30:11','2022-11-25 09:30:12'),
	(11,'AITU-19930214-1-001',NULL,'{\"type\":\"110\",\"email\":\"asowa45@gmail.com\"}','Addition','contact_details','Contact Detail',2,NULL,NULL,1,0,'New',NULL,'2022-11-25 10:11:26','2022-11-25 10:11:26'),
	(12,'AITU-19930214-1-001','{\"type_name\":\"Email\",\"type\":110,\"mobile\":null,\"telephone\":\"\",\"email\":\"hos@mail.com\",\"code\":\"PPUO\",\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',3,'dfd',NULL,1,0,'Verified','Accurate','2022-11-25 10:49:32','2022-11-25 13:01:31'),
	(13,'AITU-19930214-1-001','{\"type_name\":\"Mobile Number\",\"type\":109,\"mobile\":\"0244237891\",\"telephone\":\"\",\"email\":\"\",\"code\":\"TCU2\",\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',4,'de',NULL,1,0,'Verified','Accurate','2022-11-25 10:49:54','2022-11-25 13:02:23'),
	(14,'AITU-19930214-1-001','{\"type_name\":\"Mobile Number\",\"type\":109,\"mobile\":\"0501375122\",\"telephone\":\"\",\"email\":\"\",\"code\":\"HQOJ\",\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',5,'Not accurate',NULL,1,0,'New',NULL,'2022-11-25 11:12:39','2022-11-25 12:53:07'),
	(18,'AITU-19930214-1-001',NULL,'{\"type\":\"109\",\"mobile\":\"0557205684\"}','Addition','contact_details','Contact Detail',6,NULL,NULL,1,0,'Verified','Accurate','2022-11-25 14:48:29','2022-11-25 14:55:02'),
	(19,'AITU-19930214-1-001','{\"type_name\":\"Mobile Number\",\"type\":109,\"mobile\":\"0501375124\",\"telephone\":\"\",\"email\":\"\",\"code\":null,\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',1,'Quick',NULL,1,0,'Verified','Accurate','2022-11-25 14:55:39','2022-11-25 14:55:57'),
	(20,'AITU-19930214-1-001',NULL,'{\"type\":\"109\",\"mobile\":\"0501375124\"}','Addition','contact_details','Contact Detail',7,NULL,NULL,1,0,'New',NULL,'2022-11-25 15:26:45','2022-11-25 15:26:46'),
	(21,'AITU-19930214-1-001','{\"type_name\":\"Mobile Number\",\"type\":109,\"mobile\":\"0501375124\",\"telephone\":\"\",\"email\":\"\",\"code\":null,\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',7,'Done',NULL,1,0,'New',NULL,'2022-11-25 15:28:51','2022-11-25 15:28:51'),
	(22,'ATIU-19900130-1-001','\"\"','\"Cook Islands\"','Update','applicants','country_of_births',1,'New',NULL,1,0,'Verified','Accurate','2022-11-26 12:00:22','2022-11-26 12:35:18'),
	(23,'ATIU-19900130-1-001','\"app-uploads\\/applicant\\/profile\\/phZoE2kOqWdARkmSg2JVEYwcTJHYmcBdkjINBKEI.jpg\"','\"app-uploads\\/applicant\\/profile\\/ySC8E5XVaz8YDD0ycOl6C2CpEc7sFRA4YESo7GmO.jpg\"','Update','applicants','upload_passport_pic',1,'New',NULL,1,0,'Verified','Done','2022-11-26 12:00:22','2022-11-26 12:38:35'),
	(24,'MANG-19900601-2-001','\"app-uploads\\/applicant\\/profile\\/iKZ2crQaxsLIZlZbahqN84omgxi86ZvBlHF9OS8I.jpg\"','\"app-uploads\\/applicant\\/profile\\/ofTlmEnSNPQ8fn9iiI64MKB8nCMYwbKguUKRfKvx.jpg\"','Update','applicants','upload_passport_pic',17,'Perfect',NULL,2,0,'Verified','All data provided are accurate','2022-12-01 12:33:37','2022-12-01 12:50:21'),
	(25,'MANG-19900601-2-001','\"app-uploads\\/applicant\\/profile\\/iKZ2crQaxsLIZlZbahqN84omgxi86ZvBlHF9OS8I.jpg\"','\"app-uploads\\/applicant\\/profile\\/ofTlmEnSNPQ8fn9iiI64MKB8nCMYwbKguUKRfKvx.jpg\"','Update','applicants','avatar',17,'Perfect',NULL,2,0,'New',NULL,'2022-12-01 12:33:37','2022-12-01 12:50:02'),
	(26,'MANG-19900601-2-001','{\"type\":\"Son\",\"surname\":\"Jones\",\"first_name\":\"Greg\",\"other_name\":\"Junior\",\"date_of_birth\":\"2019-06-13\",\"id_type\":\"Birth Certificate\",\"dependent_reference_id\":\"12234389-09\",\"is_dependent\":\"Yes\"}','{\"type\":\"Son\",\"surname\":\"Jones\",\"first_name\":\"Greg\",\"other_name\":\"Junior\",\"date_of_birth\":\"2019-06-13\",\"id_type\":\"Birth Certificate\",\"dependent_reference_id\":\"12234389-34\",\"is_dependant\":\"Yes\"}','Updated','family','Family',6,'34343',NULL,2,0,'Verified','Done','2022-12-01 12:58:00','2022-12-01 13:33:23'),
	(27,'MANG-19900601-2-001',NULL,'{\"type\":\"109\",\"mobile\":\"0501375124\"}','Addition','contact_details','Contact Detail',8,NULL,NULL,2,0,'New',NULL,'2022-12-01 14:18:49','2022-12-01 14:18:51'),
	(28,'MANG-19900601-2-001',NULL,'{\"id_types\":\"Passport\",\"id_number\":\"45454665\",\"expiry\":\"07\\/14\\/2023\",\"document\":\"public\\/applicants\\/17\\/identifications\\/passport.jpeg\"}','Addition','identification_details','Identification Detail',25,NULL,NULL,2,0,'Verified','Accurate','2022-12-01 14:20:08','2022-12-01 14:21:31'),
	(29,'MANG-19900601-2-001',NULL,'{\"bank_name\":\"Access Bank (Ghana) Plc\",\"account_type\":\"Current\",\"account_holder_name\":\"Candace Owens\",\"account_number\":\"020090903323\",\"branch\":\"Dansoman Branch\"}','Addition','account_details','Account Detail',15,NULL,NULL,2,0,'Verified','All data provided are accurate','2022-12-01 14:24:32','2022-12-01 14:25:04'),
	(30,'MANG-19930616-1-007','\"Cook Island\"','\"Cook Islanders\"','Update','applicants','nationalities',10,'Quick',NULL,1,0,'Verified','Accurate','2022-12-05 16:14:28','2022-12-20 13:02:24'),
	(31,'MANG-19930616-1-007','\"\"','\"Cook Islands\"','Update','applicants','country_of_births',10,'Quick',NULL,1,0,'Verified','Accurate','2022-12-05 16:14:28','2022-12-20 13:02:32'),
	(32,'MANG-19930616-1-007','\"\"','\"app-uploads\\/applicant\\/profile\\/m2Lq1QdlprZKmknDyqVA0rYky4QzlD6NSN9SbYJ4.jpg\"','Update','applicants','upload_passport_pic',10,'Update',NULL,1,0,'Verified','Perfect','2022-12-05 16:14:28','2022-12-05 16:15:11'),
	(33,'MANG-19930616-1-007','\"\"','\"app-uploads\\/applicant\\/profile\\/m2Lq1QdlprZKmknDyqVA0rYky4QzlD6NSN9SbYJ4.jpg\"','Update','applicants','avatar',10,'Update',NULL,1,0,'New',NULL,'2022-12-05 16:14:28','2022-12-05 16:14:28'),
	(34,'MANG-19930616-1-007',NULL,'{\"type\":\"109\",\"mobile\":\"0501375124\"}','Addition','contact_details','Contact Detail',9,NULL,NULL,1,0,'New',NULL,'2022-12-06 14:42:13','2022-12-06 14:42:14'),
	(35,'MANG-19930616-1-007',NULL,'{\"type\":\"107\",\"island\":\"Atiu\",\"village\":\"Asokwa\",\"address\":\"Manna Valley\",\"postal_address\":null,\"upload_residency\":\"public\\/applicants\\/10\\/proof-residence\\/birth-cert.jpeg\"}','Addition','contact_details','Contact Detail',11,NULL,NULL,1,0,'New',NULL,'2022-12-06 15:08:17','2022-12-06 15:08:17'),
	(36,'MANG-19930616-1-007',NULL,'{\"type\":\"Daughter\",\"surname\":\"Sowa\",\"first_name\":\"Joyce\",\"other_name\":\"Naa\",\"date_of_birth\":\"09\\/09\\/2022\",\"id_type\":\"Birth Certificate\",\"dependent_reference_id\":\"12234389-10\",\"is_dependant\":\"Yes\"}','Addition','family','Family',7,NULL,NULL,1,0,'Verified','Perfect','2022-12-06 15:44:35','2022-12-06 15:45:18'),
	(37,'MANG-19930616-1-007',NULL,'{\"bank_name\":\"Ecobank Ghana Plc\",\"account_type\":\"Current\",\"account_holder_name\":\"Candace Owens\",\"account_number\":\"020090903323\",\"branch\":null}','Addition','account_details','Account Detail',16,NULL,NULL,1,0,'Verified','Perfect','2022-12-07 12:44:19','2022-12-07 12:45:30'),
	(38,'MANG-19930616-1-007',NULL,'{\"id_types\":\"Passport\",\"id_number\":\"45454665\",\"expiry\":\"12\\/30\\/2022\"}','Addition','identification_details','Identification Detail',26,NULL,NULL,1,0,'New',NULL,'2022-12-21 16:37:27','2022-12-21 16:37:27'),
	(39,'ATIU-19900131-1-001','\"Alfred\"','\"Alfreda\"','Update','applicants','first_names',3,'Try',NULL,1,0,'New',NULL,'2023-01-27 10:47:11','2023-01-27 10:47:11'),
	(40,'ATIU-19900131-1-001','\"Cook Island\"','\"Afghan\"','Update','applicants','nationalities',3,'Try',NULL,1,0,'New',NULL,'2023-01-27 10:47:11','2023-01-27 10:47:11'),
	(41,'ATIU-19900131-1-001','\"\"','\"Afghanistan\"','Update','applicants','country_of_births',3,'Try',NULL,1,0,'New',NULL,'2023-01-27 10:47:11','2023-01-27 10:47:11'),
	(42,'MANG-19900601-2-001',NULL,'{\"account_type\":\"117\",\"bank_name\":\"MTN Ghana\",\"account_number\":\"0557205684\",\"account_holder_name\":\"Alfred Sowa\",\"branch\":\"Deluxe Money Tranfer Limited\"}','Addition','account_details','Account Detail',17,NULL,NULL,1,0,'New',NULL,'2023-03-20 12:39:45','2023-03-20 12:39:45'),
	(43,NULL,NULL,'{\"type\":\"137\",\"household_number\":\"AA000005\",\"is_household_head\":\"1\"}','Addition','contact_details','Contact Detail',0,NULL,NULL,1,0,'New',NULL,'2023-03-28 16:26:17','2023-03-28 16:26:17'),
	(44,'ALB-20100325-2-001','{\"type_name\":\"Household\",\"type\":137,\"mobile\":null,\"telephone\":\"\",\"email\":\"\",\"code\":null,\"household_number\":\"AA000005\",\"is_household_head\":1,\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',12,'transfer',NULL,1,0,'Verified','Done','2023-03-28 16:27:16','2023-03-28 16:58:42'),
	(45,'ALB-20100325-2-001',NULL,'{\"type\":\"137\",\"household_number\":\"AA000005\",\"is_household_head\":\"0\"}','Addition','contact_details','Contact Detail',13,NULL,NULL,1,0,'Verified','Done','2023-03-28 17:05:54','2023-03-28 17:40:01'),
	(46,'ALB-20100325-2-001','{\"type_name\":\"Household\",\"type\":137,\"mobile\":null,\"telephone\":\"\",\"email\":\"\",\"code\":null,\"household_number\":\"AA000005\",\"is_household_head\":0,\"postal_address\":null,\"upload_residency\":null,\"address\":null,\"village\":null,\"island\":null,\"verified\":0,\"verified_by\":null,\"verified_at\":null}','[]','Deletion','contact_details','Contact Detail',13,'Done',NULL,1,0,'Verified','Done','2023-03-28 17:41:55','2023-03-28 17:42:14'),
	(47,'ALB-20100325-2-001',NULL,'{\"type\":\"137\",\"household_number\":\"AA000005\",\"is_household_head\":\"1\"}','Addition','contact_details','Contact Detail',14,NULL,NULL,1,0,'Verified','Done','2023-03-28 17:42:38','2023-03-28 17:55:22');



# Dump of table region_survey
# ------------------------------------------------------------

CREATE TABLE `region_survey` (
  `region_id` bigint unsigned NOT NULL,
  `survey_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `region_survey` (`region_id`, `survey_id`, `created_at`, `updated_at`)
VALUES
	(22,1,NULL,NULL),
	(114,1,NULL,NULL);



# Dump of table role_user
# ------------------------------------------------------------

CREATE TABLE `role_user` (
  `role_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`)
VALUES
	(2,1,'App\\Models\\User'),
	(2,2,'App\\Models\\User'),
	(2,20,'App\\Models\\User'),
	(2,25,'App\\Models\\User'),
	(3,26,'App\\Models\\User'),
	(7,21,'App\\Models\\User'),
	(7,22,'App\\Models\\User'),
	(7,23,'App\\Models\\User'),
	(7,24,'App\\Models\\User'),
	(7,27,'App\\Models\\User'),
	(7,28,'App\\Models\\User'),
	(7,29,'App\\Models\\User');



# Dump of table roles
# ------------------------------------------------------------

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead` bigint DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `roles` (`id`, `name`, `code`, `display_name`, `lead`, `description`, `status`, `created_at`, `updated_at`)
VALUES
	(2,'administrator','ADM','Administrator',NULL,'All Permissions',1,'2021-11-20 19:30:02','2022-09-25 16:45:34'),
	(3,'hod','HOD','Head of Department',2,NULL,1,'2021-11-21 21:37:44','2022-10-08 08:14:07'),
	(4,'tester','TST','Tester',NULL,NULL,1,'2021-12-02 16:34:39','2022-09-25 16:46:25'),
	(6,'guest','GST','Guest',2,NULL,1,'2022-10-08 06:47:59','2022-10-08 06:47:59'),
	(7,'beneficiary','BEF','Beneficiary',3,NULL,1,'2022-12-12 12:54:09','2022-12-12 12:54:41'),
	(8,'financial-advisor','FAD','Financial Advisor',2,NULL,1,'2023-01-26 22:31:31','2023-01-26 22:31:31');



# Dump of table sessions
# ------------------------------------------------------------

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`)
VALUES
	('KOQoimtOa88Gh8GYHqHR7lE56NC24vWwnNVIYsed',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.54 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMXFVWTJaR3VKQ0t4S0JlWTd3MjdwdHJpVFZmcVRGNkhuQmE4d1FDNSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2Rhc2hib2FyZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI3OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1637706819);



# Dump of table settings
# ------------------------------------------------------------

CREATE TABLE `settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `val` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `settings` (`id`, `name`, `val`, `created_at`, `updated_at`, `group`)
VALUES
	(1,'app_name',NULL,'2021-12-12 12:20:46','2022-11-14 12:02:05','default'),
	(2,'from_email','admin@bewsys.com','2021-12-12 12:20:46','2021-12-12 12:20:46','default'),
	(3,'from_name','Bewsys Limited','2021-12-12 12:20:46','2021-12-12 12:20:46','default'),
	(4,'app_project_name','Alleviate','2022-11-14 12:02:05','2022-11-14 12:02:05','default'),
	(7,'logo',NULL,'2021-12-12 13:37:16','2022-09-02 08:32:34','default'),
	(8,'footer_details','Copyright © 2022 <a href=\'\'>Bewsys Management System</a> All rights reserved.','2021-12-12 15:58:46','2022-09-22 09:10:18','default'),
	(9,'password_expiry_days','90','2022-01-10 08:05:48','2022-01-10 08:05:51','default'),
	(10,'app_email','info@alleviate.org','2022-11-14 12:02:05','2022-11-14 12:02:05','default'),
	(11,'app_owner','Bewsys','2022-11-14 12:02:05','2022-11-14 12:02:05','default'),
	(12,'app_contact','(590) 909-0554','2022-11-14 12:02:05','2022-12-06 11:41:42','default'),
	(13,'app_main_currency','82','2022-11-14 12:02:05','2023-02-07 11:55:27','default'),
	(14,'app_country','77','2022-11-14 12:02:05','2022-12-06 11:26:38','default'),
	(15,'app_description','Hello','2022-11-14 12:02:05','2022-11-15 08:35:56','default'),
	(16,'app_linkedIn_url',NULL,'2022-11-14 12:02:05','2022-11-15 11:20:41','default'),
	(17,'app_twitter_url',NULL,'2022-11-14 12:02:05','2022-11-15 11:20:41','default'),
	(18,'app_facebook_url',NULL,'2022-11-14 12:02:05','2022-11-15 11:20:41','default'),
	(19,'app_copyright','@2022 Alleviate SP by <a href=\"https://bewsys.com\" target=\"_blank\"> Bewsys</a>','2022-11-14 12:02:05','2022-11-15 10:56:48','default'),
	(20,'app_deployment_date','11/01/2022','2022-11-14 12:02:05','2022-11-14 12:16:54','default'),
	(21,'app_logo',NULL,'2022-11-14 12:02:05','2022-12-05 13:16:39','default'),
	(23,'app_address','12 Nii Amon Kotey Street. East Legon','2022-11-14 12:16:42','2022-11-15 08:35:56','default'),
	(24,'app_whatsApp_url',NULL,'2022-11-15 06:21:06','2022-11-15 11:20:41','default'),
	(25,'app_main_currency_symbol','GHS','2022-11-15 09:55:58','2023-02-07 11:55:27','default'),
	(26,'app_main_currency_code','GHS','2022-11-15 09:55:58','2023-02-07 11:55:27','default'),
	(27,'applicant_title','Beneficiary','2022-11-25 12:09:05','2022-11-25 12:09:05','default'),
	(28,'applicant_description','Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ab aliquam delectus, eligendi et illo nesciunt possimus. Consequatur cupiditate deserunt eius eum, laudantium, minima, odio officiis pariatur totam veritatis vero voluptatem.','2022-11-25 12:09:06','2022-11-25 12:09:06','default'),
	(29,'app_call_code','44','2022-12-06 11:25:28','2022-12-06 11:26:38','default'),
	(30,'app_country_name','United Kingdom','2022-12-06 11:25:28','2022-12-06 11:26:38','default');



# Dump of table stage_emails
# ------------------------------------------------------------

CREATE TABLE `stage_emails` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email_template_id` int unsigned NOT NULL,
  `lookup_id` int unsigned NOT NULL,
  `order` int DEFAULT NULL,
  `roles` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stage_emails_email_template_id_foreign` (`email_template_id`),
  KEY `stage_emails_lookup_id_foreign` (`lookup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `stage_emails` (`id`, `email_template_id`, `lookup_id`, `order`, `roles`, `active`, `created_at`, `updated_at`)
VALUES
	(1,1,3,1,'1',1,'2021-12-10 14:11:05','2021-12-10 14:11:05'),
	(2,2,12,1,'1,5',1,'2021-12-21 09:26:08','2022-01-19 09:02:04'),
	(3,3,13,4,'1,5',1,'2021-12-21 09:26:25','2021-12-21 10:14:58'),
	(4,4,14,2,'1',1,'2021-12-21 09:26:39','2021-12-21 09:26:39'),
	(5,5,15,6,'1',1,'2021-12-21 14:25:23','2022-02-23 09:25:21'),
	(6,6,31,1,'1',1,'2022-01-18 18:45:37','2022-01-18 18:45:37'),
	(7,7,32,2,'1,5',1,'2022-01-19 12:29:28','2022-01-27 19:25:19'),
	(8,8,33,3,'1,5',1,'2022-01-19 12:33:11','2022-01-27 19:25:31'),
	(9,9,34,4,'1,5',1,'2022-01-19 12:33:44','2022-01-27 19:25:43'),
	(10,10,16,5,'1',1,'2022-01-27 00:31:10','2022-01-27 00:33:07'),
	(11,4,35,3,'1,3,5',1,'2022-02-23 09:26:35','2022-02-23 09:26:35');



# Dump of table statuses
# ------------------------------------------------------------

CREATE TABLE `statuses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(50) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `statuses` (`id`, `status`, `created_at`, `updated_at`)
VALUES
	(1,'Pending','2021-12-03 15:04:00','2021-12-03 15:04:03'),
	(2,'Approved','2021-12-03 15:04:22','2021-12-03 15:04:24'),
	(3,'On-Hold','2021-12-03 15:04:37','2021-12-03 15:04:39'),
	(4,'Rejected','2021-12-03 15:05:03','2021-12-03 15:05:05'),
	(5,'Active','2022-02-01 10:20:35','2022-02-01 10:20:38'),
	(6,'Inactive','2022-02-01 10:20:51','2022-02-01 10:20:53');



# Dump of table surveys
# ------------------------------------------------------------

CREATE TABLE `surveys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` bigint NOT NULL,
  `purpose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `program_id` bigint NOT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `status` bigint NOT NULL DEFAULT '155',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `surveys` (`id`, `title`, `type`, `purpose`, `program_id`, `duration`, `start_date`, `end_date`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES
	(1,'National Census Collations',149,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam sit amet pretium mauris. Nulla aliquet nisl ornare ante cursus iaculis. Nunc ornare facilisis nisi, sed euismod mauris iaculis ac. Phasellus bibendum sapien nec posuere ultricies. Duis varius eleifend dui, a tempus ex tincidunt ut. Donec at leo ac elit vulputate tincidunt. Sed in commodo sem, non rhoncus metus. Etiam justo metus, ornare at iaculis non, tempus a ante.',2,'03/29/2023 - 04/27/2023','2023-03-29','2023-04-27',155,1,1,'2023-04-14 14:46:49','2023-04-14 16:33:07');



# Dump of table team_invitations
# ------------------------------------------------------------

CREATE TABLE `team_invitations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `team_id` bigint unsigned NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_invitations_team_id_email_unique` (`team_id`,`email`),
  CONSTRAINT `team_invitations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table team_management_members
# ------------------------------------------------------------

CREATE TABLE `team_management_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_birth` date NOT NULL,
  `gender` bigint unsigned NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `education_level` bigint unsigned NOT NULL,
  `education_institution` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_experience` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `training_skills` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `references` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `languages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `criminal_background` tinyint(1) DEFAULT '0',
  `criminal_background_file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `avatar_url` text COLLATE utf8mb4_unicode_ci,
  `availability` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) DEFAULT '1',
  `last_seen` timestamp NULL DEFAULT NULL,
  `verification_date` timestamp NULL DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `team_management_members` (`id`, `name`, `date_of_birth`, `gender`, `email`, `phone`, `address`, `education_level`, `education_institution`, `work_experience`, `training_skills`, `references`, `languages`, `criminal_background`, `criminal_background_file`, `avatar_url`, `availability`, `status`, `last_seen`, `verification_date`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'Serwaa Dontoh','2013-04-05',2,'deqanaceje@mailinator.com','+1 (405) 918-1801','Doloribus impedit v',169,'Lester Dillon','Sit dolor mollit ut','Doloremque aut et pr',NULL,'[\"14\",\"15\"]',0,'app-uploads/team-members/documents/OcUzwv8Re0gQRYKgp40whihi0ktVhdfi7gSXemVE.pdf','app-uploads/team-members/YEYHx26bFn8ureXVg3eC8tOeeQMlAYanbaOx7fyb.jpg',1,1,NULL,NULL,1,1,'2023-04-17 17:07:24','2023-04-17 17:26:23',NULL);



# Dump of table team_members
# ------------------------------------------------------------

CREATE TABLE `team_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `team_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `role` bigint unsigned NOT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `team_members` (`id`, `team_id`, `user_id`, `role`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,2,1,163,0,1,1,'2023-04-15 14:09:28','2023-04-15 15:07:24',NULL),
	(2,2,20,163,0,1,1,'2023-04-15 14:12:33','2023-04-17 11:04:53',NULL);



# Dump of table teams
# ------------------------------------------------------------

CREATE TABLE `teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `program_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `teams` (`id`, `code`, `program_id`, `name`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'7XL7F',2,'Northern Smart Group',0,1,1,'2023-04-15 11:11:32','2023-04-17 11:04:18',NULL),
	(2,'05DWA',2,' UNICEF Team One',1,1,NULL,'2023-04-15 12:07:02','2023-04-15 12:07:02',NULL);



# Dump of table user_profiles
# ------------------------------------------------------------

CREATE TABLE `user_profiles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `avatar_full_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_profiles_user_id_foreign` (`user_id`),
  CONSTRAINT `user_profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `user_profiles` (`id`, `company_name`, `contact`, `website`, `avatar_full_path`, `avatar`, `user_id`, `created_at`, `updated_at`)
VALUES
	(1,'Cook Island','0557205684','http://google.com','http://127.0.0.1:8001/storage/1/avatar/1637373740.jpg','1637373740.jpg',1,NULL,'2021-12-02 08:15:10'),
	(8,'Ministry of Internal Affairs',NULL,NULL,NULL,NULL,8,'2021-11-23 12:22:01','2021-12-02 16:32:33'),
	(14,NULL,NULL,NULL,NULL,NULL,14,'2021-12-07 19:58:30','2021-12-07 19:58:30'),
	(15,NULL,NULL,NULL,NULL,NULL,15,'2022-01-20 18:06:11','2022-01-20 18:06:11'),
	(16,NULL,NULL,NULL,NULL,NULL,16,'2022-01-30 13:47:02','2022-01-30 13:47:02'),
	(17,NULL,NULL,NULL,NULL,NULL,17,'2022-02-09 10:08:52','2022-02-09 10:08:52');



# Dump of table user_saved_reports
# ------------------------------------------------------------

CREATE TABLE `user_saved_reports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `tablename` varchar(50) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `querystring` text,
  `displayfields` json DEFAULT NULL,
  `data` text,
  `report_data` json DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `chart_type` varchar(50) DEFAULT NULL,
  `groupedby` varchar(50) DEFAULT NULL,
  `report_title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `user_saved_reports` (`id`, `user_id`, `tablename`, `title`, `querystring`, `displayfields`, `data`, `report_data`, `created_at`, `updated_at`, `chart_type`, `groupedby`, `report_title`)
VALUES
	(2,8,'Beneficiaries','List of Beneficiaries','select `Benefit_Title`, `first_names`, `surnames`, `dobs`, `Gender`, `Island` from `beneficiaries_list_view`','\"[\\\"Gender\\\"]\"',NULL,'{\"data\": \"Beneficiaries\", \"view\": \"raw\", \"value\": [null], \"filter\": [null], \"condition\": [\"<\"], \"groupedby\": null, \"reportfields\": [\"Benefit_Title\", \"first_names\", \"surnames\", \"dobs\", \"Gender\", \"Island\"]}','2022-01-18 11:31:52','2022-01-18 11:31:52',NULL,NULL,NULL),
	(3,8,'Beneficiaries','LIST OF BENEFICIARIES','select `surnames`, `first_names`, `date_of_birth`, `Gender`, `Island`, `Benefit_Title` from `beneficiaries_list_view`','\"[\\\"surnames\\\",\\\"first_names\\\",\\\"date_of_birth\\\",\\\"Gender\\\",\\\"Island\\\",\\\"Benefit_Title\\\"]\"',NULL,'{\"data\": \"Beneficiaries\", \"view\": \"raw\", \"value\": [null], \"filter\": [null], \"condition\": [\"<\"], \"groupedby\": null, \"report_title\": \"LIST OF BENEFICIARIES\", \"reportfields\": [\"surnames\", \"first_names\", \"date_of_birth\", \"Gender\", \"Island\", \"Benefit_Title\"]}','2022-01-19 09:48:03','2022-01-19 09:48:03',NULL,NULL,NULL),
	(11,8,'Beneficiaries','LIST OF BENEFICIARIES','select `Benefit_Title`, `first_names`, `surnames`, `date_of_birth`, `Island` from `beneficiaries_list_view`','\"[\\\"Benefit_Title\\\",\\\"first_names\\\",\\\"surnames\\\",\\\"date_of_birth\\\",\\\"Island\\\"]\"',NULL,'{\"data\": \"Beneficiaries\", \"view\": \"raw\", \"value\": [null], \"filter\": [null], \"condition\": [\"<\"], \"groupedby\": null, \"report_title\": \"LIST OF BENEFICIARIES\", \"reportfields\": [\"Benefit_Title\", \"first_names\", \"surnames\", \"date_of_birth\", \"Island\"]}','2022-01-20 19:02:59','2022-01-20 19:02:59',NULL,NULL,NULL);




