ALTER TABLE visit_charge ADD `doctor_fee_guid` VARCHAR(38) NULL
ALTER TABLE visit_charge ADD `pttype2_guid` VARCHAR(38) NULL
ALTER TABLE visit_charge ADD `pttype1_guid` VARCHAR(38) NULL
ALTER TABLE thalassaemia_result ADD `thalassaemia_result_export` VARCHAR(10) NULL
ALTER TABLE thalassaemia_result ADD `thalassaemia_result_name` VARCHAR(150) NOT NULL
ALTER TABLE person_anc ADD `thalassaemia_result_id` INT NULL
ALTER TABLE dxa_vital_sign ADD `vital_sign_score` INT NULL
ALTER TABLE dxa_vital_sign ADD `vital_sign_value2` VARCHAR(200) NULL
ALTER TABLE dxa_vital_sign ADD `vital_sign_value1` VARCHAR(200) NULL
ALTER TABLE dxa_vital_sign ADD `vital_sign_condition` VARCHAR(20) NOT NULL
ALTER TABLE dxa_vital_sign ADD `vital_sign_name` VARCHAR(150) NOT NULL
ALTER TABLE dxa_vital_sign ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_treatment ADD `drugusage` VARCHAR(9) NULL
ALTER TABLE dxa_treatment ADD `qty` INT NOT NULL
ALTER TABLE dxa_treatment ADD `icode` VARCHAR(7) NOT NULL
ALTER TABLE dxa_treatment ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_physical_exam ADD `dxa_physical_exam_name` VARCHAR(250) NOT NULL
ALTER TABLE dxa_person_properties ADD `dxa_person_properties_score` INT NULL
ALTER TABLE dxa_person_properties ADD `dxa_person_properties_value` VARCHAR(200) NOT NULL
ALTER TABLE dxa_person_properties ADD `dxa_person_properties_name` VARCHAR(200) NOT NULL
ALTER TABLE dxa_person_properties ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_person_habit ADD `dxa_person_habit_name` VARCHAR(200) NOT NULL
ALTER TABLE dxa_disease_physical_exam ADD `dxa_physical_exam_score` INT NULL
ALTER TABLE dxa_disease_physical_exam ADD `dxa_physical_exam_id` INT NOT NULL
ALTER TABLE dxa_disease_physical_exam ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_disease_habit ADD `dxa_person_habit_score` INT NULL
ALTER TABLE dxa_disease_habit ADD `dxa_person_habit_id` INT NOT NULL
ALTER TABLE dxa_disease_habit ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_disease_cc ADD `dxa_disease_cc_score` INT NULL
ALTER TABLE dxa_disease_cc ADD `dxa_cc_id` INT NOT NULL
ALTER TABLE dxa_disease_cc ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE dxa_disease ADD `dxa_disease_discription` longtext NULL
ALTER TABLE dxa_disease ADD `dxa_disease_name` VARCHAR(150) NOT NULL
ALTER TABLE dxa_cc ADD `dxa_cc_name` VARCHAR(250) NOT NULL
ALTER TABLE dxa_advice ADD `dxa_advice_rtf` longtext NULL
ALTER TABLE dxa_advice ADD `dxa_advice_text` longtext NULL
ALTER TABLE dxa_advice ADD `dxa_disease_id` INT NOT NULL
ALTER TABLE doctor_form_list ADD `doctor` VARCHAR(9) NOT NULL
ALTER TABLE doctor_form_list ADD `form_name` VARCHAR(150) NOT NULL
CREATE TABLE visit_charge ( `vn` VARCHAR(13) NOT NULL )
CREATE TABLE thalassaemia_result ( `thalassaemia_result_id` INT NOT NULL )
CREATE TABLE dxa_vital_sign ( `dxa_vital_sign_id` INT NOT NULL )
CREATE TABLE dxa_treatment ( `dxa_treatment_id` INT NOT NULL )
CREATE TABLE dxa_physical_exam ( `dxa_physical_exam_id` INT NOT NULL )
CREATE TABLE dxa_person_properties ( `dxa_person_properties_id` INT NOT NULL )
CREATE TABLE dxa_person_habit ( `dxa_person_habit_id` INT NOT NULL )
CREATE TABLE dxa_disease_physical_exam ( `dxa_disease_physical_exam_id` INT NOT NULL )
CREATE TABLE dxa_disease_habit ( `dxa_disease_habit_id` INT NOT NULL )
CREATE TABLE dxa_disease_cc ( `dxa_disease_cc_id` INT NOT NULL )
CREATE TABLE dxa_disease ( `dxa_disease_id` INT NOT NULL )
CREATE TABLE dxa_cc ( `dxa_cc_id` INT NOT NULL )
CREATE TABLE dxa_advice ( `dxa_advice_id` INT NOT NULL )
CREATE TABLE doctor_form_list ( `doctor_form_list_id` INT NOT NULL )