INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Afghanistan', 'Afghan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Albania', 'Albanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Algeria', 'Algerian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('American Samoa', 'American Samoan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Andorra', 'Andorran\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Anguilla', 'Anguillan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Antarctica', 'Antarctican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Antigua And Barbuda', 'Antiguan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Argentina', 'Argentine\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Armenia', 'Armenian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Aruba', 'Aruban\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Australia', 'Australian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Austria', 'Austrian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Azerbaijan', 'Azerbaijani\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bahrain', 'Bahraini\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bangladesh', 'Bangladeshi\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Barbados', 'Barbadan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Belarus', 'Belarusian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Belgium', 'Belgian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Belize', 'Belizean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Benin', 'Beninese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bermuda', 'Bermudan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bhutan', 'Bhutanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bolivia', 'Bolivian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bosnia and Herzegovina', 'Bosnian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Botswana', 'Motswana\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bouvet Island', 'Bouvet Island\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Brazil', 'Brazilian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('British Indian Ocean Territory', 'British Indian Ocean Territory citizen\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Brunei', 'Bruneian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Bulgaria', 'Bulgarian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Burkina Faso', 'Burkinabe\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Burundi', 'Burundian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cambodia', 'Cambodian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cameroon', 'Cameroonian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Canada', 'Canadian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cape Verde', 'Cape Verdean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cayman Islands', 'Caymanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Central African Republic', 'Central African\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Chad', 'Chadian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Chile', 'Chilean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('China', 'Chinese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Christmas Island', 'Christmas Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cocos (Keeling) Islands', 'Cocos Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Colombia', 'Colombian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Comoros', 'Comorian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cook Islands', 'Cook Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Costa Rica', 'Costa Rican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cote D\'Ivoire (Ivory Coast)', 'Ivorian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Croatia (Hrvatska)', 'Croatian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cuba', 'Cuban\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Cyprus', 'Cypriot\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Czech Republic', 'Czech\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Democratic Republic Of The Congo', 'Congolese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Denmark', 'Danish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Djibouti', 'Djiboutian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Dominica', 'Dominican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Dominican Republic', 'Dominican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('East Timor', 'Timorese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Ecuador', 'Ecuadorian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Egypt', 'Egyptian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('El Salvador', 'Salvadoran\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Equatorial Guinea', 'Equatoguinean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Eritrea', 'Eritrean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Estonia', 'Estonian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Ethiopia', 'Ethiopian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('External Territories of Australia', 'Australian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Falkland Islands', 'Falkland Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Faroe Islands', 'Faroese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Fiji Islands', 'Fijian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Finland', 'Finnish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('France', 'French\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('French Guiana', 'French Guianese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('French Polynesia', 'French Polynesian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('French Southern Territories', 'French\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Gabon', 'Gabonese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Gambia', 'Gambian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Georgia', 'Georgian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Germany', 'German\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Ghana', 'Ghanaian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Gibraltar', 'Gibraltarian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Greece', 'Greek\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Greenland', 'Greenlander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Grenada', 'Grenadian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guadeloupe', 'Guadeloupean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guam', 'Guamanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guatemala', 'Guatemalan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guernsey and Alderney', 'Guernseyan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guinea', 'Guinean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guinea-Bissau', 'Guinea-Bissauan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Guyana', 'Guyanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Haiti', 'Haitian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Heard and McDonald Islands', 'Heard and McDonald Islands\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Honduras', 'Honduran\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Hong Kong S.A.R.', 'Hong Konger\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Hungary', 'Hungarian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Iceland', 'Icelandic\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('India', 'Indian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Indonesia', 'Indonesian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Iran', 'Iranian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Iraq', 'Iraqi\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Ireland', 'Irish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Israel', 'Israeli\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Italy', 'Italian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Jamaica', 'Jamaican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Japan', 'Japanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Jersey', 'Jerseyman\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Jordan', 'Jordanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Kazakhstan', 'Kazakh\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Kenya', 'Kenyan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Kiribati', 'I-Kiribati\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Korea North', 'North Korean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Korea South', 'South Korean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Kuwait', 'Kuwaiti\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Kyrgyzstan', 'Kyrgyzstani\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Laos', 'Laotian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Latvia', 'Latvian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Lebanon', 'Lebanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Lesotho', 'Mosotho\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Liberia', 'Liberian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Libya', 'Libyan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Liechtenstein', 'Liechtensteiner\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Lithuania', 'Lithuanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Luxembourg', 'Luxembourger\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Macau S.A.R.', 'Macanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Macedonia', 'Macedonian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Madagascar', 'Malagasy\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Malawi', 'Malawian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Malaysia', 'Malaysian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Maldives', 'Maldivian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mali', 'Malian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Malta', 'Maltese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Man (Isle of)', 'Manx\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Marshall Islands', 'Marshallese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Martinique', 'Martiniquan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mauritania', 'Mauritanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mauritius', 'Mauritian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mayotte', 'Mahoran\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mexico', 'Mexican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Micronesia', 'Micronesian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Moldova', 'Moldovan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Monaco', 'Monegasque\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mongolia', 'Mongolian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Montserrat', 'Montserratian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Morocco', 'Moroccan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Mozambique', 'Mozambican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Myanmar', 'Burmese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Namibia', 'Namibian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Nauru', 'Nauruan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Nepal', 'Nepali\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Netherlands', 'Dutch\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Netherlands Antilles', 'Netherlander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('New Caledonia', 'New Caledonian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('New Zealand', 'New Zealander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Nicaragua', 'Nicaraguan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Niger', 'Nigerien\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Nigeria', 'Nigerian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Niue', 'Niuean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Norfolk Island', 'Norfolk Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Northern Mariana Islands', 'Northern Mariana Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Norway', 'Norwegian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Oman', 'Omani\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Pakistan', 'Pakistani\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Palau', 'Palauan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Palestinian Territory Occupied', 'Palestinian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Panama', 'Panamanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Papua New Guinea', 'Papua New Guinean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Paraguay', 'Paraguayan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Peru', 'Peruvian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Philippines', 'Filipino or Filipina\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Pitcairn Island', 'Pitcairn Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Poland', 'Polish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Portugal', 'Portuguese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Puerto Rico', 'Puerto Rican\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Qatar', 'Qatari\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Republic Of The Congo', 'Congolese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Reunion', 'Reunionese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Romania', 'Romanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Russia', 'Russian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Rwanda', 'Rwandan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saint Helena', 'Saint Helenian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saint Kitts And Nevis', 'Kittitian or Nevisian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saint Lucia', 'Saint Lucian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saint Pierre and Miquelon', 'Saint-Pierrais or Miquelonnais\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saint Vincent And the Grenadines', 'Saint Vincentian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Samoa', 'Samoan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('San Marino', 'Sammarinese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Sao Tome And Principe', 'Sao Tomean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Saudi Arabia', 'Saudi Arabian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Senegal', 'Senegalese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Serbia', 'Serbian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Serbia and Montenegro', 'Montenegrin\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Seychelles', 'Seychellois\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Sierra Leone', 'Sierra Leonean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Singapore', 'Singaporean\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Slovakia', 'Slovak\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Slovenia', 'Slovene\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Smaller Territories of the UK', 'British\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Solomon Islands', 'Solomon Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Somalia', 'Somali\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('South Africa', 'South African\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('South Georgia South Sandwich Islands', 'South Georgia South Sandwich Islands\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('South Sudan', 'South Sudanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Spain', 'Spanish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Sri Lanka', 'Sri Lankan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Sudan', 'Sudanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Suriname', 'Surinamese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Svalbard And Jan Mayen Islands', 'Svalbard And Jan Mayen Islands\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Swaziland', 'Swazi\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Sweden', 'Swedish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Switzerland', 'Swiss\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Syria', 'Syrian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Taiwan', 'Taiwanese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tajikistan', 'Tajikistani\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tanzania', 'Tanzanian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Thailand', 'Thai\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Togo', 'Togolese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tokelau', 'Tokelauan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tonga', 'Tongan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Trinidad And Tobago', 'Trinidadian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tunisia', 'Tunisian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Turkey', 'Turkish\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Turkmenistan', 'Turkmen\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Turks And Caicos Islands', 'Turks and Caicos Islander\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Tuvalu', 'Tuvaluan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Uganda', 'Ugandan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Ukraine', 'Ukrainian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('United Arab Emirates', 'Emirati\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('United Kingdom', 'British\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('United States', 'American\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('United States Minor Outlying Islands', 'American\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Uruguay', 'Uruguayan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Uzbekistan', 'Uzbek\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Vanuatu', 'Ni-Vanuatu\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Vatican City State (Holy See)', 'Holy See citizen\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Venezuela', 'Venezuelan\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Vietnam', 'Vietnamese\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Virgin Islands (British)', 'Virgin Islander (British)\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Virgin Islands (US)', 'Virgin Islander (US)\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Wallis And Futuna Islands', 'Wallisian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Western Sahara', 'Sahrawi\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Yemen', 'Yemeni\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Yugoslavia', 'Yugoslavian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Zambia', 'Zambian\r');
INSERT INTO `proll_nationality` (`country`, `nationality`) VALUES ('Zimbabwe', 'Zimbabwean\r');

UPDATE proll_nationality pn
LEFT JOIN countries c ON pn.country = c.country
SET pn.country = CASE
    WHEN c.country_id IS NULL THEN 0
    ELSE c.country_id
END;

ALTER TABLE `proll_nationality` CHANGE COLUMN `country` `country_id` INT(10) UNSIGNED NOT NULL AFTER `id`;

DELETE FROM proll_nationality WHERE country_id=0;

ALTER TABLE `proll_nationality` ADD CONSTRAINT `proll_nationality_country_id_countries_country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`) ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE `proll_employee` CHANGE COLUMN `job_status` `job_status` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `status`;
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`)
VALUES (48, 45, 11, 'Close', 'Close', NULL, 1, NULL, 1, '2024-05-16 02:44:00', NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL);

ALTER TABLE `proll_employee` ADD COLUMN `vacant_position_created_against` INT NULL AFTER `is_employee`;

ALTER TABLE `proll_employee_info` ADD COLUMN `inactive_marked_by` INT NULL DEFAULT NULL;
ALTER TABLE `proll_employee_info` ADD COLUMN `inactive_marked_at` DATE NULL DEFAULT NULL;

DROP TABLE IF EXISTS `employee_details_log`;
CREATE TABLE IF NOT EXISTS `employee_details_log` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
	`emp_id` INT(10) NULL DEFAULT NULL,
	`band_id` INT(10) NULL DEFAULT NULL,
	`department_id` INT(10) NULL DEFAULT NULL,
	`designation_id` INT(10) NULL DEFAULT NULL,
	`department_lm_id` INT(10) NULL DEFAULT NULL,
	`employement_status_id` INT(10) NULL DEFAULT NULL,
	`employee_status_id` INT(10) NULL DEFAULT NULL,
	`department_joining_date` DATE NULL DEFAULT NULL,
	`sub_department_id` INT(10) NULL DEFAULT NULL,
	`branch_id` INT(10) NULL DEFAULT NULL,
	`shift_id` INT(10) NULL DEFAULT NULL,
	`external_lm1_id` INT(10) NULL DEFAULT NULL,
	`external_lm2_id` INT(10) NULL DEFAULT NULL,
	`mobile_attendance` TINYINT(3) NULL DEFAULT '0',
	`remote_attendance` TINYINT(3) NULL DEFAULT '0',
	`probation_period` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci',
	`probation_completion_date` DATE NULL DEFAULT NULL,
	`doj` DATE NULL DEFAULT NULL,
	`orignal_doj` DATE NULL DEFAULT NULL,
	`last_working_date` DATE NULL DEFAULT NULL,
	`dor` DATE NULL DEFAULT NULL,
	`currency_id` INT(10) NULL DEFAULT NULL,
	`gross_annual_salary` FLOAT NULL DEFAULT NULL,
	`gross_monthly_salary` FLOAT NULL DEFAULT NULL,
	`source` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci',
	`eobi_applicable` TINYINT(3) NULL DEFAULT '0',
	`social_security_applicable` TINYINT(3) NULL DEFAULT '0',
	`appraisal_rating_prior_year` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci',
	`appraisal_rating_last_year` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_0900_ai_ci',
	`last_promotion_date` DATE NULL DEFAULT NULL,
	`created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
	`updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
	`updated_by` INT(10) NULL DEFAULT NULL,
	`inactive_marked_at` DATE NULL DEFAULT NULL,
	`reason_for_leaving` INT(10) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `proll_reference_data_code` (`reference_code`, `cid`) VALUES ('Contract_Type_Values', (SELECT id FROM proll_client WHERE status=1 LIMIT 1));

INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Hourly Rate', 'Hourly Rate', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Daily Rate', 'Daily Rate', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Milestone Based', 'Milestone Based', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Monthly Rate', 'Monthly Rate', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Salary Based', 'Salary Based', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `proll_reference_data` (`cid`, `ref_id`, `reference_key`, `description`, `reference_code`, `sort_order`, `status`, `flag`, `created_by`, `created_date`, `modified_by`, `modified_date`, `reference_data_id`, `emportal`, `lmportal`, `hrportal`, `allow_edit`, `allow_delete`, `system_ind`, `allow_add`) VALUES ((SELECT id FROM proll_client WHERE status=1 LIMIT 1), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Contract_Type_Values'), (SELECT ref_id FROM proll_reference_data_code WHERE reference_code='Employment_Type'), 'Retainership', 'Retainership', NULL, 1, NULL, NULL, '2024-08-22 02:05:20', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);

ALTER TABLE `proll_employee_contracts` ADD COLUMN `contract_type` INT NULL, ADD COLUMN `contract_milestone` INT NULL, ADD COLUMN `milestone_value` INT NULL,
ADD COLUMN `frequency_rate` INT NULL, ADD COLUMN `milestone_timeline` INT NULL, ADD COLUMN `contract_period` VARCHAR(50) NULL DEFAULT NULL,
ADD COLUMN `extension_no` VARCHAR(50) NULL DEFAULT NULL;

ALTER TABLE `proll_employee_contracts`
	CHANGE COLUMN `contract_milestone` `contract_milestone` VARCHAR(50) NULL DEFAULT NULL,
	CHANGE COLUMN `milestone_timeline` `milestone_timeline` DATE NULL DEFAULT NULL;

SET @parent_id := (SELECT id FROM acm_menus WHERE parent_id=(SELECT id FROM acm_menus WHERE menu_title='Org & Emp') AND menu_title='Analytics' LIMIT 1);
INSERT INTO `acm_menus` 
(`menu_title`, `parent_id`, `menu_order`, `menu_type_id`, `level`, `client_id`, `icon`, `img`, `page_menu_title`, `isDeleted`, `created_by`, `updated_at`, `created_at`, `is_approved`, `pre_approved_status`, `pre_approved_value`, `pre_approved_description`, `approval_request_generated_by`)
VALUES 
('Contract Details Report', @parent_id, 10, 1, 3, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 'org-emp/employee-profile/history-reports/contract-details-report', 'org & emp analytics-icons_Emp Profile Analytics_Contract Details Report.svg', 'Contract Details Report', 0, 58472, NULL, NULL, 1, 0, 0, NULL, NULL);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='HR'), 'Contract Details Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 0);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='CR'), 'Contract Details Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 13:00:46', '2024-08-26 13:00:46', 0);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='CEO'), 'Contract Details Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 13:26:39', '2024-08-26 13:26:39', 0);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='HR'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'org-emp/employee-profile/history-reports/contract-details-report', NULL, 'View the comprehensive list of employees and their Contract Details', 1);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='CR'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'org-emp/employee-profile/history-reports/contract-details-report', NULL, 'View the comprehensive list of employees and their Contract Details', 1);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Contract Details Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='CEO'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'org-emp/employee-profile/history-reports/contract-details-report', NULL, 'View the comprehensive list of employees and their Contract Details', 1);

ALTER TABLE dms_document_files ADD Column `is_active` TINYINT(3) NULL DEFAULT '1';

INSERT INTO `modules` (`cid`, `name`, `status`, `display_lm_config`, `display_hr_config`, `is_client_purchased`, `module_display_name`) 
VALUES ((SELECT id FROM proll_client WHERE STATUS=1 LIMIT 1), 'position_management', 1, 0, 0, 1, 'Rec & Sel - Position Management');
 
INSERT INTO `module_level_policy` (`module_id`, `name`, `description`, `status`, `created_at`, `updated_at`, `value`) 
VALUES ((SELECT id FROM modules WHERE name='position_management'), 'display_vacant_employment_data', 'To show vacant data either in form of "Vacant Job Summary" or by "Employment Detail"', 1, NULL, NULL, '1');

SET @parent_id := (SELECT id FROM acm_menus WHERE parent_id=(SELECT id FROM acm_menus WHERE parent_id=(SELECT id FROM acm_menus WHERE menu_title='Comp & Ben') AND menu_title='Analytics' LIMIT 1) AND menu_title='Payroll Reports' LIMIT 1);
INSERT INTO `acm_menus` 
(`menu_title`, `parent_id`, `menu_order`, `menu_type_id`, `level`, `client_id`, `icon`, `img`, `page_menu_title`, `isDeleted`, `created_by`, `updated_at`, `created_at`, `is_approved`, `pre_approved_status`, `pre_approved_value`, `pre_approved_description`, `approval_request_generated_by`)
VALUES 
('Bulk Salary Report', @parent_id, 42, 3, 4, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 'Payroll Reports_Bulk Salary.svg', 'Payroll Reports_Bulk Salary.svg', 'Bulk Salary Report', 0, 58472, NULL, NULL, 1, 0, 0, NULL, NULL);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='HR'), 'Bulk Salary Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 0);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='CR'), 'Bulk Salary Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 13:00:46', '2024-08-26 13:00:46', 0);

INSERT INTO `acm_group_role_menu` (`menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT acp.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
WHERE role='CEO'), 'Bulk Salary Report', 0, 1, (SELECT id FROM proll_client WHERE status=1 LIMIT 1), 56193, 56193, '2024-08-26 13:26:39', '2024-08-26 13:26:39', 0);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='HR'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'comp-ben/compensation/salary-composition-bulk', NULL, 'This report facilitates the bulk downloading of employee Pay Slips.', 1);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='CR'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'comp-ben/compensation/salary-composition-bulk', NULL, 'This report facilitates the bulk downloading of employee Pay Slips.', 1);

INSERT INTO `acm_group_role_association` (`menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) 
VALUES ((SELECT id FROM acm_menus WHERE menu_title='Bulk Salary Report'), (SELECT agr.id FROM acm_portals ap
INNER JOIN acm_client_portals acp ON acp.portal_id=ap.id
INNER JOIN acm_group_roles agr ON agr.roles_portal_id=acp.id
WHERE ap.role='CEO'), 0, 0, 0, 0, '2024-08-26 16:26:08', '2024-08-26 16:26:08', 'comp-ben/compensation/salary-composition-bulk', NULL, 'This report facilitates the bulk downloading of employee Pay Slips.', 1);

ALTER TABLE `proll_client_location` ADD COLUMN `state_id` INT NULL AFTER `modified_date`, ADD COLUMN `cluster_id` INT NULL AFTER `state_id`, ADD COLUMN `market_id` INT NULL, ADD COLUMN `sub_cluster_id` INT NULL;
