ALTER TABLE `kpis_questions` ADD `section` ENUM('Qualitative','KPIs','Added Value') NOT NULL DEFAULT 'KPIs' AFTER `kpi_id`;


ALTER TABLE `users_kpis_questions` ADD `kpi_question_section` ENUM('qualitative', 'kpis', 'added_value') NOT NULL DEFAULT 'kpis' AFTER `kpi_question_weight`, ADD `kpi_question_target` INT NOT NULL DEFAULT '0' AFTER `kpi_question_section`;



ALTER TABLE `users_kpis` ADD `strengths` TEXT NULL DEFAULT NULL AFTER `total_employee_score`, ADD `areas_to_be_developed` TEXT NULL DEFAULT NULL AFTER `strengths`;



INSERT INTO `permissions` (`id`, `group`, `name`, `guard_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES (NULL, 'Users kpis', 'users_kpis.show', 'web', '0', NULL, '2023-07-17 08:26:46', NULL);

INSERT INTO `permissions` (`id`, `group`, `name`, `guard_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES (NULL, 'Users kpis', 'users_kpis.report_show', 'web', '0', NULL, '2023-07-17 08:26:46', NULL);
INSERT INTO `permissions` (`id`, `group`, `name`, `guard_name`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES (NULL, 'Users kpis', 'users_kpis.total_report_show', 'web', '0', NULL, '2023-07-17 08:26:46', NULL);