ALTER TABLE person_anc_screen ADD `dt_decay_count` INT NULL
ALTER TABLE person_anc_screen ADD `dt_screen5` CHAR(1) NULL
ALTER TABLE person_anc_screen ADD `dt_screen4` CHAR(1) NULL
ALTER TABLE person_anc_screen ADD `dt_screen3` CHAR(1) NULL
ALTER TABLE person_anc_screen ADD `dt_screen2` CHAR(1) NULL
ALTER TABLE person_anc_screen ADD `dt_screen1` CHAR(1) NULL
ALTER TABLE person ADD `patient_hn` VARCHAR(9) NULL
ALTER TABLE person ADD `patient_link` CHAR(1) NULL
ALTER TABLE patient_adr_medication ADD `medication_idr` VARCHAR(150) NULL
ALTER TABLE patient_adr_medication ADD `medication_name` VARCHAR(150) NULL
ALTER TABLE patient_adr_medication ADD `adr_medication_source_id` INT NULL
ALTER TABLE patient_adr_medication ADD `medication_icd` VARCHAR(9) NULL
ALTER TABLE patient_adr_medication ADD `medication_end_date` DATE NULL
ALTER TABLE patient_adr_medication ADD `medication_begin_date` DATE NULL
ALTER TABLE patient_adr_medication ADD `adr_medication_type_id` INT NULL
ALTER TABLE patient_adr_medication ADD `patient_adr_id` INT NOT NULL
ALTER TABLE patient_adr_death ADD `adr_death_icd` VARCHAR(7) NULL
ALTER TABLE patient_adr_death ADD `adr_death_id` INT NOT NULL
ALTER TABLE patient_adr_death ADD `patient_adr_id` INT NOT NULL
ALTER TABLE patient_adr ADD `medication_list` VARCHAR(250) NULL
ALTER TABLE patient_adr ADD `adr_report_type_id` INT NULL
ALTER TABLE patient_adr ADD `adr_possibility_id` INT NULL
ALTER TABLE patient_adr ADD `adr_cause_id` INT NULL
ALTER TABLE patient_adr ADD `report_date` DATE NULL
ALTER TABLE patient_adr ADD `entry_officer_position` VARCHAR(150) NULL
ALTER TABLE patient_adr ADD `entry_officer_name` VARCHAR(150) NULL
ALTER TABLE patient_adr ADD `dx_doctor_position` VARCHAR(150) NULL
ALTER TABLE patient_adr ADD `dx_doctor_name` VARCHAR(150) NULL
ALTER TABLE patient_adr ADD `adr_outcome_id` INT NULL
ALTER TABLE patient_adr ADD `adr_norechallenge` CHAR(1) NULL
ALTER TABLE patient_adr ADD `adr_continue_rechallenge_id` INT NULL
ALTER TABLE patient_adr ADD `adr_continue_rechallenge` CHAR(1) NULL
ALTER TABLE patient_adr ADD `adr_dechallenge_type_id` INT NULL
ALTER TABLE patient_adr ADD `adr_rechallenge_type_id` INT NULL
ALTER TABLE patient_adr ADD `adr_rechallenge` CHAR(1) NULL
ALTER TABLE patient_adr ADD `adr_dechallange` CHAR(1) NULL
ALTER TABLE patient_adr ADD `adr_seriousness_id` INT NULL
ALTER TABLE patient_adr ADD `lab_pe_text` longtext NULL
ALTER TABLE patient_adr ADD `adverse_effect_date` DATE NULL
ALTER TABLE patient_adr ADD `adverse_effect` longtext NULL
ALTER TABLE patient_adr ADD `adr_product_type_id` INT NULL
ALTER TABLE patient_adr ADD `other_dx` VARCHAR(7) NULL
ALTER TABLE patient_adr ADD `has_adr_history` CHAR(1) NULL
ALTER TABLE patient_adr ADD `an` VARCHAR(9) NULL
ALTER TABLE patient_adr ADD `department` CHAR(3) NULL
ALTER TABLE patient_adr ADD `hn` VARCHAR(9) NOT NULL
ALTER TABLE medplan_ipd_wait ADD `off_staff` VARCHAR(25) NULL
ALTER TABLE medplan_ipd_wait ADD `med_interval_type_id` INT NULL
ALTER TABLE medplan_ipd_wait ADD `icode_type` CHAR(1) NULL
ALTER TABLE medplan_ipd_wait ADD `first_dose_date_time` datetime NULL
ALTER TABLE medplan_ipd_wait ADD `frequency` INT NULL
ALTER TABLE medplan_ipd_wait ADD `sp_use` VARCHAR(7) NULL
ALTER TABLE medplan_ipd_wait ADD `drugusage` VARCHAR(7) NULL
ALTER TABLE medplan_ipd_wait ADD `orderstatus` CHAR(1) NULL
ALTER TABLE medplan_ipd_wait ADD `orderdate` DATE NULL
ALTER TABLE medplan_ipd_wait ADD `offdate` DATE NULL
ALTER TABLE medplan_ipd_wait ADD `qty` INT NULL
ALTER TABLE medplan_ipd_wait ADD `icode` VARCHAR(7) NOT NULL
ALTER TABLE medplan_ipd_wait ADD `doctor` VARCHAR(7) NULL
ALTER TABLE medplan_ipd_wait ADD `hn` VARCHAR(9) NOT NULL
ALTER TABLE adr_seriousness ADD `adr_seriousness_name` VARCHAR(250) NOT NULL
ALTER TABLE adr_report_type ADD `adr_report_type_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_rechallenge_type ADD `adr_rechallenge_type_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_product_type ADD `adr_product_type_name` VARCHAR(200) NOT NULL
ALTER TABLE adr_possibility ADD `adr_possibility_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_outcome ADD `adr_outcome_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_medication_type ADD `adr_medication_type_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_medication_source ADD `adr_medication_source_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_dechallenge_type ADD `adr_dechallenge_type_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_death ADD `adr_death_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_continue_rechallenge ADD `adr_continue_rechallenge_name` VARCHAR(150) NOT NULL
ALTER TABLE adr_cause ADD `adr_cause_name` VARCHAR(150) NOT NULL
CREATE TABLE patient_adr_medication ( `patient_adr_medication_id` INT NOT NULL )
CREATE TABLE patient_adr_death ( `patient_adr_death_id` INT NOT NULL )
CREATE TABLE patient_adr ( `patient_adr_id` INT NOT NULL )
CREATE TABLE medplan_ipd_wait ( `med_plan_number` INT NOT NULL )
CREATE TABLE adr_seriousness ( `adr_seriousness_id` INT NOT NULL )
CREATE TABLE adr_report_type ( `adr_report_type_id` INT NOT NULL )
CREATE TABLE adr_rechallenge_type ( `adr_rechallenge_type_id` INT NOT NULL )
CREATE TABLE adr_product_type ( `adr_product_type_id` INT NOT NULL )
CREATE TABLE adr_possibility ( `adr_possibility_id` INT NOT NULL )
CREATE TABLE adr_outcome ( `adr_outcome_id` INT NOT NULL )
CREATE TABLE adr_medication_type ( `adr_medication_type_id` INT NOT NULL )
CREATE TABLE adr_medication_source ( `adr_medication_source_id` INT NOT NULL )
CREATE TABLE adr_dechallenge_type ( `adr_dechallenge_type_id` INT NOT NULL )
CREATE TABLE adr_death ( `adr_death_id` INT NOT NULL )
CREATE TABLE adr_continue_rechallenge ( `adr_continue_rechallenge_id` INT NOT NULL )
CREATE TABLE adr_cause ( `adr_cause_id` INT NOT NULL )