CREATE TABLE `cb_payroll_extract_log` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
	`header` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`applied_date` DATETIME NULL DEFAULT NULL,
	`emp_id` INT(11) NULL DEFAULT NULL,
	`module_id` INT(11) NULL DEFAULT NULL,
	`table_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`table_primary_id` INT(11) NULL DEFAULT NULL,
	`value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`created_at` DATETIME NULL DEFAULT NULL,
	`updated_at` DATETIME NULL DEFAULT NULL,
	`created_by` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
ENGINE=INNODB
AUTO_INCREMENT=1
;
 
ALTER TABLE `pm_appraisal_launch_history` ADD COLUMN `is_fulfilled_by_payroll` INT(11) NULL DEFAULT 0 AFTER `is_non_appraisal`;
ALTER TABLE `pr_promotions` ADD COLUMN `is_fulfilled_by_payroll` INT(11) NULL DEFAULT 0 AFTER `lm_status`;
ALTER TABLE `pr_awards` ADD COLUMN `is_fulfilled_by_payroll` INT(11) NULL DEFAULT 0 AFTER `lm_status`;
 
CREATE TABLE `cb_payroll_increment_and_promotion` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`payroll_emf_file_info_id` INT(11) NULL DEFAULT NULL,
	`emp_id` INT(11) NULL DEFAULT NULL,
	`empcode` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`emp_name` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`increment_amount` FLOAT NULL DEFAULT NULL,
	`designation_id` INT(11) NULL DEFAULT NULL,
	`department_id` INT(11) NULL DEFAULT NULL,
	`band_id` INT(11) NULL DEFAULT NULL,
	`location_id` INT(11) NULL DEFAULT NULL,
	`promotion_title` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`source` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`approval_date` DATETIME NULL DEFAULT NULL,
	`created_at` DATETIME NULL DEFAULT current_timestamp(),
	`created_by` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
ENGINE=InnoDB
AUTO_INCREMENT=1
;