CREATE TABLE cb_payroll_description(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NULL DEFAULT NULL,
`code` VARCHAR(50) NULL DEFAULT NULL,
`status` TINYINT(2) DEFAULT 0,
`description` LONGTEXT NULL DEFAULT NULL,
`is_common` TINYINT(2) DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE);

INSERT INTO cb_payroll_description (`title`, `code`, `status`, `description`)
VALUES
('People Tech PAK Contractual Staff Salary', '', 1, 'People Tech PAK Contractual Staff Salary'),
('People Tech PAK Regular Staff Salary', '', 1, 'People Tech PAK Regular Staff Salary'),
('People Tech PAK Regular Staff Final Settlement', '', 1, 'People Tech PAK Regular Staff Final Settlement'),
('CSNP PAK Regular Staff Salary', '', 1, 'CSNP PAK Regular Staff Salary'),
('CSNP PAK Contractual Staff Salary', '', 1, 'CSNP PAK Contractual Staff Salary'),
('CSNP PAK Regular Staff Final Settlement', '', 1, 'CSNP PAK Regular Staff Final Settlement'),
('People UAE Contractual Staff for PPTECH Salary', '', 1, 'People UAE Contractual Staff for PPTECH Salary'),
('People PAK Contractual Staff Salary', '', 1, 'People PAK Contractual Staff Salary'),
('People PAK Regular Staff Salary', '', 1, 'People PAK Regular Staff Salary'),
('People PAK Regular Staff Final Settlement', '', 1, 'People PAK Regular Staff Final Settlement'),
('People AFG Contractual Staff Salary', '', 1, 'People AFG Contractual Staff Salary'),
('People AFG Regular Staff Salary', '', 1, 'People AFG Regular Staff Salary'),
('People AFG Regular Staff Final Settlement', '', 1, 'People AFG Regular Staff Final Settlement'),
('People KSA Contractual Staff Salary', '', 1, 'People KSA Contractual Staff Salary'),
('People KSA Regular Staff Salary', '', 1, 'People KSA Regular Staff Salary'),
('People KSA Regular Staff Final Settlement', '', 1, 'People KSA Regular Staff Final Settlement'),
('People UAE Contractual Staff Salary', '', 1, 'People UAE Contractual Staff Salary'),
('People UAE Regular Staff Salary', '', 1, 'People UAE Regular Staff Salary'),
('People UAE Regular Staff Final Settlement', '', 1, 'People UAE Regular Staff Final Settlement');
