-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.16-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping data for table peoplei_300_people_dev.employee_trainings: ~1 rows (approximately)
DELETE FROM `employee_trainings`;
/*!40000 ALTER TABLE `employee_trainings` DISABLE KEYS */;
INSERT INTO `employee_trainings` (`id`, `emp_id`, `appraisal_id`, `client_id`, `status`, `created_at`, `updated_at`) VALUES
	(3, 56877, 1, 48, 1, NULL, NULL);
/*!40000 ALTER TABLE `employee_trainings` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.pm_individual_calculation: ~5 rows (approximately)
DELETE FROM `pm_individual_calculation`;
/*!40000 ALTER TABLE `pm_individual_calculation` DISABLE KEYS */;
INSERT INTO `pm_individual_calculation` (`id`, `pm_role_based_calculation_id`, `client_id`, `country_id`, `status`, `role_id`, `role_status`, `role_comments`, `role_date`, `emp_id`, `what's_average_rating`, `what's_weightage_rating`, `how's_weightage_rating`, `how's_average_rating`, `how's_total_rating`, `what's_total_rating`, `final_rating`, `group_id`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, NULL, 48, 154, 1, 2, 1, 'Good Work', '2022-01-19 17:58:09', 58443, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(2, NULL, 48, 154, 1, 2, 2, 'Need Improvement', '2022-01-19 17:58:09', 57523, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(3, NULL, 48, 154, 1, 3, 2, 'agreed', '2022-01-19 17:58:09', 55572, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(4, NULL, 48, 154, 1, 3, 2, 'agreed', '2022-01-19 17:58:09', 56193, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(5, NULL, 48, 154, 1, 1, 1, 'I did My Work', '2022-01-19 17:58:09', 56877, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `pm_individual_calculation` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.pm_key_accountability_areas: ~2 rows (approximately)
DELETE FROM `pm_key_accountability_areas`;
/*!40000 ALTER TABLE `pm_key_accountability_areas` DISABLE KEYS */;
INSERT INTO `pm_key_accountability_areas` (`id`, `kaa_title`, `weightage`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `client_id`) VALUES
	(260, 'KAA1', 50, '2022-01-19 18:20:28', '2022-01-19 18:20:29', '2022-01-19 18:20:29', NULL, NULL, NULL, 48),
	(261, 'KAA2', 50, '2022-01-19 18:20:55', '2022-01-19 18:20:55', '2022-01-19 18:20:55', NULL, NULL, NULL, 48);
/*!40000 ALTER TABLE `pm_key_accountability_areas` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.pm_key_perfomance_indicator: ~2 rows (approximately)
DELETE FROM `pm_key_perfomance_indicator`;
/*!40000 ALTER TABLE `pm_key_perfomance_indicator` DISABLE KEYS */;
INSERT INTO `pm_key_perfomance_indicator` (`id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `status`, `kpi_title`, `kaa_id`, `goal_id`, `client_id`) VALUES
	(212, '2022-01-19 18:21:24', '2022-01-19 18:21:24', '2022-01-19 18:21:25', NULL, NULL, NULL, 1, 'kpi1', 260, NULL, 48),
	(213, '2022-01-19 18:21:24', '2022-01-19 18:21:24', '2022-01-19 18:21:25', NULL, NULL, NULL, 1, 'kpi2', 260, NULL, 48);
/*!40000 ALTER TABLE `pm_key_perfomance_indicator` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.pm_rating: ~15 rows (approximately)
DELETE FROM `pm_rating`;
/*!40000 ALTER TABLE `pm_rating` DISABLE KEYS */;
INSERT INTO `pm_rating` (`id`, `rating_title`, `application_individual_claculation_id`, `competency_id`, `kpi_id`, `kaa_id`, `goal_id`, `rating_description`, `client_id`, `group_id`, `country_id`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '1', 1, NULL, NULL, 260, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(2, '1', 1, NULL, 212, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(3, '1', 1, NULL, 213, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(4, '2', 2, NULL, NULL, 260, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(5, '2', 2, NULL, 212, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(6, '2', 2, NULL, 213, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(7, '2', 3, NULL, NULL, 260, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(8, '2', 4, NULL, NULL, 260, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(9, '1', 5, NULL, NULL, 260, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(10, '2', 3, NULL, 212, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(11, '2', 4, NULL, 212, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(12, '1', 5, NULL, 212, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(13, '2', 3, NULL, 213, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(14, '2', 4, NULL, 213, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46'),
	(15, '1`', 5, NULL, 213, NULL, NULL, NULL, 48, NULL, 154, NULL, NULL, NULL, '2022-01-19 18:22:46', '2022-01-19 18:22:46', '2022-01-19 18:22:46');
/*!40000 ALTER TABLE `pm_rating` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.trainings: ~3 rows (approximately)
DELETE FROM `trainings`;
/*!40000 ALTER TABLE `trainings` DISABLE KEYS */;
INSERT INTO `trainings` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'CCNA', '1', '2022-02-01 12:08:15', '2022-02-01 12:08:15'),
	(2, 'CCNP', '1', '2022-02-01 12:08:17', '2022-02-01 12:08:17'),
	(3, 'Ielts', '1', '2022-02-01 12:08:18', '2022-02-01 12:08:19');
/*!40000 ALTER TABLE `trainings` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.training_categories: ~0 rows (approximately)
DELETE FROM `training_categories`;
/*!40000 ALTER TABLE `training_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `training_categories` ENABLE KEYS */;

-- Dumping data for table peoplei_300_people_dev.training_requests: ~8 rows (approximately)
DELETE FROM `training_requests`;
/*!40000 ALTER TABLE `training_requests` DISABLE KEYS */;
INSERT INTO `training_requests` (`id`, `appraisal_id`, `training_id`, `emp_id`, `role_id`, `rating_id`, `kaa_id`, `kpi_id`, `goal_id`, `emp_training_id`, `request_training`, `flag`, `client_id`, `created_at`, `updated_at`) VALUES
	(5, 1, 1, 56877, 1, NULL, 260, NULL, NULL, 3, NULL, 'kaa', 48, '2022-01-31 11:30:04', '2022-01-31 11:30:04'),
	(6, 1, 2, 56877, 1, NULL, NULL, 212, NULL, 3, NULL, 'kpi', 48, '2022-01-31 11:30:04', '2022-01-31 11:30:04'),
	(7, 1, 3, 56877, 1, NULL, NULL, 213, NULL, 3, NULL, 'kpi', 48, '2022-01-31 11:30:04', '2022-01-31 11:30:04'),
	(8, 1, NULL, 56877, 1, NULL, NULL, NULL, NULL, 3, 'communication skills', 'custom', 48, '2022-01-31 11:30:04', '2022-01-31 11:30:04'),
	(9, 1, 1, 58443, 2, NULL, 260, NULL, NULL, 3, NULL, 'kaa', 48, '2022-01-31 11:59:35', '2022-01-31 11:59:35'),
	(10, 1, 2, 58443, 2, NULL, NULL, 212, NULL, 3, NULL, 'kpi', 48, '2022-01-31 11:59:35', '2022-01-31 11:59:35'),
	(11, 1, 3, 58443, 2, NULL, NULL, 213, NULL, 3, NULL, 'kpi', 48, '2022-01-31 11:59:35', '2022-01-31 11:59:35'),
	(12, 1, NULL, 58443, 2, NULL, NULL, NULL, NULL, 3, 'communication skills', 'custom', 48, '2022-01-31 11:59:35', '2022-01-31 11:59:35');
/*!40000 ALTER TABLE `training_requests` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;