
-- STEP 1
CREATE TABLE `cb_payroll_process_promotion` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`payroll_process_id` INT(11) NULL DEFAULT NULL,
	`emp_id` INT(11) NULL DEFAULT NULL,
	`previous_salary` DECIMAL(20,6) NULL DEFAULT NULL,
	`current_salary` DECIMAL(20,6) NULL DEFAULT NULL,
	`salary_difference` DECIMAL(20,6) NULL DEFAULT NULL,
	`created_at` DATETIME NULL DEFAULT NULL,
	`deleted_at` DATETIME NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=21
;
 
-- STEP 2
INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (1, 2477, 16, 74457.000000, 97963.000000, 23506.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (2, 2485, 154, 39922.000000, 52023.000000, 12101.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (3, 2534, 557, 124109.000000, 170650.000000, 46541.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (4, 2553, 604, 300000.000000, 345000.000000, 45000.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (5, 2578, 650, 70000.000000, 100100.000000, 30100.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (6, 2583, 660, 49000.000000, 69640.000000, 20640.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (7, 2595, 692, 95000.000000, 125400.000000, 30400.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (8, 2597, 711, 29025.000000, 42455.000000, 13430.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (9, 2948, 482, 86400.000000, 145000.000000, 58600.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (10, 3373, 837, 45000.000000, 45000.000000, 0.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (11, 6224, 615, 60000.000000, 84810.000000, 24810.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (12, 6237, 646, 55000.000000, 79255.000000, 24255.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (13, 6247, 671, 55000.000000, 75000.000000, 20000.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (14, 6260, 779, 137714.000000, 158146.000000, 20432.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (15, 6305, 885, 25000.000000, 50000.000000, 25000.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (16, 6363, 862, 90000.000000, 90000.000000, 0.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (17, 7244, 573, 170000.000000, 221000.000000, 51000.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (18, 7310, 837, 45000.000000, 65000.000000, 20000.000000, NULL, NULL);INSERT INTO `cb_payroll_process_promotion` (`id`, `payroll_process_id`, `emp_id`, `previous_salary`, `current_salary`, `salary_difference`, `created_at`, `deleted_at`) VALUES (19, 7655, 553, 240012.000000, 240012.000000, 0.000000, NULL, NULL);