-- Milan Sarvaiya (10 March 2026)
ALTER TABLE `resume` ADD `introduction` LONGTEXT NULL DEFAULT NULL AFTER `skill_other_skills`;
ALTER TABLE `resume` ADD `special_needs_children` INT NULL DEFAULT NULL COMMENT '0= No, 1= Yes' AFTER `introduction`, ADD `camp_counselor_program_past` INT NULL DEFAULT NULL COMMENT '0= No, 1= Yes' AFTER `special_needs_children`, ADD `camp_counselor_past_many_times` INT NULL DEFAULT NULL AFTER `camp_counselor_program_past`, ADD `faith_based_camp` INT NULL COMMENT '0= No, 1= Yes' AFTER `camp_counselor_past_many_times`, ADD `religion` INT NULL DEFAULT NULL AFTER `faith_based_camp`, ADD `describe_doctrine` LONGTEXT NULL AFTER `religion`, ADD `activities_such_as_bible_study` INT NULL DEFAULT NULL COMMENT '0= No, 1= Yes' AFTER `describe_doctrine`, ADD `personal_care` INT NULL DEFAULT NULL COMMENT '0= No, 1= Yes' AFTER `activities_such_as_bible_study`;
ALTER TABLE `resume` ADD `date_of_birth` DATE NULL DEFAULT NULL AFTER `personal_care`;
------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Milan Sarvaiya (13 March 2026)
ALTER TABLE `resume` ADD `is_whatsapp_number` TINYINT(1) NOT NULL DEFAULT '0' AFTER `date_of_birth`;

ALTER TABLE `resume_education`
MODIFY `school` VARCHAR(255) NULL,
MODIFY `degree` VARCHAR(255) NULL,
MODIFY `start_date` DATE NULL,
MODIFY `end_date` DATE NULL;
------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Milan Sarvaiya (19 March 2026)
ALTER TABLE `resume` ADD `work_special_needs_camp` INT NULL COMMENT '0= No, 1= Yes' AFTER `is_whatsapp_number`, ADD `lifeguard_certified` INT NULL COMMENT '0= No, 1= Yes, I have the swimming skills needed, 2= Yes, I am currently or previously lifeguard certified.' AFTER `work_special_needs_camp`, ADD `rustic_env_comfort` INT NULL COMMENT '0= No, 1= Yes' AFTER `lifeguard_certified`, ADD `why_work_us_camp` TEXT NULL AFTER `rustic_env_comfort`, ADD `positive_camp_impact` TEXT NULL AFTER `why_work_us_camp`;
--------------------------------------------------------------------------------------------------------------------------------------------------
-- Hetal Visaveliya (26 March 2026)
ALTER TABLE `as_steps` ADD `ui_design` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 = OLD UI, 1 = NEW UI' AFTER `j1_status_id`;

ALTER TABLE `as_steps_by_dos` ADD `ui_design` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 = OLD UI, 1 = NEW UI' AFTER `step_order`;

ALTER TABLE as_steps DROP INDEX as_order_key;

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (41, '1_eligibility_test', 'Complete The J-1 Eligibility Test', 'fa-check-square', '', '', 'The purpose of the eligibility test is to determine which J1 visa sub-category you ', '1001,1002', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (42, '1_resume_upload', 'Create Your ITN Resume', 'fa-file-text', 'Upload a resume to impress your Host Companies. This is your chance to catch your Host Companies attention. If you don\' have a resume, we will offer you a free resume builder.', 'Upload a resume to impress your Host Companies. This is your chance to catch your Host Companies attention. If you don\' have a resume, we will offer you a free resume builder.', 'Your Resume has been submitted successfully.', '1003', '1');
  
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (44, '1_j1_interview', 'Schedule Your Introductory Call', 'fa-user', 'Introductory Call interview with an %branding% representative to evaluate your English level and gather additional information regarding your application.', 'Introductory Call interview with an %branding% representative to evaluate your English level and gather additional information regarding your application.', 'Introductory Call interview with an %branding% representative to evaluate your English level and gather additional information regarding your application.', '1006,1007', '1'); 
 
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (45, '1_j1_agreement', 'Sign The ITN Agreement', 'fa-file-text', 'You will need to sign the Agreement in order to continue our process.', 'You will need to sign the Agreement in order to continue our process.', 'You will need to sign the Agreement in order to continue our process.', '1008', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (46, '1_registration_fee', 'Pay The Registration Fee', 'fa-dollar', 'USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application.', 'USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application.', 'USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application.', '1009,1015', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (47, '1_additional_info', 'Additional Information', 'fa-info-circle', '', 'This is where we ask you to provide a few more pieces of information, if needed.', 'This is where we ask you to provide a few more pieces of information, if needed.', '1010,1016', '1');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '41', '1', '1', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '42', '1', '2', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '44', '1', '5', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '45', '1', '6', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '46', '1', '7', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '47', '1', '8', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES ('48', '2_supporting_documents', 'Placement Supporting Documents', 'fa-file-text', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', '3018,2001,1014', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (49, '2_booked', 'Interview Schedule with Host Company', 'fa-calendar', '\"Booking\" means that an Host Company has shown interest in interviewing you!', '\"Booking\" means that an Host Company has shown interest in interviewing you!', '\"Booking\" means that an Host Company has shown interest in interviewing you!', '2003', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (50, '2_placed', 'Placement Confirmed', 'fa-download', 'This where we confirm when the Host Company is ready to hire you.', 'This where we confirm when the Host Company is ready to hire you.', 'This where we confirm when the Host Company is ready to hire you.', '2004', '1');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '48', '2', '1', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '49', '2', '2', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '50', '2', '3', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (51, '3_post_placement_documents', 'Submit Your Documents', 'fa-file-text', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', 'We need certain documents based on the specific requirements for the visa type which you will use to enter the U.S.', '3001', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (52, '3_pay_program_fees', 'Pay The Program Fees', 'fa-dollar', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (53, '3_ds7002_signed', 'DS-7002 (Training Plan)', 'fa-pencil', 'At this step you are expected to sign the DS7002 Form, the form was sent to your registered address.', 'At this step you are expected to sign the DS7002 Form, the form was sent to your registered address.', 'At this step you are expected to sign the DS7002 Form, the form was sent to your registered address.', '3004', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (54, '3_sevis_confirmation', 'SEVIS Confirmation', 'fa-file-text', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (55, '3_ds2019_sent', 'DS-2019', 'fa-file-text', 'You will receive the DS2019 Form to presented in your US embassy interview.', 'You will receive the DS2019 Form to presented in your US embassy interview.', 'You will receive the DS2019 Form to presented in your US embassy interview.', '3005,3016', '1');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '51', '3', '1', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '52', '3', '2', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '53', '3', '3', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '54', '3', '4', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '55', '3', '5', '1');

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (56, '4_medical_insurance', 'Medical Insurance', 'fa-stethoscope', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (57, '4_predeparture_orientation', 'Pre Departure Orientation', 'fa-file-text', 'Pre Departure Orientation', 'Pre Departure Orientation', 'Pre Departure Orientation', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (58, '4_us_embassy_interview', 'US Embassy Interview', 'fa-user', '', '', '', '3006,3009', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (59, '4_us_visa_outcome', 'US Visa Outcome', 'fa-cc-visa', '', '', '', '3007', '1');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '56', '4', '1', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '57', '4', '2', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '58', '4', '3', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '59', '4', '4', '1'); 

INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (60, '5_flight_info', 'Flight Details', 'fa-plane', 'Information about your flight.', 'Information about your flight.', 'Information about your flight.', '3008', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (61, '5_arrival_check_in', 'Arrival Check-In', 'fa-plane', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (62, '5_monthly_check_in', 'Monthly Check-In', 'fa-calendar-check', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (63, '5_mid_super_evaluation', 'Review Your Midterm Supervisor Evaluation', 'fa-smile', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (64, '5_mid_evaluation', 'Mid-term Evaluation', 'fa-smile', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (65, '5_final_super_evaluation', 'Review Your Final Supervisor Evaluation', 'fa-smile', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (66, '5_final_evaluation', 'Final Evaluation', 'fa-smile', '', '', '', '', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (67, '5_departure_info', 'Departure Information', 'fa-plane', 'Information about your departure flight.', 'Information about your departure flight.', 'Information about your departure flight.', '4010', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`, `ui_design`) VALUES (68, '5_diploma_completion', 'Diploma Completion', 'fa-file-text', '', '', '', '', '1');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '60', '5', '1', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '61', '5', '2', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '62', '5', '3', '1');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '63', '5', '5', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '64', '5', '4', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '65', '5', '7', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '66', '5', '6', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '67', '5', '8', '1'); 
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`, `ui_design`) VALUES (NULL, '1', '68', '5', '9', '1'); 
------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Milan Sarvaiya (03 March 2026)
ALTER TABLE `resume` CHANGE `religion` `religion` TEXT NULL DEFAULT NULL;
ALTER TABLE `resume_employment` MODIFY `duties` TEXT NULL;
------------------------------------------------------------------------------------------------------------------------------------------------------------
