ALTER TABLE village_toilet_type ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_toilet_type ADD `pass_percent` DOUBLE(15,3) NULL
ALTER TABLE village_toilet_type ADD `setting_has_pass` INT NULL
ALTER TABLE village_toilet_type ADD `setting_target` INT NULL
ALTER TABLE village_toilet_type ADD `village_toilet_type_name` VARCHAR(250) NOT NULL
ALTER TABLE village_toilet_survey_image ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_toilet_survey_image ADD `image_data` longblob NULL
ALTER TABLE village_toilet_survey_image ADD `image_no` INT NULL
ALTER TABLE village_toilet_survey_image ADD `village_toilet_survey_id` INT NOT NULL
ALTER TABLE village_toilet_survey ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_toilet_survey ADD `has_pass` CHAR(1) NULL
ALTER TABLE village_toilet_survey ADD `village_toilet_survey_date` DATE NULL
ALTER TABLE village_toilet_survey ADD `village_toilet_survey_name` VARCHAR(250) NULL
ALTER TABLE village_toilet_survey ADD `village_toilet_type_id` INT NOT NULL
ALTER TABLE village_toilet_survey ADD `village_id` INT NOT NULL
ALTER TABLE village_market_type ADD `village_market_type_name` VARCHAR(150) NOT NULL
ALTER TABLE village_market_survey ADD `village_market_standard_type_id` INT NULL
ALTER TABLE village_market_survey ADD `village_market_name` VARCHAR(250) NULL
ALTER TABLE village_market_survey ADD `phone` VARCHAR(150) NULL
ALTER TABLE village_market_survey ADD `standard_score` INT NULL
ALTER TABLE village_market_survey ADD `standard_pass` CHAR(1) NULL
ALTER TABLE village_market_survey ADD `training_pass` CHAR(1) NULL
ALTER TABLE village_market_survey ADD `village_market_location` VARCHAR(250) NULL
ALTER TABLE village_market_survey ADD `village_market_owner_name` VARCHAR(250) NULL
ALTER TABLE village_market_survey ADD `village_market_type_id` INT NOT NULL
ALTER TABLE village_market_standard_type ADD `village_market_standard_type_name` VARCHAR(150) NOT NULL
ALTER TABLE village_agri_surveillance_member ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_agri_surveillance_member ADD `training_pass` CHAR(1) NULL
ALTER TABLE village_agri_surveillance_member ADD `village_agri_surveillance_id` INT NOT NULL
ALTER TABLE village_agri_surveillance_member ADD `person_name` VARCHAR(150) NOT NULL
ALTER TABLE village_agri_surveillance_member ADD `person_cid` VARCHAR(13) NULL
ALTER TABLE village_agri_surveillance ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_agri_surveillance ADD `training_no_pass_count` INT NULL
ALTER TABLE village_agri_surveillance ADD `training_pass_count` INT NULL
ALTER TABLE village_agri_surveillance ADD `village_agri_group_type_id` INT NULL
ALTER TABLE village_agri_surveillance ADD `agri_remark` VARCHAR(250) NULL
ALTER TABLE village_agri_surveillance ADD `agri_member_count` INT NULL
ALTER TABLE village_agri_surveillance ADD `agri_location` VARCHAR(250) NULL
ALTER TABLE village_agri_surveillance ADD `agri_director_name` VARCHAR(150) NULL
ALTER TABLE village_agri_surveillance ADD `agri_group_name` VARCHAR(250) NOT NULL
ALTER TABLE village_agri_group_type ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_agri_group_type ADD `village_agri_group_type_name` VARCHAR(150) NOT NULL
ALTER TABLE survey_year_period ADD `survey_year_period_name` VARCHAR(150) NOT NULL
ALTER TABLE physic_main_ipd ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE physic_list_ipd ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE person_labour ADD `thyroid_treatment_date` DATE NULL
ALTER TABLE person_labour ADD `thyroid_confirm_date` DATE NULL
ALTER TABLE person_labour ADD `thyroid_confirm` CHAR(1) NULL
ALTER TABLE person_labour ADD `thyroid_screen_date` DATE NULL
ALTER TABLE person_bw_survey_list ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE person_bw_survey_list ADD `height` DOUBLE(15,3) NULL
ALTER TABLE person_bw_survey_list ADD `sex` CHAR(1) NULL
ALTER TABLE person_bw_survey_list ADD `village_id` INT NULL
ALTER TABLE person_bw_survey_list ADD `house_id` INT NULL
ALTER TABLE person_bw_survey_list ADD `age_month` INT NULL
ALTER TABLE person_bw_survey_list ADD `body_weight` DOUBLE(15,3) NULL
ALTER TABLE person_bw_survey_list ADD `survey_date` DATE NULL
ALTER TABLE person_bw_survey_list ADD `bmi_level_id` INT NULL
ALTER TABLE person_bw_survey_list ADD `person_id` INT NOT NULL
ALTER TABLE person_bw_survey_list ADD `person_bw_survey_id` INT NOT NULL
ALTER TABLE person_bw_survey ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE person_bw_survey ADD `person_bw_survey_year` INT NULL
ALTER TABLE person_bw_survey ADD `survey_person_percent` DOUBLE(15,3) NULL
ALTER TABLE person_bw_survey ADD `survey_person_count` INT NULL
ALTER TABLE person_bw_survey ADD `total_person_count` INT NULL
ALTER TABLE person_bw_survey ADD `survey_year_period_id` INT NOT NULL
ALTER TABLE person_anc_preg_care ADD `real_preg_care` CHAR(1) NULL
ALTER TABLE operation_list_anes_type ADD `operation_list_anes_type_name` VARCHAR(150) NOT NULL
ALTER TABLE operation_list ADD `operation_list_anes_type_id` INT NULL
ALTER TABLE lab_form_head ADD `hos_guid` CHAR(38) NULL
ALTER TABLE lab_form ADD `hos_guid` CHAR(38) NULL
ALTER TABLE lab_department ADD `hos_guid` CHAR(38) NULL
ALTER TABLE ipt_type ADD `hos_guid` CHAR(38) NULL
ALTER TABLE ipt_order_type ADD `hos_guid` CHAR(38) NULL
ALTER TABLE ipt_medication_type ADD `hos_guid` CHAR(38) NULL
ALTER TABLE ipt_admit_stat ADD `hos_guid` CHAR(38) NULL
ALTER TABLE death_autopsy_perform ADD `autopsy_time` TIME NULL
ALTER TABLE death_autopsy_perform ADD `autopsy_date` DATE NULL
ALTER TABLE death_autopsy_perform ADD `autopsy_doctor` VARCHAR(10) NULL
ALTER TABLE death_autopsy_perform ADD `transfer_hospcode` CHAR(5) NULL
ALTER TABLE death_autopsy_perform ADD `transfer` CHAR(1) NULL
ALTER TABLE death_autopsy_perform ADD `biopsy_examine` CHAR(1) NULL
ALTER TABLE death_autopsy_perform ADD `surgery_examine` CHAR(1) NULL
ALTER TABLE death_autopsy_perform ADD `surface_examine` CHAR(1) NULL
ALTER TABLE death_autopsy_perform ADD `work_no` INT NULL
ALTER TABLE death_autopsy_perform ADD `autopsy_death_type_id` INT NULL
ALTER TABLE death_autopsy_perform ADD `death_transfer` CHAR(1) NULL
ALTER TABLE death_autopsy_perform ADD `budget_type_id` INT NULL
ALTER TABLE death ADD `autopsy_perform` CHAR(1) NULL
ALTER TABLE dchtype ADD `hos_guid` CHAR(38) NULL
ALTER TABLE dchstts ADD `hos_guid` CHAR(38) NULL
ALTER TABLE budget_type ADD `budget_type_name` VARCHAR(150) NOT NULL
ALTER TABLE autopsy_death_type ADD `autopsy_death_type_name` VARCHAR(150) NOT NULL
CREATE TABLE village_toilet_type ( `village_toilet_type_id` INT NOT NULL )
CREATE TABLE village_toilet_survey_image ( `village_toilet_survey_image_id` INT NOT NULL )
CREATE TABLE village_toilet_survey ( `village_toilet_survey_id` INT NOT NULL )
CREATE TABLE village_market_type ( `village_market_type_id` INT NOT NULL )
CREATE TABLE village_market_survey ( `village_market_survey_id` INT NOT NULL )
CREATE TABLE village_market_standard_type ( `village_market_standard_type_id` INT NOT NULL )
CREATE TABLE village_agri_surveillance_member ( `village_agri_surveillance_member_id` INT NOT NULL )
CREATE TABLE village_agri_surveillance ( `village_agri_surveillance_id` INT NOT NULL )
CREATE TABLE village_agri_group_type ( `village_agri_group_type_id` INT NOT NULL )
CREATE TABLE survey_year_period ( `survey_year_period_id` INT NOT NULL )
CREATE TABLE person_bw_survey_list ( `person_bw_survey_list_id` INT NOT NULL )
CREATE TABLE person_bw_survey ( `person_bw_survey_id` INT NOT NULL )
CREATE TABLE operation_list_anes_type ( `operation_list_anes_type_id` INT NOT NULL )
CREATE TABLE death_autopsy_perform ( `hn` VARCHAR(9) NOT NULL )
CREATE TABLE budget_type ( `budget_type_id` INT NOT NULL )
CREATE TABLE autopsy_death_type ( `autopsy_death_type_id` INT NOT NULL )
Checking STRUCTURE phase 1
TABLE opdscreen has hos_guid
TABLE patient has hos_guid
TABLE ovst has hos_guid
TABLE opitemrece has hos_guid
UPDATE hosxp_dll_field DATA ...
Upgrade MySQL START