-- STEP 1
DROP TABLE IF EXISTS `cb_payroll_process_promotion`;
CREATE TABLE IF NOT EXISTS `cb_payroll_process_promotion` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `payroll_process_id` INT NULL DEFAULT NULL,
    `emp_id` INT 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`)
);

-- STEP 2
INSERT INTO cb_payroll_process_promotion values (' ' ,2477 , 16 , 74457.00 , 97963.00 , 23506.00 ,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2485 , 154 , 39922.00 , 52023.00 , 12101.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2534 , 557 , 124109.00 , 170650.00 , 46541.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2553 , 604 , 300000.00 , 345000.00 , 45000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2578 , 650 , 70000.00 , 100100.00 , 30100.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2583 , 660 , 49000.00 , 69640.00 , 20640.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2595 , 692 , 95000.00 , 125400.00 , 30400.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2597 , 711 , 29025.00 , 42455.00 , 13430.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,2948 , 482 , 86400.00 , 145000.00 , 58600.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,3373 , 837 , 45000.00 , 45000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6224 , 615 , 60000.00 , 84810.00 , 24810.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6237 , 646 , 55000.00 , 79255.00 , 24255.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6247 , 671 , 55000.00 , 75000.00 , 20000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6260 , 779 , 137714.00 , 158146.00 , 20432.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6305 , 885 , 25000.00 , 50000.00 , 25000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,6363 , 862 , 90000.00 , 90000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7244 , 573 , 170000.00 , 221000.00 , 51000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7310 , 837 , 45000.00 , 65000.00 , 20000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7573 , 453 , 189924.00 , 189924.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7575 , 553 , 240012.00 , 240012.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7576 , 598 , 140000.00 , 140000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7577 , 607 , 175350.00 , 175350.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7578 , 648 , 140875.00 , 140875.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7581 , 698 , 159530.25 , 159530.25 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7584 , 836 , 140000.00 , 140000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7585 , 846 , 160000.00 , 160000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7590 , 881 , 175000.00 , 175000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7592 , 884 , 210000.00 , 210000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7598 , 921 , 140000.00 , 140000.00 , 0.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,7716 , 838 , 25000.00 , 75000.00 , 50000.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8055 , 433 , 65800.00 , 99010.00 , 33210.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8104 , 921 , 140000.00 , 218400.00 , 78400.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8116 , 848 , 250000.00 , 400088.00 , 150088.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8124 , 667 , 54000.00 , 98010.00 , 44010.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8171 , 678 , 72000.00 , 114048.00 , 42048.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8183 , 845 , 814214.00 , 1029981.00 , 215767.00,NULL , NULL);
INSERT INTO cb_payroll_process_promotion values (' ' ,8187 , 692 , 125400.00 , 165528.00 , 40128.00,NULL , NULL);
