INSERT INTO languages (`name`) VALUES ('Hindi');
INSERT INTO languages (`name`) VALUES ('Punjabi');
INSERT INTO languages (`name`) VALUES ('Korean');
INSERT INTO languages (`name`) VALUES ('Indonesian');

UPDATE countries SET `country`='Netherlands' WHERE  `country_id`=259;


INSERT INTO religion (`religion_name`) VALUES ('Sikhism');
INSERT INTO religion (`religion_name`) VALUES ('Jainism');
INSERT INTO religion (`religion_name`) VALUES ('Buddhism');
INSERT INTO religion (`religion_name`) VALUES ('Shinto');

UPDATE `proll_reference_data` SET `description`='Expert', `reference_code`='Expert' WHERE  `id`=246;


INSERT INTO proll_reference_data (`cid`, `ref_id`, `description`, `reference_code`, `status`, `created_by`, `created_date`, `lmportal`) VALUES (48, 54, 'Divorced', 'Divorced', 1, 1, '2024-01-24 15:25:00', 1);
INSERT INTO proll_reference_data (`cid`, `ref_id`, `description`, `reference_code`, `status`, `created_by`, `created_date`, `lmportal`) VALUES (48, 54, 'Widow', 'Widow', 1, 1, '2024-01-24 15:25:00', 1);


INSERT INTO proll_reference_data (`cid`, `ref_id`, `description`, `reference_code`, `status`, `created_by`, `created_date`, `lmportal`) VALUES (48, 57, 'Middle School', 'Middle School', 1, 1, '2024-01-24 16:50:33', 1);
INSERT INTO proll_reference_data (`cid`, `ref_id`, `description`, `reference_code`, `status`, `created_by`, `created_date`, `lmportal`) VALUES (48, 57, 'Mphil', 'Mphil', 1, 1, '2024-01-24 16:50:33', 1);
INSERT INTO proll_reference_data (`cid`, `ref_id`, `description`, `reference_code`, `status`, `created_by`, `created_date`, `lmportal`) VALUES (48, 57, 'Phd', 'Phd', 1, 1, '2024-01-24 16:50:33', 1);

INSERT INTO dms_document_categories_fields (`name`, `document_category_id`, `cid`, `added_by`, `created_at`, `reference_id`) VALUES ('Middle School', 8, 48, 8, '2024-01-24 16:56:37', (SELECT id FROM proll_reference_data WHERE ref_id=57 AND description="Middle School"));
INSERT INTO dms_document_categories_fields (`name`, `document_category_id`, `cid`, `added_by`, `created_at`, `reference_id`) VALUES ('Mphil', 8, 48, 8, '2024-01-24 16:56:37', (SELECT id FROM proll_reference_data WHERE ref_id=57 AND description="Mphil"));
INSERT INTO dms_document_categories_fields (`name`, `document_category_id`, `cid`, `added_by`, `created_at`, `reference_id`) VALUES ('Phd', 8, 48, 8, '2024-01-24 16:56:37', (SELECT id FROM proll_reference_data WHERE ref_id=57 AND description="Phd"));
DELETE FROM skills WHERE  skill_id=11;