-- Run this only on an already-installed database.  For a new installation,
-- import hmsci.sql; it already contains these statements.
ALTER TABLE `admin` ADD `alternate_phone` varchar(20) NOT NULL DEFAULT '', ADD `sex` varchar(15) NOT NULL DEFAULT '', ADD `birth_date` varchar(20) NOT NULL DEFAULT '', ADD `blood_group` varchar(10) NOT NULL DEFAULT '', ADD `marital_status` varchar(20) NOT NULL DEFAULT '', ADD `occupation` varchar(100) NOT NULL DEFAULT '', ADD `city` varchar(100) NOT NULL DEFAULT '', ADD `state` varchar(100) NOT NULL DEFAULT '', ADD `pincode` varchar(15) NOT NULL DEFAULT '', ADD `emergency_name` varchar(150) NOT NULL DEFAULT '', ADD `emergency_phone` varchar(20) NOT NULL DEFAULT '', ADD `relation` varchar(50) NOT NULL DEFAULT '', ADD `aadhar_no` varchar(20) NOT NULL DEFAULT '', ADD `insurance_company` varchar(150) NOT NULL DEFAULT '', ADD `insurance_policy` varchar(100) NOT NULL DEFAULT '';
ALTER TABLE `patient` ADD `patient_code` varchar(30) NOT NULL DEFAULT '', ADD `alternate_phone` varchar(20) NOT NULL DEFAULT '', ADD `marital_status` varchar(20) NOT NULL DEFAULT '', ADD `occupation` varchar(100) NOT NULL DEFAULT '', ADD `city` varchar(100) NOT NULL DEFAULT '', ADD `state` varchar(100) NOT NULL DEFAULT '', ADD `pincode` varchar(15) NOT NULL DEFAULT '', ADD `emergency_name` varchar(150) NOT NULL DEFAULT '', ADD `emergency_phone` varchar(20) NOT NULL DEFAULT '', ADD `relation` varchar(50) NOT NULL DEFAULT '', ADD `aadhar_no` varchar(20) NOT NULL DEFAULT '', ADD `insurance_company` varchar(150) NOT NULL DEFAULT '', ADD `insurance_policy` varchar(100) NOT NULL DEFAULT '', ADD `allergies` longtext NOT NULL, ADD `medical_history` longtext NOT NULL, ADD `current_medication` longtext NOT NULL;
ALTER TABLE `doctor` ADD `alternate_phone` varchar(20) NOT NULL DEFAULT '', ADD `gender` varchar(15) NOT NULL DEFAULT '', ADD `date_of_birth` date DEFAULT NULL, ADD `blood_group` varchar(10) NOT NULL DEFAULT '', ADD `marital_status` varchar(20) NOT NULL DEFAULT '', ADD `occupation` varchar(100) NOT NULL DEFAULT '', ADD `city` varchar(100) NOT NULL DEFAULT '', ADD `state` varchar(100) NOT NULL DEFAULT '', ADD `pincode` varchar(15) NOT NULL DEFAULT '', ADD `emergency_name` varchar(150) NOT NULL DEFAULT '', ADD `emergency_phone` varchar(20) NOT NULL DEFAULT '', ADD `relation` varchar(50) NOT NULL DEFAULT '', ADD `aadhar_no` varchar(20) NOT NULL DEFAULT '', ADD `insurance_company` varchar(150) NOT NULL DEFAULT '', ADD `insurance_policy` varchar(100) NOT NULL DEFAULT '', ADD `qualification` varchar(150) NOT NULL DEFAULT '', ADD `specialist_in` varchar(150) NOT NULL DEFAULT '', ADD `registration_number` varchar(100) NOT NULL DEFAULT '', ADD `experience_years` int(11) NOT NULL DEFAULT 0, ADD `consultation_fee` decimal(10,2) NOT NULL DEFAULT 0, ADD `available_days` varchar(150) NOT NULL DEFAULT '', ADD `available_time` varchar(150) NOT NULL DEFAULT '';
ALTER TABLE `nurse` ADD `gender` varchar(15) NOT NULL DEFAULT '', ADD `date_of_birth` date DEFAULT NULL, ADD `qualification` varchar(150) NOT NULL DEFAULT '', ADD `shift` varchar(30) NOT NULL DEFAULT '', ADD `joining_date` date DEFAULT NULL, ADD `department_id` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `pharmacist` ADD `gender` varchar(15) NOT NULL DEFAULT '', ADD `date_of_birth` date DEFAULT NULL, ADD `license_number` varchar(100) NOT NULL DEFAULT '', ADD `qualification` varchar(150) NOT NULL DEFAULT '', ADD `joining_date` date DEFAULT NULL;
ALTER TABLE `laboratorist` ADD `gender` varchar(15) NOT NULL DEFAULT '', ADD `date_of_birth` date DEFAULT NULL, ADD `qualification` varchar(150) NOT NULL DEFAULT '', ADD `license_number` varchar(100) NOT NULL DEFAULT '', ADD `specialization` varchar(150) NOT NULL DEFAULT '', ADD `joining_date` date DEFAULT NULL;
ALTER TABLE `accountant` ADD `gender` varchar(15) NOT NULL DEFAULT '', ADD `date_of_birth` date DEFAULT NULL, ADD `qualification` varchar(150) NOT NULL DEFAULT '', ADD `joining_date` date DEFAULT NULL, ADD `employee_id` varchar(100) NOT NULL DEFAULT '';