21 lines
873 B
Plaintext
21 lines
873 B
Plaintext
--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`;
|
|
|