initial.sql

ALTER TABLE `aefis` ADD `initial_id` INT(11) NULL DEFAULT NULL AFTER `aefi_id`;
ALTER TABLE `adrs` ADD `initial_id` INT(11) NULL DEFAULT NULL AFTER `adr_id`;
ALTER TABLE `saefis` ADD `initial_id` INT(11) NULL DEFAULT NULL AFTER `saefi_id`
ALTER TABLE `sadrs` ADD `initial_id` INT(11) NULL DEFAULT NULL AFTER `sadr_id`
UPDATE sadrs SET initial_id=sadr_id WHERE report_type='FollowUp';

-- Action Date 

ALTER TABLE `sadrs` ADD `action_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `modified`;
ALTER TABLE `adrs` ADD `action_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `modified`;
ALTER TABLE `aefis` ADD `action_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `modified`;
ALTER TABLE `saefis` ADD `action_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `modified`;
ALTER TABLE `ce2bs` ADD `action_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `modified`;

ALTER TABLE `aefi_list_of_vaccines` ADD `manufacturer` VARCHAR(255) NULL DEFAULT NULL AFTER `vaccine_name`;
ALTER TABLE `aefis` ADD `age_group` VARCHAR(255) NOT NULL AFTER `age_at_onset_specify`;
ALTER TABLE `aefis` CHANGE `age_group` `age_group` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `aefis` ADD `female_status` VARCHAR(255) NULL DEFAULT NULL AFTER `gender`;

ALTER TABLE `saefis` ADD `comorbidity_disorder` VARCHAR(255) NULL DEFAULT NULL AFTER `allergy_history_remarks`, ADD `comorbidity_disorder_remarks` TEXT NULL DEFAULT NULL AFTER `comorbidity_disorder`, ADD `covid_positive` VARCHAR(255) NULL DEFAULT NULL AFTER `comorbidity_disorder_remarks`, ADD `covid_positive_remarks` TEXT NULL DEFAULT NULL AFTER `covid_positive`;


ALTER TABLE `saefis` ADD `injection_dose_route` VARCHAR(255) NULL AFTER `syringes_used_findings`, ADD `injection_time_mentioned` VARCHAR(255) NULL AFTER `injection_dose_route`, ADD `injection_no_touch` VARCHAR(255) NULL AFTER `injection_time_mentioned`, ADD `injection_contraindications` VARCHAR(255) NULL AFTER `injection_no_touch`, ADD `injection_reported` VARCHAR(255) NULL AFTER `injection_contraindications`, ADD `injection_vaccines` VARCHAR(255) NULL AFTER `injection_reported`, ADD `injection_vaccines_yes` VARCHAR(255) NULL AFTER `injection_vaccines`, ADD `injection_observations` TEXT NULL AFTER `injection_vaccines_yes`;