-- ALTER statements for tbl_dischargecards table
-- Add missing fields for new discharge card form

ALTER TABLE `tbl_dischargecards` 
ADD COLUMN `UhidNo` varchar(100) DEFAULT NULL AFTER `MrdNo`,
ADD COLUMN `WtOnAdm` varchar(50) DEFAULT NULL AFTER `Address`,
ADD COLUMN `BirthDate` date DEFAULT NULL AFTER `AdmissionTime`,
ADD COLUMN `BirthWt` varchar(50) DEFAULT NULL AFTER `BirthDate`,
ADD COLUMN `ConsultantName` varchar(255) DEFAULT NULL AFTER `BirthWt`,
ADD COLUMN `ParentOccupation` varchar(255) DEFAULT NULL AFTER `ConsultantName`,
ADD COLUMN `Ventilation` varchar(100) DEFAULT NULL AFTER `ParentOccupation`,
ADD COLUMN `Oxygen` varchar(100) DEFAULT NULL AFTER `Ventilation`,
ADD COLUMN `HeadCircumference` varchar(50) DEFAULT NULL AFTER `Oxygen`,
ADD COLUMN `Height` varchar(50) DEFAULT NULL AFTER `HeadCircumference`,
ADD COLUMN `BloodGroup` varchar(10) DEFAULT NULL AFTER `Height`,
ADD COLUMN `WtOnDischarge` varchar(50) DEFAULT NULL AFTER `BloodGroup`,
ADD COLUMN `MotherBloodGroup` varchar(10) DEFAULT NULL AFTER `WtOnDischarge`,
ADD COLUMN `ContactToDoctor` varchar(255) DEFAULT NULL AFTER `MotherBloodGroup`,
ADD COLUMN `ModeOfDelivery` varchar(100) DEFAULT NULL AFTER `ContactToDoctor`,
ADD COLUMN `MaternalRiskFactor` varchar(255) DEFAULT NULL AFTER `ModeOfDelivery`,
ADD COLUMN `ChiefComplaints` text DEFAULT NULL AFTER `MaternalRiskFactor`,
ADD COLUMN `BirthHistory` text DEFAULT NULL AFTER `ChiefComplaints`,
ADD COLUMN `PastHistory` text DEFAULT NULL AFTER `BirthHistory`,
ADD COLUMN `FamilyHistory` text DEFAULT NULL AFTER `PastHistory`,
ADD COLUMN `ImmunizationHistory` text DEFAULT NULL AFTER `FamilyHistory`,
ADD COLUMN `CourseDuringAdmission` text DEFAULT NULL AFTER `ImmunizationHistory`,
ADD COLUMN `ConditionOnAdm` text DEFAULT NULL AFTER `CourseDuringAdmission`,
ADD COLUMN `ProcedureDone` text DEFAULT NULL AFTER `ConditionOnAdm`,
ADD COLUMN `ReasonOfAdm` text DEFAULT NULL AFTER `ProcedureDone`,
ADD COLUMN `DevHistory` text DEFAULT NULL AFTER `ReasonOfAdm`,
ADD COLUMN `InvestigationDone` text DEFAULT NULL AFTER `DevHistory`,
ADD COLUMN `SpecialAdvice` text DEFAULT NULL AFTER `InvestigationDone`,
ADD COLUMN `DischargeCardType` varchar(100) DEFAULT NULL AFTER `SpecialAdvice`,
ADD COLUMN `DischargeStatus` varchar(100) DEFAULT NULL AFTER `DischargeCardType`,
ADD COLUMN `PlaceOfDelivery` varchar(255) DEFAULT NULL AFTER `DischargeStatus`;
