--dipak
ALTER TABLE `tbl_users` ADD `current_ohctype` INT(100) NOT NULL AFTER `access1`;

ALTER TABLE `tbl_users` ADD `staff_id` INT(10) NOT NULL AFTER `req_pass_chng`;

ALTER TABLE `employee_appointment` ADD `pre_med_history` VARCHAR(500) NOT NULL AFTER `doc_comment`;

ALTER TABLE `patient_master` ADD `client_location_id` INT(11) NOT NULL AFTER `patient_surname`, ADD `client_id` INT(11) NOT NULL AFTER `client_location_id`;


ALTER TABLE `medicine_usage_cat` CHANGE `medicine_usage_cat_name` `medicine_usage_cat_name` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `followup_details` ADD `pre_med_history` VARCHAR(100) NOT NULL AFTER `pulse_output`;


ALTER TABLE `employee_appointment` CHANGE `followup` `followup` DATETIME NULL DEFAULT NULL;


ALTER TABLE `patient_master` ADD `passport` VARCHAR(100) NOT NULL AFTER `father_surname`;